Home » SQL & PL/SQL » SQL & PL/SQL » How to Identify Table Usage Information (Oracle 10g)
How to Identify Table Usage Information [message #353291] Mon, 13 October 2008 04:50 Go to next message
sanyadu
Messages: 30
Registered: October 2006
Location: Chicago
Member
Hi ,

I have a tables and i want to know its usage information in terms of Size , Tablespace.

Can someone send me a query to get this done..
Re: How to Identify Table Usage Information [message #353297 is a reply to message #353291] Mon, 13 October 2008 04:58 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search for user_tables and user_segments.

Regards

Raj
Previous Topic: SEQUENCE
Next Topic: how to write in appned mode thru DBMS_XSLPROCESSOR.CLOB2FILE
Goto Forum:
  


Current Time: Tue Dec 06 04:32:24 CST 2016

Total time taken to generate the page: 0.09510 seconds