Home » RDBMS Server » Enterprise Manager » Complete newbie question (11GR2 RAC on Windows)
Complete newbie question [message #528028] Fri, 21 October 2011 05:23 Go to next message
Kwisatz78
Messages: 24
Registered: October 2011
Junior Member
Hi all

Whats the easiest way I can see a list of tablespaces and what tables and indexes are in those tablsespaces?

Can this be done through OEM?

Sorry for the newbiest of newbie questions.
Re: Complete newbie question [message #528038 is a reply to message #528028] Fri, 21 October 2011 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 66632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_SEGMENTS will give this with a simple SQL query.

Regards
Michel
Re: Complete newbie question [message #528076 is a reply to message #528038] Fri, 21 October 2011 07:04 Go to previous messageGo to next message
Kwisatz78
Messages: 24
Registered: October 2011
Junior Member
Thanks will check it out.
Re: Complete newbie question [message #528347 is a reply to message #528028] Mon, 24 October 2011 06:55 Go to previous message
daverich
Messages: 23
Registered: January 2010
Location: UK
Junior Member
Yes, you can also view this information from OEM.

You can do this ( I am using OEM 11g Grid Control):

1. Go to Targets->All Targets
2. Select the Database instance
3. Select Server Tab.
4. Select Tablespaces.
5. Select the tablespace you want to check (double click)
6. On View tablespace screen select "Show tablespace contents". Then Click Go.

Contents of that tablespace will be retrieved and displayed on OEM.
Previous Topic: NOT ABLE TO CONNECT DATABASE
Next Topic: Alert Notification From Enterprise Manager
Goto Forum:
  


Current Time: Mon Oct 14 01:08:24 CDT 2019