OraFAQ Forum: Performance Tuning » best strategy to gather statistics in a very dynamic

Home » RDBMS Server » Performance Tuning » best strategy to gather statistics in a very dynamic

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

best strategy to gather statistics in a very dynamic [message #131953]

Wed, 10 August 2005 02:46

peterzaweber
Messages: 2
Registered: August 2005

Junior Member

Hi,

We have a "cache" database, that is used to merge data from different applications and present them to a web front end. Most of the data is purged from the database at night. This means, that we have many transactions during the day, and the the amount of data grows during a working day.

In addition we need DB statistics to make sure, that the application performance is acceptable. ... and we will migrate soon from Oracle 8i to Oracle 10g.

Does anyone have experience or ideas, what the best strategy would be to gather db/system statistics within Oracle 10g for such a system.

Thank you very much for your help
Peter

Report message to a moderator

Re: best strategy to gather statistics in a very dynamic [message #132020 is a reply to message #131953]

Wed, 10 August 2005 07:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. Look into dynamic sampling.
2. Enable Table monitoring.
sql> alter table table_name monitoring;
Then
your table will be analyzed only if there is a certain percentage of changes.
In your dbms_stats use GATHER STALE
3. Look into GATHER_SYTEM_STATS.

Report message to a moderator

Re: best strategy to gather statistics in a very dynamic [message #132039 is a reply to message #132020]

Wed, 10 August 2005 08:26

peterzaweber
Messages: 2
Registered: August 2005

Junior Member

Thank you for your reply.

That's what I did plan in the first place. But I thought this 'monitoring' is not possible any more with Oracle 10g.

Am I wrong about this?

Report message to a moderator

Re: best strategy to gather statistics in a very dynamic [message #132041 is a reply to message #132039]

Wed, 10 August 2005 08:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Thanks for pointing that.
You are right.
Monitoring option is depreciated in 10g.
The right approach would be enabling automatic satistics gathering.

Report message to a moderator

Previous Topic:	How manage over 8GB memory
Next Topic:	Index & Performance Tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 16:16:16 CST 2024