Database DataWarehousing (MOSC)

MOSC Banner

USING DEFAULT LOCAL ROLLBACK SEGMENT

edited Jun 11, 2010 4:13AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 Hi,
DB Version is 10.2.0.4

Recently Noticed a MV refresh taking various time to complete. The MV refresh starts at 9pm and completes some time at 1am or 12am are sometimes very fast at 10pm. The number of records are almost same. There are no locks in the db during that time.. Opening the MV script i could see

	REFRESH COMPLETE
	WITH ROWID
 USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS
	


Using default local rollback segment - is that allocation of rollback segment causes this

Referred the manul

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6002.htm - where it says this clause is not valid if the DB is in automatic undo mode.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

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