What to monitor during stress test

We want to monitor our Oracle server during a test where we submit an unusually high amount of data to the server.  On a server side, what are some of the key resources that we should monitor?  On the application side, the same.  Are there any tools out there that can be used to collect key data from Oracle?  We are using Red Hat Enterprise 5 as our OS.
NytroZAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
If you are licensed for it, I suggest AWR and ADDM through Enterprise Manager.

I suppose monitoring the application depends on things like:  What is it written in?
0
Naveen KumarProduction Manager / Application Support ManagerCommented:
Apart from the above, If you want to monitor an oracle database or unix or linix box, there are plenty of tools/utilities/resources available which you can get by search from google or any search engine.

For example, if you specific about the application monitoring - then monitoring the weblogic/app server connections, database connections to see whether they are hitting the max number of allowed connections etc can be done to avoid app not crashing/becoming unresponsive/throwing errors etc.

What kind of app is yours and what is that used for ? If we have some more information, then we can give more responses/feedback related to that one and also we can try to keep that precise with respect to the context of your question.

Thanks,
0
Geert GOracle dbaCommented:
it's always the queries, well ... in 98% of the cases it is

if you are uploading tons of data, then i would assume you have thought of parallel inserts
check the tables INITRANS parameter if you do this (default it's at 2)

http://www.proligence.com/itl_waits_demystified.html

next to that the report as slightwv suggested

or do it yourself ... way cheaper

every x seconds (we do this every second)
query the v$sql table sorted by disk_reads and buffer_gets
the queries  with the highest disk_reads and buffer_gets require attention

v$sql sorted by the field executions will give you the queries executed most
> these top ones are usually design flaws or some of them can be buffered
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

slightwv (䄆 Netminder) Commented:
If you want to go the 'free' way, I suggest Statspack.  It will do most of what is posted above and a lot more.

Oracle is trying to get away from this but it is still around.

This is a 9i doc but it should still apply up through 11gR2 (Haven't checked 12c).

http://docs.oracle.com/cd/E13160_01/wli/docs10gr3/dbtuning/statsApdx.html
0
Mark GeerlingsDatabase AdministratorCommented:
And what are you trying to learn or demonstrate with this test?  Are you trying to be prepared for an increase in data or transaction volume that you know (or hope) may happen someday soon?  Are you trying to demonstrate that your current server and storage hardware is adequate or inadequate?  What kind of application is this: transaction processing, data warehouse, a mix, etc.?  Is this a purchased application (if so, which one) or is this a custom application?  Who set up the permformance-related parameters in your Oracle parameter file?  Was that someone with a lot of experience managing Oracle on Linux for this kind of application?  What kind of storage system do you have: NAS, SAN, etc.?    Does it include some SDDs?  Does your database use Oracle's ASM feature?

Unless you can help us understand what some of the business problems are that you are trying to solve, it is very difficult for us to give you specific help.
0
NytroZAuthor Commented:
Is there a place on this site to find a consultant for projects?
0
slightwv (䄆 Netminder) Commented:
>>Is there a place on this site to find a consultant for projects?

Some Experts post that they are available for contract jobs in their profiles.

There is also a jobs board on the site:
http://careers.experts-exchange.com/
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.