OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Table analysed (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table analysed [message #363199]

Fri, 05 December 2008 06:18

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I am using Oracle 10g.
When i seen the last_analysed column of the dba_tables then i find that the few tables are analysed yesterday 10:00 PM.

SELECT	table_name, last_analyzed 
FROM 	dba_tables
WHERE 	OWNER IN ('TEST')

But i did not analysed those tables.
Please let me know does oracle itself analyses the tables?

Thanks,

Report message to a moderator

Re: Table analysed [message #363202 is a reply to message #363199]

Fri, 05 December 2008 06:27

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle does it for you.
Check the jobs.

Regards
Michel

Report message to a moderator

Re: Table analysed [message #363207 is a reply to message #363199]

Fri, 05 December 2008 06:33

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Thanks,

But which jobs you are telling.

Is it oracle suppled inbuild jobs?

And how they determined that object to be analysed?

Thanks,

Report message to a moderator

Re: Table analysed [message #363217 is a reply to message #363207]

Fri, 05 December 2008 06:51

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is it oracle suppled inbuild jobs?

Yes.

Quote:

And how they determined that object to be analysed?

Internal and not documented algorithm based on modification rates.

Regards
Michel

Report message to a moderator

Re: Table analysed [message #364318 is a reply to message #363199]

Sun, 07 December 2008 23:51

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Thank you so much.

Still one question is before 10g was it required to analyse table mannually?

Thanks,

Report message to a moderator

Re: Table analysed [message #364338 is a reply to message #364318]

Mon, 08 December 2008 00:54

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Only if default job does not suit the needs for your queries.

Regards
Michel

Report message to a moderator

Previous Topic:	REGARDING SYSDATE
Next Topic:	Oracle 10G schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 07:50:30 CDT 2024