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
Messages: 33
Registered: June 2007
Location: mumbai

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.

Re: query for database [message #395016 is a reply to message #395007] Tue, 31 March 2009 01:30 Go to previous message
Messages: 89
Registered: May 2008
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: Wed Aug 16 10:16:35 CDT 2017

Total time taken to generate the page: 0.27223 seconds