Help - Search - Members - Calendar
Full Version: tablespace autoextend
Oracle DBA Forums > Oracle > Oracle Forum
alazka
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.
dave
you cant as it isnt logged anywhere in the database im afraid
alazka
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.
dave
yep sure, no issues with that - also that will be logged in the database alert log if you do it manually
alazka
QUOTE (dave @ Apr 18 2007, 11:12 AM) *
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.
burleson
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
alazka
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!




QUOTE (burleson @ Apr 18 2007, 09:50 PM) *
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
burleson
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.
wizoracle
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
burleson
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
wizoracle
Hi BC,
Thanks a ton for the explanation.

Regards,
Mujaahid
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.