The main idea of the blog is to share solutions for problems I faced before
Tuesday, 12 March 2013
Query to find the SCHEMA Size in oracle database
Here the query,
SELECT s.owner,SUM (s.BYTES) / (1024 * 1024 * 1024) SIZE_IN_GB
FROM dba_segments s
GROUP BY s.owner;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment