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
Karma: 0
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: 10677
Registered: March 2002
Location: oracleDocoVille
Karma: 0
Senior Member
Account Moderator
try
dbms_stats.gather_schema_stats('NSL',cascade=>true);
Previous Topic: Spool from DB table to flat file slow
Next Topic: Basic question in PT
Goto Forum:
  


Current Time: Tue Aug 22 10:03:29 CDT 2017

Total time taken to generate the page: 0.07157 seconds