In-depth discussion on Shared Pool (4)
Link: http://www.eygle.com/internal/shared_pool-4.htm
Let's discuss the processing of Shared Pool:
Advance the corresponding query, get test data:
[Oracle @ Jumper Udump] $ SQLPLUS "/ as sysdba"
SQL * Plus: Release 9.2.0.3.0 - Production on Th twu aug 26 10:21:54 2004
CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.3.0 - Production
With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS
JServer Release 9.2.0.3.3.0 - PRODUCTION
SQL> Connect Eygle / Eygle
Connected.
SQL> CREATE TABLE EMP AS SELECT * from scott.emp;
Table created.
SQL>
SQL> Connect / as sysdba
Connected.
SQL> Startup force;
Oracle Instance Started.
Total System Global Area 47256168 Bytes
Fixed size 451176 bytes
Variable size 29360128 bytes
Database buffers 16777216 BYTES
Redo buffers 667648 bytes
Database mounted.
Database opened.
SQL> SET LINESIZE 120
SQL> Connect Scott / Tiger
Connected.
SQL> SELECT * FROM EMP;
Empno ename Job Mgr Hiredate Sal Comm Deptno
---------- ------------------------------------- -------- --------------------
7369 Smith Clerk 7902 17-DEC-80 800 20
8888 Eygle Manager 11-Aug-04 9999 10 10
7566 Jones Manager 7839 02-APR-81 2975 20
7698 Blake Manager 7839 01-MAY-81 2850 30
7782 Clark Manager 7839 09-JUN-81 2450 10
7788 Scott Analyst 7566 19-APR-87 3000 20
7839 King President 17-NOV-81 5000 107876 Adams Clerk 7788 23-May-87 1100 20
7900 James Clerk 7698 03-DEC-81 950 30
7902 Ford Analyst 7566 03-DEC-81 3000 20
7934 Miller Clerk 7782 23-JAN-82 1300 10
11 rows selected.
SQL> Connect Eygle / Eygle
Connected.
SQL> SELECT * FROM EMP;
Empno ename Job Mgr Hiredate Sal Comm Deptno
---------- ------------------------------------- -------- --------------------
7369 Smith Clerk 7902 17-DEC-80 800 20
8888 Eygle Manager 11-Aug-04 9999 10 10
7566 Jones Manager 7839 02-APR-81 2975 20
7698 Blake Manager 7839 01-MAY-81 2850 30
7782 Clark Manager 7839 09-JUN-81 2450 10
7788 Scott Analyst 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7876 Adams Clerk 7788 23-May-87 1100 20
7900 James Clerk 7698 03-DEC-81 950 30
7902 Ford Analyst 7566 03-DEC-81 3000 20
7934 Miller Clerk 7782 23-JAN-82 1300 10
11 rows selected.
SQL> SELECT SQL_TEXT, VERSION_COUNT, HASH_VALUE, TO_CHAR (Hash_Value, 'XXXXXXXXX') HEX, Address
2 from v $ sqlarea where sql_text limited 'SELECT * ex%';
SQL_Text Version_Count Hash_Value Hex Address -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------
Select * from EMP 2 2648707557 9DE011E5 52D9EA28
SQL> SELECT SQL_TEXT, UserName, Address, Hash_Value, TO_CHAR (HASH_VALUE, 'XXXXXXXXX') HEX_HASH_VALUE, Child_Number, Child_Latch
2 from V $ SQL A, DBA_USERS B Where A.Parsing_user_id = B.user_id and sql_text limited 'SELECT * FROM EMP%'
SQL_TEXT UserName Address Hash_Value Hex_hash_va child_number child_latch
------------------------------------------------------------------------------- -------- ----------------------------- -
SELECT * FROM EMP Scott 52d9EA28 2648707557 9DE011E5 0 1
Select * from Emp Eygle 52D9EA28 2648707557 9DE011E5 1 1
Note: Here we can see the difference between V $ SQLAREA and V $ SQL.
V $ SQL reserves an entry for each SQL, and V $ SQLAREA is based on SQL_Text, and the number of child pointers is calculated through the Version_Count.
We noticed that these two SQL statements are identical because their code is identical, so their address, hash_value is exactly the same.
This means that the two SQL statements are the same in the storage location in Shared Pool (although their execution plan may be different), the code is shared.
In this process, Oracle completed the first step of SQL parsing: grammar analysis
Oracle follows the principle of right-left and bottom-up, if you find a syntax error, you will return an error.
After the syntax check, Oracle converts SQL text to the corresponding ASCII value, then calculate its Hash_Value based on the value via the Hash function.
Looking for whether there is the same SQL statement in Shared Pool, if you exist, go to the next step; if you don't exist, try to get shared pool latch
Request memory, store the SQL code
There is a problem here, you need to explain:
Since the ASCII value of the uppercase letter is different, Oracle will use different code to handle the code as a different SQL, let's take a look at the test:
SQL> SELECT * from scott.dept;
DEPTNO DNAME LOC
---------- ---------------------------
10 Accounting New York
20 Research Dallas
30 Sales Chicago
40 Operations Boston
SQL> SELECT * from scott.dept;
DEPTNO DNAME LOC
---------- ---------------------------
10 Accounting New York20 Research Dallas
30 Sales Chicago
40 Operations Boston
SQL> COL SQL_TEXT FOR A30
SQL> SELECT SQL_TEXT, HASH_VALUE FROM V $ SQL Where SQL_TEXT LIKE 'SELECT * from SCOTT%';
SQL_TEXT HASH_VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * from scott.dept 4096614922
Select * from scott.dept 2089404358
We noticed that only the difference between case, makes the same SQL statement into two "different code"
So from here we can see that SQL's standardization is very important.
After completing this step, Oracle needs to perform semantic analysis:
In this step, Oracle needs to verify that the object exists, whether the relevant user has permission, whether the reference is the same object ...
For our first query, actually the EMP table comes from different users, then the execution plan of SQL is different.
Of course, there are many factors affecting the SQL execution plan, including optimizer mode, etc.
SQL> SELECT a. *, To_char (to_hash, 'xxxxxxxxx') HEX_HASH_VALUE
2 from V $ Object_dependency a where to_name = 'EMP'
From_add from_hash t_owner to_name to_addre to_hash to_type hex_hash_va
-------- -------------------------------------------------------------------------------------------------------------------------------------------------- -------- -----------------------------------
52D9EA28 264870755 SCOTT EMP 52D9DEBC 828228010 2 315DC1AA
52D9EA28 264870755 Eygle EMP 52D82E58 1930491453 2 7310F63D
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 1';
Session altered.
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 2';
Session altered.
SQL> Alter Session Set Events 'Immediate Trace Name Library_Cache Level 4';
Session altered.
SQL> Alter Session Set Events 'Immediate Trace Name Library_Cache Level 8';
Session altered.
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 16';
Session altered.
SQL> Alter Session Set Events 'Immediate Trace Name Library_Cache Level 32'; session altered.
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 100';
Session altered.
The Shared Pool is dumped here at different levels.
Before turning to the trace file, we look at the structure of library cache through the following figure:
Library Cache Handle points to Library Cache Object, contains object names, Namespace, timestamp, reference list, lock object, and PIN object list.
We look at the specific information from the Dump file, from the above V $ SQL view we get the above Query Hash_Value is 9DE011E5, address is 52D9EA28
In Bucket 4851, we found the SQL statement of SELECT * from EMP.
BUCKET 4581:
Library Object Handle: Handle = 52D9EA28
Name = SELECT * FROM EMP
Hash = 9DE011E5 TIMESTAMP = 08-26-2004 10:24:43
==> This HASH is the Hash_Value value of the SQL statement in V $ SQL.
Namespace = CRSR FLAGS = RON / TIM / PN0 / SML / [12010000]
KKKK-DDDD-LLLL = 0000-0001-0001 Lock = 0 PIN = 0 LATCH # = 1
LWT = 0x52d9EA40 [0x52d9EA40, 0X52D9EA40] LTM = 0x52d9ea48 [0x52d9ea48, 0x52d9ea48]
PWT = 0x52d9ea58 [0x52d9ea58, 0x52d9ea58] PTM = 0x52d9eab0 [0x52d9eab0, 0x52d9eab0]
Ref = 0x52d9ea30 [0x52d9ea30, 0x52d9ea30] LND = 0x52d9eabc [0x52d9eabc, 0x52d9eabc]
Library Object: Object = 52d9E7B0
TYPE = CRSR FLAGS = EXS [0001] pflags = [00] status = VALD LOAD = 0
Children: size = 16
Child # Table Reference Handle
------ ------------------------
0 52D9E96C 52D9E6CC 52D9E4AC
1 52D9E96C 52D9E70C 52D885CC
==> This is the child pointer mentioned before, each pointing to a different Handle
Data Blocks:
Data # Heap Pointer Status Pins Change Alloc (K) Size (K)
------------ --------------------- ---
0 52D9E9B8 52D9E838 I / - / A 0 none 0.86 1.09
==> The HEAP here refers to the memory address.
==> This is SQL code and user connection information
HEAP Dump of Data Block 0:
*********************************************************** ****
Heap dump head name = "library cache" desc = 0x52d9e9b8EXtent SZ = 0x224 alt = 32767 HET = 16 REC = 9 flg = 2 OPC = 0
Parent = 0x5000002c oowner = 0x52d9e7b0 nex = (nil) xsz = 0x224
EXTENT 0 AddR = 0x52d9E558
Chunk 52d9e560 SZ = 540 Perm "Perm" alo = 448
52D9E560 5000021D 00000000 52D9E7A0 000001C0 [... p ....... r ....]
52D9E570 52D9E704 52D9E660 00020002 52D9E57C [... r`r .... | ..r]
52D9E580 52D9E57C 00000000 52D9E588 52D9E588 [| .r ....... r ... r]
52D9E590 00000000 52D9E594 52D9E594 000000 [....... r ... r ....]
52D9E5A0 52D9E5A0 52D9E5A0 00000000 52D9E5AC [... r ... r ....... r]
52D9E5B0 52D9E5AC 00000000 52D9E5B8 52D9E5B8 [... r ....... r ... r]
52D9E5C0 00000000 52D9E5C4 52D9E5C4 00000000 [....... r ... r ....]
52D9E5D0 52D9E5D0 52D9E5D0 00000000 52D9E5DC [... r ... r ....... r]
52D9E5E0 52D9E5DC 00000000 52D9E5E8 52D9E5E8 [... r ....... r ... r]
52D9E5F0 00000000 52D9E5F4 52D9E5F4 00000000 [....... r ... r ....]
52D9E600 52D9E600 52D9E600 00000000 52D9E60C [... r ... r ....... r]
52D9E610 52D9E60C 00000000 52D9E618 52D9E618 [... r ....... r ... r]
52D9E620 00000000 52D9E624 52D9E624 00000000 [.... $ .. r $ .. r ....]
52D9E630 52D9E630 52D9E630 00040004 00000000 [0..R0..r ........]
52D9E640 52D9E6E4 00000018 00000000 00000000 [... r ............]
52D9E650 00000000 00000000 52D9E63C 00000000 [....... <.. r ....]
52D9E660 52D9E570 52D9E704 00000000 000,000 [p..r ... r ........]
52D9E670 00000000 52D9E6BC 00000010 00000004 [....... r ........]
52D9E680 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D9E6B0 00000000 00000000 00000000 52D9E96C [............ l..r]
52D9E6C0 00000000 00000000 00000000 52D9E4B4 [............... r]
52D9E6D0 52D9E4B4 52D9E4AC 00000000 00000002 [... r ... r ........] 52D9E6E0 00000000000000 00010018 00000001 [................]
52D9E6F0 00000000 聽 0000000 000,00000 52D9E6E0 [............... r]
52D9E700 00000000 52D9E660 52D9E570 52D885D4 [.... `..rp..r ... r]
52D9E710 52D885D4 52D885CC 00000000 00000002 [... r ... r ........]
52D9E720 00000000 00000000 000,000 00000000 [................]
Repeat 4 Times
52D9E770 00000000 00000000 00000000 [............]
Extent 1 addr = 0x52d9e798
CHUNK 52D9E7A0 SZ = 360 Perm "Perm" alo = 360
52D9E7A0 40000169 00000000 00000000 000168 [i .. @ ........ h ...]
52D9E7B0 52D9EA28 52D9E7B4 52D9E7B4 52D9E7BC [(.r ... r ... r ... r]
52D9E7C0 52D9E7BC 52D9E668 00000000 00010001 [... rh..r ........]
52D9E7D0 00000000 000000000000000000000000 [................]
52D9E7E0 52D9E824 00000000 00000000 000,000 [$ .. r .........
52D9E7F0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D9E820 00000000 52D9E9B8 00000000 52D9E838 [....... r .... 8..r]
52D9E830 00000000 52FF79A4 00080304 00000000 [..... Y.R ........]
52D9E840 00000000 000000000000000000000010 [................]
52D9E850 00000004 00000000 000,000 00000000 [................]
52D9E860 00000000 52D9E640 00000002 2A4C5153 [.... @ .. r .... sql *]
52D9E870 73756C50 706D756A 682E7265 61727275 [Plusjumper.hurra]
52D9E880 6F632E79 6E632E6D 4E542820 31562053 [Y.com.cn (TNS V1]
52D9E890 2933562D 00000000 00000000 00000008 [-V3) ............]
52D9E8A0 daBefa60 00000000 0000000000 000,00000 [`...............]
52D9E8B0 00000000 00000000 0000000000000000 [................]
52D9E8C0 00000000 00000000 F0318558 52D9E8D8 [........ X.1 .... r]
52D9E8D0 52D9E630 00000000 52D9E570 00000000 [0..r .... p..r ....] 52D9E8E0 000000000000000000000000000000 [................]
52D9E8F0 00000000 00000000 0000002 000000D [................]
52D9E900 00000001 00000000 [.......]
CHUNK 52D9E908 SZ = 88 Free ""
52D9E900 C0000059 52D9E7A0 [Y ... r]
52D9E910 52D9EA00 52D9EA00 00000000 000,000 [... r ... r ........]
52D9E920 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
Chunk 52d9e960 sz = 76 Freeable "kgltbtab"
52D9E960 1000004D 52D9E908 0A857928 52D9E6CC [m ..... r (y ..... r]
52D9E970 52D9E70C 00000000 00000000 000,000 [... r ..........]
52D9E980 00000000 00000000 00000000 000,00000 [................]
Repeat 1 Times
52D9E9A0 00000000 00000000 00000000 [............]
Total Heap Size = 1064
Free Lists:
BUCKET 0 size = 0
CHUNK 52D9E908 SZ = 88 Free ""
52D9E900 C0000059 52D9E7A0 [Y ... r]
52D9E910 52D9EA00 52D9EA00 00000000 000,000 [... r ... r ........]
52D9E920 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
Total Free Space = 88
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
Chunk 52d9e560 SZ = 540 Perm "Perm" alo = 448
52D9E560 5000021D 00000000 52D9E7A0 000001C0 [... p ....... r ....]
52D9E570 52D9E704 52D9E660 00020002 52D9E57C [... r`r .... | ..r]
52D9E580 52D9E57C 00000000 52D9E588 52D9E588 [| .r ....... r ... r]
52D9E590 00000000 52D9E594 52D9E594 000000 [....... r ... r ....]
52D9E5A0 52D9E5A0 52D9E5A0 00000000 52D9E5AC [... r ... r ....... r] 52D9E5B0 52D9E5AC 00000000 52D9E5B8 52D9E5B8 [... r ....... r ... r]
52D9E5C0 00000000 52D9E5C4 52D9E5C4 00000000 [....... r ... r ....]
52D9E5D0 52D9E5D0 52D9E5D0 00000000 52D9E5DC [... r ... r ....... r]
52D9E5E0 52D9E5DC 00000000 52D9E5E8 52D9E5E8 [... r ....... r ... r]
52D9E5F0 00000000 52D9E5F4 52D9E5F4 00000000 [....... r ... r ....]
52D9E600 52D9E600 52D9E600 00000000 52D9E60C [... r ... r ....... r]
52D9E610 52D9E60C 00000000 52D9E618 52D9E618 [... r ....... r ... r]
52D9E620 00000000 52D9E624 52D9E624 00000000 [.... $ .. r $ .. r ....]
52D9E630 52D9E630 52D9E630 00040004 00000000 [0..R0..r ........]
52D9E640 52D9E6E4 00000018 00000000 00000000 [... r ............]
52D9E650 00000000 00000000 52D9E63C 00000000 [....... <.. r ....]
52D9E660 52D9E570 52D9E704 00000000 000,000 [p..r ... r ........]
52D9E670 00000000 52D9E6BC 00000010 00000004 [....... r ........]
52D9E680 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D9E6B0 00000000 00000000 00000000 52D9E96C [............ l..r]
52D9E6C0 00000000 00000000 00000000 52D9E4B4 [............... r]
52D9E6D0 52D9E4B4 52D9E4AC 00000000 00000002 [... r ... r ........]
52D9E6E0 00000000 00000000 00010018 00000001 [................]
52D9E6F0 00000000 聽 0000000 000,00000 52D9E6E0 [............... r]
52D9E700 00000000 52D9E660 52D9E570 52D885D4 [.... `..rp..r ... r]
52D9E710 52D885D4 52D885CC 00000000 00000002 [... r ... r ........]
52D9E720 00000000 00000000 000,000 00000000 [................]
Repeat 4 Times
52D9E770 00000000 00000000 00000000 [............]
CHUNK 52D9E7A0 SZ = 360 Perm "Perm" alo = 360
52D9E7A0 40000000000 00000000000000 0000000000000000 000000000000 00000000 0000168 [i .. @ ........ h ... 52d9e7b0 52d9ea28 52d9e7b4 52d9e7b4 52d9e7bc [(.r ... r ... r ... r]
52D9E7C0 52D9E7BC 52D9E668 00000000 00010001 [... rh..r ........]
52D9E7D0 00000000 000000000000000000000000 [................]
52D9E7E0 52D9E824 00000000 00000000 000,000 [$ .. r .........
52D9E7F0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D9E820 00000000 52D9E9B8 00000000 52D9E838 [....... r .... 8..r]
52D9E830 00000000 52FF79A4 00080304 00000000 [..... Y.R ........]
52D9E840 00000000 000000000000000000000010 [................]
52D9E850 00000004 00000000 000,000 00000000 [................]
52D9E860 00000000 52D9E640 00000002 2A4C5153 [.... @ .. r .... sql *]
52D9E870 73756C50 706D756A 682E7265 61727275 [Plusjumper.hurra]
52D9E880 6F632E79 6E632E6D 4E542820 31562053 [Y.com.cn (TNS V1]
52D9E890 2933562D 00000000 00000000 00000008 [-V3) ............]
52D9E8A0 daBefa60 00000000 0000000000 000,00000 [`...............]
52D9E8B0 00000000 00000000 0000000000000000 [................]
52D9E8C0 00000000 00000000 F0318558 52D9E8D8 [........ X.1 .... r]
52D9E8D0 52D9E630 00000000 52D9E570 00000000 [0..r .... p..r ....]
52D9E8E0 00000000 000000000000000000000000 [................]
52D9E8F0 00000000 00000000 0000002 000000D [................]
52D9E900 00000001 00000000 [.......]
Permanent Space = 900
*********************************************************** ****
BUCKET 4581 Total Object Count = 1
We look at the structure of Library Cache Object as a case: Take the Handle: 52D885CC:
*********************************************************** ****
Library Object Handle: Handle = 52D885CC
Namespace = CRSR FLAGS = RON / KGHP / PN0 / [10010000]
KKKK-DDDD-LLLL = 0000-0041-0041 lock = 0 pin = 0 latch # = 1LWT = 0x52d885E4 [0x52d885e4, 0x52d885e4] ltm = 0x52d885ec [0x52d885ec, 0x52d885ec]
PWT = 0x52d885fc [0x52d885fc, 0x52d885fc] PTM = 0x52d88654 [0x52d88654, 0x52d88654]
Ref = 0x52d885d4 [0x52d9e70c, 0x52d9e70c] LND = 0x52d88660 [0x52d88660, 0x52d88660]
Library Object: Object = 52d82a24
TYPE = CRSR FLAGS = EXS [0001] pflags = [00] status = VALD LOAD = 0
Dependencies: count = 1 size = 16
Dependency # Table Reference Handle Position Flags
------------------------------------ -------------
0 52D82BE0 52D82B20 52D82E58 14 dep [01]
==> We saw this Cursor-dependent object at the Dependency section, Handle: 52D82E58
==> This handle point is an Eygle.EMP table, if the above two CRSR access is the same object, then
==> These two SQL will be real sharing. Here our SQL is the same, the access is the data sheet for different users.
==> The concept of child pointer is coming out.
==> Here we see 52D82E58 points to the Eygle.emp object, that is, the data table queryed by Eygle.
Accesses: count = 1 size = 16
Dependency # types
----------- -----
0 0009
TRANSLATIONS: count = 1 size = 16
Original Final
-------- --------
52D82E58 52D82E58
Data Blocks:
Data # Heap Pointer Status Pins Change Alloc (K) Size (K)
------------ --------------------- ---
0 52D8C244 52D827E4 I / - / A 0 none 1.09 1.64
6 52D82AC0 52D817C4 I / - / A 0 None 3.70 3.73
==> Data Blocks here is an important part
==> Each control block contains a Heap Descriptor, pointing to the corresponding Heap Memory, this Heap Memory is included.
==> Diana Tree, P-CURE, SOURCE CODE, Shared Cursor Context Area, etc., it is usually
==> What is said, the parsed SQL and the implementation plan, the SQL is only shared after it is true here. Just avoid hard
==> Analysis
HEAP Dump of Data Block 0:
*********************************************************** ****
Heap dump head name = "library cache" desc = 0x52d8c244EXtent SZ = 0x224 alt = 32767 HET = 16 REC = 9 flg = 2 OPC = 0
Parent = 0x5000002c Owner = 0x52d82a24 nex = (nil) xsz = 0x224
Extent 0 AddR = 0x52D80FF0
CHUNK 52D80FF8 SZ = 464 free ""
52D80FF0 C00001D1 00000000 [........]
52D81000 52D8C28C 52D8C28C 00000000 00000000 [... r ... r ........]
52D81010 00000000 million 00000000 [................]
REPEAT 26 TIMES
52D811C0 00000000 00000000 [.......]
Chunk 52D811C8 SZ = 76 Freeable "KGLTBTAB"
52D811C0 1000004D 52D80FF8 [m ... r]
52D811D0 0A857928 52D82B68 00000000 00000000 [(Y..h .r ........]
52D811E0 00000000 000000000000000000000000 [................]
Repeat 2 Times
52D81210 00000000 [....]
Extent 1 addr = 0x52d827cc
CHUNK 52D827D4 SZ = 540 Perm "Perm" alo = 532
52D827D0 5000021D 00000000 52D82A14 [... p ..... *. R]
52D827E0 0000000014 00000000 0000001A 00000069 [........... I ...]
52D827F0 00000000000000000000000000000006 [................]
52D82800 00000850 00000010 00000008 00000005 [P ...............]
52D82810 00000005 4C475945 00000045 00000000 [.... Eygle .......]
52D82820 00000000 00000000 000,000 00000000 [................]
52D82830 00050000 52D82970 00000000 00000000 [.... p) .r ........]
52D82840 00000069 4C475945 00000045 00000000 [i ... Eygle .......]
52D82850 000000000000000000000000000000 [................]
52D82860 00050000 00000001 00000004 00000019 [................]
52D82870 0000000B 00000000 00000002 00000001 [................] 52D82880 00002DC7 00000000 000030A4 00000000 [.-....... 0 ......]
52D82890 00000000 04000000 00000000 00650000 [............ e.]
52D828A0 00100000 00050001 01050100 00000001 [................]
52D828B0 000007D0 00640000 00010000 01000000 [... D .........]
52D828C0 00000404 00000000 01010101 01010001 [................]
52D828D0 01010101 00010001 01010101 00000000 [................]
52D828E0 00000202 02010000 01010100 01010101 [................]
52D828F0 00000000 01000001 00000000 00000000 [................]
52D82900 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82910 0036190B 0000000 0000001C4 00000000 [..6 .............
52D82920 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82940 00022000 0000000 0000fff fffffff [. ............]
52D82950 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82960 0036190B 00000000 00000000 000,000 [..6 .............
52D82970 00000001 00000069 00000077 00000002 [.... i ... w .......]
52D82980 00000003 52D829D8 00010010 00000004 [.....). R ........]
52D82990 00000000 00000000 000,000 00000000 [................]
52D829A0 00000000 00000000 52D82B58 00010010 [........ x .r ....]
52D829B0 00000004 52D82B40 00010010 00000004 [.... @ . R ........]
52D829C0 00000000 million 00000000 [................]
52D829D0 00000000 00000000 52D82BE0 00000000 [......... . R ....]
52D829E0 00000000 00000000 00000000 000,000 [................]
Extent 2 AddR = 0x52D82A0C
CHUNK 52D82A14 SZ = 252 Perm "Perm" alo = 252
52D82A10 400000FD 00000000 00000000 [... @ ........]
52D82A20 000000FC 52D885CC 52D82A28 52D82A28 [....... r (*. R (*. R] 52D82A30 52D82A30 52D82A30 52D82984 00000000 [0 * .R0 * .R.). R ....
52D82A40 00010001 00000000 00000000 000,000 [................]
52D82A50 00000000 52D82A98 00000000 00000000 [..... *. R ........]
52D82A60 00000000 00000000 00000000 52D82AAC [............. *. R]
52D82A70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82A90 00000000 00000000 52D8C244 00000000 [......... D..R ....]
52D82AA0 52D827E4 00000000 52FF5B74 52D82AC0 [. '. R .... t [.r. *. R]
52D82AB0 00000000 52D817C4 00040000 52FF5B9C [....... r ..... [. R]
52D82AC0 5000002C 00001024 52D82A24 52D817AC [, .. p $ ... $ *. R ... r]
52D82AD0 52D817B4 00000000 52D8237C 05010200 [... r .... | # .r ....]
52D82AE0 00000000 00000000 206C7173 61657261 [........ SQL Area]
52D82AF0 00000000 00000000 00107FFF 7FFF7FFF [................]
52D82B00 00000401 000000 52D82B08 52D82B08 [....... . R. . R]
CHUNK 52D82B10 SZ = 120 Perm "Perm" alo = 104
52D82B10 40000079 52D82A14 52D827D4 00000068 [Y .. @. *. R. '. Rh ...]
52D82B20 52B2D470 52B2D470 52D82E58 00000000 [p..RP..RX..R ....]
52D82B30 00000001 52D82A24 0000000E 00000001 [... $ *. R ........]
52D82B40 52D82B94 00000000 00000000 00000000 [. . R ............]]]
52D82B50 52D82E58 52D82E58 52D811D4 000000 [X..RX..R ... r ....]
52D82B60 00000000 million 00000000 [................]
52D82B70 02000000 00000000 00000000 000,00000 [................]
52D82B80 00000000 00000000 [.......]
CHUNK 52D82B88 SZ = 76 Freeable "KGLTBTAB"
52D82B80 0000004D 52D82B10 [m .... . R]
52D82B90 0A857928 52D82B50 00000000 00000000 [(Yi ...)
Repeat 2 Times
52D82BD0 00000000 [....]
Chunk 52D82BD4 SZ = 76 Freeable "KGLTBTAB"
52D82BD0 1000004D 52D82B88 0A857928 [m .... . R (y ..]
52D82BE0 52D82B20 00000000 00000000 00000000 [ .r ............]
52D82BF0 00000000000000000000000000000000 [................]
Repeat 2 Times
Total HEAP SIZE = 1604
Free Lists:
BUCKET 0 size = 0
CHUNK 52D80FF8 SZ = 464 free ""
52D80FF0 C00001D1 00000000 [........]
52D81000 52D8C28C 52D8C28C 00000000 00000000 [... r ... r ........]
52D81010 00000000 million 00000000 [................]
REPEAT 26 TIMES
52D811C0 00000000 00000000 [.......]
Total Free Space = 464
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
CHUNK 52D82B10 SZ = 120 Perm "Perm" alo = 104
52D82B10 40000079 52D82A14 52D827D4 00000068 [Y .. @. *. R. '. Rh ...]
52D82B20 52B2D470 52B2D470 52D82E58 00000000 [p..RP..RX..R ....]
52D82B30 00000001 52D82A24 0000000E 00000001 [... $ *. R ........]
52D82B40 52D82B94 00000000 00000000 00000000 [. . R ............]]]
52D82B50 52D82E58 52D82E58 52D811D4 000000 [X..RX..R ... r ....]
52D82B60 00000000 million 00000000 [................]
52D82B70 02000000 00000000 00000000 000,00000 [................]
52D82B80 00000000 00000000 [.......]
CHUNK 52D827D4 SZ = 540 Perm "Perm" alo = 532
52D827D0 5000021D 00000000 52D82A14 [... p ..... *. R] 52D827E0 00000214 00000000 0000001a 00000069 [............. I ...]
52D827F0 00000000000000000000000000000006 [................]
52D82800 00000850 00000010 00000008 00000005 [P ...............]
52D82810 00000005 4C475945 00000045 00000000 [.... Eygle .......]
52D82820 00000000 00000000 000,000 00000000 [................]
52D82830 00050000 52D82970 00000000 00000000 [.... p) .r ........]
52D82840 00000069 4C475945 00000045 00000000 [i ... Eygle .......]
52D82850 000000000000000000000000000000 [................]
52D82860 00050000 00000001 00000004 00000019 [................]
52D82870 0000000B 00000000 00000002 00000001 [................]
52D82880 00002DC7 00000000 000030A4 00000000 [.-....... 0 ......]
52D82890 00000000 04000000 00000000 00650000 [............ e.]
52D828A0 00100000 00050001 01050100 00000001 [................]
52D828B0 000007D0 00640000 00010000 01000000 [... D .........]
52D828C0 00000404 00000000 01010101 01010001 [................]
52D828D0 01010101 00010001 01010101 00000000 [................]
52D828E0 00000202 02010000 01010100 01010101 [................]
52D828F0 00000000 01000001 00000000 00000000 [................]
52D82900 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82910 0036190B 0000000 0000001C4 00000000 [..6 .............
52D82920 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82940 00022000 0000000 0000fff fffffff [. ............]
52D82950 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82960 0036190B 00000000 00000000 000,000 [..6 .............
52D82970 00000001 00000069 00000077 00000002 [.... i ... w .......]
52D82980 00000003 52D829D8 00010010 00000004 [.....). R ........] 52D82990 000000000000000000000000000000 [................]
52D829A0 00000000 00000000 52D82B58 00010010 [........ x .r ....]
52D829B0 00000004 52D82B40 00010010 00000004 [.... @ . R ........]
52D829C0 00000000 million 00000000 [................]
52D829D0 00000000 00000000 52D82BE0 00000000 [......... . R ....]
52D829E0 00000000 00000000 00000000 000,000 [................]
CHUNK 52D82A14 SZ = 252 Perm "Perm" alo = 252
52D82A10 400000FD 00000000 00000000 [... @ ........]
52D82A20 000000FC 52D885CC 52D82A28 52D82A28 [....... r (*. R (*. R]
52D82A30 52D82A30 52D82A30 52D82984 00000000 [0 * .R0 * .r.). R ....
52D82A40 00010001 00000000 00000000 000,000 [................]
52D82A50 00000000 52D82A98 00000000 00000000 [..... *. R ........]
52D82A60 00000000 00000000 00000000 52D82AAC [............. *. R]
52D82A70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82A90 00000000 00000000 52D8C244 00000000 [......... D..R ....]
52D82AA0 52D827E4 00000000 52FF5B74 52D82AC0 [. '. R .... t [.r. *. R]
52D82AB0 00000000 52D817C4 00040000 52FF5B9C [....... r ..... [. R]
52D82AC0 5000002C 00001024 52D82A24 52D817AC [, .. p $ ... $ *. R ... r]
52D82AD0 52D817B4 00000000 52D8237C 05010200 [... r .... | # .r ....]
52D82AE0 00000000 00000000 206C7173 61657261 [........ SQL Area]
52D82AF0 00000000 00000000 00107FFF 7FFF7FFF [................]
52D82B00 00000401 000000 52D82B08 52D82B08 [....... . R. . R]
Permanent Space = 912
*********************************************************** ****
HEAP Dump of Data Block 6:
*********************************************************** **** Heap Dump Heap Name = "SQL Area" DESC = 0x52D82AC0
Extent SZ = 0x1024 alt = 32767 HET = 16 REC = 0 flg = 2 OPC = 5
Parent = 0x5000002c oowner = 0x52d82a24 nex = (nil) xsz = 0x0
EXTENT 0 AddR = 0x52d817ac
CHUNK 52D817B4 SZ = 3784 Perm "perm" alo = 3784
52D817B0 50000EC9 00000000 00000000 [... p ........]
52D817C0 00000EC8 00000010 00000004 00000010 [................]
52D817D0 00000000000000000000 [................]
52D817E0 0000000000000000000000000000000000 [................]
52D817F0 00000000 52D81F5C 404EEB2C 00000000 [.... / .. r, .n @ ....]
52D81800 00000000 00000000 00000000 52D81A08 [............... r]
52D81810 000000000000000000000010 0000000003 [................]
52D81820 00000000 00000000 00000000 1A086878 [............ xh ..]
52D81830 0029180B 00000000 00000000 000,000 [..) .............
52D81840 52D81C10 52D82540 00000000 52D824D4 [... r @%. R ..... $. R]
52D81850 00000000 00000000 00000000 52D81B7C [............ | ..r]
52D81860 000,000 0000000 0000001 52D81BFC [............... r]
52D81870 52D82360 00000000 00000000 52D82894 [`# .r ......... (. R]
52D81880 00000000 00000000 000,000 00000000 [................]
Repeat 1 Times
52D818A0 00000000 00000000 08000000 52D823AC [............. #. R]
52D818B0 00000000000000000000 [................]
52D818C0 00000000210000000 0000000000000000 [$ ...............
52D818D0 0000000 000 million 00000000 52D81C1C [............... r]
52D818E0 00000000 00000000 00000000 52D82620 [.......... & .r]
52D818F0 00000000 00000000 00000000 52D81958 [............ x..r]
52D81900 00000000000000000000000000000000 [................] 52D81910 00000000 00000000 52D8252C 00010001 [........%. R ....]
52D81920 EBCE39A4 00000000 00000000 00000000 [.9 ............]
52D81930 00000000 00000000000000000000000001 [................]
52D81940 00000001 00000794 00000000 0000001 [................]
52D81950 0000001 0000008 000,00000 52D817C4 [............... r]
52D81960 00000000 00000000 00000202 00000000 [................]
52D81970 52D819B8 52D819A0 52D81990 5001A874 [... r ... r ... rt..P]
52D81980 00000000 000,000 52D819FC 52D819CC [........... r ... r]
52D81990 52D82AC0 404EFB80 00000000 00000000 [. *. R..n @ ........]
52D819A0 00000000 00000000 52D81958 00000000 [......... X..r ....]
52D819B0 00000000 00000000 00000000 52D81958 [............ x..r]
52D819C0 00000002 52D885CC 00000000 52D819E4 [....... r ....... r]
52D819D0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D819F0 00000001 00000000 00000000 52D81958 [............ x..r]
52D81A00 00000000 00000000 4C475945 00000045 [......... Eygle ...]
52D81A10 00000000000000000000000000000000 [................]
52D81A20 00000000 00050000 00000069 0000000E [........ i .......]
52D81A30 4D450003 00000050 00000000 00000500 [..emp ...........]
52D81A40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D81A60 404EE794 00000000 00000000 00000014 [..n @ ............]
52D81A70 000000000000000000 [................]
52D81A80 0000000000000000000000000000000000 [................]
52D81A90 000000000000000000000000 00003F09 [...........? ..]
52D81AA0 00000000000000000000000000000000000000 [................]
52D81AB0 00000000 00000069 00080008 00000000 [.... i ...........] 52D81AC0 08687800 29180B1A 1A086878 7829180B [.xH ....) XH ....) x]
52D81AD0 0B1A0868 00002918 00000000 00000000 [h ....) ........]
52D81AE0 00000000000000000000000000000000 [................]
52D81AF0 00000000 00000001 00000000 0002E0 [................]
52D81B00 00000000 00000008 00000000 000,000 [................]
52D81B10 00000000 404EEC04 00000000 52D81B9C [... n @ ....... r]
52D81B20 52D81B9C 00000000 00000000 000,000 [... r ............]
52D81B30 00000000 million 00000000 [................]
52D81B40 00000000 0000000000000000 20000000 [...............]
52D81B50 00000000 million 0000000000 [................]
Repeat 1 Times
52D81B70 000000 00000000 00000000 52D81948 [............ h..r]
52D81B80 00000000 00000002 00000008 0000000E [..............]
52D81B90 59450005 00454C47 00000000 00000000 [..eygle .........]
52D81BA0 405480000000001 00000064 00000000 [..t @ .... d .......]
52D81BB0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D81BD0 00000000 0000000000000000000000 [..... ........]
52D81BE0 00000000000000000000000000000000 [................]
52D81BF0 00000000 00000000 00003F09 00000000 [......... ......]
52D81C00 00000014 00000004 00000001 00000000 [................]
52D81C10 00000000 00003F09 00010000 52D81FD4 [..... ......... r]
52D81C20 52D81F08 52D81F64 00000000 00000010 [... rd..r ........]
52D81C30 00000007 00000100 00000000 000,00000 [................]
52D81C40 00000000 000000000000000000000010 [................]
52D81C50 00000104 00000000 00000000 000,00000 [................]
52D81C60 0000000000000000000000000000000000 [................] 52D81C70 52D81A2C 00000000 404EE794 00000000 [, .. r ... n @ ....]
52D81C80 00000000 00000007 000001010 000,00000 [................]
52D81C90 00010041 00000000 00000014 00000004 [a ...............]
52D81CA0 0000000010 000001A0 00000016 00000000 [................]
52D81CB0 52D824B4 00040000 00000000 52D82300 [. $. R ......... #. R]
52D81CC0 00000000 52D81A2C 52D81FC4 404EE794 [...., .. r ... r..n @]
52D81CD0 00000000 00000000 000,00000 52D81C84 [............. r]
52D81CE0 00000007 00000102 00000000 00010041 [............ a ...]
52D81CF0 00000000 00000014 00000001C 00000010 [................]
52D81D00 00000194 00000016 00000000 52D82494 [........... $. R]
52D81D10 00040000 00000000 52D822A0 00000000 [......... ". R ....]
52D81D20 52D81A2C 52D81FB8 404EE794 00000000 [, .. r ... r..n @ ....]
52D81D30 00000000 52D81CD8 52D81CE0 00000007 [....... r ... r ....]
52D81D40 00000102 00000000 00010041 00000000 [........ a .......]
52D81D50 0000000014 00000034 00000010 00000188 [.... 4 ...........]
52D81D60 0000000016 00000000 52D82474 00040000 [........ t $ .r ....]
52D81D70 00000000 52D8240 00000000 52D81A2C [.... @ ". R ...., .. r]
52D81D80 52D81FAC 404EE794 00000000 00000000 [... r..n @ ........]
52D81D90 52D81D34 52D81D3C 00000007 0000010C [4..R <.. r ........]
52D81DA0 00000000 00010041 00000000 00000014 [.... a ...........]
52D81DB0 0000004C 00000010 0000017C 00000007 [l ....... | .......]
52D81DC0 00000000 52D82454 00040000 00000000 [.... t $ .r ........]
52D81DD0 52D821E0 00000000 52D81A2C 52D81F9C [.! R ...., .. r ... r]
52D81DE0 404EE794 00000000 00000000 52D81D90 [..n @ ........... r]
52D81DF0 52D81D98 00000007 00000102 00000000 [... r ............]
52D81E00 00010041 00000000 00000014 00000054 [A ......... T ...] 52D81E10 00000010 00000000 [.... P ...........]
52D81E20 52D82434 00040000 00000000 52D82180 [4 $ .r .........!. R]
52D81E30 00000000 52D81A2C 52D81F90 404EE794 [...., .. r ... r..n @]
52D81E40 00000000 000,000 52D81DEC 52D81DF4 [........... r ... r]
52D81E50 00000007 00000101 00010354 00010041 [........ t ... a ...]
52D81E60 00040000 00000014 0000006C 00000010 [........ l .......]
52D81E70 00000164 00090009 00000000 52D82414 [D ......... $. R]
52D81E80 00040000 00000000 52D82120 00000000 [........! .R ....]
52D81E90 52D81A2C 52D81F84 404EE794 00000000 [, .. r ... r..n @ ....]
52D81EA0 00000000 52D81E48 52D81E50 00000007 [.... h..rp..r ....]
52D81EB0 00000101 00010354 00010041 00040000 [.... t ... a .......]
52D81EC0 0000000014 00000078 00000010 00000158 [.... x ....... x ...]
52D81ED0 000A000A 00000000 52D823F4 00040000 [......... #. R ....]
52D81EE0 00000000 52D820C0 00000000 52D81A2C [......r ...., .. r]
52D81EF0 52D81F74 404EE794 00000000 00000000 [t..r..n @ ........]
52D81F00 52D81EA4 52D81EAC 00000007 00000102 [... r ... r ........]
52D81F10 00000000 00010041 00000000 00000014 [.... a ...........]
52D81F20 00000084 00000010 0000014C 00000016 [........ l .......]
52D81F30 00000000 52D823D4 00040000 00000000 [..... #. R ........]
52D81F40 52D82060 00000000 52D81A2C 52D81F64 [`.r ...., .. rd..r]
52D81F50 404EE794 00000000 00000000 52D81F00 [..n @ ........... r]
52D81F60 52D81F08 00000007 4D450005 004F4E50 [... r ... Empno.]
52D81F70 00000000 00000007 4E450005 00454D41 [........ ename.]
52D81F80 00000000 000000004 4F4A0003 00000042 [........ Job ...]
52D81F90 00000007 474D0003 00000052 00000007 [... Mgr .......]
52D81FA0 49480004 4144452 00004554 00000007 [..hiredate ...] 52D81FB0 41530007 4F430004 [..sal ......... CO]
52D81FC0 00004D4D 00000007 45440006 4F4E5450 [mm ........ deptno]
52D81FD0 00000000 52D81FE8 52D81EAC 52D81F74 [....... r ... rt..r]
52D81FE0 00000000 00000010 52D81FFC 52D81E50 [........... rp..r]
52D81FF0 52D81F84 00000000 00000010 52D82010 [... r ..........R]
52D82000 52D81DF4 52D81F90 00000000 00000010 [... r ... r ........]
52D82010 52D82024 52D81D98 52D81F9C 00000000 [$ .r ... r ... r ....]
52D82020 00000010 52D82038 52D81D3C 52D81FAC [.... 8 .r <.. r ... r]
52D82030 00000000 00000010 52D8204C 52D81CE0 [........ l.r ... r]
52D82040 52D81FB8 00000000 00000010 00000000 [... r ............]
52D82050 52D81C84 52D81FC4 00000000 00000010 [... r ... r ........]
52D82060 00000000 00010001 00020001 00000016 [................]
52D82070 00000004 00000000 00000000 00000000 [................]
52D82080 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D820B0 00000000 00000000 00000000 00003F09 [...........? ..]
52D820C0 00000000 00020002 00010002 000A000A [..............]
52D820D0 0000000000000000000000000000000000 [................]
Repeat 2 Times
52D82100 00010354 00000000 0000000000000000 [T ...............]
52D82110 00000000 00000000 00000000 00003F09 [...........? ..]
52D82120 00000000 00030003 00010003 00090009 [................]
52D82130 00000000 00000000 00000000 000,00000 [................]
Repeat 2 Times
52D82160 00010354 00000000 00000000 00000000 [T ...............]
52D82170 0000000000000000000000 00003F09 [...........? ..]
52D82180 000000 00040004 00020004 00000016 [................]
52D82190 000000000000000000 000,000 00000000 [................] 52D821A0 000000000000000000000000000000 [................]
Repeat 2 Times
52D821D0 00000000 0000000000000000 00003F09 [...........? ..]
52D821E0 00000000 00050005 000c0005 00000007 [................]
52D821F0 00000000000000000000000000000000 [................]
Repeat 3 Times
52D82230 00000000 00000000 00000000 00003F09 [............? ..]
52D82240 00000000 00060006 00020006 00000016 [................]
52D82250 00000000000000000000 [................]
52D82260 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D82290 00000000 000000000000000000003f09 [...........? ..]
52D822A0 00000000 00070007 00020007 00000016 [................]
52D822B0 00000207 000000000000000000000000 [................]
52D822C0 00000000 million 00000000 [................]
Repeat 2 Times
52D822F0 00000000 00000000 00000000 00003F09 [...........? ..]
52D82300 00000000 00080008 00020008 00000016 [................]
52D82310 00000000000000000000 [................]
52D82320 000000000000000000000000000000 [................]
Repeat 2 Times
52D82350 00000000 00000000 00000000 00003F09 [............? ..]
52D82360 00000000 00000000 00000000 52D82374 [............ t # .r]
52D82370 00003F09 00000000 52D82370 3eeeeeeee [.? ... p # .r ...>]
52D82380 00000000 52D817B4 52D82388 52D82388 [....... r. #. R. #. R]
52D82390 00000000 404EECB8 404EECB8 404EECB8 [... n @ .. n @ .. n @]
52D823A0 00000000 00000000 000,00000 52D81A6C [........... L.R]
52D823B0 00000008 52D81F08 52D81EAC 52D81E50 [....... r ... rp..r]
52D823C0 52D81DF4 52D81D98 52D81D3C 52D81CE0 [... r ... r <.. r ... r]
52D823D0 52D81C84 00000010 0000014C 00000014 [... r .... l .......] 52D823E0 00000084 00000016 00000001 52D82060 [........... `.r]
52D823F0 00000001 00000010 00000158 00000014 [........ x .......]
52D82400 00000078 0000000A 00000002 52D820C0 [x .......... .r]
52D82410 00000001 00000010 00000164 00000014 [........ d .......]
52D82420 0000006C 00000009 00000003 52D82120 [l ...........! .R]
52D82430 00000001 00000010 00000170 00000014 [........ p .......]
52D82440 00000054 00000016 00000004 52D82180 [T ............! R]
52D82450 00000001 00000010 0000017C 00000014 [........ | .......]
52D82460 0000004C 00000007 00000005 52D821E0 [l ............! R]
52D82470 00000001 00000010 00000188 00000014 [................]
52D82480 00000034 00000016 00000006 52D82240 [4 ........... @ ". R]
52D82490 00000001 00000010 00000194 00000014 [................]
52D824A0 0000001C 00000016 00000007 52D822A0 [............. ". R]
52D824B0 00000001 00000010 000001A0 00000014 [................]
52D824C0 00000004 00000016 00000008 52D82300 [............. #. R]
52D824D0 00000001 52D81938 00000004 00000002 [.... 8..r ........]
52D824E0 000000BC 00000000 52D81C1C 00000008 [........... r ....]
52D824F0 00000000 00000000 00000000 000,00000 [................]
52D82500 00000000 0000000000000012 02400791 [............ @.]
52D82510 00003F09 00003F09 00030000 00001FE8 [.? ...? ........]
52D82520 00000000 00000100 3F091826 00000001 [........ & ..? ....
52D82530 00000000000000000000 [................]
52D82540 00000000000000000000000000000000 [................]
52D82550 52D823B0 00000010 000001D0 00000017 [. #. R ..........]
52D82560 52D82524 00000001 00003F09 00000000 [$%. R ..... ......]
52D82570 000000000000 million 00000000 [................] 52D82580 00000000 00000000 0000000000000000 [................]
52D82590 00000000 00000000 52D823D4 00080000 [......... #. R ....]
52D825A0 00000000000000000000000 52D82508 [...........%. R]
52D825B0 00000000000000000000000010 00000270 [........... p ...]
52D825C0 52D823D4 00000008 00000014 0000009C [. #. R ............]
52D825D0 00000000 00000000 00000000 52D81ACF [............... r]
52D825E0 00000000 00000000 00000000 000,00000 [................]
Repeat 3 Times
52D82620 52D8263C 00000010 000006D4 00000010 [<&. R ............]
52D82630 000006F4 00000010 000006F8 00000010 [................]
52D82640 000006FC 00000010 00000714 00000010 [................]
52D82650 00000720 00000010 00072C 00000010 [......., .......]
52D82660 000007410 0000010 00074C 00000010 [d ....... l .......]
52D82670 00000764 00000010 0000077C [D ....... | ...]
Total Heap Size = 3784
Free Lists:
BUCKET 0 size = 0
Total Free Space = 0
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
CHUNK 52D817B4 SZ = 3784 Perm "perm" alo = 3784
52D817B0 50000EC9 00000000 00000000 [... p ........]
52D817C0 00000EC8 00000010 00000004 00000010 [................]
52D817D0 00000000000000000000 [................]
52D817E0 0000000000000000000000000000000000 [................]
52D817F0 00000000 52D81F5C 404EEB2C 00000000 [.... / .. r, .n @ ....]
52D81800 00000000 00000000 00000000 52D81A08 [............... r]
52D81810 000000000000000000000010 0000000003 [................]
52D81820 00000000 00000000 00000000 1A086878 [............ xh ..]
52D81830 0029180B 00000000 00000000 000,000 [..) ............................,
52D81850 00000000 00000000 00000000 52D81B7C [............ | ..r]
52D81860 000,000 0000000 0000001 52D81BFC [............... r]
52D81870 52D82360 00000000 00000000 52D82894 [`# .r ......... (. R]
52D81880 00000000 00000000 000,000 00000000 [................]
Repeat 1 Times
52D818A0 00000000 00000000 08000000 52D823AC [............. #. R]
52D818B0 00000000000000000000 [................]
52D818C0 00000000210000000 0000000000000000 [$ ...............
52D818D0 0000000 000 million 00000000 52D81C1C [............... r]
52D818E0 00000000 00000000 00000000 52D82620 [.......... & .r]
52D818F0 00000000 00000000 00000000 52D81958 [............ x..r]
52D81900 00000000 million 00000000 [................]
52D81910 00000000 00000000 52D8252C 00010001 [........%. R ....]
52D81920 EBCE39A4 00000000 00000000 00000000 [.9 ............]
52D81930 00000000 00000000000000000000000001 [................]
52D81940 00000001 00000794 00000000 0000001 [................]
52D81950 0000001 0000008 000,00000 52D817C4 [............... r]
52D81960 00000000 00000000 00000202 00000000 [................]
52D81970 52D819B8 52D819A0 52D81990 5001A874 [... r ... r ... rt..P]
52D81980 00000000 000,000 52D819FC 52D819CC [........... r ... r]
52D81990 52D82AC0 404EFB80 00000000 00000000 [. *. R..n @ ........]
52D819A0 00000000 00000000 52D81958 00000000 [......... X..r ....]
52D819B0 00000000 00000000 00000000 52D81958 [............ x..r]
52D819C0 00000002 52D885CC 00000000 52D819E4 [....... r ....... r]
52D819D0 00000000000000000000000000000000 [................]
Repeat 1 TIMES52D819F0 000000011000000000000000 52D81958 [............ x..r]
52D81A00 00000000 00000000 4C475945 00000045 [......... Eygle ...]
52D81A10 00000000000000000000000000000000 [................]
52D81A20 00000000 00050000 00000069 0000000E [........ i .......]
52D81A30 4D450003 00000050 00000000 00000500 [..emp ...........]
52D81A40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D81A60 404EE794 00000000 00000000 00000014 [..n @ ............]
52D81A70 000000000000000000 [................]
52D81A80 0000000000000000000000000000000000 [................]
52D81A90 000000000000000000000000 00003F09 [...........? ..]
52D81AA0 00000000000000000000000000000000000000 [................]
52D81AB0 00000000 00000069 00080008 000000 [.... i ...........]
52D81AC0 08687800 29180B1A 1A086878 7829180B [.xH ....) XH ....) x]
52D81AD0 0B1A0868 00002918 00000000 00000000 [h ....) ........]
52D81AE0 00000000000000000000000000000000 [................]
52D81AF0 00000000 00000001 00000000 0002E0 [................]
52D81B00 00000000 00000008 00000000 000,000 [................]
52D81B10 00000000 404EEC04 00000000 52D81B9C [... n @ ....... r]
52D81B20 52D81B9C 00000000 00000000 000,000 [... r ............]
52D81B30 00000000 million 00000000 [................]
52D81B40 00000000 0000000000000000 20000000 [...............]
52D81B50 00000000 million 0000000000 [................]
Repeat 1 Times
52D81B70 000000 00000000 00000000 52D81948 [............ h..r]
52D81B80 00000000 00000002 00000008 0000000E [..............]
52D81B90 59450005 00454C47 00000000 00000000 [..eygle .........]
52D81BA0 40548000 00000001 00000064 00000000 [..t @ .... d .......] 52D81BB0 000000000000000000000000000000 [................]
Repeat 1 Times
52D81BD0 00000000 0000000000000000000000 [..... ........]
52D81BE0 00000000000000000000000000000000 [................]
52D81BF0 00000000 00000000 00003F09 00000000 [......... ......]
52D81C00 00000014 00000004 00000001 00000000 [................]
52D81C10 00000000 00003F09 00010000 52D81FD4 [..... ......... r]
52D81C20 52D81F08 52D81F64 00000000 00000010 [... rd..r ........]
52D81C30 00000007 00000100 00000000 000,00000 [................]
52D81C40 00000000 000000000000000000000010 [................]
52D81C50 00000104 00000000 00000000 000,00000 [................]
52D81C60 00000000000000000000000000000000 [................]
52D81C70 52D81A2C 00000000 404EE794 00000000 [, .. r ... n @ ....]
52D81C80 00000000 00000007 000001010 000,00000 [................]
52D81C90 00010041 00000000 00000014 00000004 [a ...............]
52D81CA0 0000000010 000001A0 00000016 00000000 [................]
52D81CB0 52D824B4 00040000 00000000 52D82300 [. $. R ......... #. R]
52D81CC0 00000000 52D81A2C 52D81FC4 404EE794 [...., .. r ... r..n @]
52D81CD0 00000000 00000000 000,00000 52D81C84 [............. r]
52D81CE0 00000007 00000102 00000000 00010041 [............ a ...]
52D81CF0 00000000 00000014 00000001C 00000010 [................]
52D81D00 00000194 00000016 00000000 52D82494 [........... $. R]
52D81D10 00040000 00000000 52D822A0 00000000 [......... ". R ....]
52D81D20 52D81A2C 52D81FB8 404EE794 00000000 [, .. r ... r..n @ ....]
52D81D30 00000000 52D81CD8 52D81CE0 00000007 [....... r ... r ....]
52D81D40 00000102 00000000 00010041 00000000 [........ a .......]
52D81D50 0000000014 00000034 00000010 00000188 [.... 4 ...........]
52D81D60 0000000016 00000000 52D82474 00040000 [........ t $ .r ....]
52D81D70 00000000 52D8240 00000000 52D81A2C [.... @ ". R ...., .. r]
52D81D80 52D81FAC 404EE794 00000000 00000000 [... r..n @ ........]
52D81D90 52D81D34 52D81D3C 00000007 0000010C [4..R <.. r ........]
52D81DA0 00000000 00010041 00000000 00000014 [.... a ...........]
52D81DB0 0000004C 00000010 0000017C 00000007 [l ....... | .......]
52D81DC0 00000000 52D82454 00040000 00000000 [.... t $ .r ........]
52D81DD0 52D821E0 00000000 52D81A2C 52D81F9C [.! R ...., .. r ... r]
52D81DE0 404EE794 00000000 00000000 52D81D90 [..n @ ........... r]
52D81DF0 52D81D98 00000007 00000102 00000000 [... r ............]
52D81E00 00010041 00000000 00000014 00000054 [a ......... T ...]
52D81E10 00000000000000000000000016 00000000 [.... p ...........]
52D81E20 52D82434 00040000 00000000 52D82180 [4 $ .r .........!. R]
52D81E30 00000000 52D81A2C 52D81F90 404EE794 [...., .. r ... r..n @]
52D81E40 00000000 000,000 52D81DEC 52D81DF4 [........... r ... r]
52D81E50 00000007 00000101 00010354 00010041 [........ t ... a ...]
52D81E60 00040000 00000014 0000006C 00000010 [........ l .......]
52D81E70 00000164 00090009 00000000 52D82414 [D ......... $. R]
52D81E80 00040000 00000000 52D82120 00000000 [........! .R ....]
52D81E90 52D81A2C 52D81F84 404EE794 00000000 [, .. r ... r..n @ ....]
52D81EA0 00000000 52D81E48 52D81E50 00000007 [.... h..rp..r ....]
52D81EB0 00000101 00010354 00010041 00040000 [.... t ... a .......]
52D81EC0 0000000014 00000078 00000010 00000158 [.... x ....... x ...]
52D81ED0 000A000A 00000000 52D823F4 00040000 [......... #. R ....]
52D81EE0 00000000 52D820C0 00000000 52D81A2C [......r ...., .. r]
52D81EF0 52D81F74 404EE794 00000000 00000000 [t..r..n @ ........ 52D81F00 52D81EA4 52D81EAC 00000007 00000102 [... r ... r ........]
52D81F10 00000000 00010041 00000000 00000014 [.... a ...........]
52D81F20 00000084 00000010 0000014C 00000016 [........ l .......]
52D81F30 00000000 52D823D4 00040000 00000000 [..... #. R ........]
52D81F40 52D82060 00000000 52D81A2C 52D81F64 [`.r ...., .. rd..r]
52D81F50 404EE794 00000000 00000000 52D81F00 [..n @ ........... r]
52D81F60 52D81F08 00000007 4D450005 004F4E50 [... r ... Empno.]
52D81F70 00000000 00000007 4E450005 00454D41 [........ ename.]
52D81F80 00000000 000000004 4F4A0003 00000042 [........ Job ...]
52D81F90 00000007 474D0003 00000052 00000007 [... Mgr .......]
52D81FA0 49480008 41444552 00004554 00000007 [..hired ......]]
52D81FB0 41530003 0000004C 00000007 4F430004 [..sal ......... Co]
52D81FC0 00004D4D 00000007 45440006 4F4E5450 [mm ........ deptno]
52D81FD0 00000000 52D81FE8 52D81EAC 52D81F74 [....... r ... rt..r]
52D81FE0 00000000 00000010 52D81FFC 52D81E50 [........... rp..r]
52D81FF0 52D81F84 00000000 00000010 52D82010 [... r ..........R]
52D82000 52D81DF4 52D81F90 00000000 00000010 [... r ... r ........]
52D82010 52D82024 52D81D98 52D81F9C 00000000 [$ .r ... r ... r ....]
52D82020 00000010 52D82038 52D81D3C 52D81FAC [.... 8 .r <.. r ... r]
52D82030 00000000 00000010 52D8204C 52D81CE0 [........ l.r ... r]
52D82040 52D81FB8 00000000 00000010 00000000 [... r ............]
52D82050 52D81C84 52D81FC4 00000000 00000010 [... r ... r ........]
52D82060 00000000 00010001 00020001 00000016 [................]
52D82070 00000004 00000000 00000000 00000000 [................]
52D82080 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D820B0 00000000 00000000 00000000 00003F09 [............? ..] 52D820C0 00000000 00020002 00010002 000A000A [................]
52D820D0 0000000000000000000000000000000000 [................]
Repeat 2 Times
52D82100 00010354 00000000 0000000000000000 [T ...............]
52D82110 00000000 00000000 00000000 00003F09 [...........? ..]
52D82120 00000000 00030003 00010003 00090009 [................]
52D82130 00000000 00000000 00000000 000,00000 [................]
Repeat 2 Times
52D82160 00010354 00000000 00000000 00000000 [T ...............]
52D82170 0000000000000000000000 00003F09 [...........? ..]
52D82180 000000 00040004 00020004 00000016 [................]
52D82190 000000000000000000 [................]
52D821A0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D821D0 00000000 0000000000000000 00003F09 [...........? ..]
52D821E0 00000000 00050005 000c0005 00000007 [................]
52D821F0 00000000000000000000000000000000 [................]
Repeat 3 Times
52D82230 00000000 00000000 00000000 00003F09 [............? ..]
52D82240 00000000 00060006 00020006 00000016 [................]
52D82250 00000000000000000000 [................]
52D82260 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D82290 00000000 000000000000000000003f09 [...........? ..]
52D822A0 00000000 00070007 00020007 00000016 [................]
52D822B0 00000207 000000000000000000000000 [................]
52D822C0 00000000 million 00000000 [................]
Repeat 2 Times
52D822F0 00000000 00000000 00000000 00003F09 [...........? ..]
52D82300 00000000 00080008 00020008 00000016 [................]
52D82310 0000000000000000000000000000000000 [................] 52D82320 @00000000000000 0000000000000000 [................]
Repeat 2 Times
52D82350 00000000 00000000 00000000 00003F09 [............? ..]
52D82360 00000000 00000000 00000000 52D82374 [............ t # .r]
52D82370 00003F09 00000000 52D82370 3eeeeeeee [.? ... p # .r ...>]
52D82380 00000000 52D817B4 52D82388 52D82388 [....... r. #. R. #. R]
52D82390 00000000 404EECB8 404EECB8 404EECB8 [... n @ .. n @ .. n @]
52D823A0 00000000 00000000 000,00000 52D81A6C [........... L.R]
52D823B0 00000008 52D81F08 52D81EAC 52D81E50 [....... r ... rp..r]
52D823C0 52D81DF4 52D81D98 52D81D3C 52D81CE0 [... r ... r <.. r ... r]
52D823D0 52D81C84 00000010 0000014C 00000014 [... r .... l .......]
52D823E0 00000084 00000016 00000001 52D82060 [........... `` .r]
52D823F0 00000001 00000010 00000158 00000014 [........ x .......]
52D82400 00000078 0000000A 00000002 52D820C0 [x .......... .r]
52D82410 00000001 00000010 00000164 00000014 [........ d .......]
52D82420 0000006C 00000009 00000003 52D82120 [l ...........! .R]
52D82430 00000001 00000010 00000170 00000014 [........ p .......]
52D82440 00000054 00000016 00000004 52D82180 [T ............! R]
52D82450 00000001 00000010 0000017C 00000014 [........ | .......]
52D82460 0000004C 00000007 00000005 52D821E0 [l ............! R]
52D82470 00000001 00000010 00000188 00000014 [................]
52D82480 00000034 00000016 00000006 52D82240 [4 ........... @ ". R]
52D82490 00000001 00000010 00000194 00000014 [................]
52D824A0 0000001C 00000016 00000007 52D822A0 [............. ". R]
52D824B0 00000001 00000010 000001A0 00000014 [................]
52D824C0 00000004 00000016 00000008 52D82300 [............. #. R] 52D824D0 00000001 52D81938 00000004 000002 [.... 8..r ........]
52D824E0 000000BC 00000000 52D81C1C 00000008 [........... r ....]
52D824F0 00000000 00000000 00000000 000,00000 [................]
52D82500 00000000 0000000000000012 02400791 [............ @.]
52D82510 00003F09 00003F09 00030000 00001FE8 [.? ...? ........]
52D82520 00000000 00000100 3F091826 00000001 [........ & ..? ....
52D82530 00000000000000000000 [................]
52D82540 00000000000000000000000000000000 [................]
52D82550 52D823B0 00000010 000001D0 00000017 [. #. R ..........]
52D82560 52D82524 00000001 00003F09 00000000 [$%. R ..... ......]
52D82570 0000000000 00000000 [................]
52D82580 000000000000000000000000000000 [................]
52D82590 00000000 00000000 52D823D4 00080000 [......... #. R ....]
52D825A0 00000000000000000000000 52D82508 [...........%. R]
52D825B0 00000000000000000000000010 00000270 [........... p ...]
52D825C0 52D823D4 00000008 00000014 0000009C [. #. R ............]
52D825D0 00000000 00000000 00000000 52D81ACF [............... r]
52D825E0 00000000 00000000 00000000 000,00000 [................]
Repeat 3 Times
52D82620 52D8263C 00000010 000006D4 00000010 [<&. R ............]
52D82630 000006F4 00000010 000006F8 00000010 [................]
52D82640 000006FC 00000010 00000714 00000010 [................]
52D82650 00000720 00000010 00072C 00000010 [......., .......]
52D82660 000007410 0000010 00074C 00000010 [d ....... l .......]
52D82670 00000764 00000010 0000077C [D ....... | ...]
Permanent Space = 3784
Marks:
Mark 0x52d8237c
*********************************************************** **** The handle = 52d82e58 here is the object information of SQL-dependent:
BUCKET 63037:
Library Object Handle: Handle = 52D82E58
Name = EYGLE.EMP
Hash = 7310f63d TimeStamp = 08-26-2004 10:23:40
Namespace = Tabl / prcD / type flags = kGHP / TIM / SML / [02000000]
KKKK-DDDD-LLLL = 0000-0501-0501 Lock = 0 PIN = 0 LATCH # = 1
LWT = 0x52d82e70 [0x52d82e70, 0x52d82e70] ltm = 0x52d82e78 [0x52d82e78, 0x52d82e78]
PWT = 0x52d82e88 [0x52d82e88, 0x52d82e88] PTM = 0x52d82ee0 [0x52d82ee0, 0x52d82ee0]
Ref = 0x52d82e60 [0x52d82e60, 0x52d82e60] lnd = 0x52d82eec [0x52d7dcf0, 0x52d89fc8]
Library Object: Object = 52d81594
TYPE = Tabl flags = exS / Loc [0005] pflags = [00] status = vald load = 0
==> Type: Object Type, here is a table
==> Flags: Representative object status
Data Blocks:
Data # Heap Pointer Status Pins Change Alloc (K) Size (K)
------------ --------------------- ---
0 52D8C1E4 52D8161C I / - / A 0 none 0.66 1.09
8 52D81238 52D80A18 I / - / A 0 none 1.10 1.13
10 52D8129C 52D80EA0 I / - / A 0 none 0.12 0.37
HEAP Dump of Data Block 0:
*********************************************************** ****
Heap dump head name = "library cache" desc = 0x52d8c1e4
Extent SZ = 0x224 alt = 32767 Het = 16 REC = 9 flg = 2 OPC = 0
PARENT = 0x5000002c Owner = 0x52d81594 nex = (nil) xsz = 0x224
==> Each Heap Descriptor contains an Owner section, pointing to the owner, the 52D81594 here is Eygle.emp
==> Pointed Library object: library object: Object = 52d81594
EXTENT 0 AddR = 0x52d81220
CHUNK 52D81228 SZ = 540 Perm "Perm" alo = 196
52D81220 5000021D 00000000 [... p ...] 52D81230 52D81584 000000C4 5000002C 00000824 [... r ...., .. p $ ...]
52D81240 52D81594 52D80A00 52D80A08 000000 [... r ... r ... r ....]
52D81250 00000000 05010200 00000000 00000000 [................]
52D81260 534C474B 61656820 00000070 000000 [KGLS HEAP .......]
52D81270 00107FFF 7FFF7FFF 00000401 00000000 [..............]
52D81280 52D81280 52D81280 52D8129C 00000000 [... r ... r ... r ....]
52D81290 52D80EA0 00040000 52FF5C14 5000002C [... r ..... /. R, .. p]
52D812A0 00000824 52D81594 52D80E88 52D80E90 [$ ... r ... r ... r]
52D812B0 00000000 00000000 05010200 00000000 [................]
52D812C0 0000015C 534C474B 61656820 00000070 [/.....kgls heap ...]
52D812D0 00000000 00107FFF 7FFF7FFF 00000401 [................]
52D812E0 00000000 52D812E4 52D812E4 00000000 [....... r ... r ....]
52D812F0 0000000000000000 qditary 1000000000 [................]
Repeat 20 Times
52D81440 00000000 [....]
Extent 1 addr = 0x52d8157c
CHUNK 52D81584 SZ = 484 Perm "Perm" alo = 484
52D81580 400001E5 00000000 000,000 [... @ ........]
52D81590 000001E4 52D82E58 52D81598 52D81598 [.... x..r ... r ... r]
52D815A0 52D815A0 52D815A0 00000000 000,000 [... r ... r ........]
52D815B0 00010005 00000000 00000000 000,000 [................]
52D815C0 02000000 52D81608 00000000 00000000 [....... r ........]
52D815D0 00000000000000000000000000000000 [................]
52D815E0 00000000 52D81754 00000000 52D81288 [.... t .r ....... r]
52D815F0 00000000 000000000000000000000000 [................]
52D81600 000 million 00000000 52D8C1E4 00000000 [........... r ....]
52D81610 52D8161C 00000000 52FF5BC4 00000006 [... r ..... [. R ....] 52D81620 00000000 52D81650 00000000 00000000 [.... p..r ........]
52D81630 00003F09 00003F09 00000000 000,000 [.? ...? ........
52D81640 00000000 0000000000000069 00000000 [......... I .......]
52D81650 2000000010101 00080008 00000008 [............]
52D81660 00000000 2D2D2D2D 2D2D2D2D2D2D2D [....------------]
52D81670 2D2D2D2D2D2D2D 2D2D2D 2D2D2D2D [----------------]
52D81680 2D2D2D2D 00000012 02400791 00000000 [----...... @ .....
52D81690 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
52D816D0 00000000 0001280A 000000FF 00000000 [..... (........]
52D816E0 40548000 0000001 00000064 00000000 [..t @ .... d .......]
52D816F0 00000000000000000000000000000000 [................]
52D81700 00000000 00000000 00000000 00000001 [................]
52D81710 000000000000000000000000000000000001 [................]
52D81720 00000000 00000000 0002E0 00000000 [................]
52D81730 000000000000000000000000000000 [................]
52D81740 ffffffffff ffffffff 68780000 180b1a08 [........ xh ....]
52D81750 00000029 52D81238 00000000 52D80A18 [) ... 8..r ....... r]
52D81760 00040000 52FF5BEC [..... [. R]
CHUNK 52D81768 SZ = 40 Free ""
52D81760 D0000029 52D81584 [) ... r]
52D81770 52D8C22C 52D8C22C 00000000 00000000 [, .. r, .. r ........]
52D81780 00000000 00000000 000,000 00000000 [................]
Total Heap Size = 1064
Free Lists:
BUCKET 0 size = 0
CHUNK 52D81768 SZ = 40 Free ""
52D81760 D0000029 52D81584 [) ... r]
52D81770 52D8C22C 52D8C22C 00000000 00000000 [, .. r, .. r ........ 52D81780 00000000000000 00000000000000 [................]
Total Free Space = 40
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
CHUNK 52D81228 SZ = 540 Perm "Perm" alo = 196
52D81220 5000021D 00000000 [... p ....]
52D81230 52D81584 000000C4 5000002C 00000824 [... r ...., .. p $ ...]
52D81240 52D81594 52D80A00 52D80A08 000000 [... r ... r ... r ....]
52D81250 00000000 05010200 00000000 00000000 [................]
52D81260 534C474B 61656820 00000070 000000 [KGLS HEAP .......]
52D81270 00107FFF 7FFF7FFF 00000401 00000000 [..............]
52D81280 52D81280 52D81280 52D8129C 00000000 [... r ... r ... r ....]
52D81290 52D80EA0 00040000 52FF5C14 5000002C [... r ..... /. R, .. p]
52D812A0 00000824 52D81594 52D80E88 52D80E90 [$ ... r ... r ... r]
52D812B0 00000000 00000000 05010200 00000000 [................]
52D812C0 0000015C 534C474B 61656820 00000070 [/.....kgls heap ...]
52D812D0 00000000 00107FFF 7FFF7FFF 00000401 [................]
52D812E0 00000000 52D812E4 52D812E4 00000000 [....... r ... r ....]
52D812F0 0000000000000000 qditary 1000000000 [................]
Repeat 20 Times
52D81440 00000000 [....]
CHUNK 52D81584 SZ = 484 Perm "Perm" alo = 484
52D81580 400001E5 00000000 000,000 [... @ ........]
52D81590 000001E4 52D82E58 52D81598 52D81598 [.... x..r ... r ... r]
52D815A0 52D815A0 52D815A0 00000000 000,000 [... r ... r ........]
52D815B0 00010005 00000000 00000000 000,000 [................]
52D815C0 02000000 52D81608 00000000 00000000 [....... r ........]
52D815D0 0000000000000000000000000000000000 [................] 52D815E0 00000000 52D81754 00000000 52D81288 [.... t..r ....... r]
52D815F0 00000000 000000000000000000000000 [................]
52D81600 000 million 00000000 52D8C1E4 00000000 [........... r ....]
52D81610 52D8161C 00000000 52FF5BC4 00000006 [... r ..... [. R ....]
52D81620 00000000 52D81650 00000000 00000000 [.... p..r ........]
52D81630 00003F09 00003F09 00000000 000,000 [.? ...? ........
52D81640 00000000 0000000000000069 00000000 [......... I .......]
52D81650 2000000010101 00080008 00000008 [............]
52D81660 00000000 2D2D2D2D 2D2D2D2D2D2D2D [....------------]
52D81670 2D2D2D2D2D2D2D 2D2D2D 2D2D2D2D [----------------]
52D81680 2D2D2D2D 00000012 02400791 00000000 [----...... @ .....
52D81690 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
52D816D0 00000000 0001280A 000000FF 00000000 [..... (........]
52D816E0 40548000 0000001 00000064 00000000 [..t @ .... d .......]
52D816F0 00000000000000000000000000000000 [................]
52D81700 00000000 00000000 00000000 00000001 [................]
52D81710 000000000000000000000000000000000001 [................]
52D81720 00000000 00000000 0002E0 00000000 [................]
52D81730 000000000000000000000000000000 [................]
52D81740 ffffffffff ffffffff 68780000 180b1a08 [........ xh ....]
52D81750 00000029 52D81238 00000000 52D80A18 [) ... 8..r ....... r]
52D81760 00040000 52FF5BEC [..... [. R]
Permanent Space = 1024
*********************************************************** ****
HEAP Dump of Data Block 8:
*********************************************************** ****
HEAP DUMP Heap Name = "KGLS HEAP" DESC = 0x52d81238EXtent SZ = 0x824 alt = 32767 Het = 16 REC = 0 flg = 2 OPC = 5
Parent = 0x5000002c oowner = 0x52d81594 nex = (nil) xsz = 0x0
Extent 0 Addr = 0x52D80A00
Chunk 52D80A08 SZ = 1124 perm "perm" alo = 1124
52D80A00 50000465 00000000 [E..P ....]
52D80A10 00000000 00000464 00000000 00000007 [.... d ...........]
52D80A20 00000454 00000000 52D80E00 52D80B0C [t ........ r ... r]
52D80A30 52D80A30 52D80A30 00000000 00000008 [0..R0..r ........]
52D80A40 00000003 52D80A44 52D80A44 52D80A4C [.... d..rd..rl..r]
52D80A50 52D80A4C 00000000 00000000 00000023 [L.R ........ # ...]
52D80A60 52D80A60 52D80A60 52D80A68 52D80A68 [`....rh..r]
52D80A70 00000000 00000000 00000032 52D80A7C [........ 2 ... | ..r]
52D80A80 52D80A7C 52D80A84 52D80A84 000000 [| .r ... r ... r ....]
52D80A90 00000000 00000033 52D80A98 52D80A98 [.... 3 ... r ... r]
52D80AA0 52D80AA0 52D80AA0 00000000 000,000 [... r ... r ........]
52D80AB0 0000002C 52D80AB4 52D80AB4 52D80ABC [, ... r ... r ... r]
52D80AC0 52D80ABC 00000000 00000000 00000035 [... r ........ 5 ...]
52D80AD0 52D80AD0 52D80AD0 52D80AD8 52D80AD8 [... r ... r ... r ... r]
52D80Ae0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80B00 00000000 00000000 00000000 52D80A28 [........... (. R]
52D80B10 52D80B78 00000000 45440006 4F4E5450 [X..r ...... deptno]
52D80B20 00000000000000000000000000000000 [................]
52D80B30 00000000 00000000 00080008 00160002 [................]
52D80B40 00000200 00000008 00000000 000,00000 [................]
52D80B50 000000000000000000000000000000 [................]
Repeat 1 Times
52D80B70 00000000 0000000 52D80B0C 52D80BE4 [........... r ... r]
52D80B80 00000000 4F430004 00004D4D 00000000 [... Comm ......]
52D80B90 00000000000000000000000000000000 [................]
52D80BA0 00000000 00070007 00160002 00020700 [................]
52D80BB0 00000000000000000000 [................]
52D80BC0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80BE0 00000000 52D80B78 52D80C50 00000000 [.... x..rp..r ....]
52D80BF0 4153000 00000004C 00000000 00000000 [..sal ...........]
52D80C00 00000000 00000000 00000000 000,000 [................]
52D80C10 00060006 00160002 00020700 00000006 [................]
52D80C20 00000000000000000000000000000000 [................]
Repeat 2 Times
52D80C50 52D80BE4 52D80CBC 00000000 49480008 [... r ... r ... hi]
52D80C60 41444552 00004554 00000000 000,000 [redate ........]
52D80C70 00000000 00000000 00000000 00050005 [................]
52D80C80 0007000C 00000000 00000005 00000000 [................]
52D80C90 000000000000000000000000000000 [................]
Repeat 1 Times
52D80CB0 00000000 00000000 000,00000 52D80C50 [............ p..r]
52D80CC0 52D80D28 00000000 474D0003 00000052 [(.r ... mgr ...]
52D80CD0 00000000000000000000000000000000 [................]
52D80CE0 00000000 00000000 00040004 00160002 [................]
52D80CF0 00000400 00000004 00000000 000,00000 [................]
52D80D00 0000000000000000000000000000000000 [................]
Repeat 1 Times
52D80D20 0000000 0000000 52D80CBC 52D80D94 [........... r ... r]
52D80D30 00000000 4F4A0003 00000042 00000000 [... Job .......]
52D80D40 000000000000000000000000000000 [................]
52D80D50 00000000 0003000 00090001 000000 [................] 52D80D60 00000003 000000 00010354 00090000 [........ t .......]
52D80D70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80D90 000000000 52D80D28 52D80E00 00000000 [.... (. R ... r ....]
52D80DA0 4E450005 00454D41 000000 000,000 [..ename .........]
52D80DB0 00000000000000000000000000000000 [................]
52D80DC0 00020002 000A0001 00000000 00000002 [................]
52D80DD0 00000000 00010354 000A0000 00000000 [.... T ...........]
52D80DE0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80E00 52D80D94 52D80A28 00000000 4D450005 [... R (. R ... em)
52D80E10 004F4E50 00000000 00000000 00000000 [PNO .............]
52D80E20 00000000 0000000000000000 00010001 [................]
52D80E30 00160002 00000400 00000001 00000000 [................]
52D80E40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D80E60 00000000 00000000 00000000 [..........]
Total Heap Size = 1124
Free Lists:
BUCKET 0 size = 0
Total Free Space = 0
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
Chunk 52D80A08 SZ = 1124 perm "perm" alo = 1124
52D80A00 50000465 00000000 [E..P ....]
52D80A10 00000000 00000464 00000000 00000007 [.... d ...........]
52D80A20 00000454 00000000 52D80E00 52D80B0C [t ........ r ... r]
52D80A30 52D80A30 52D80A30 00000000 00000008 [0..R0..r ........]
52D80A40 00000003 52D80A44 52D80A44 52D80A4C [.... d..rd..rl..r]
52D80A50 52D80A4C 00000000 00000000 00000023 [L.R ........ # ...]
52D80A60 52D80A60 52D80A60 52D80A68 52D80A68 [`..R`..r..rh..r] 52D80A70 0000000000000000 00000032 52D80A7C [..........................
52D80A80 52D80A7C 52D80A84 52D80A84 000000 [| .r ... r ... r ....]
52D80A90 00000000 00000033 52D80A98 52D80A98 [.... 3 ... r ... r]
52D80AA0 52D80AA0 52D80AA0 00000000 000,000 [... r ... r ........]
52D80AB0 0000002C 52D80AB4 52D80AB4 52D80ABC [, ... r ... r ... r]
52D80AC0 52D80ABC 00000000 00000000 00000035 [... r ........ 5 ...]
52D80AD0 52D80AD0 52D80AD0 52D80AD8 52D80AD8 [... r ... r ... r ... r]
52D80Ae0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80B00 00000000 00000000 00000000 52D80A28 [........... (. R]
52D80B10 52D80B78 00000000 45440006 4F4E5450 [X..r ...... deptno]
52D80B20 00000000000000000000000000000000 [................]
52D80B30 00000000 00000000 00080008 00160002 [................]
52D80B40 00000200 00000008 00000000 000,00000 [................]
52D80B50 000000000000000000000000000000 [................]
Repeat 1 Times
52D80B70 00000000 0000000 52D80B0C 52D80BE4 [........... r ... r]
52D80B80 00000000 4F430004 00004D4D 00000000 [... Comm ......]
52D80B90 00000000000000000000000000000000 [................]
52D80BA0 00000000 00070007 00160002 00020700 [................]
52D80BB0 00000000000000000000 [................]
52D80BC0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80BE0 00000000 52D80B78 52D80C50 00000000 [.... x..rp..r ....]
52D80BF0 4153000 00000004C 00000000 00000000 [..sal ...........]
52D80C00 00000000 00000000 00000000 000,000 [................]
52D80C10 00060006 00160002 00020700 00000006 [................]
52D80C20 0000000000000000000000000000000000 [..............] Repeat 2 Times
52D80C50 52D80BE4 52D80CBC 00000000 49480008 [... r ... r ... hi]
52D80C60 41444552 00004554 00000000 000,000 [redate ........]
52D80C70 00000000 00000000 00000000 00050005 [................]
52D80C80 0007000C 00000000 00000005 00000000 [................]
52D80C90 000000000000000000000000000000 [................]
Repeat 1 Times
52D80CB0 00000000 00000000 000,00000 52D80C50 [............ p..r]
52D80CC0 52D80D28 00000000 474D0003 00000052 [(.r ... mgr ...]
52D80CD0 00000000000000000000000000000000 [................]
52D80CE0 00000000 00000000 00040004 00160002 [................]
52D80CF0 00000400 00000004 00000000 000,00000 [................]
52D80D00 0000000000000000000000000000000000 [................]
Repeat 1 Times
52D80D20 0000000 0000000 52D80CBC 52D80D94 [........... r ... r]
52D80D30 00000000 4F4A0003 00000042 00000000 [... Job .......]
52D80D40 000000000000000000000000000000 [................]
52D80D50 00000000 00030003 00090001 000000 [................]
52D80D60 00000003 00000000 00010354 00090000 [........ T .......]
52D80D70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80D90 000000000 52D80D28 52D80E00 00000000 [.... (. R ... r ....]
52D80DA0 4E450005 00454D41 000000 000,000 [..ename .........]
52D80DB0 00000000000000000000000000000000 [................]
52D80DC0 00020002 000A0001 00000000 00000002 [................]
52D80DD0 00000000 00010354 000A0000 00000000 [.... T ...........]
52D80DE0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80E00 52D80D94 52D80A28 00000000 4D450005 [... R (. R ... em)
52D80E10 004F4E50 00000000 0000000000000000 [PNO .............] 52D80E20 000000 00010001 [................]
52D80E30 00160002 00000400 00000001 00000000 [................]
52D80E40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D80E60 00000000 00000000 00000000 [..........]
Permanent Space = 1124
*********************************************************** ****
HEAP Dump of Data Block 10:
*********************************************************** ****
HEAP DUMP Heap Name = "KGLS Heap" DESC = 0x52D8129C
Extent SZ = 0x824 alt = 32767 Het = 16 REC = 0 flg = 2 OPC = 5
PARENT = 0x5000002c Owner = 0x52d81594 nex = (nil) xsz = 0x15c
Extent 0 addr = 0x52d80e88
Chunk 52D80E90 SZ = 340 Perm "Perm" alo = 120
52D80E90 50000155 00000000 00000000 00000078 [Up ........ x ...]
52D80EA0 00000000 000000002 00000068 00000004 [........ h .......]
52D80EB0 52D80EB0 52D80EB0 52D80EB8 52D80EB8 [... r ... r ... r ... r]
52D80EC0 00000000 00000000 0000005 52D80ECC [............... r]
52D80ED0 52D80ECC 52D80ED4 52D80ED4 0000000 [... r ... r ... r ....]
52D80EE0 00000000 000000000000000000000000 [................]
REPEAT 15 TIMES
52D80FE0 00000000 [....]
Total Heap Size = 340
Free Lists:
BUCKET 0 size = 0
Total Free Space = 0
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
Chunk 52D80E90 SZ = 340 Perm "Perm" alo = 120
52D80E90 50000155 00000000 00000000 00000078 [Up ........ x ...]
52D80EA0 00000000 000000002 00000068 00000004 [........ h .......]
52D80EB0 52D80EB0 52D80EB0 52D80EB8 52D80EB8 [... r ... r ... r ... r] 52D80EC0 00000000 00000000 0000005 52D80ECC [............. r]
52D80ED0 52D80ECC 52D80ED4 52D80ED4 0000000 [... r ... r ... r ....]
52D80EE0 00000000 000000000000000000000000 [................]
REPEAT 15 TIMES
52D80FE0 00000000 [....]
Permanent Space = 340
*********************************************************** ****
BUCKET 63037 Total Object Count = 1
Thursday, 2004-09-02 23:33
Eygle
Let's discuss the processing of Shared Pool:
Advance the corresponding query, get test data:
[Oracle @ Jumper Udump] $ SQLPLUS "/ as sysdba"
SQL * Plus: Release 9.2.0.3.0 - Production on Th twu aug 26 10:21:54 2004
CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.3.0 - Production
With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS
JServer Release 9.2.0.3.3.0 - PRODUCTION
SQL> Connect Eygle / Eygle
Connected.
SQL> CREATE TABLE EMP AS SELECT * from scott.emp;
Table created.
SQL>
SQL> Connect / as sysdba
Connected.
SQL> Startup force;
Oracle Instance Started.
Total System Global Area 47256168 Bytes
Fixed size 451176 bytes
Variable size 29360128 bytes
Database buffers 16777216 BYTES
Redo buffers 667648 bytes
Database mounted.
Database opened.
SQL> SET LINESIZE 120
SQL> Connect Scott / Tiger
Connected.
SQL> SELECT * FROM EMP;
Empno ename Job Mgr Hiredate Sal Comm Deptno
---------- ------------------------------------- -------- --------------------
7369 Smith Clerk 7902 17-DEC-80 800 20
8888 Eygle Manager 11-Aug-04 9999 10 107566 Jones Manager 7839 02-APR-81 2975 20
7698 Blake Manager 7839 01-MAY-81 2850 30
7782 Clark Manager 7839 09-JUN-81 2450 10
7788 Scott Analyst 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7876 Adams Clerk 7788 23-May-87 1100 20
7900 James Clerk 7698 03-DEC-81 950 30
7902 Ford Analyst 7566 03-DEC-81 3000 20
7934 Miller Clerk 7782 23-JAN-82 1300 10
11 rows selected.
SQL> Connect Eygle / Eygle
Connected.
SQL> SELECT * FROM EMP;
Empno ename Job Mgr Hiredate Sal Comm Deptno
---------- ------------------------------------- -------- --------------------
7369 Smith Clerk 7902 17-DEC-80 800 20
8888 Eygle Manager 11-Aug-04 9999 10 10
7566 Jones Manager 7839 02-APR-81 2975 20
7698 Blake Manager 7839 01-MAY-81 2850 30
7782 Clark Manager 7839 09-JUN-81 2450 10
7788 Scott Analyst 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7876 Adams Clerk 7788 23-May-87 1100 20
7900 James Clerk 7698 03-DEC-81 950 307902 Ford Analyst 7566 03-DEC-81 3000 20
7934 Miller Clerk 7782 23-JAN-82 1300 10
11 rows selected.
SQL> SELECT SQL_TEXT, VERSION_COUNT, HASH_VALUE, TO_CHAR (Hash_Value, 'XXXXXXXXX') HEX, Address
2 from v $ sqlarea where sql_text limited 'SELECT * ex%';
SQL_Text Version_Count Hash_Value Hex Address
----------------------------------- ---- --------
Select * from EMP 2 2648707557 9DE011E5 52D9EA28
SQL> SELECT SQL_TEXT, UserName, Address, Hash_Value, TO_CHAR (HASH_VALUE, 'XXXXXXXXX') HEX_HASH_VALUE, Child_Number, Child_Latch
2 from V $ SQL A, DBA_USERS B Where A.Parsing_user_id = B.user_id and sql_text limited 'SELECT * FROM EMP%'
SQL_TEXT UserName Address Hash_Value Hex_hash_va child_number child_latch
------------------------------------------------------------------------------- -------- ----------------------------- -
SELECT * FROM EMP Scott 52d9EA28 2648707557 9DE011E5 0 1
Select * from Emp Eygle 52D9EA28 2648707557 9DE011E5 1 1
Note: Here we can see the difference between V $ SQLAREA and V $ SQL.
V $ SQL reserves an entry for each SQL, and V $ SQLAREA is based on SQL_Text, and the number of child pointers is calculated through the Version_Count.
We noticed that these two SQL statements are identical because their code is identical, so their address, hash_value is exactly the same.
This means that the two SQL statements are the same in the storage location in Shared Pool (although their execution plan may be different), the code is shared.
In this process, Oracle completed the first step of SQL parsing: grammar analysis
Oracle follows the principle of right-left and bottom-up, if you find a syntax error, you will return an error.
After the syntax check, Oracle converts SQL text to the corresponding ASCII value, then calculate its Hash_Value based on the value via the Hash function.
Looking for whether there is the same SQL statement in Shared Pool, if you exist, go to the next step; if there is no existence, try to get the Shared Pool Latch request memory, store the SQL code
There is a problem here, you need to explain:
Since the ASCII value of the uppercase letter is different, Oracle will use different code to handle the code as a different SQL, let's take a look at the test:
SQL> SELECT * from scott.dept;
DEPTNO DNAME LOC
---------- ---------------------------
10 Accounting New York
20 Research Dallas
30 Sales Chicago
40 Operations Boston
SQL> SELECT * from scott.dept;
DEPTNO DNAME LOC
---------- ---------------------------
10 Accounting New York
20 Research Dallas
30 Sales Chicago
40 Operations Boston
SQL> COL SQL_TEXT FOR A30
SQL> SELECT SQL_TEXT, HASH_VALUE FROM V $ SQL Where SQL_TEXT LIKE 'SELECT * from SCOTT%';
SQL_TEXT HASH_VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * from scott.dept 4096614922
Select * from scott.dept 2089404358
We noticed that only the difference between case, makes the same SQL statement into two "different code"
So from here we can see that SQL's standardization is very important.
After completing this step, Oracle needs to perform semantic analysis:
In this step, Oracle needs to verify that the object exists, whether the relevant user has permission, whether the reference is the same object ...
For our first query, actually the EMP table comes from different users, then the execution plan of SQL is different.
Of course, there are many factors affecting the SQL execution plan, including optimizer mode, etc.
SQL> SELECT a. *, To_char (to_hash, 'xxxxxxxxx') HEX_HASH_VALUE
2 from V $ Object_dependency a where to_name = 'EMP'
From_add from_hash t_owner to_name to_addre to_hash to_type hex_hash_va
-------- -------------------------------------------------------------------------------------------------------------------------------------------------- -------- -----------------------------------
52D9EA28 264870755 SCOTT EMP 52D9DEBC 828228010 2 315DC1AA
52D9EA28 264870755 Eygle EMP 52D82E58 1930491453 2 7310F63D
SQL> ALTER session set events 'immediate trace name library_cache level 1'; session altered.
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 2';
Session altered.
SQL> Alter Session Set Events 'Immediate Trace Name Library_Cache Level 4';
Session altered.
SQL> Alter Session Set Events 'Immediate Trace Name Library_Cache Level 8';
Session altered.
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 16';
Session altered.
SQL> Alter Session Set Events 'Immediate Trace Name Library_Cache Level 32'
Session altered.
SQL> ALTER Session Set Events 'Immediate Trace Name Library_Cache Level 100';
Session altered.
The Shared Pool is dumped here at different levels.
Before turning to the trace file, we look at the structure of library cache through the following figure:
Library Cache Handle points to Library Cache Object, contains object names, Namespace, timestamp, reference list, lock object, and PIN object list.
We look at the specific information from the Dump file, from the above V $ SQL view we get the above Query Hash_Value is 9DE011E5, address is 52D9EA28
In Bucket 4851, we found the SQL statement of SELECT * from EMP.
BUCKET 4581:
Library Object Handle: Handle = 52D9EA28
Name = SELECT * FROM EMP
Hash = 9DE011E5 TIMESTAMP = 08-26-2004 10:24:43
==> This HASH is the Hash_Value value of the SQL statement in V $ SQL.
Namespace = CRSR FLAGS = RON / TIM / PN0 / SML / [12010000]
KKKK-DDDD-LLLL = 0000-0001-0001 Lock = 0 PIN = 0 LATCH # = 1
LWT = 0x52d9EA40 [0x52d9EA40, 0X52D9EA40] LTM = 0x52d9ea48 [0x52d9ea48, 0x52d9ea48]
PWT = 0x52d9ea58 [0x52d9ea58, 0x52d9ea58] PTM = 0x52d9eab0 [0x52d9eab0, 0x52d9eab0]
Ref = 0x52d9ea30 [0x52d9ea30, 0x52d9ea30] LND = 0x52d9eabc [0x52d9eabc, 0x52d9eabc]
Library Object: Object = 52d9E7B0
TYPE = CRSR FLAGS = EXS [0001] pflags = [00] status = VALD LOAD = 0
Children: size = 16
Child # Table Reference Handle ------ ----------------------
0 52D9E96C 52D9E6CC 52D9E4AC
1 52D9E96C 52D9E70C 52D885CC
==> This is the child pointer mentioned before, each pointing to a different Handle
Data Blocks:
Data # Heap Pointer Status Pins Change Alloc (K) Size (K)
------------ --------------------- ---
0 52D9E9B8 52D9E838 I / - / A 0 none 0.86 1.09
==> The HEAP here refers to the memory address.
==> This is SQL code and user connection information
HEAP Dump of Data Block 0:
*********************************************************** ****
Heap dump head name = "library cache" desc = 0x52d9e9b8
Extent SZ = 0x224 alt = 32767 Het = 16 REC = 9 flg = 2 OPC = 0
Parent = 0x5000002c oowner = 0x52d9e7b0 nex = (nil) xsz = 0x224
EXTENT 0 AddR = 0x52d9E558
Chunk 52d9e560 SZ = 540 Perm "Perm" alo = 448
52D9E560 5000021D 00000000 52D9E7A0 000001C0 [... p ....... r ....]
52D9E570 52D9E704 52D9E660 00020002 52D9E57C [... r`r .... | ..r]
52D9E580 52D9E57C 00000000 52D9E588 52D9E588 [| .r ....... r ... r]
52D9E590 00000000 52D9E594 52D9E594 000000 [....... r ... r ....]
52D9E5A0 52D9E5A0 52D9E5A0 00000000 52D9E5AC [... r ... r ....... r]
52D9E5B0 52D9E5AC 00000000 52D9E5B8 52D9E5B8 [... r ....... r ... r]
52D9E5C0 00000000 52D9E5C4 52D9E5C4 00000000 [....... r ... r ....]
52D9E5D0 52D9E5D0 52D9E5D0 00000000 52D9E5DC [... r ... r ....... r]
52D9E5E0 52D9E5DC 00000000 52D9E5E8 52D9E5E8 [... r ....... r ... r]
52D9E5F0 00000000 52D9E5F4 52D9E5F4 00000000 [....... r ... r ....]
52D9E600 52D9E600 52D9E600 00000000 52D9E60C [... r ... r ....... r]
52D9E610 52D9E60C 00000000 52D9E618 52D9E618 [... r ....... r ... r]
52D9E620 00000000 52D9E624 52D9E624 00000000 [.... $ .. r $ .. r ....]
52D9E630 52D9E630 52D9E630 00040004 00000000 [0..R0..R ........ 52d9E640 52D9E6E4 000000000000000000000000 [... r ............]
52D9E650 00000000 00000000 52D9E63C 00000000 [....... <.. r ....]
52D9E660 52D9E570 52D9E704 00000000 000,000 [p..r ... r ........]
52D9E670 00000000 52D9E6BC 00000010 00000004 [....... r ........]
52D9E680 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D9E6B0 00000000 00000000 00000000 52D9E96C [............ l..r]
52D9E6C0 00000000 00000000 00000000 52D9E4B4 [............... r]
52D9E6D0 52D9E4B4 52D9E4AC 00000000 00000002 [... r ... r ........]
52D9E6E0 00000000 00000000 00010018 00000001 [................]
52D9E6F0 00000000 聽 0000000 000,00000 52D9E6E0 [............... r]
52D9E700 00000000 52D9E660 52D9E570 52D885D4 [.... `..rp..r ... r]
52D9E710 52D885D4 52D885CC 00000000 00000002 [... r ... r ........]
52D9E720 00000000 00000000 000,000 00000000 [................]
Repeat 4 Times
52D9E770 00000000 00000000 00000000 [............]
Extent 1 addr = 0x52d9e798
CHUNK 52D9E7A0 SZ = 360 Perm "Perm" alo = 360
52D9E7A0 40000169 00000000 00000000 000168 [i .. @ ........ h ...]
52D9E7B0 52D9EA28 52D9E7B4 52D9E7B4 52D9E7BC [(.r ... r ... r ... r]
52D9E7C0 52D9E7BC 52D9E668 00000000 00010001 [... rh..r ........]
52D9E7D0 00000000 000000000000000000000000 [................]
52D9E7E0 52D9E824 00000000 00000000 000,000 [$ .. r .........
52D9E7F0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D9E820 00000000 52D9E9B8 00000000 52D9E838 [....... r .... 8..r]
52D9E830 00000000 52FF79A4 00080304 00000000 [..... Y.R ........]
52D9E840 00000000 000000000000000000000010 [................]
52D9E850 00000004 00000000 000,000 00000000 [................]
52D9E860 00000000 52D9E640 00000002 2A4C5153 [.... @ .. r .... sql *]
52D9E870 73756C50 706D756A 682E7265 61727275 [Plusjumper.hurra]
52D9E880 6F632E79 6E632E6D 4E542820 31562053 [Y.com.cn (TNS V1]
52D9E890 2933562D 00000000 00000000 00000008 [-V3) ............]
52D9E8A0 daBefa60 00000000 0000000000 000,00000 [`...............]
52D9E8B0 00000000 00000000 0000000000000000 [................]
52D9E8C0 00000000 00000000 F0318558 52D9E8D8 [........ X.1 .... r]
52D9E8D0 52D9E630 00000000 52D9E570 00000000 [0..r .... p..r ....]
52D9E8E0 00000000 000000000000000000000000 [................]
52D9E8F0 00000000 00000000 0000002 000000D [................]
52D9E900 00000001 00000000 [.......]
CHUNK 52D9E908 SZ = 88 Free ""
52D9E900 C0000059 52D9E7A0 [Y ... r]
52D9E910 52D9EA00 52D9EA00 00000000 000,000 [... r ... r ........]
52D9E920 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
Chunk 52d9e960 sz = 76 Freeable "kgltbtab"
52D9E960 1000004D 52D9E908 0A857928 52D9E6CC [m ..... r (y ..... r]
52D9E970 52D9E70C 00000000 00000000 000,000 [... r ..........]
52D9E980 00000000 00000000 00000000 000,00000 [................]
Repeat 1 Times
52D9E9A0 00000000 00000000 00000000 [............]
Total Heap Size = 1064
Free Lists:
BUCKET 0 size = 0
CHUNK 52D9E908 SZ = 88 Free ""
52D9E900 C0000059 52D9E7A0 [Y ... r]
52D9E910 52D9EA00 52D9EA00 00000000 000,000 [... r ... r ........]
52D9E920 00000000 00000000 000,000 00000000 [................] Repeat 3 Times
Total Free Space = 88
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
Chunk 52d9e560 SZ = 540 Perm "Perm" alo = 448
52D9E560 5000021D 00000000 52D9E7A0 000001C0 [... p ....... r ....]
52D9E570 52D9E704 52D9E660 00020002 52D9E57C [... r`r .... | ..r]
52D9E580 52D9E57C 00000000 52D9E588 52D9E588 [| .r ....... r ... r]
52D9E590 00000000 52D9E594 52D9E594 000000 [....... r ... r ....]
52D9E5A0 52D9E5A0 52D9E5A0 00000000 52D9E5AC [... r ... r ....... r]
52D9E5B0 52D9E5AC 00000000 52D9E5B8 52D9E5B8 [... r ....... r ... r]
52D9E5C0 00000000 52D9E5C4 52D9E5C4 00000000 [....... r ... r ....]
52D9E5D0 52D9E5D0 52D9E5D0 00000000 52D9E5DC [... r ... r ....... r]
52D9E5E0 52D9E5DC 00000000 52D9E5E8 52D9E5E8 [... r ....... r ... r]
52D9E5F0 00000000 52D9E5F4 52D9E5F4 00000000 [....... r ... r ....]
52D9E600 52D9E600 52D9E600 00000000 52D9E60C [... r ... r ....... r]
52D9E610 52D9E60C 00000000 52D9E618 52D9E618 [... r ....... r ... r]
52D9E620 00000000 52D9E624 52D9E624 00000000 [.... $ .. r $ .. r ....]
52D9E630 52D9E630 52D9E630 00040004 00000000 [0..R0..r ........]
52D9E640 52D9E6E4 00000018 00000000 00000000 [... r ............]
52D9E650 00000000 00000000 52D9E63C 00000000 [....... <.. r ....]
52D9E660 52D9E570 52D9E704 00000000 000,000 [p..r ... r ........]
52D9E670 00000000 52D9E6BC 00000010 00000004 [....... r ........]
52D9E680 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D9E6B0 00000000 00000000 00000000 52D9E96C [............ l..r]
52D9E6C0 00000000 00000000 00000000 52D9E4B4 [............... r]
52D9E6D0 52D9E4B4 52D9E4AC 00000000 00000002 [... r ... r ........]
52D9E6E0 00000000 00000000 00010018 00000001 [................] 52D9E6F0 00000000 00000000 00000000 52D9E6E0 [............. r]
52D9E700 00000000 52D9E660 52D9E570 52D885D4 [.... `..rp..r ... r]
52D9E710 52D885D4 52D885CC 00000000 00000002 [... r ... r ........]
52D9E720 00000000 00000000 000,000 00000000 [................]
Repeat 4 Times
52D9E770 00000000 00000000 00000000 [............]
CHUNK 52D9E7A0 SZ = 360 Perm "Perm" alo = 360
52D9E7A0 40000169 00000000 00000000 000168 [i .. @ ........ h ...]
52D9E7B0 52D9EA28 52D9E7B4 52D9E7B4 52D9E7BC [(.r ... r ... r ... r]
52D9E7C0 52D9E7BC 52D9E668 00000000 00010001 [... rh..r ........]
52D9E7D0 00000000 000000000000000000000000 [................]
52D9E7E0 52D9E824 00000000 00000000 000,000 [$ .. r .........
52D9E7F0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D9E820 00000000 52D9E9B8 00000000 52D9E838 [....... r .... 8..r]
52D9E830 00000000 52FF79A4 00080304 00000000 [..... Y.R ........]
52D9E840 00000000 000000000000000000000010 [................]
52D9E850 00000004 00000000 000,000 00000000 [................]
52D9E860 00000000 52D9E640 00000002 2A4C5153 [.... @ .. r .... sql *]
52D9E870 73756C50 706D756A 682E7265 61727275 [Plusjumper.hurra]
52D9E880 6F632E79 6E632E6D 4E542820 31562053 [Y.com.cn (TNS V1]
52D9E890 2933562D 00000000 00000000 00000008 [-V3) ............]
52D9E8A0 daBefa60 00000000 0000000000 000,00000 [`...............]
52D9E8B0 00000000 00000000 0000000000000000 [................]
52D9E8C0 00000000 00000000 F0318558 52D9E8D8 [........ X.1 .... r]
52D9E8D0 52D9E630 00000000 52D9E570 00000000 [0..r .... p..r ....]
52D9E8E0 0000000000000000000000000000000000 [................] 52D9E8F0 000000000000000000000002 0000000D [................]
52D9E900 00000001 00000000 [.......]
Permanent Space = 900
*********************************************************** ****
BUCKET 4581 Total Object Count = 1
We look at the structure of Library Cache Object as a case: Take the Handle: 52D885CC:
*********************************************************** ****
Library Object Handle: Handle = 52D885CC
Namespace = CRSR FLAGS = RON / KGHP / PN0 / [10010000]
KKKK-DDDD-LLLL = 0000-0041-0041 Lock = 0 PIN = 0 latch # = 1
LWT = 0x52d885e4 [0x52d885e4, 0x52d885e4] ltm = 0x52d885ec [0x52d885ec, 0x52d885ec]
PWT = 0x52d885fc [0x52d885fc, 0x52d885fc] PTM = 0x52d88654 [0x52d88654, 0x52d88654]
Ref = 0x52d885d4 [0x52d9e70c, 0x52d9e70c] LND = 0x52d88660 [0x52d88660, 0x52d88660]
Library Object: Object = 52d82a24
TYPE = CRSR FLAGS = EXS [0001] pflags = [00] status = VALD LOAD = 0
Dependencies: count = 1 size = 16
Dependency # Table Reference Handle Position Flags
------------------------------------ -------------
0 52D82BE0 52D82B20 52D82E58 14 dep [01]
==> We saw this Cursor-dependent object at the Dependency section, Handle: 52D82E58
==> This handle point is an Eygle.EMP table, if the above two CRSR access is the same object, then
==> These two SQL will be real sharing. Here our SQL is the same, the access is the data sheet for different users.
==> The concept of child pointer is coming out.
==> Here we see 52D82E58 points to the Eygle.emp object, that is, the data table queryed by Eygle.
Accesses: count = 1 size = 16
Dependency # types
----------- -----
0 0009
TRANSLATIONS: count = 1 size = 16
Original Final
-------- --------
52D82E58 52D82E58
Data Blocks:
Data # Heap Pointer Status Pins Change Alloc (K) Size (K)
------------ --------------------- --- 0 52D8C244 52D827E4 I / - / A 0 none 1.09 1.64
6 52D82AC0 52D817C4 I / - / A 0 None 3.70 3.73
==> Data Blocks here is an important part
==> Each control block contains a Heap Descriptor, pointing to the corresponding Heap Memory, this Heap Memory is included.
==> Diana Tree, P-CURE, SOURCE CODE, Shared Cursor Context Area, etc., it is usually
==> What is said, the parsed SQL and the implementation plan, the SQL is only shared after it is true here. Just avoid hard
==> Analysis
HEAP Dump of Data Block 0:
*********************************************************** ****
Heap dump head name = "library cache" desc = 0x52d8c244
Extent SZ = 0x224 alt = 32767 Het = 16 REC = 9 flg = 2 OPC = 0
Parent = 0x5000002c Owner = 0x52d82a24 nex = (nil) xsz = 0x224
Extent 0 AddR = 0x52D80FF0
CHUNK 52D80FF8 SZ = 464 free ""
52D80FF0 C00001D1 00000000 [........]
52D81000 52D8C28C 52D8C28C 00000000 00000000 [... r ... r ........]
52D81010 00000000 million 00000000 [................]
REPEAT 26 TIMES
52D811C0 00000000 00000000 [.......]
Chunk 52D811C8 SZ = 76 Freeable "KGLTBTAB"
52D811C0 1000004D 52D80FF8 [m ... r]
52D811D0 0A857928 52D82B68 00000000 00000000 [(Y..h .r ........]
52D811E0 00000000 000000000000000000000000 [................]
Repeat 2 Times
52D81210 00000000 [....]
Extent 1 addr = 0x52d827cc
CHUNK 52D827D4 SZ = 540 Perm "Perm" alo = 532
52D827D0 5000021D 00000000 52D82A14 [... p ..... *. R]
52D827E0 0000000014 00000000 0000001A 00000069 [........... I ...]
52D827F0 0000000000000000000000000000 00000006 [..................] 52D82800 00000850 00000010 00000008 00000005 [P ...............
52D82810 00000005 4C475945 00000045 00000000 [.... Eygle .......]
52D82820 00000000 00000000 000,000 00000000 [................]
52D82830 00050000 52D82970 00000000 00000000 [.... p) .r ........]
52D82840 00000069 4C475945 00000045 00000000 [i ... Eygle .......]
52D82850 000000000000000000000000000000 [................]
52D82860 00050000 00000001 00000004 00000019 [................]
52D82870 0000000B 00000000 00000002 00000001 [................]
52D82880 00002DC7 00000000 000030A4 00000000 [.-....... 0 ......]
52D82890 00000000 04000000 00000000 00650000 [............ e.]
52D828A0 00100000 00050001 01050100 00000001 [................]
52D828B0 000007D0 00640000 00010000 01000000 [... D .........]
52D828C0 00000404 00000000 01010101 01010001 [................]
52D828D0 01010101 00010001 01010101 00000000 [................]
52D828E0 00000202 02010000 01010100 01010101 [................]
52D828F0 00000000 01000001 00000000 00000000 [................]
52D82900 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82910 0036190B 0000000 0000001C4 00000000 [..6 .............
52D82920 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82940 00022000 0000000 0000fff fffffff [. ............]
52D82950 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82960 0036190B 00000000 00000000 000,000 [..6 .............
52D82970 00000001 00000069 00000077 00000002 [.... i ... w .......]
52D82980 00000003 52D829D8 00010010 00000004 [.....). R ........]
52D82990 00000000 00000000 000,000 00000000 [................]
52D829A0 00000000 00000000 52D82B58 00010010 [........ x .r ....] 52D829B0 00000004 52D82B40 00010010 00000004 [.... @ . R ........]
52D829C0 00000000 million 00000000 [................]
52D829D0 00000000 00000000 52D82BE0 00000000 [......... . R ....]
52D829E0 00000000 00000000 00000000 000,000 [................]
Extent 2 AddR = 0x52D82A0C
CHUNK 52D82A14 SZ = 252 Perm "Perm" alo = 252
52D82A10 400000FD 00000000 00000000 [... @ ........]
52D82A20 000000FC 52D885CC 52D82A28 52D82A28 [....... r (*. R (*. R]
52D82A30 52D82A30 52D82A30 52D82984 00000000 [0 * .R0 * .r.). R ....
52D82A40 00010001 00000000 00000000 000,000 [................]
52D82A50 00000000 52D82A98 00000000 00000000 [..... *. R ........]
52D82A60 00000000 00000000 00000000 52D82AAC [............. *. R]
52D82A70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82A90 00000000 00000000 52D8C244 00000000 [......... D..R ....]
52D82AA0 52D827E4 00000000 52FF5B74 52D82AC0 [. '. R .... t [.r. *. R]
52D82AB0 00000000 52D817C4 00040000 52FF5B9C [....... r ..... [. R]
52D82AC0 5000002C 00001024 52D82A24 52D817AC [, .. p $ ... $ *. R ... r]
52D82AD0 52D817B4 00000000 52D8237C 05010200 [... r .... | # .r ....]
52D82AE0 00000000 00000000 206C7173 61657261 [........ SQL Area]
52D82AF0 00000000 00000000 00107FFF 7FFF7FFF [................]
52D82B00 00000401 000000 52D82B08 52D82B08 [....... . R. . R]
CHUNK 52D82B10 SZ = 120 Perm "Perm" alo = 104
52D82B10 40000079 52D82A14 52D827D4 00000068 [Y .. @. *. R. '. Rh ...]
52D82B20 52B2D470 52B2D470 52D82E58 00000000 [p..RP..RX..R ....]
52D82B30 00000001 52D82A24 0000000E 00000001 [... $ *. R ........ 52D82B40 52D82B94 00000000000000 00000000 [. . R ..........]
52D82B50 52D82E58 52D82E58 52D811D4 000000 [X..RX..R ... r ....]
52D82B60 00000000 million 00000000 [................]
52D82B70 02000000 00000000 00000000 000,00000 [................]
52D82B80 00000000 00000000 [.......]
CHUNK 52D82B88 SZ = 76 Freeable "KGLTBTAB"
52D82B80 0000004D 52D82B10 [m .... . R]
52D82B90 0A857928 52D82B50 00000000 00000000 [(Y..P .r ........]
52D82BA0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D82BD0 00000000 [....]
Chunk 52D82BD4 SZ = 76 Freeable "KGLTBTAB"
52D82BD0 1000004D 52D82B88 0A857928 [m .... . R (y ..]
52D82BE0 52D82B20 00000000 00000000 00000000 [ .r ............]
52D82BF0 00000000000000000000000000000000 [................]
Repeat 2 Times
Total HEAP SIZE = 1604
Free Lists:
BUCKET 0 size = 0
CHUNK 52D80FF8 SZ = 464 free ""
52D80FF0 C00001D1 00000000 [........]
52D81000 52D8C28C 52D8C28C 00000000 00000000 [... r ... r ........]
52D81010 00000000 million 00000000 [................]
REPEAT 26 TIMES
52D811C0 00000000 00000000 [.......]
Total Free Space = 464
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
CHUNK 52D82B10 SZ = 120 Perm "Perm" alo = 104
52D82B10 40000079 52D82A14 52D827D4 00000068 [Y .. @. *. R. '. Rh ...]
52D82B20 52B2D470 52B2D470 52D82E58 00000000 [p..RP..RX..R ....] 52D82B30 00000001 52D82A24 0000000E 00000001 [... $ *. R ........]
52D82B40 52D82B94 00000000 00000000 00000000 [. . R ............]]]
52D82B50 52D82E58 52D82E58 52D811D4 000000 [X..RX..R ... r ....]
52D82B60 00000000 million 00000000 [................]
52D82B70 02000000 00000000 00000000 000,00000 [................]
52D82B80 00000000 00000000 [.......]
CHUNK 52D827D4 SZ = 540 Perm "Perm" alo = 532
52D827D0 5000021D 00000000 52D82A14 [... p ..... *. R]
52D827E0 0000000014 00000000 0000001A 00000069 [........... I ...]
52D827F0 00000000000000000000000000000006 [................]
52D82800 00000850 00000010 00000008 00000005 [P ...............]
52D82810 00000005 4C475945 00000045 00000000 [.... Eygle .......]
52D82820 00000000 00000000 000,000 00000000 [................]
52D82830 00050000 52D82970 00000000 00000000 [.... p) .r ........]
52D82840 00000069 4C475945 00000045 00000000 [i ... Eygle .......]
52D82850 000000000000000000000000000000 [................]
52D82860 00050000 00000001 00000004 00000019 [................]
52D82870 0000000B 00000000 00000002 00000001 [................]
52D82880 00002DC7 00000000 000030A4 00000000 [.-....... 0 ......]
52D82890 00000000 04000000 00000000 00650000 [............ e.]
52D828A0 00100000 00050001 01050100 00000001 [................]
52D828B0 000007D0 00640000 00010000 01000000 [... D .........]
52D828C0 00000404 00000000 01010101 01010001 [................]
52D828D0 01010101 00010001 01010101 00000000 [................]
52D828E0 00000202 02010000 01010100 01010101 [................]
52D828F0 000000000000000000000000 [................] 52D82900 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82910 0036190B 0000000 0000001C4 00000000 [..6 .............
52D82920 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82940 00022000 0000000 0000fff fffffff [. ............]
52D82950 00000000 00000000 00000000 1A086878 [............ xh ..]
52D82960 0036190B 00000000 00000000 000,000 [..6 .............
52D82970 00000001 00000069 00000077 00000002 [.... i ... w .......]
52D82980 00000003 52D829D8 00010010 00000004 [.....). R ........]
52D82990 00000000 00000000 000,000 00000000 [................]
52D829A0 00000000 00000000 52D82B58 00010010 [........ x .r ....]
52D829B0 00000004 52D82B40 00010010 00000004 [.... @ . R ........]
52D829C0 00000000 million 00000000 [................]
52D829D0 00000000 00000000 52D82BE0 00000000 [......... . R ....]
52D829E0 00000000 00000000 00000000 000,000 [................]
CHUNK 52D82A14 SZ = 252 Perm "Perm" alo = 252
52D82A10 400000FD 00000000 00000000 [... @ ........]
52D82A20 000000FC 52D885CC 52D82A28 52D82A28 [....... r (*. R (*. R]
52D82A30 52D82A30 52D82A30 52D82984 00000000 [0 * .R0 * .r.). R ....
52D82A40 00010001 00000000 00000000 000,000 [................]
52D82A50 00000000 52D82A98 00000000 00000000 [..... *. R ........]
52D82A60 00000000 00000000 00000000 52D82AAC [............. *. R]
52D82A70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D82A90 00000000 00000000 52D8C244 00000000 [......... D..R ....]
52D82AA0 52D827E4 00000000 52FF5B74 52D82AC0 [. '. R .... t [.r. *. R]
52D82AB0 00000000 52D817C4 00040000 52FF5B9C [....... r ..... [. R] 52D82AC0 5000002C 00001024 52D82A24 52D817AC [, .. p $ ... $ *. R ... r]
52D82AD0 52D817B4 00000000 52D8237C 05010200 [... r .... | # .r ....]
52D82AE0 00000000 00000000 206C7173 61657261 [........ SQL Area]
52D82AF0 00000000 00000000 00107FFF 7FFF7FFF [................]
52D82B00 00000401 000000 52D82B08 52D82B08 [....... . R. . R]
Permanent Space = 912
*********************************************************** ****
HEAP Dump of Data Block 6:
*********************************************************** ****
Heap dump heap name = "sql area" dec = 0x52d82ac0
Extent SZ = 0x1024 alt = 32767 HET = 16 REC = 0 flg = 2 OPC = 5
Parent = 0x5000002c oowner = 0x52d82a24 nex = (nil) xsz = 0x0
EXTENT 0 AddR = 0x52d817ac
CHUNK 52D817B4 SZ = 3784 Perm "perm" alo = 3784
52D817B0 50000EC9 00000000 00000000 [... p ........]
52D817C0 00000EC8 00000010 00000004 00000010 [................]
52D817D0 00000000000000000000 [................]
52D817E0 0000000000000000000000000000000000 [................]
52D817F0 00000000 52D81F5C 404EEB2C 00000000 [.... / .. r, .n @ ....]
52D81800 00000000 00000000 00000000 52D81A08 [............... r]
52D81810 000000000000000000000010 0000000003 [................]
52D81820 00000000 00000000 00000000 1A086878 [............ xh ..]
52D81830 0029180B 00000000 00000000 000,000 [..) .............
52D81840 52D81C10 52D82540 00000000 52D824D4 [... r @%. R ..... $. R]
52D81850 00000000 00000000 00000000 52D81B7C [............ | ..r]
52D81860 000,000 0000000 0000001 52D81BFC [............... r]
52D81870 52D82360 00000000 00000000 52D82894 [`# .r ......... (. R] 52D81880 000000000000000000000000000000 [................]
Repeat 1 Times
52D818A0 00000000 00000000 08000000 52D823AC [............. #. R]
52D818B0 00000000000000000000 [................]
52D818C0 00000000210000000 0000000000000000 [$ ...............
52D818D0 0000000 000 million 00000000 52D81C1C [............... r]
52D818E0 00000000 00000000 00000000 52D82620 [.......... & .r]
52D818F0 00000000 00000000 00000000 52D81958 [............ x..r]
52D81900 00000000 million 00000000 [................]
52D81910 00000000 00000000 52D8252C 00010001 [........%. R ....]
52D81920 EBCE39A4 00000000 00000000 00000000 [.9 ............]
52D81930 00000000 00000000000000000000000001 [................]
52D81940 00000001 00000794 00000000 0000001 [................]
52D81950 0000001 0000008 000,00000 52D817C4 [............... r]
52D81960 00000000 00000000 00000202 00000000 [................]
52D81970 52D819B8 52D819A0 52D81990 5001A874 [... r ... r ... rt..P]
52D81980 00000000 000,000 52D819FC 52D819CC [........... r ... r]
52D81990 52D82AC0 404EFB80 00000000 00000000 [. *. R..n @ ........]
52D819A0 00000000 00000000 52D81958 00000000 [......... X..r ....]
52D819B0 00000000 00000000 00000000 52D81958 [............ x..r]
52D819C0 00000002 52D885CC 00000000 52D819E4 [....... r ....... r]
52D819D0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D819F0 00000001 00000000 00000000 52D81958 [............ x..r]
52D81A00 00000000 00000000 4C475945 00000045 [......... Eygle ...]
52D81A10 00000000000000000000000000000000 [................]
52D81A20 00000000 00050000 00000069 0000000E [......... I .......] 52D81A30 4D450003 00000050 00000000 00000500 [..emp ...........
52D81A40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D81A60 404EE794 00000000 00000000 00000014 [..n @ ............]
52D81A70 000000000000000000 [................]
52D81A80 0000000000000000000000000000000000 [................]
52D81A90 000000000000000000000000 00003F09 [...........? ..]
52D81AA0 00000000000000000000000000000000000000 [................]
52D81AB0 00000000 00000069 00080008 000000 [.... i ...........]
52D81AC0 08687800 29180B1A 1A086878 7829180B [.xH ....) XH ....) x]
52D81AD0 0B1A0868 00002918 00000000 00000000 [h ....) ........]
52D81AE0 00000000000000000000000000000000 [................]
52D81AF0 00000000 00000001 00000000 0002E0 [................]
52D81B00 00000000 00000008 00000000 000,000 [................]
52D81B10 00000000 404EEC04 00000000 52D81B9C [... n @ ....... r]
52D81B20 52D81B9C 00000000 00000000 000,000 [... r ............]
52D81B30 00000000 million 00000000 [................]
52D81B40 00000000 0000000000000000 20000000 [...............]
52D81B50 00000000 million 0000000000 [................]
Repeat 1 Times
52D81B70 000000 00000000 00000000 52D81948 [............ h..r]
52D81B80 00000000 00000002 00000008 0000000E [..............]
52D81B90 59450005 00454C47 00000000 00000000 [..eygle .........]
52D81BA0 405480000000001 00000064 00000000 [..t @ .... d .......]
52D81BB0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D81BD0 00000000 0000000000000000000000 [..... ........]
52D81BE0 0000000000000000000000000000000000 [................] 52D81BF0 0000000000000000 00003F09 00000000 [..............]
52D81C00 00000014 00000004 00000001 00000000 [................]
52D81C10 00000000 00003F09 00010000 52D81FD4 [..... ......... r]
52D81C20 52D81F08 52D81F64 00000000 00000010 [... rd..r ........]
52D81C30 00000007 00000100 00000000 000,00000 [................]
52D81C40 00000000 000000000000000000000010 [................]
52D81C50 00000104 00000000 00000000 000,00000 [................]
52D81C60 00000000000000000000000000000000 [................]
52D81C70 52D81A2C 00000000 404EE794 00000000 [, .. r ... n @ ....]
52D81C80 00000000 00000007 000001010 000,00000 [................]
52D81C90 00010041 00000000 00000014 00000004 [a ...............]
52D81CA0 0000000010 000001A0 00000016 00000000 [................]
52D81CB0 52D824B4 00040000 00000000 52D82300 [. $. R ......... #. R]
52D81CC0 00000000 52D81A2C 52D81FC4 404EE794 [...., .. r ... r..n @]
52D81CD0 00000000 00000000 000,00000 52D81C84 [............. r]
52D81CE0 00000007 00000102 00000000 00010041 [............ a ...]
52D81CF0 00000000 00000014 00000001C 00000010 [................]
52D81D00 00000194 00000016 00000000 52D82494 [........... $. R]
52D81D10 00040000 00000000 52D822A0 00000000 [......... ". R ....]
52D81D20 52D81A2C 52D81FB8 404EE794 00000000 [, .. r ... r..n @ ....]
52D81D30 00000000 52D81CD8 52D81CE0 00000007 [....... r ... r ....]
52D81D40 00000102 00000000 00010041 00000000 [........ a .......]
52D81D50 0000000014 00000034 00000010 00000188 [.... 4 ...........]
52D81D60 0000000016 00000000 52D82474 00040000 [........ t $ .r ....]
52D81D70 00000000 52D8240 00000000 52D81A2C [.... @ ". R ...., .. r]
52D81D80 52D81FAC 404EE794 00000000 00000000 [... r..n @ ........ 52D81D90 52D81D34 52D81D3C 00000007 0000010C [4..R <.. r ........]
52D81DA0 00000000 00010041 00000000 00000014 [.... a ...........]
52D81DB0 0000004C 00000010 0000017C 00000007 [l ....... | .......]
52D81DC0 00000000 52D82454 00040000 00000000 [.... t $ .r ........]
52D81DD0 52D821E0 00000000 52D81A2C 52D81F9C [.! R ...., .. r ... r]
52D81DE0 404EE794 00000000 00000000 52D81D90 [..n @ ........... r]
52D81DF0 52D81D98 00000007 00000102 00000000 [... r ............]
52D81E00 00010041 00000000 00000014 00000054 [a ......... T ...]
52D81E10 00000000000000000000000016 00000000 [.... p ...........]
52D81E20 52D82434 00040000 00000000 52D82180 [4 $ .r .........!. R]
52D81E30 00000000 52D81A2C 52D81F90 404EE794 [...., .. r ... r..n @]
52D81E40 00000000 000,000 52D81DEC 52D81DF4 [........... r ... r]
52D81E50 00000007 00000101 00010354 00010041 [........ t ... a ...]
52D81E60 00040000 00000014 0000006C 00000010 [........ l .......]
52D81E70 00000164 00090009 00000000 52D82414 [D ......... $. R]
52D81E80 00040000 00000000 52D82120 00000000 [........! .R ....]
52D81E90 52D81A2C 52D81F84 404EE794 00000000 [, .. r ... r..n @ ....]
52D81EA0 00000000 52D81E48 52D81E50 00000007 [.... h..rp..r ....]
52D81EB0 00000101 00010354 00010041 00040000 [.... t ... a .......]
52D81EC0 0000000014 00000078 00000010 00000158 [.... x ....... x ...]
52D81ED0 000A000A 00000000 52D823F4 00040000 [......... #. R ....]
52D81EE0 00000000 52D820C0 00000000 52D81A2C [......r ...., .. r]
52D81EF0 52D81F74 404EE794 00000000 00000000 [t..r..n @ ........]
52D81F00 52D81EA4 52D81EAC 00000007 00000102 [... r ... r ........]
52D81F10 00000000 00010041 00000000 00000014 [.... a ...........]
52D81F20 00000084 00000010 0000014C 00000016 [........ L .......] 52D81F30 00000000 52D823D4 00040000 00000000 [..... #. R ........]
52D81F40 52D82060 00000000 52D81A2C 52D81F64 [`.r ...., .. rd..r]
52D81F50 404EE794 00000000 00000000 52D81F00 [..n @ ........... r]
52D81F60 52D81F08 00000007 4D450005 004F4E50 [... r ... Empno.]
52D81F70 00000000 00000007 4E450005 00454D41 [........ ename.]
52D81F80 00000000 000000004 4F4A0003 00000042 [........ Job ...]
52D81F90 00000007 474D0003 00000052 00000007 [... Mgr .......]
52D81FA0 49480008 41444552 00004554 00000007 [..hired ......]]
52D81FB0 41530003 0000004C 00000007 4F430004 [..sal ......... Co]
52D81FC0 00004D4D 00000007 45440006 4F4E5450 [mm ........ deptno]
52D81FD0 00000000 52D81FE8 52D81EAC 52D81F74 [....... r ... rt..r]
52D81FE0 00000000 00000010 52D81FFC 52D81E50 [........... rp..r]
52D81FF0 52D81F84 00000000 00000010 52D82010 [... r ..........R]
52D82000 52D81DF4 52D81F90 00000000 00000010 [... r ... r ........]
52D82010 52D82024 52D81D98 52D81F9C 00000000 [$ .r ... r ... r ....]
52D82020 00000010 52D82038 52D81D3C 52D81FAC [.... 8 .r <.. r ... r]
52D82030 00000000 00000010 52D8204C 52D81CE0 [........ l.r ... r]
52D82040 52D81FB8 00000000 00000010 00000000 [... r ............]
52D82050 52D81C84 52D81FC4 00000000 00000010 [... r ... r ........]
52D82060 00000000 00010001 00020001 00000016 [................]
52D82070 00000004 00000000 00000000 00000000 [................]
52D82080 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D820B0 00000000 00000000 00000000 00003F09 [...........? ..]
52D820C0 00000000 00020002 00010002 000A000A [..............]
52D820D0 0000000000000000000000000000000000 [................]
Repeat 2 TIMES52D82100 00010354 000000 000,000 0000000 [T ...............]
52D82110 00000000 00000000 00000000 00003F09 [...........? ..]
52D82120 00000000 00030003 00010003 00090009 [................]
52D82130 00000000 00000000 00000000 000,00000 [................]
Repeat 2 Times
52D82160 00010354 00000000 00000000 00000000 [T ...............]
52D82170 0000000000000000000000 00003F09 [...........? ..]
52D82180 000000 00040004 00020004 00000016 [................]
52D82190 000000000000000000 [................]
52D821A0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D821D0 00000000 0000000000000000 00003F09 [...........? ..]
52D821E0 00000000 00050005 000c0005 00000007 [................]
52D821F0 00000000000000000000000000000000 [................]
Repeat 3 Times
52D82230 00000000 00000000 00000000 00003F09 [............? ..]
52D82240 00000000 00060006 00020006 00000016 [................]
52D82250 00000000000000000000 [................]
52D82260 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D82290 00000000 000000000000000000003f09 [...........? ..]
52D822A0 00000000 00070007 00020007 00000016 [................]
52D822B0 00000207 000000000000000000000000 [................]
52D822C0 00000000 million 00000000 [................]
Repeat 2 Times
52D822F0 00000000 00000000 00000000 00003F09 [...........? ..]
52D82300 00000000 00080008 00020008 00000016 [................]
52D82310 00000000000000000000 [................]
52D82320 000000000000000000000000000000 [................]
Repeat 2 Times
52D82350 000 million 00000000000000000000000000000000000000000000000000000000000000000000 00000000 52D82374 [............ t # .r]
52D82370 00003F09 00000000 52D82370 3eeeeeeee [.? ... p # .r ...>]
52D82380 00000000 52D817B4 52D82388 52D82388 [....... r. #. R. #. R]
52D82390 00000000 404EECB8 404EECB8 404EECB8 [... n @ .. n @ .. n @]
52D823A0 00000000 00000000 000,00000 52D81A6C [........... L.R]
52D823B0 00000008 52D81F08 52D81EAC 52D81E50 [....... r ... rp..r]
52D823C0 52D81DF4 52D81D98 52D81D3C 52D81CE0 [... r ... r <.. r ... r]
52D823D0 52D81C84 00000010 0000014C 00000014 [... r .... l .......]
52D823E0 00000084 00000016 00000001 52D82060 [........... `` .r]
52D823F0 00000001 00000010 00000158 00000014 [........ x .......]
52D82400 00000078 0000000A 00000002 52D820C0 [x .......... .r]
52D82410 00000001 00000010 00000164 00000014 [........ d .......]
52D82420 0000006C 00000009 00000003 52D82120 [l ...........! .R]
52D82430 00000001 00000010 00000170 00000014 [........ p .......]
52D82440 00000054 00000016 00000004 52D82180 [T ............! R]
52D82450 00000001 00000010 0000017C 00000014 [........ | .......]
52D82460 0000004C 00000007 00000005 52D821E0 [l ............! R]
52D82470 00000001 00000010 00000188 00000014 [................]
52D82480 00000034 00000016 00000006 52D82240 [4 ........... @ ". R]
52D82490 00000001 00000010 00000194 00000014 [................]
52D824A0 0000001C 00000016 00000007 52D822A0 [............. ". R]
52D824B0 00000001 00000010 000001A0 00000014 [................]
52D824C0 00000004 00000016 00000008 52D82300 [............. #. R]
52D824D0 00000001 52D81938 00000004 00000002 [.... 8..r ........]
52D824E0 000000BC 00000000 52D81C1C 00000008 [........... r ....]
52D824F0 0000000000000000000000000000000000 [................] 52D82500 00000000 00000000 00000012 02400791 [............ @.]
52D82510 00003F09 00003F09 00030000 00001FE8 [.? ...? ........]
52D82520 00000000 00000100 3F091826 00000001 [........ & ..? ....
52D82530 00000000000000000000 [................]
52D82540 00000000000000000000000000000000 [................]
52D82550 52D823B0 00000010 000001D0 00000017 [. #. R ..........]
52D82560 52D82524 00000001 00003F09 00000000 [$%. R ..... ......]
52D82570 0000000000 00000000 [................]
52D82580 000000000000000000000000000000 [................]
52D82590 00000000 00000000 52D823D4 00080000 [......... #. R ....]
52D825A0 00000000000000000000000 52D82508 [...........%. R]
52D825B0 00000000000000000000000010 00000270 [........... p ...]
52D825C0 52D823D4 00000008 00000014 0000009C [. #. R ............]
52D825D0 00000000 00000000 00000000 52D81ACF [............... r]
52D825E0 00000000 00000000 00000000 000,00000 [................]
Repeat 3 Times
52D82620 52D8263C 00000010 000006D4 00000010 [<&. R ............]
52D82630 000006F4 00000010 000006F8 00000010 [................]
52D82640 000006FC 00000010 00000714 00000010 [................]
52D82650 00000720 00000010 00072C 00000010 [......., .......]
52D82660 000007410 0000010 00074C 00000010 [d ....... l .......]
52D82670 00000764 00000010 0000077C [D ....... | ...]
Total Heap Size = 3784
Free Lists:
BUCKET 0 size = 0
Total Free Space = 0
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
CHUNK 52D817B4 SZ = 3784 Perm "perm" alo = 3784
52D817B0 50000EC9 00000000 00000000 [... p ........] 52D817C0 00000EC8 00000010 00000004 00000010 [................]
52D817D0 00000000000000000000 [................]
52D817E0 0000000000000000000000000000000000 [................]
52D817F0 00000000 52D81F5C 404EEB2C 00000000 [.... / .. r, .n @ ....]
52D81800 00000000 00000000 00000000 52D81A08 [............... r]
52D81810 000000000000000000000010 0000000003 [................]
52D81820 00000000 00000000 00000000 1A086878 [............ xh ..]
52D81830 0029180B 00000000 00000000 000,000 [..) .............
52D81840 52D81C10 52D82540 00000000 52D824D4 [... r @%. R ..... $. R]
52D81850 00000000 00000000 00000000 52D81B7C [............ | ..r]
52D81860 000,000 0000000 0000001 52D81BFC [............... r]
52D81870 52D82360 00000000 00000000 52D82894 [`# .r ......... (. R]
52D81880 00000000 00000000 000,000 00000000 [................]
Repeat 1 Times
52D818A0 00000000 00000000 08000000 52D823AC [............. #. R]
52D818B0 00000000000000000000 [................]
52D818C0 00000000210000000 0000000000000000 [$ ...............
52D818D0 0000000 000 million 00000000 52D81C1C [............... r]
52D818E0 00000000 00000000 00000000 52D82620 [.......... & .r]
52D818F0 00000000 00000000 00000000 52D81958 [............ x..r]
52D81900 00000000 million 00000000 [................]
52D81910 00000000 00000000 52D8252C 00010001 [........%. R ....]
52D81920 EBCE39A4 00000000 00000000 00000000 [.9 ............]
52D81930 00000000 00000000000000000000000001 [................]
52D81940 00000001 00000794 00000000 0000001 [................]
52D81950 0000001 0000008 000,00000 52D817C4 [............... r]
52D81960 0000000000000000 000202 00000000 [................] 52D81970 52D819B8 52D819A0 52D81990 5001A874 [... r ... r ... rt..P]
52D81980 00000000 000,000 52D819FC 52D819CC [........... r ... r]
52D81990 52D82AC0 404EFB80 00000000 00000000 [. *. R..n @ ........]
52D819A0 00000000 00000000 52D81958 00000000 [......... X..r ....]
52D819B0 00000000 00000000 00000000 52D81958 [............ x..r]
52D819C0 00000002 52D885CC 00000000 52D819E4 [....... r ....... r]
52D819D0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D819F0 00000001 00000000 00000000 52D81958 [............ x..r]
52D81A00 00000000 00000000 4C475945 00000045 [......... Eygle ...]
52D81A10 00000000000000000000000000000000 [................]
52D81A20 00000000 00050000 00000069 0000000E [........ i .......]
52D81A30 4D450003 00000050 00000000 00000500 [..emp ...........]
52D81A40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D81A60 404EE794 00000000 00000000 00000014 [..n @ ............]
52D81A70 000000000000000000 [................]
52D81A80 0000000000000000000000000000000000 [................]
52D81A90 000000000000000000000000 00003F09 [...........? ..]
52D81AA0 00000000000000000000000000000000000000 [................]
52D81AB0 00000000 00000069 00080008 000000 [.... i ...........]
52D81AC0 08687800 29180B1A 1A086878 7829180B [.xH ....) XH ....) x]
52D81AD0 0B1A0868 00002918 00000000 00000000 [h ....) ........]
52D81AE0 00000000000000000000000000000000 [................]
52D81AF0 00000000 00000001 00000000 0002E0 [................]
52D81B00 00000000 00000008 00000000 000,000 [................]
52D81B10 00000000 404EEC04 00000000 52D81B9C [... n @ ....... r] 52D81B20 52D81B9C 00000000 00000000000000 [... r ............]
52D81B30 00000000 million 00000000 [................]
52D81B40 00000000 0000000000000000 20000000 [...............]
52D81B50 00000000 million 0000000000 [................]
Repeat 1 Times
52D81B70 000000 00000000 00000000 52D81948 [............ h..r]
52D81B80 00000000 00000002 00000008 0000000E [..............]
52D81B90 59450005 00454C47 00000000 00000000 [..eygle .........]
52D81BA0 405480000000001 00000064 00000000 [..t @ .... d .......]
52D81BB0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D81BD0 00000000 0000000000000000000000 [..... ........]
52D81BE0 00000000000000000000000000000000 [................]
52D81BF0 00000000 00000000 00003F09 00000000 [......... ......]
52D81C00 00000014 00000004 00000001 00000000 [................]
52D81C10 00000000 00003F09 00010000 52D81FD4 [..... ......... r]
52D81C20 52D81F08 52D81F64 00000000 00000010 [... rd..r ........]
52D81C30 00000007 00000100 00000000 000,00000 [................]
52D81C40 00000000 000000000000000000000010 [................]
52D81C50 00000104 00000000 00000000 000,00000 [................]
52D81C60 00000000000000000000000000000000 [................]
52D81C70 52D81A2C 00000000 404EE794 00000000 [, .. r ... n @ ....]
52D81C80 00000000 00000007 000001010 000,00000 [................]
52D81C90 00010041 00000000 00000014 00000004 [a ...............]
52D81CA0 0000000010 000001A0 00000016 00000000 [................]
52D81CB0 52D824B4 00040000 00000000 52D82300 [. $. R ......... #. R]
52D81CC0 00000000 52D81A2C 52D81FC4 404EE794 [...., .. r ... r..n @] 52D81CD0 000000000000000000000000 52D81C84 [............. r]
52D81CE0 00000007 00000102 00000000 00010041 [............ a ...]
52D81CF0 00000000 00000014 00000001C 00000010 [................]
52D81D00 00000194 00000016 00000000 52D82494 [........... $. R]
52D81D10 00040000 00000000 52D822A0 00000000 [......... ". R ....]
52D81D20 52D81A2C 52D81FB8 404EE794 00000000 [, .. r ... r..n @ ....]
52D81D30 00000000 52D81CD8 52D81CE0 00000007 [....... r ... r ....]
52D81D40 00000102 00000000 00010041 00000000 [........ a .......]
52D81D50 0000000014 00000034 00000010 00000188 [.... 4 ...........]
52D81D60 0000000016 00000000 52D82474 00040000 [........ t $ .r ....]
52D81D70 00000000 52D8240 00000000 52D81A2C [.... @ ". R ...., .. r]
52D81D80 52D81FAC 404EE794 00000000 00000000 [... r..n @ ........]
52D81D90 52D81D34 52D81D3C 00000007 0000010C [4..R <.. r ........]
52D81DA0 00000000 00010041 00000000 00000014 [.... a ...........]
52D81DB0 0000004C 00000010 0000017C 00000007 [l ....... | .......]
52D81DC0 00000000 52D82454 00040000 00000000 [.... t $ .r ........]
52D81DD0 52D821E0 00000000 52D81A2C 52D81F9C [.! R ...., .. r ... r]
52D81DE0 404EE794 00000000 00000000 52D81D90 [..n @ ........... r]
52D81DF0 52D81D98 00000007 00000102 00000000 [... r ............]
52D81E00 00010041 00000000 00000014 00000054 [a ......... T ...]
52D81E10 00000000000000000000000016 00000000 [.... p ...........]
52D81E20 52D82434 00040000 00000000 52D82180 [4 $ .r .........!. R]
52D81E30 00000000 52D81A2C 52D81F90 404EE794 [...., .. r ... r..n @]
52D81E40 00000000 000,000 52D81DEC 52D81DF4 [........... r ... r]
52D81E50 00000007 00000101 00010354 00010041 [........ t ... a ...]
52D81E60 00040000 00000010 [........ L .......] 52D81E70 00000164 00090009 00000000 52D82414 [D .......... $. R]
52D81E80 00040000 00000000 52D82120 00000000 [........! .R ....]
52D81E90 52D81A2C 52D81F84 404EE794 00000000 [, .. r ... r..n @ ....]
52D81EA0 00000000 52D81E48 52D81E50 00000007 [.... h..rp..r ....]
52D81EB0 00000101 00010354 00010041 00040000 [.... t ... a .......]
52D81EC0 0000000014 00000078 00000010 00000158 [.... x ....... x ...]
52D81ED0 000A000A 00000000 52D823F4 00040000 [......... #. R ....]
52D81EE0 00000000 52D820C0 00000000 52D81A2C [......r ...., .. r]
52D81EF0 52D81F74 404EE794 00000000 00000000 [t..r..n @ ........]
52D81F00 52D81EA4 52D81EAC 00000007 00000102 [... r ... r ........]
52D81F10 00000000 00010041 00000000 00000014 [.... a ...........]
52D81F20 00000084 00000010 0000014C 00000016 [........ l .......]
52D81F30 00000000 52D823D4 00040000 00000000 [..... #. R ........]
52D81F40 52D82060 00000000 52D81A2C 52D81F64 [`.r ...., .. rd..r]
52D81F50 404EE794 00000000 00000000 52D81F00 [..n @ ........... r]
52D81F60 52D81F08 00000007 4D450005 004F4E50 [... r ... Empno.]
52D81F70 00000000 00000007 4E450005 00454D41 [........ ename.]
52D81F80 00000000 000000004 4F4A0003 00000042 [........ Job ...]
52D81F90 00000007 474D0003 00000052 00000007 [... Mgr .......]
52D81FA0 49480008 41444552 00004554 00000007 [..hired ......]]
52D81FB0 41530003 0000004C 00000007 4F430004 [..sal ......... Co]
52D81FC0 00004D4D 00000007 45440006 4F4E5450 [mm ........ deptno]
52D81FD0 00000000 52D81FE8 52D81EAC 52D81F74 [....... r ... rt..r]
52D81FE0 00000000 00000010 52D81FFC 52D81E50 [........... rp..r]
52D81FF0 52D81F84 00000000 00000010 52D82010 [... r ..........R]
52D82000 52D81DF4 52D81F90 00000000 00000010 [... r ... r ........] 52D82010 52D82024 52D81D98 52D81F9C 00000000 [$ .r ... r ... r ....]
52D82020 00000010 52D82038 52D81D3C 52D81FAC [.... 8 .r <.. r ... r]
52D82030 00000000 00000010 52D8204C 52D81CE0 [........ l.r ... r]
52D82040 52D81FB8 00000000 00000010 00000000 [... r ............]
52D82050 52D81C84 52D81FC4 00000000 00000010 [... r ... r ........]
52D82060 00000000 00010001 00020001 00000016 [................]
52D82070 00000004 00000000 00000000 00000000 [................]
52D82080 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D820B0 00000000 00000000 00000000 00003F09 [...........? ..]
52D820C0 00000000 00020002 00010002 000A000A [..............]
52D820D0 0000000000000000000000000000000000 [................]
Repeat 2 Times
52D82100 00010354 00000000 0000000000000000 [T ...............]
52D82110 00000000 00000000 00000000 00003F09 [...........? ..]
52D82120 00000000 00030003 00010003 00090009 [................]
52D82130 00000000 00000000 00000000 000,00000 [................]
Repeat 2 Times
52D82160 00010354 00000000 00000000 00000000 [T ...............]
52D82170 0000000000000000000000 00003F09 [...........? ..]
52D82180 000000 00040004 00020004 00000016 [................]
52D82190 000000000000000000 [................]
52D821A0 00000000000000000000000000000000 [................]
Repeat 2 Times
52D821D0 00000000 0000000000000000 00003F09 [...........? ..]
52D821E0 00000000 00050005 000c0005 00000007 [................]
52D821F0 00000000000000000000000000000000 [................]
Repeat 3 Times
52D82230 00000000 00000000 00000000 00003F09 [............? ..]
52D82240 00000000 00060006 00020006 00000016 [................] 52D82250 000000000000000000 00000000 [................]
52D82260 00000000 00000000 000,000 00000000 [................]
Repeat 2 Times
52D82290 00000000 000000000000000000003f09 [...........? ..]
52D822A0 00000000 00070007 00020007 00000016 [................]
52D822B0 00000207 000000000000000000000000 [................]
52D822C0 00000000 million 00000000 [................]
Repeat 2 Times
52D822F0 00000000 00000000 00000000 00003F09 [...........? ..]
52D82300 00000000 00080008 00020008 00000016 [................]
52D82310 00000000000000000000 [................]
52D82320 000000000000000000000000000000 [................]
Repeat 2 Times
52D82350 00000000 00000000 00000000 00003F09 [............? ..]
52D82360 00000000 00000000 00000000 52D82374 [............ t # .r]
52D82370 00003F09 00000000 52D82370 3eeeeeeee [.? ... p # .r ...>]
52D82380 00000000 52D817B4 52D82388 52D82388 [....... r. #. R. #. R]
52D82390 00000000 404EECB8 404EECB8 404EECB8 [... n @ .. n @ .. n @]
52D823A0 00000000 00000000 000,00000 52D81A6C [........... L.R]
52D823B0 00000008 52D81F08 52D81EAC 52D81E50 [....... r ... rp..r]
52D823C0 52D81DF4 52D81D98 52D81D3C 52D81CE0 [... r ... r <.. r ... r]
52D823D0 52D81C84 00000010 0000014C 00000014 [... r .... l .......]
52D823E0 00000084 00000016 00000001 52D82060 [........... `` .r]
52D823F0 00000001 00000010 00000158 00000014 [........ x .......]
52D82400 00000078 0000000A 00000002 52D820C0 [x .......... .r]
52D82410 00000001 00000010 00000164 00000014 [........ d .......]
52D82420 0000006C 00000009 00000003 52D82120 [l ...........! .R]
52D82430 00000001 00000010 00000170 00000014 [........ P .......] 52D82440 00000054 00000016 00000004 52D82180 [T ............!. R]
52D82450 00000001 00000010 0000017C 00000014 [........ | .......]
52D82460 0000004C 00000007 00000005 52D821E0 [l ............! R]
52D82470 00000001 00000010 00000188 00000014 [................]
52D82480 00000034 00000016 00000006 52D82240 [4 ........... @ ". R]
52D82490 00000001 00000010 00000194 00000014 [................]
52D824A0 0000001C 00000016 00000007 52D822A0 [............. ". R]
52D824B0 00000001 00000010 000001A0 00000014 [................]
52D824C0 00000004 00000016 00000008 52D82300 [............. #. R]
52D824D0 00000001 52D81938 00000004 00000002 [.... 8..r ........]
52D824E0 000000BC 00000000 52D81C1C 00000008 [........... r ....]
52D824F0 00000000 00000000 00000000 000,00000 [................]
52D82500 00000000 0000000000000012 02400791 [............ @.]
52D82510 00003F09 00003F09 00030000 00001FE8 [.? ...? ........]
52D82520 00000000 00000100 3F091826 00000001 [........ & ..? ....
52D82530 00000000000000000000 [................]
52D82540 00000000000000000000000000000000 [................]
52D82550 52D823B0 00000010 000001D0 00000017 [. #. R ..........]
52D82560 52D82524 00000001 00003F09 00000000 [$%. R ..... ......]
52D82570 0000000000 00000000 [................]
52D82580 000000000000000000000000000000 [................]
52D82590 00000000 00000000 52D823D4 00080000 [......... #. R ....]
52D825A0 00000000000000000000000 52D82508 [...........%. R]
52D825B0 00000000000000000000000010 00000270 [........... p ...]
52D825C0 52D823D4 00000008 00000014 0000009C [. #. R ............]
52D825D0 00000000 00000000 00000000 52D81ACF [............... R] 52D825E0 0000000000000000000000000000 [................]
Repeat 3 Times
52D82620 52D8263C 00000010 000006D4 00000010 [<&. R ............]
52D82630 000006F4 00000010 000006F8 00000010 [................]
52D82640 000006FC 00000010 00000714 00000010 [................]
52D82650 00000720 00000010 00072C 00000010 [......., .......]
52D82660 000007410 0000010 00074C 00000010 [d ....... l .......]
52D82670 00000764 00000010 0000077C [D ....... | ...]
Permanent Space = 3784
Marks:
Mark 0x52d8237c
*********************************************************** ****
The handle = 52D82E58 here is the object information of SQL dependencies:
BUCKET 63037:
Library Object Handle: Handle = 52D82E58
Name = EYGLE.EMP
Hash = 7310f63d TimeStamp = 08-26-2004 10:23:40
Namespace = Tabl / prcD / type flags = kGHP / TIM / SML / [02000000]
KKKK-DDDD-LLLL = 0000-0501-0501 Lock = 0 PIN = 0 LATCH # = 1
LWT = 0x52d82e70 [0x52d82e70, 0x52d82e70] ltm = 0x52d82e78 [0x52d82e78, 0x52d82e78]
PWT = 0x52d82e88 [0x52d82e88, 0x52d82e88] PTM = 0x52d82ee0 [0x52d82ee0, 0x52d82ee0]
Ref = 0x52d82e60 [0x52d82e60, 0x52d82e60] lnd = 0x52d82eec [0x52d7dcf0, 0x52d89fc8]
Library Object: Object = 52d81594
TYPE = Tabl flags = exS / Loc [0005] pflags = [00] status = vald load = 0
==> Type: Object Type, here is a table
==> Flags: Representative object status
Data Blocks:
Data # Heap Pointer Status Pins Change Alloc (K) Size (K)
------------ --------------------- ---
0 52D8C1E4 52D8161C I / - / A 0 none 0.66 1.09
8 52D81238 52D80A18 I / - / A 0 none 1.10 1.13
10 52D8129C 52D80EA0 I / - / A 0 none 0.12 0.37
HEAP Dump of Data Block 0:
*********************************************************** **** Heap dump head name = "library cache" desc = 0x52d8c1e4
Extent SZ = 0x224 alt = 32767 Het = 16 REC = 9 flg = 2 OPC = 0
PARENT = 0x5000002c Owner = 0x52d81594 nex = (nil) xsz = 0x224
==> Each Heap Descriptor contains an Owner section, pointing to the owner, the 52D81594 here is Eygle.emp
==> Pointed Library object: library object: Object = 52d81594
EXTENT 0 AddR = 0x52d81220
CHUNK 52D81228 SZ = 540 Perm "Perm" alo = 196
52D81220 5000021D 00000000 [... p ....]
52D81230 52D81584 000000C4 5000002C 00000824 [... r ...., .. p $ ...]
52D81240 52D81594 52D80A00 52D80A08 000000 [... r ... r ... r ....]
52D81250 00000000 05010200 00000000 00000000 [................]
52D81260 534C474B 61656820 00000070 000000 [KGLS HEAP .......]
52D81270 00107FFF 7FFF7FFF 00000401 00000000 [..............]
52D81280 52D81280 52D81280 52D8129C 00000000 [... r ... r ... r ....]
52D81290 52D80EA0 00040000 52FF5C14 5000002C [... r ..... /. R, .. p]
52D812A0 00000824 52D81594 52D80E88 52D80E90 [$ ... r ... r ... r]
52D812B0 00000000 00000000 05010200 00000000 [................]
52D812C0 0000015C 534C474B 61656820 00000070 [/.....kgls heap ...]
52D812D0 00000000 00107FFF 7FFF7FFF 00000401 [................]
52D812E0 00000000 52D812E4 52D812E4 00000000 [....... r ... r ....]
52D812F0 0000000000000000 qditary 1000000000 [................]
Repeat 20 Times
52D81440 00000000 [....]
Extent 1 addr = 0x52d8157c
CHUNK 52D81584 SZ = 484 Perm "Perm" alo = 484
52D81580 400001E5 00000000 000,000 [... @ ........]
52D81590 000001E4 52D82E58 52D81598 52D81598 [.... x..r ... r ... r] 52D815A0 52D815A0 52D815A0 00000000 000,000 [... r ... r ........]
52D815B0 00010005 00000000 00000000 000,000 [................]
52D815C0 02000000 52D81608 00000000 00000000 [....... r ........]
52D815D0 00000000000000000000000000000000 [................]
52D815E0 00000000 52D81754 00000000 52D81288 [.... t .r ....... r]
52D815F0 00000000 000000000000000000000000 [................]
52D81600 000 million 00000000 52D8C1E4 00000000 [........... r ....]
52D81610 52D8161C 00000000 52FF5BC4 00000006 [... r ..... [. R ....]
52D81620 00000000 52D81650 00000000 00000000 [.... p..r ........]
52D81630 00003F09 00003F09 00000000 000,000 [.? ...? ........
52D81640 00000000 0000000000000069 00000000 [......... I .......]
52D81650 2000000010101 00080008 00000008 [............]
52D81660 00000000 2D2D2D2D 2D2D2D2D2D2D2D [....------------]
52D81670 2D2D2D2D2D2D2D 2D2D2D 2D2D2D2D [----------------]
52D81680 2D2D2D2D 00000012 02400791 00000000 [----...... @ .....
52D81690 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
52D816D0 00000000 0001280A 000000FF 00000000 [..... (........]
52D816E0 40548000 0000001 00000064 00000000 [..t @ .... d .......]
52D816F0 00000000000000000000000000000000 [................]
52D81700 00000000 00000000 00000000 00000001 [................]
52D81710 000000000000000000000000000000000001 [................]
52D81720 00000000 00000000 0002E0 00000000 [................]
52D81730 000000000000000000000000000000 [................]
52D81740 ffffffffff ffffffff 68780000 180b1a08 [........ xh ....]
52D81750 00000029 52D81238 00000000 52D80A18 [) ... 8..r ....... r]
52D81760 00040000 52FF5BEC [..... [. R] chunk 52d81768 sz = 40 free ""
52D81760 D0000029 52D81584 [) ... r]
52D81770 52D8C22C 52D8C22C 00000000 00000000 [, .. r, .. r ........]
52D81780 00000000 00000000 000,000 00000000 [................]
Total Heap Size = 1064
Free Lists:
BUCKET 0 size = 0
CHUNK 52D81768 SZ = 40 Free ""
52D81760 D0000029 52D81584 [) ... r]
52D81770 52D8C22C 52D8C22C 00000000 00000000 [, .. r, .. r ........]
52D81780 00000000 00000000 000,000 00000000 [................]
Total Free Space = 40
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
CHUNK 52D81228 SZ = 540 Perm "Perm" alo = 196
52D81220 5000021D 00000000 [... p ....]
52D81230 52D81584 000000C4 5000002C 00000824 [... r ...., .. p $ ...]
52D81240 52D81594 52D80A00 52D80A08 000000 [... r ... r ... r ....]
52D81250 00000000 05010200 00000000 00000000 [................]
52D81260 534C474B 61656820 00000070 000000 [KGLS HEAP .......]
52D81270 00107FFF 7FFF7FFF 00000401 00000000 [..............]
52D81280 52D81280 52D81280 52D8129C 00000000 [... r ... r ... r ....]
52D81290 52D80EA0 00040000 52FF5C14 5000002C [... r ..... /. R, .. p]
52D812A0 00000824 52D81594 52D80E88 52D80E90 [$ ... r ... r ... r]
52D812B0 00000000 00000000 05010200 00000000 [................]
52D812C0 0000015C 534C474B 61656820 00000070 [/.....kgls heap ...]
52D812D0 00000000 00107FFF 7FFF7FFF 00000401 [................]
52D812E0 00000000 52D812E4 52D812E4 00000000 [....... r ... r ....]
52D812F0 00000000 00000000 000000000000000000 [................] Repeat 20 Times
52D81440 00000000 [....]
CHUNK 52D81584 SZ = 484 Perm "Perm" alo = 484
52D81580 400001E5 00000000 000,000 [... @ ........]
52D81590 000001E4 52D82E58 52D81598 52D81598 [.... x..r ... r ... r]
52D815A0 52D815A0 52D815A0 00000000 000,000 [... r ... r ........]
52D815B0 00010005 00000000 00000000 000,000 [................]
52D815C0 02000000 52D81608 00000000 00000000 [....... r ........]
52D815D0 00000000000000000000000000000000 [................]
52D815E0 00000000 52D81754 00000000 52D81288 [.... t .r ....... r]
52D815F0 00000000 000000000000000000000000 [................]
52D81600 000 million 00000000 52D8C1E4 00000000 [........... r ....]
52D81610 52D8161C 00000000 52FF5BC4 00000006 [... r ..... [. R ....]
52D81620 00000000 52D81650 00000000 00000000 [.... p..r ........]
52D81630 00003F09 00003F09 00000000 000,000 [.? ...? ........
52D81640 00000000 0000000000000069 00000000 [......... I .......]
52D81650 2000000010101 00080008 00000008 [............]
52D81660 00000000 2D2D2D2D 2D2D2D2D2D2D2D [....------------]
52D81670 2D2D2D2D2D2D2D 2D2D2D 2D2D2D2D [----------------]
52D81680 2D2D2D2D 00000012 02400791 00000000 [----...... @ .....
52D81690 00000000 00000000 000,000 00000000 [................]
Repeat 3 Times
52D816D0 00000000 0001280A 000000FF 00000000 [..... (........]
52D816E0 40548000 0000001 00000064 00000000 [..t @ .... d .......]
52D816F0 00000000000000000000000000000000 [................]
52D81700 00000000 00000000 00000000 00000001 [................]
52D81710 000000000000000000000000000000000001 [..................] 52D81720 00000000 00000000 0002E0 00000000 [................]
52D81730 000000000000000000000000000000 [................]
52D81740 ffffffffff ffffffff 68780000 180b1a08 [........ xh ....]
52D81750 00000029 52D81238 00000000 52D80A18 [) ... 8..r ....... r]
52D81760 00040000 52FF5BEC [..... [. R]
Permanent Space = 1024
*********************************************************** ****
HEAP Dump of Data Block 8:
*********************************************************** ****
HEAP DUMP Heap Name = "KGLS HEAP" DESC = 0x52D81238
Extent SZ = 0x824 alt = 32767 Het = 16 REC = 0 flg = 2 OPC = 5
Parent = 0x5000002c oowner = 0x52d81594 nex = (nil) xsz = 0x0
Extent 0 Addr = 0x52D80A00
Chunk 52D80A08 SZ = 1124 perm "perm" alo = 1124
52D80A00 50000465 00000000 [E..P ....]
52D80A10 00000000 00000464 00000000 00000007 [.... d ...........]
52D80A20 00000454 00000000 52D80E00 52D80B0C [t ........ r ... r]
52D80A30 52D80A30 52D80A30 00000000 00000008 [0..R0..r ........]
52D80A40 00000003 52D80A44 52D80A44 52D80A4C [.... d..rd..rl..r]
52D80A50 52D80A4C 00000000 00000000 00000023 [L.R ........ # ...]
52D80A60 52D80A60 52D80A60 52D80A68 52D80A68 [`....rh..r]
52D80A70 00000000 00000000 00000032 52D80A7C [........ 2 ... | ..r]
52D80A80 52D80A7C 52D80A84 52D80A84 000000 [| .r ... r ... r ....]
52D80A90 00000000 00000033 52D80A98 52D80A98 [.... 3 ... r ... r]
52D80AA0 52D80AA0 52D80AA0 00000000 000,000 [... r ... r ........]
52D80AB0 0000002C 52D80AB4 52D80AB4 52D80ABC [, ... r ... r ... r]
52D80AC0 52D80ABC 00000000 00000000 00000035 [... r ........ 5 ...] 52D80AD0 52D80AD8 52D80AD8 [... r ... r ... r ... r]
52D80Ae0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80B00 00000000 00000000 00000000 52D80A28 [........... (. R]
52D80B10 52D80B78 00000000 45440006 4F4E5450 [X..r ...... deptno]
52D80B20 00000000000000000000000000000000 [................]
52D80B30 00000000 00000000 00080008 00160002 [................]
52D80B40 00000200 00000008 00000000 000,00000 [................]
52D80B50 000000000000000000000000000000 [................]
Repeat 1 Times
52D80B70 00000000 0000000 52D80B0C 52D80BE4 [........... r ... r]
52D80B80 00000000 4F430004 00004D4D 00000000 [... Comm ......]
52D80B90 00000000000000000000000000000000 [................]
52D80BA0 00000000 00070007 00160002 00020700 [................]
52D80BB0 00000000000000000000 [................]
52D80BC0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80BE0 00000000 52D80B78 52D80C50 00000000 [.... x..rp..r ....]
52D80BF0 4153000 00000004C 00000000 00000000 [..sal ...........]
52D80C00 00000000 00000000 00000000 000,000 [................]
52D80C10 00060006 00160002 00020700 00000006 [................]
52D80C20 00000000000000000000000000000000 [................]
Repeat 2 Times
52D80C50 52D80BE4 52D80CBC 00000000 49480008 [... r ... r ... hi]
52D80C60 41444552 00004554 00000000 000,000 [redate ........]
52D80C70 00000000 00000000 00000000 00050005 [................]
52D80C80 0007000C 00000000 00000005 00000000 [................]
52D80C90 000000000000000000000000000000 [................]
Repeat 1 Times
52D80CB0 00000000 00000000 00000000 52D80C50 [............ p..r] 52D80CC0 52D80D28 00000000 474D0003 00000052 [(.r ... mgr ...]
52D80CD0 00000000000000000000000000000000 [................]
52D80CE0 00000000 00000000 00040004 00160002 [................]
52D80CF0 00000400 00000004 00000000 000,00000 [................]
52D80D00 0000000000000000000000000000000000 [................]
Repeat 1 Times
52D80D20 0000000 0000000 52D80CBC 52D80D94 [........... r ... r]
52D80D30 00000000 4F4A0003 00000042 00000000 [... Job .......]
52D80D40 000000000000000000000000000000 [................]
52D80D50 00000000 00030003 00090001 000000 [................]
52D80D60 00000003 00000000 00010354 00090000 [........ T .......]
52D80D70 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80D90 000000000 52D80D28 52D80E00 00000000 [.... (. R ... r ....]
52D80DA0 4E450005 00454D41 000000 000,000 [..ename .........]
52D80DB0 00000000000000000000000000000000 [................]
52D80DC0 00020002 000A0001 00000000 00000002 [................]
52D80DD0 00000000 00010354 000A0000 00000000 [.... T ...........]
52D80DE0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80E00 52D80D94 52D80A28 00000000 4D450005 [... R (. R ... em)
52D80E10 004F4E50 00000000 00000000 00000000 [PNO .............]
52D80E20 00000000 0000000000000000 00010001 [................]
52D80E30 00160002 00000400 00000001 00000000 [................]
52D80E40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D80E60 00000000 00000000 00000000 [..........]
Total Heap Size = 1124
Free Lists:
BUCKET 0 size = 0
Total Free Space = 0
Unpinned Recreatable Chunks (Lru First): Permanent Chunks:
Chunk 52D80A08 SZ = 1124 perm "perm" alo = 1124
52D80A00 50000465 00000000 [E..P ....]
52D80A10 00000000 00000464 00000000 00000007 [.... d ...........]
52D80A20 00000454 00000000 52D80E00 52D80B0C [t ........ r ... r]
52D80A30 52D80A30 52D80A30 00000000 00000008 [0..R0..r ........]
52D80A40 00000003 52D80A44 52D80A44 52D80A4C [.... d..rd..rl..r]
52D80A50 52D80A4C 00000000 00000000 00000023 [L.R ........ # ...]
52D80A60 52D80A60 52D80A60 52D80A68 52D80A68 [`....rh..r]
52D80A70 00000000 00000000 00000032 52D80A7C [........ 2 ... | ..r]
52D80A80 52D80A7C 52D80A84 52D80A84 000000 [| .r ... r ... r ....]
52D80A90 00000000 00000033 52D80A98 52D80A98 [.... 3 ... r ... r]
52D80AA0 52D80AA0 52D80AA0 00000000 000,000 [... r ... r ........]
52D80AB0 0000002C 52D80AB4 52D80AB4 52D80ABC [, ... r ... r ... r]
52D80AC0 52D80ABC 00000000 00000000 00000035 [... r ........ 5 ...]
52D80AD0 52D80AD0 52D80AD0 52D80AD8 52D80AD8 [... r ... r ... r ... r]
52D80Ae0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80B00 00000000 00000000 00000000 52D80A28 [........... (. R]
52D80B10 52D80B78 00000000 45440006 4F4E5450 [X..r ...... deptno]
52D80B20 00000000000000000000000000000000 [................]
52D80B30 00000000 00000000 00080008 00160002 [................]
52D80B40 00000200 00000008 00000000 000,00000 [................]
52D80B50 000000000000000000000000000000 [................]
Repeat 1 Times
52D80B70 00000000 0000000 52D80B0C 52D80BE4 [........... r ... r]
52D80B80 00000000 4F430004 00004D4D 00000000 [... Comm ......]
52D80B90 0000000000000000000000000000000000 [................] 52D80BA0 00000000 0007007 00160002 00020700 [................]
52D80BB0 00000000000000000000 [................]
52D80BC0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80BE0 00000000 52D80B78 52D80C50 00000000 [.... x..rp..r ....]
52D80BF0 4153000 00000004C 00000000 00000000 [..sal ...........]
52D80C00 00000000 00000000 00000000 000,000 [................]
52D80C10 00060006 00160002 00020700 00000006 [................]
52D80C20 00000000000000000000000000000000 [................]
Repeat 2 Times
52D80C50 52D80BE4 52D80CBC 00000000 49480008 [... r ... r ... hi]
52D80C60 41444552 00004554 00000000 000,000 [redate ........]
52D80C70 00000000 00000000 00000000 00050005 [................]
52D80C80 0007000C 00000000 00000005 00000000 [................]
52D80C90 000000000000000000000000000000 [................]
Repeat 1 Times
52D80CB0 00000000 00000000 000,00000 52D80C50 [............ p..r]
52D80CC0 52D80D28 00000000 474D0003 00000052 [(.r ... mgr ...]
52D80CD0 00000000000000000000000000000000 [................]
52D80CE0 00000000 00000000 00040004 00160002 [................]
52D80CF0 00000400 00000004 00000000 000,00000 [................]
52D80D00 0000000000000000000000000000000000 [................]
Repeat 1 Times
52D80D20 0000000 0000000 52D80CBC 52D80D94 [........... r ... r]
52D80D30 00000000 4F4A0003 00000042 00000000 [... Job .......]
52D80D40 000000000000000000000000000000 [................]
52D80D50 00000000 00030003 00090001 000000 [................]
52D80D60 00000003 00000000 00010354 00090000 [........ T .......]
52D80D70 0000000000000000000000000000000000 [................] Repeat 1 Times
52D80D90 000000000 52D80D28 52D80E00 00000000 [.... (. R ... r ....]
52D80DA0 4E450005 00454D41 000000 000,000 [..ename .........]
52D80DB0 00000000000000000000000000000000 [................]
52D80DC0 00020002 000A0001 00000000 00000002 [................]
52D80DD0 00000000 00010354 000A0000 00000000 [.... T ...........]
52D80DE0 00000000000000000000000000000000 [................]
Repeat 1 Times
52D80E00 52D80D94 52D80A28 00000000 4D450005 [... R (. R ... em)
52D80E10 004F4E50 00000000 00000000 00000000 [PNO .............]
52D80E20 00000000 0000000000000000 00010001 [................]
52D80E30 00160002 00000400 00000001 00000000 [................]
52D80E40 00000000 00000000 0000000000000000 [................]
Repeat 1 Times
52D80E60 00000000 00000000 00000000 [..........]
Permanent Space = 1124
*********************************************************** ****
HEAP Dump of Data Block 10:
*********************************************************** ****
HEAP DUMP Heap Name = "KGLS Heap" DESC = 0x52D8129C
Extent SZ = 0x824 alt = 32767 Het = 16 REC = 0 flg = 2 OPC = 5
PARENT = 0x5000002c Owner = 0x52d81594 nex = (nil) xsz = 0x15c
Extent 0 addr = 0x52d80e88
Chunk 52D80E90 SZ = 340 Perm "Perm" alo = 120
52D80E90 50000155 00000000 00000000 00000078 [Up ........ x ...]
52D80EA0 00000000 000000002 00000068 00000004 [........ h .......]
52D80EB0 52D80EB0 52D80EB0 52D80EB8 52D80EB8 [... r ... r ... r ... r]
52D80EC0 00000000 00000000 0000005 52D80ECC [............... r]
52D80ED0 52D80ECC 52D80ED4 52D80ED4 0000000 [... r ... r ... r ....]
52D80EE0 00000000 00000000 00000000 000,00000 [................] Repeat 15 Times
52D80FE0 00000000 [....]
Total Heap Size = 340
Free Lists:
BUCKET 0 size = 0
Total Free Space = 0
Unpinned Recreatable Chunks (Lru First):
Permanent Chunks:
Chunk 52D80E90 SZ = 340 Perm "Perm" alo = 120
52D80E90 50000155 00000000 00000000 00000078 [Up ........ x ...]
52D80EA0 00000000 000000002 00000068 00000004 [........ h .......]
52D80EB0 52D80EB0 52D80EB0 52D80EB8 52D80EB8 [... r ... r ... r ... r]
52D80EC0 00000000 00000000 0000005 52D80ECC [............... r]
52D80ED0 52D80ECC 52D80ED4 52D80ED4 0000000 [... r ... r ... r ....]
52D80EE0 00000000 000000000000000000000000 [................]
REPEAT 15 TIMES
52D80FE0 00000000 [....]
Permanent Space = 340
*********************************************************** ****
BUCKET 63037 Total Object Count = 1
