RE: recently migrated 8i to 9i switch memory configuration

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Wed, 25 Aug 2004 14:53:08 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8CBE@dohsmail02.doh.ad.state.fl.us>

Guys,

I have recently migrated several databases from 8i to 9i. I am = interested in "trying" dynamic SGA memory management, workarea_policies = and pga_aggregate_target. What is the best way to "benchmark" = performance before and after to determine the impact on my systems? = What if I have limited access to users for the database I support and it = is a COTS package with limited communication from developers? I love to = have input and involvement from users and developers but that isn't = always politically possible. So how can I best monitor/benchmark = independently?

10046 traces???
Oracle's built-in advisors??
Queries against the v$ views?
statspack?? - which I understand is not preferred as it isn't quite = reliable.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Aug 25 2004 - 14:24:46 CDT