MIHIR KAR
asked on
Oracle_AWR_read_process
Hi Expert,
I'm working with production Oracle DB, which runs 24/7 basics, there are thousands of transaction running parallel everyday, i have seen many oracle jobs are running more than expect, i tried analyze them by "AWR" report but unable to trace the bottleneck.
Could you please guide me steps to read "AWR" for getting the session bottleneck.
Your Advice always valuable.
Thanks in Advance.
I'm working with production Oracle DB, which runs 24/7 basics, there are thousands of transaction running parallel everyday, i have seen many oracle jobs are running more than expect, i tried analyze them by "AWR" report but unable to trace the bottleneck.
Could you please guide me steps to read "AWR" for getting the session bottleneck.
Your Advice always valuable.
Thanks in Advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it looks like you have a developer who wants the optimizer not to be used
i bet it would all run way better if all those hints were switched off
or you can use 1 hint:
/*+ RULE */
beats all the other hints anytime anywhere ...
i bet it would all run way better if all those hints were switched off
or you can use 1 hint:
/*+ RULE */
beats all the other hints anytime anywhere ...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and besides all that, the database was telling it's connected clients it wanted more work, cos it was idle
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:1860804200346441327
SQL*Net message from client 409,952 0 3,971,127 9687 0.08
or you have a lot of connected clients which are reading the paper or having a very long coffee break, probably all night
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:1860804200346441327
SQL*Net message from client 409,952 0 3,971,127 9687 0.08
or you have a lot of connected clients which are reading the paper or having a very long coffee break, probably all night
RULE would only work better if there is proper indexing. Given the number of parallel hints, I would guess it probably isn't. RULE also doesn't do a very good job if things are over-indexed.
Given the time of day, idle clients aren't surprising. People can't be bothered to log out when they leave.
Given the time of day, idle clients aren't surprising. People can't be bothered to log out when they leave.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please find the attachment for html format of the AWR report .
Thank You!!
awr_report_40498_40501.html