-
autoextensions arent logged anywhere
-
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.
-
autoextensions are NOT logged in the alert log
-
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.
-
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!
-
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.
-
Originally Posted by PAVB
or does it shows you have set datafile for autoextend?
Yes.
-
so therefore is doesnt log auto extensions, so stop peddling your crap
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|