• State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 60 subscribers
  • Views 4290 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

TEMP tablespace ran out of space, can SQL PI help?

kris.semple_69291
over 5 years ago

Last night the TEMP tablespace maxed out on one of your databases:

ORA-1652: unable to extend temp segment by 64 in tablespace TEMP

It almost doubled in size to 8GB in a matter of minutes. I was trying to use SQL PI to find out what happened and if there is anything that I need to do to stop it happening again. But I can't seem to find anything in SQL PI that correlates with this event. Can SQL PI help me understand this better?

Thanks,

Kris

Parents
  • 0 over 5 years ago

    Hi Kris,

    If you narrow down the zonar to the range, then drill down in to Database | DBName | Actions, are there any that were highly active during the time?

    The action can then be expanded and drilled down into for more details (SQL statements, OS Users, Machines, etc).

    John

Reply
  • 0 over 5 years ago

    Hi Kris,

    If you narrow down the zonar to the range, then drill down in to Database | DBName | Actions, are there any that were highly active during the time?

    The action can then be expanded and drilled down into for more details (SQL statements, OS Users, Machines, etc).

    John

Children
No Data