Home » RDBMS Server » Performance Tuning » DBA_FREE_SPACE view in 10g taking more time
DBA_FREE_SPACE view in 10g taking more time [message #184803] Fri, 28 July 2006 02:09 Go to next message
vvoracle
Messages: 3
Registered: July 2006
Junior Member
Hi,

My SQL queires that are using DBA_FREE_SPACE view is taking more time to execute on 10g environment. I am seeing this behaviour
with 10.2.0.2 version.

I just would like to know from the forum if anyone of you have come acrross the same problem.

Regards,
vasu

Report message to a moderator

Re: DBA_FREE_SPACE view in 10g taking more time [message #184865 is a reply to message #184803] Fri, 28 July 2006 06:27 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A known issue ( well, it depends on how you use the sql).
Did you already try this?
http://www.jlcomp.demon.co.uk/faq/freespace3.html

Report message to a moderator

Previous Topic: Getting queries
Next Topic: hints required
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 01:28:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.