NON-RAC db.
select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Load Profile Per Second Per Transaction
-------------------- -------------- ---------------
DB Time 7.5
DB CPU 3.6
Redo size 2,153,376.6 14,650.7
Logical reads 884,987.1 6,021.1
Block changes 10,441.6 71.0
Physical reads 732.1 5.0
Physical writes 391.0 2.7
User calls 9,141.4 62.2
Parses 4,714.1 32.1
Hard Parses .9 .0
Logons .4 .0
Executes 5,509.4 37.5
Rollbacks .0
Transactions 147.0
Applied urec 2.2 .0
I want to understand What exactly User calls and Executes suggests in above load-profile for awr snap which is taken for 30 min interval. Do they have any relation in between?
I got almost double Executes than User-calls, what does that suggest ?
A related question on awr ...Is that any script to get 'Top 5 Timed Foreground Events' section of AWR in SQLPLUS ?
PS: This thread is purely for knowledge gaining.