world apps dba

Saturday, 22 February 2014

Query to find the SCHEMA Size in oracle database

Query to find the SCHEMA Size in oracle database

SELECT s.owner,SUM (s.BYTES) / (1024 * 1024 * 1024) SIZE_IN_GB

FROM dba_segments s
GROUP BY s.owner;
Posted by saudiappsdba at 04:22
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: 11g, 12c, 9i, database, database .feature, SQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

saudiappsdba
View my complete profile

Blog Archive

  • ▼  2014 (46)
    • ►  December (4)
    • ►  October (4)
    • ►  September (12)
    • ►  August (1)
    • ►  April (2)
    • ►  March (3)
    • ▼  February (13)
      • Base Tables of O2C Process:
      • Query to find the SCHEMA Size in oracle database
      • Oracle RAC Interview Questions and Answers
      • Install Htop (Linux Process Monitoring) for RHEL
      • VirtualBox kernel problem ( Kernel driver not inst...
      • New Features in Oracle Database 12c
      • crsctl & srvctl commands
      • Oracle ASM commands
      • oracle faq
      • Installing an X server under Windows
      • Step by Step guide to build dataguard in Oracle 11g
      • Oracle Database 11g RAC On Oracle Linux 6.3 Using ...
      • step_by_step_installing_oracle_12c_rac_on_virtualbox
    • ►  January (7)
Simple theme. Powered by Blogger.