OraFAQ Forum: Performance Tuning » Performance impact on Oracle

Home » RDBMS Server » Performance Tuning » Performance impact on Oracle (websphere application, oracle 9 database)

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

Performance impact on Oracle [message #275944]

Tue, 23 October 2007 08:19

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!

Report message to a moderator

Re: Performance impact on Oracle [message #275953 is a reply to message #275944]

Tue, 23 October 2007 08:42

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read How to Identify Performance Problem and Bottleneck .

Regards
Michel

Report message to a moderator

Re: Performance impact on Oracle [message #275964 is a reply to message #275953]

Tue, 23 October 2007 09:05

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.

Report message to a moderator

Re: Performance impact on Oracle [message #275965 is a reply to message #275964]

Tue, 23 October 2007 09:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

None.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:57:43 CST 2024