Home » SQL & PL/SQL » SQL & PL/SQL » query for database
query for database [message #395007] Tue, 31 March 2009 00:52 Go to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
Hi

anyone can give me query to find out

1) size of database
2) size of a table
3) size of a table containing blob file.

thanks
Re: query for database [message #395016 is a reply to message #395007] Tue, 31 March 2009 01:30 Go to previous message
ora_baby
Messages: 89
Registered: May 2008
Member
1)size of database - what is it? tablespace or ...?
2)dba_tables , user_segments, dba_segments
3) In order to find out the size of LOBs in your database, you'll want to use the DBMS_LOB supplied PL/SQL package, specifically the GETLENGTH ... http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_cid499515,00.html

[Updated on: Tue, 31 March 2009 01:33]

Report message to a moderator

Previous Topic: query
Next Topic: How to fetch time interval
Goto Forum:
  


Current Time: Fri Dec 09 15:38:28 CST 2016

Total time taken to generate the page: 0.08136 seconds