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

Report message to a moderator

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: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try
dbms_stats.gather_schema_stats('NSL',cascade=>true);

Report message to a moderator

Previous Topic: Very low network times when retriving data from a query.
Next Topic: Fine Tuning This query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 06 16:02:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.