Home » RDBMS Server » Performance Tuning » Performance impact on Oracle (websphere application, oracle 9 database)
Performance impact on Oracle [message #275944] Tue, 23 October 2007 08:19 Go to next message
oraclechick
Messages: 33
Registered: February 2006
Member
Hi,
How can I find out what the performance impact of an application is on an Oracle 9 database (without using Database Control)?
What I would like to know is the data per transaction and how long the transactions take?
Thanks!
Re: Performance impact on Oracle [message #275953 is a reply to message #275944] Tue, 23 October 2007 08:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read How to Identify Performance Problem and Bottleneck .

Regards
Michel
Re: Performance impact on Oracle [message #275964 is a reply to message #275953] Tue, 23 October 2007 09:05 Go to previous messageGo to next message
oraclechick
Messages: 33
Registered: February 2006
Member
Hi,
Which dynamic performance views could be used to check for the data per transaction and the time it takes for each transaction?
Thanks.
Re: Performance impact on Oracle [message #275965 is a reply to message #275964] Tue, 23 October 2007 09:12 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None.

Regards
Michel
Previous Topic: why ESTD_PHYSICAL_READS and ESTD_PHYSICAL_READ_TIME are not change in proportional in v$db_cache_a
Next Topic: Cached Cursor
Goto Forum:
  


Current Time: Mon Dec 05 08:57:04 CST 2016

Total time taken to generate the page: 0.08779 seconds