Home » RDBMS Server » Server Administration » undo and temp tablespaces (oracle DB 10G on solaris)
undo and temp tablespaces [message #277766] Wed, 31 October 2007 07:42 Go to next message
Messages: 1
Registered: October 2007
Junior Member

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.


Re: undo and temp tablespaces [message #277769 is a reply to message #277766] Wed, 31 October 2007 07:58 Go to previous message
Messages: 4759
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.
Previous Topic: Ask : Upgrade Oracle 9i to Oracle 10G
Next Topic: applying patchset
Goto Forum:

Current Time: Fri Jul 28 02:15:44 CDT 2017

Total time taken to generate the page: 0.18729 seconds