DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: How can i identify SQL statements that used up space in temp segment?

  1. 07-05-2005, 01:23 PM #11
    Harry_Potter
    Harry_Potter is offline Junior Member
    Join Date
    Jun 2005
    Posts
    17
    Thanks dbtoo and KenEwald Actually im a newbie DBA and i dont know yet the statspack you're saying. Any other option aside from running statspack?
    Reply With Quote Reply With Quote
  2. 07-05-2005, 03:35 PM #12
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Harry,

    Didn't know you were new to Oracle, sorry.

    I'm not a big fan of this guy, but ...

    Quickly find Oracle Session hogs

    If you don't have OEM (Oracle Enterprise Manager), running statspack is not that tough. I'd recommend you muster up the courage and figure it out and collect stats for a day, the report will probably suprise you.

    Oracle9i Database Performance Tuning Guide and Reference
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
  3. 07-06-2005, 03:17 AM #13
    Harry_Potter
    Harry_Potter is offline Junior Member
    Join Date
    Jun 2005
    Posts
    17
    Thanks a lot KenEwald
    Reply With Quote Reply With Quote
  4. 07-06-2005, 10:28 AM #14
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    No worries Harry.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width