OraFAQ Forum: Performance Tuning » Analysys about a single oracle table

Home » RDBMS Server » Performance Tuning » Analysys about a single oracle table (red hat linux 4/oracle 10g2)

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

Analysys about a single oracle table [message #484386]

Tue, 30 November 2010 03:57

goracle9
Messages: 136
Registered: December 2006

Senior Member

Dear all

my developer told me that a particular table giving slow response
he have me the table name

how could i analyz the particular table queary slowness
please help me

thanks

Report message to a moderator

Re: Analysys about a single oracle table [message #484393 is a reply to message #484386]

Tue, 30 November 2010 04:31

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

You don't analyze the performance of tables, you analyze the performance of queries.

Report message to a moderator

Re: Analysys about a single oracle table [message #484465 is a reply to message #484393]

Tue, 30 November 2010 18:40

Constancy
Messages: 2
Registered: November 2010
Location: China

Junior Member

You can use 'analyze table tablename compute statistics' or 'dbms_stats.gather_table_stats(user,'table_name',cascade=>true)'
to analyze the particular table for a good explain.

Report message to a moderator

Re: Analysys about a single oracle table [message #484466 is a reply to message #484465]

Tue, 30 November 2010 18:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>analyze table tablename compute statistics

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4005.htm#i2086320

when all else fails, Read The Fine Manual as above is says
"Do not use the COMPUTE and ESTIMATE clauses of ANALYZE to collect optimizer statistics. "

Report message to a moderator

Re: Analysys about a single oracle table [message #484480 is a reply to message #484466]

Tue, 30 November 2010 23:36

goracle9
Messages: 136
Registered: December 2006

Senior Member

thanks for the reply

after analyzed where could i see the report
please help me

Report message to a moderator

Re: Analysys about a single oracle table [message #484481 is a reply to message #484480]

Tue, 30 November 2010 23:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>please help me
for V10+ use DBMS_STATS

Report message to a moderator

Re: Analysys about a single oracle table [message #484531 is a reply to message #484481]

Wed, 01 December 2010 05:04

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

The analyze command and dbms_stats do not generate reports. They tell oracle to calculate statistics that the CBO uses to work out query execution plans.

Report message to a moderator

Re: Analysys about a single oracle table [message #484550 is a reply to message #484480]

Wed, 01 December 2010 08:43

Constancy
Messages: 2
Registered: November 2010
Location: China

Junior Member

You can 'set autotrace on' in sql*plus,or execute 'explain plan for sqlstatement' to see the execution plan.
You should see the syntax about of execution plan in the oracle documention.

Report message to a moderator

Previous Topic:	SQL - Query Performance
Next Topic:	Why oracle doesn't use the index?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 08:30:52 CDT 2024