Database Tuning (MOSC)

MOSC Banner

talk about impact of "alter table .. shrink space"

edited January 2010 in Database Tuning (MOSC) 1 commentAnswered
I have read so many wonderful things about "alter table .. shrink space".

However I still hestiate to use it on our large tables since we cannot afford full table lock on the table and behind cost on the system.

In our OLTP system, the table could have billion rows, and could have over 20 transcations per second.

Can someone explain to me what kind of impact this could cause, such as on CPU, redo logs, and UNDO?

I read that the full table lock only happen at end and only for very short moment. My concern is if at same time, there are people doing insert/update, what could happend? Is it could cause any dead-lock?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center