Home » Applications » Oracle Fusion Apps & E-Business Suite » From where Indexes are analyzed (From where Indexes are analyzed)
From where Indexes are analyzed [message #443303] Mon, 15 February 2010 00:52 Go to next message
katripon
Messages: 6
Registered: February 2010
Location: Bangladesh
Junior Member
Everyday morning I see from TOAD that indexes of per_all_people_f table have been analyzed. But, there is no gather stat was running or any other concurrent program was not running at that moment.
How I can track that indexes are analyed from which program?

Report message to a moderator

Re: From where Indexes are analyzed [message #443432 is a reply to message #443303] Mon, 15 February 2010 14:28 Go to previous message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Do you have any database scheduler to collect statistics nightly?

Report message to a moderator

Previous Topic: Dependent package of per_all_people_f table
Next Topic: Oracle 10.7 - Receivables Adjustment issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 18:15:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.