Do you have stress queries
573339Jun 12 2007 — edited Jun 14 2007Hi Gurus.
We are in the process of testing 10g migration from 9i.
We do not have a real test set up with full volume of data
and load. The Company entrusted with me the smooth
migration from 9i to 10g. In the absense of proper testing
situation, I plan to do the following :
1) Collected tkprof of important sqls found in
v$sql area (highest disk reads)
2) Did explain plan with old stats and production stats
3) Run a long running queries now it is running for the
past 3 days with 16% cpu utilisation
4) Now I seek advise from you is there any standard
sqls that can be used to measure cpu time,elapsed time,
memory usage, i/o waits.
If you provide 4 above, I will open atleast 20 session and take
the system,session statistics and records it. After 10g
migration, I will run the same queries and find the difference. Hope
this is the best I can do to satisfy that load is not abnormal
after migration.
S.D. RAVICHANDRAN
Verizon.