Results 1 to 7 of 7

Thread: Is anyone good in ORACLE ?

  1. #1
    OilSheikh
    Guest

    Is anyone good in ORACLE ?

    Need help in getting query execution time from Enterprise manager

  2. #2
    bored out of my tiny mind malfunction's Avatar
    Join Date
    Jul 2003
    Location
    Lurking
    Posts
    3,923
    Thanks
    191
    Thanked
    187 times in 163 posts
    • malfunction's system
      • Motherboard:
      • Gigabyte G1.Sniper (with daft heatsinks and annoying Killer NIC)
      • CPU:
      • Xeon X5670 (6 core LGA 1366) @ 4.4GHz
      • Memory:
      • 48GB DDR3 1600 (6 * 8GB)
      • Storage:
      • 1TB 840 Evo + 1TB 850 Evo
      • Graphics card(s):
      • 290X
      • PSU:
      • Antec True Power New 750W
      • Case:
      • Cooltek W2
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Dell U2715H

    Re: Is anyone good in ORACLE ?

    I'll see if I can drag something out of my notes / books tomorrow. I don't use OEM much but I presume you're trying to find out which queries are using the most resource rather than simply timing a piece of SQL? Also - which version - 11g?

    Edit: a bit more googling helped:

    http://download.oracle.com/docs/cd/B...dppt_sqlid.htm

  3. #3
    OilSheikh
    Guest

    Re: Is anyone good in ORACLE ?

    Quote Originally Posted by malfunction View Post
    I'll see if I can drag something out of my notes / books tomorrow. I don't use OEM much but I presume you're trying to find out which queries are using the most resource rather than simply timing a piece of SQL? Also - which version - 11g?

    Edit: a bit more googling helped:

    http://download.oracle.com/docs/cd/B...dppt_sqlid.htm
    I tried that but it's absolutely useless.

    Say, I runa query SELECT * FROM CUSTOMERS, this isn't caught and the timing isn't shown. Few mins. later, you get afigure but if yu check the SQL statement, it's for a different internal work and not my statement. Gonna try using SET TIMING ON and get result in ms.

  4. #4
    bored out of my tiny mind malfunction's Avatar
    Join Date
    Jul 2003
    Location
    Lurking
    Posts
    3,923
    Thanks
    191
    Thanked
    187 times in 163 posts
    • malfunction's system
      • Motherboard:
      • Gigabyte G1.Sniper (with daft heatsinks and annoying Killer NIC)
      • CPU:
      • Xeon X5670 (6 core LGA 1366) @ 4.4GHz
      • Memory:
      • 48GB DDR3 1600 (6 * 8GB)
      • Storage:
      • 1TB 840 Evo + 1TB 850 Evo
      • Graphics card(s):
      • 290X
      • PSU:
      • Antec True Power New 750W
      • Case:
      • Cooltek W2
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Dell U2715H

    Re: Is anyone good in ORACLE ?

    If you're trying to debug an individual statement you probably want to use autotrace ("set autotrace on") or run an explain plan, not just time it.

  5. #5
    Senior Member burble's Avatar
    Join Date
    May 2007
    Location
    Olney
    Posts
    1,138
    Thanks
    8
    Thanked
    90 times in 89 posts

    Re: Is anyone good in ORACLE ?

    My Oracle skills are a bit rusty and I did everything using SQL Plus but simple 'set timing on' followed by your query should give you what you want.

    What platform are you running Oracle on? With timing it's important to use the correct version of SQL Plus for the version of Oracle so probably best to run the command on the box itself if you can. Also the format of the answer varies depending on what platform you're using and timing can be a bit broken on Windows.

    You should be able to use 'help timing' in SQL Plus to get some pointers.

  6. #6
    Synergy leverager
    Join Date
    Jun 2005
    Location
    /dev/dsk/c1d0s7
    Posts
    1,051
    Thanks
    45
    Thanked
    31 times in 27 posts
    • Mutley's system
      • Motherboard:
      • Abit IP-35 Pro
      • CPU:
      • Intel QX9650 (OC'd to 3.8Ghz)
      • Memory:
      • 8GB (4x2GB) G.Skill DDR2-1066 8500CL5D
      • Storage:
      • Samsung 840EVO 250GB SSD & Samsung HD501LJ 500GB SATA
      • Graphics card(s):
      • Asus GTX 660
      • PSU:
      • Enermax Infiniti 650W
      • Case:
      • Antec P-182
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • NEC 20WGX2
      • Internet:
      • 60MB Cable (Virgin)

    Re: Is anyone good in ORACLE ?

    Quote Originally Posted by OilSheikh View Post
    Need help in getting query execution time from Enterprise manager
    Hah, I thought you were asking about the moral nature of the people who work at Oracle. I was about to get stuck in...

  7. #7
    OilSheikh
    Guest

    Re: Is anyone good in ORACLE ?

    Quote Originally Posted by burble View Post
    My Oracle skills are a bit rusty and I did everything using SQL Plus but simple 'set timing on' followed by your query should give you what you want.

    What platform are you running Oracle on? With timing it's important to use the correct version of SQL Plus for the version of Oracle so probably best to run the command on the box itself if you can. Also the format of the answer varies depending on what platform you're using and timing can be a bit broken on Windows.

    You should be able to use 'help timing' in SQL Plus to get some pointers.
    I ended up using

    dbms_utility.get_time and this gave me results back in milllseconds

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 27-09-2010, 03:19 PM
  2. Recommend an Oracle query optimisation book or course
    By manwithnoname in forum Software
    Replies: 1
    Last Post: 22-01-2007, 12:20 PM
  3. ORACLE trigger/PLSQL question...hmm
    By Spud1 in forum Software
    Replies: 12
    Last Post: 17-10-2005, 01:30 PM
  4. Learning SQl - oracle download?
    By PanzerKnight in forum Software
    Replies: 13
    Last Post: 29-07-2004, 07:11 PM
  5. Oracle SQL
    By Raz316 in forum Software
    Replies: 7
    Last Post: 08-06-2004, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •