Re: CPU Per Exec - SQL Ordered By CPU Time
- From: Oracle Dba Wannabe <oracledbawannabe@xxxxxxxxx>
- To: vandreev@xxxxxxxxx
- Date: Thu, 25 Nov 2010 06:24:53 -0800 (PST)
thanks - which we could say is brought on by the increase in cpu utilization
that has resulted from an increase in executions of all sql's due to the
increased number of users (user count increased by about 400 during this
interval)? Utilization is seen about 75% peak at 100% (for short intervals).
________________________________
From: Vladimir Andreev <vandreev@xxxxxxxxx>
To: oracledbawannabe@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Sent: Thu, November 25, 2010 4:27:02 PM
Subject: Re: CPU Per Exec - SQL Ordered By CPU Time
I'm wondering what would cause the CPU per Exec to be greater during the Peak
time?
Latch spinning might explain (part of) the difference.
Flado
Other related posts:
