OraFAQ Forum: Performance Tuning » GATHERING STATISTICS

Home » RDBMS Server » Performance Tuning » GATHERING STATISTICS

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

GATHERING STATISTICS [message #333423]

Fri, 11 July 2008 11:23

acarella
Messages: 21
Registered: July 2008
Location: Latham, NY

Junior Member

I have a performance issue on a table

T_PROD_DATA

with fields

f_product
f_data_code
f_data
f_date_for_date_type
f_user_updated
f_date_stamp

I have done the following at the sql prompt

ANALYZE TABLE T_PROD_DATA COMPUTE STATISTICS;

table analyzed was returned.

what do I do next?

Report message to a moderator

Re: GATHERING STATISTICS [message #333425 is a reply to message #333423]

Fri, 11 July 2008 11:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

http://www.orafaq.com/forum/t/84315/74940/
which of the suggestions in URL above have you tried & what were the results?

>I have a performance issue on a table
No you do NOT!
You may have a performance issue with some SQL; which you did NOT provide.

Report message to a moderator

Re: GATHERING STATISTICS [message #333430 is a reply to message #333425]

Fri, 11 July 2008 11:30

acarella
Messages: 21
Registered: July 2008
Location: Latham, NY

Junior Member

correct.
I have a performance issue on some sql.

I have not done this before. the oracle dba is on vacation.
I was reading from an oracle book, which I ran the ANALYZE statement on a table.

it analyzed the table.
I don't know where I go from there.
And, I need to ask the customer rep about the sql statement.

Report message to a moderator

COMPUTE STATISTICS [message #333431 is a reply to message #333423]

Fri, 11 July 2008 11:35

acarella
Messages: 21
Registered: July 2008
Location: Latham, NY

Junior Member

I need to compute statistics on a table.
Can you explain how to do this.

I have done the following:

ANALYZE TABLE T_PROD_DATA COMPUTE STATISTICS;

Where do I go to view the results or what do I do from here?

Report message to a moderator

Re: GATHERING STATISTICS [message #333432 is a reply to message #333423]

Fri, 11 July 2008 11:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What has changed?
When was response time OK?

Report message to a moderator

Re: GATHERING STATISTICS [message #333433 is a reply to message #333430]

Fri, 11 July 2008 11:37

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

Senior Member
Account Moderator

Quote:

I was reading from an oracle book, which I ran the ANALYZE statement on a table.

Which is a bad idea as obsolete, you should buy a new book.

Quote:

I don't know where I go from there.

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

Report message to a moderator

Re: GATHERING STATISTICS [message #333571 is a reply to message #333423]

Sat, 12 July 2008 17:46

Kriptas
Messages: 118
Registered: June 2008

Senior Member

please describe table and query with performance issue.
how meny rows, indexes, what you selecting (query), query time and execution plan.

Report message to a moderator

Previous Topic:	Bind variable in a data warehouse
Next Topic:	Create Index ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 20:14:52 CDT 2024