Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best queries for assessing performance/speed of database

user5716448Feb 25 2015 — edited Mar 4 2015

Hi,

If not got access to Enterprise manager, are there any good queries against v$dictionary views for example which can be used to best assess speed of database.

Have access to oem for some databases and can see these via graph, top activity but if no access to oem what is best way to determine this.

For example, somebody was kicking off delete procedure and users of other systems raised performance issues with systesm.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2015
Added on Feb 25 2015
13 comments
987 views