Home » RDBMS Server » Performance Tuning » GATHERING STATISTICS
GATHERING STATISTICS [message #333423] Fri, 11 July 2008 11:23 Go to next message
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?
Re: GATHERING STATISTICS [message #333425 is a reply to message #333423] Fri, 11 July 2008 11:27 Go to previous messageGo to next message
BlackSwan
Messages: 25039
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.
Re: GATHERING STATISTICS [message #333430 is a reply to message #333425] Fri, 11 July 2008 11:30 Go to previous messageGo to next message
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.
COMPUTE STATISTICS [message #333431 is a reply to message #333423] Fri, 11 July 2008 11:35 Go to previous messageGo to next message
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?
Re: GATHERING STATISTICS [message #333432 is a reply to message #333423] Fri, 11 July 2008 11:36 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
What has changed?
When was response time OK?
Re: GATHERING STATISTICS [message #333433 is a reply to message #333430] Fri, 11 July 2008 11:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
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
Re: GATHERING STATISTICS [message #333571 is a reply to message #333423] Sat, 12 July 2008 17:46 Go to previous message
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.
Previous Topic: Bind variable in a data warehouse
Next Topic: Create Index ?
Goto Forum:
  


Current Time: Tue Dec 06 06:41:47 CST 2016

Total time taken to generate the page: 0.05878 seconds