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

Thread: How do u handle space management hourly basis.

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hi

    I want ot know how to find my tablespaces are full ,do i need to run cron job check it out regularly.
    My basic question ,from which tables i can see space management regularly like tablespaces and so on ,since its is real crucial .If something goes wrong and system is brought to halt we will be fired .

    My boss use to say me when ever space utilisation gets filled 50% u need to take preventive measures ,i need to track it when it comes to 50% send me a notification how do u it ?? in unix or pl/sql procedure.

    Thanks
    lnr





    html code is off

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    looks like your boss knows little about how an Oracle databse should be managed ... but don't tell him !!!
    well the problem in fact is to know which of your objects cannot allocate a next extent in their tablespace ... that way you know if your objects are about to explose the tablespace or not ...
    nevertheless to answer your question, you cron a shell script, which then does a

    sqlplus user/password << _END
    select
    ...
    exit;
    _END

    and your select query should use
    dba_data_files
    dba_segments
    dba_free_space

    it's yours now

  3. #3
    Join Date
    Jan 2001
    Posts
    60
    hi

    Thanks for that.
    But i want to know how do u handle daily activities ,instead of looking into it regularly.
    Is there any procedure or shell script for this type of activities
    were i can look into it and it will be helpful to me.

    Thanks
    lnr
    html code is off

  4. #4
    Join Date
    Apr 2001
    Posts
    35
    Set your tablespaces and data files autoextend with a maximum limit, say, at 4GB. You can check your OS directory to see how big the datafiles are, which can be done in many ways.

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