DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Monitoring Database Growth

  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Monitoring Database Growth

    I want to monitor the growth of my database. Which commands
    should I run ?

    At the moment I'm using this command

    " select sum(bytes)from dba_segments where segment_type in('TABLE','INDEX'); "

    Your comments will be appreciated
    Telewa

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What do you mean by growth of database? If you meant growth of Segments (Table and Index) then you can use.

    Code:
    select segment_name, segment_type, bytes from dba_segments where segment_type in ('TABLE','INDEX');
    HTH
    Last edited by SANJAY_G; 06-18-2003 at 08:00 AM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width