autoextensions arent logged anywhere
Printable View
autoextensions arent logged anywhere
Yes it is logged in alertlog.Quote:
Originally Posted by davey23uk
hussain123,
Your request for the thread is:
May be you have to go through the above threads once again and your questions are briefly answered already. :)Code:how can I monitor the Tablespace space usage while datafiles are autextend for the tablespace?
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.
Autoextends are logggggggggggggggggggggggggged.:DQuote:
Originally Posted by davey23uk
On what context you deny it? or is it by overconfident!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
dbasan, Does your piece of alertlog shows datafile extending at that particular time... or does it shows you have set datafile for autoextend?
Yes.Quote:
Originally Posted by PAVB
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. :rolleyes:
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. :oCode:Long before this place was so good.
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.Quote:
Originally Posted by davey23uk