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
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 Go to previous message
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.
Previous Topic: Ask : Upgrade Oracle 9i to Oracle 10G
Next Topic: applying patchset 9.2.0.7
Goto Forum:
  


Current Time: Thu Sep 19 19:04:58 CDT 2024