Home » RDBMS Server » Performance Tuning » Regarding Schema Stats for CBO
Regarding Schema Stats for CBO [message #198430] Tue, 17 October 2006 02:54 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Sir sometime i faced the performance problem and i observed that the statistics for CBO are stale and i run the package
dbms_stats.gather_schema_stats('NSL');
but the problem become even much severe
Can u please guide me what could be the reason ?
thanx in advance
Re: Regarding Schema Stats for CBO [message #198448 is a reply to message #198430] Tue, 17 October 2006 04:02 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try
dbms_stats.gather_schema_stats('NSL',cascade=>true);
Previous Topic: Very low network times when retriving data from a query.
Next Topic: Fine Tuning This query
Goto Forum:
  


Current Time: Fri Dec 09 08:15:01 CST 2016

Total time taken to generate the page: 0.08604 seconds