undo and temp tablespaces [message #277766] |
Wed, 31 October 2007 07:42 |
pinchasch
Messages: 1 Registered: October 2007
|
Junior Member |
|
|
Hi,
Can you help me on this issue. I need to check and maybe configure one oracle instance. My problem is that I cant work with OEM and I need analyze the undo and temp tablespaces manually.
Can you suggest any way to make this, check if the undo and temp tablespaces need to be changed.
Thanks,
Pini
|
|
|
Re: undo and temp tablespaces [message #277769 is a reply to message #277766] |
Wed, 31 October 2007 07:58 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
What do you mean by analyze?
Anything you can find in OEM can be had by looking at the DBA_ tables in the database. You really should know the underlying SYS and SYSTEM tables rather than relying on a GUI tool.
|
|
|