Tablespace space usage monitoring for autextend tablespaces - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: Tablespace space usage monitoring for autextend tablespaces

  1. #11
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    autoextensions arent logged anywhere

  2. #12
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by davey23uk
    autoextensions arent logged anywhere
    Yes it is logged in alertlog.

    hussain123,

    Your request for the thread is:

    Code:
    how can I monitor the Tablespace space usage while datafiles are autextend for the tablespace?
    May be you have to go through the above threads once again and your questions are briefly answered already.

    Install OEM and you can monitor growth graphically, else
    use the query, script it and run at frequent intervals to get you the growth.

    > autoextensible column in dba data files would let you know that the datafile is in auto extention.
    > In your case its showing a fully occupied in the sense its been utilised completely, you may consider imcreasing the disk space where the data file resides, and that should solve your problem.

  3. #13
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    autoextensions are NOT logged in the alert log

  4. #14
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Question here is... have you set a max size for the tablespace or not?

    If you have set a max size it's pretty easy to monitor it.
    If you have not, things get a little more tricky 'cause you have to check physical disk availability too.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #15
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by davey23uk
    autoextensions are NOT logged in the alert log
    Autoextends are logggggggggggggggggggggggggged.

    Code:
    Dump file d:\oracle\admin\db1\bdump\alert_db1.log
    Thu May 03 14:22:32 2007
    ORACLE V9.2.0.6.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.2 Service Pack 2, CPU type 586
    
    Tue May 08 10:51:29 2007
    ALTER DATABASE DATAFILE 'E:\ORADATA\DB1\USERS01.DBF' AUTOEXTEND on next 1m
    Tue May 08 10:51:29 2007
    Completed: ALTER DATABASE DATAFILE 'E:\ORADATA\DB1\USERS01.DB
    On what context you deny it? or is it by overconfident!

  6. #16
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    dbasan, Does your piece of alertlog shows datafile extending at that particular time... or does it shows you have set datafile for autoextend?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #17
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by PAVB
    or does it shows you have set datafile for autoextend?
    Yes.

  8. #18
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so therefore is doesnt log auto extensions, so stop peddling your crap

  9. #19
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    This is a decent forum. Dont degrade it with your foul language. I think you have to go back to school to learn decency. Communicating in this forum needs a lil bit of being civilised.

    Code:
    Long before this place was so good.
    One who knows what is the purpose of alert log would never be ignorant. Any change to the datafile status is always logged in alert. I was reiterating this and what gandolf989 said in the previous thread, which a brat could not understand.

  10. #20
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Quote Originally Posted by davey23uk
    so therefore is doesnt log auto extensions, so stop peddling your crap
    We use a Perl script to monitor the alert logs on our databases. The alert log sends emails based on a series of filters. If I alter a tablespace to make it larger, smaller, autoextend etc, i get an email. Perhaps you are correct in stating the the mere act of Oracle autoextending a tablespace does not get logged in an alert log. I would have to set up a test to make sure though.
    this space intentionally left blank

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