 |
|
Diving
Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 1)
Oracle Tips by Mike Ault |
Monitoring and Tuning the Shared Pool
Date:
11/18/98
Page: 1
Time: 04:19
PM Users SQL Area Memory
Use SYSTEM
ORTEST1
database
Shared
Persistent
User
Text
Executions Loads Used By Bytes Bytes
--------------
------------------------------------------------------------
---------- ------ ------- ------ ----------
GRAPHICS_Remote DBA BEGIN dbms_lob.read
(:1, :2, :3, :4); END; 2121 1 0
10251 488
alter session set
nls_language= 'AMERICAN' nls_territory= 7 1
0 3975 408
'AMERICA'
nls_currency= '$' nls_iso_currency=
'AMERICA'
nls_numeric_characters= '.,' nls_calENDar=
'GREGORIAN'
nls_date_format=
'DD-MON-YY' nls_date_language=
'AMERICAN'
nls_sort=
'BINARY'
BEGIN :1 :=
dbms_lob.getLength (:2); END; 6
1 0 9290 448
SELECT
TO_CHAR(image_seq.nextval) FROM dual
6 1 0 6532 484
SELECT graphic_blob
FROM internal_graphics WHERE 2 1 0
5863 468
graphic_id=10
SELECT
RPAD(TO_CHAR(graphic_id),5)||':
1 1 0 7101 472
'||RPAD(graphic_desc,30)||' : '||RPAD(graphic_type,10)
FROM
internal_graphics
ORDER BY graphic_id
SELECT graphic_blob
FROM internal_graphics WHERE 1 1 0
6099 468
graphic_id=12
SELECT graphic_blob
FROM internal_graphics WHERE 1 1 0
6079 468
graphic_id=32
SELECT graphic_blob
FROM internal_graphics WHERE 1 1 0
6074 468
graphic_id=4
SELECT graphic_blob
FROM internal_graphics WHERE 1 1 0
5962 468
graphic_id=8
***************
------
---------
sum
67226 4640
Figure 8: Report Output Example For a Users SQL
Area
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
