Hi!!

I have a small problem, i will try to explain it, My tablespaces are Automatically extend datafile when full (AUTOEXTEND). It had checked "autoextend ON" checkbox.


What I need to know is, when happened that autoextend accion(day/hour), is it possible?




Thank you!
Sincerelly alazka.

you cant as it isnt logged anywhere in the database im afraid

thank yuo dave!


And if i dissable autoextends and i create my own procedure that starts automatically when a tablespaces space is full, to extend a tablespace and store the day and hour?

Is it posibble?

thank you again dave!

alazka.

yep sure, no issues with that - also that will be logged in the database alert log if you do it manually

So, if i create that procedure, and for example, today ,when a tablespace free space was full, automatically started working my procedure extending the tablespace. After finished that if i check "the database alert log", i would find there a message that says that my procedure was executed?

If the answer is "yes", can i do another procedure that checks if it is any message of my procedure in "database alert log"? is this a good idea?

thank you again dave.

Hi,

>> when a tablespace free space was full, automatically started working my procedure extending the tablespace.

That would be too late, and Oracle would have locked-up!

Make sure to always use "autoextend on" in tablespace definitions.

How about checking for new extents?

http://www.dba-oracle.com/tune_art.htm

>> can i do another procedure that checks if it is any message of my procedure in "database alert log"?

You can easily write custom messages to your alert log, not hard:

http://www.dba-oracle.com/t_writing_alert_log_message.htm

Hi Burleson!

thanks for the help, but the situation has changed.

I can´t do what i explained before. So the cuestion is another.

example:

I have checked autoextend "on" on tablesapces. So when a tablespace is full, oracle extends the tablespace automatically.

It is stored this accion in any log?



thank you!

Hi Alazka,

>> It is stored this accion in any log?

No, not to my knowledge.

It's easy to write your own alert on a schedule:

1 - Query dba_tablespaces and store tablespace_name and extents in a temp table
2 - On the next scheduled query, compares the old and new extent values
3 - If found an extended tablespace, send an alert.

However, you may be able to use:

1 - The RMAN respository toi track extents over time.
2 - The AWR tables to see tablespace size totals over time.

Hi,
I have a query regarding autoextending.

If i have 3 datafiles in the tablespace will enabling autoextend for all these three files help or it should just be the last datafile of the tablespace.

Thanks,
Wizoracle

Hi, Wiz,

>> If i have 3 datafiles in the tablespace will enabling autoextend for all these three files help or it should just be the last datafile of the tablespace.

Good question!

Oracle knows the sequenece of the data files, that new files are added because the others are already full.

Hence, only the "last" data file will extend!

Also remember to make each object in the table with maxextents unlimited:

http://www.dba-oracle.com/t_datafile_management.htm

Hi BC,
Thanks a ton for the explanation.

Regards,
Mujaahid