Hi all, One of our table reached m 1

[shantanu125]

Hi all,
One of our table reached maximum extent and then I modified its extent to unlimited.The time during which I sent the fix my client's work was halted.I want to ask experts can I safely inrease the extent of all tables to unlimited without creating any problem in future.
Please suggest
Shantanu

 

[karluk]

It's tempting to set extents to unlimited, but I would recommend against it. You never know when an application error will result in a runaway process that repeatedly inserts data until the table fills up an entire disk.

In my opinion a better approach would be to run a job weekly or monthly that checks to see if any tables or indexes are within, say, 10% of their maximum extents. You can then adjust the max extents for just those tables that are close to running out of space.

 

[sem]

On Oracle 9i you may also safely add extents while client is waiting for your assistance by using
ALTER SESSION ENABLE RESUMABLE.

 

[shantanu125]

Hi,
Thanx Karluk... ur suggestion is right.... I will write a script that is to be run monthly to get information about present extent level of tables ......
shantanu

 

[Georgdba]

One way more is to modify the storage parameter of that Tables/idxes which will grow extraordinary (because migration and defragmentation).

Georgdba