Home » SQL & PL/SQL » SQL & PL/SQL » UNDOTB2 dba_free_space Increased (merged)
icon3.gif  UNDOTB2 dba_free_space Increased (merged) [message #331865] Sun, 06 July 2008 03:13 Go to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hi All,

My UNDOTB2 has increased from 4GB to 11GB in dba_free_space where as UNDOTB1 is 7GB, Do i need to worry or this is a normal behavior of Oracle 10g Rel2 , ASM database.


I appreciate all .........Have a good day
Re: UNDOTB2 dba_free_space Increased (merged) [message #331871 is a reply to message #331865] Sun, 06 July 2008 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the statements you executed.
What are UNDOTB1 and UNDOTB2? tablespaces or files?
This is the first time I saw someone worrying when free space increases!
By the way, free space (dba_free_space) for undo tablespaces is meaningless.

Regards
Michel

[Edit: add missing word]

[Updated on: Tue, 08 July 2008 03:54]

Report message to a moderator

Re: UNDOTB2 dba_free_space Increased (merged) [message #332317 is a reply to message #331871] Tue, 08 July 2008 03:35 Go to previous message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hi Michel,

Thanks for your keen observation............
Previous Topic: Order by Case and Union All
Next Topic: DATE FORMAT
Goto Forum:
  


Current Time: Mon Dec 05 19:09:33 CST 2016

Total time taken to generate the page: 0.11679 seconds