Java Collectibles

Friday, February 28, 2014

How to display schema size with SQL query in Oracle?




SELECT sum(bytes)
  FROM dba_segments
 WHERE owner = <<owner of schema>>
If you are logged in to the schema then,
 SELECT SUM(bytes) FROM user_segments
Posted by nigelonline at 5:15 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

Total Pageviews

Blog Archive

  • ►  2018 (1)
    • ►  November (1)
  • ▼  2014 (12)
    • ►  November (2)
    • ►  October (1)
    • ▼  February (9)
      • How to display schema size with SQL query in Oracle?
      • How to find the Class/Object which invoke a method ?
      • How to Set send from in mail session
      • How to over ride Netbeans wizard toolbar save butt...
      • How to import data into a user when another user w...
      • How to get the selected row of a tree table?
      • How to auto adjust window size based on Image size...
      • How to setup Apache Tomcat Server in Netbeans.
      • How to put Conditional Breakpoints in Netbeans.
Awesome Inc. theme. Powered by Blogger.