MIME-Version: 1.0
From: Amit Jaiswal <amit11103427@gmail.com>
Date: Fri, 5 May 2017 19:00:08 +0530
Message-ID: <CAN7WjxaiVoW60EAzL9yuZGucCfODcZ123tpik-c8dJ0g5Prsag@mail.gmail.com>
Subject: Objects hash table in SGA
To: oracle-l@freelists.org, pramod@abyeti.com
Content-Type: multipart/alternative; boundary=001a11492b2e62d37e054ec6e3df
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: amit11103427@gmail.com
--001a11492b2e62d37e054ec6e3df
Content-Type: text/plain; charset=UTF-8

Hi folks,
 In oracle 12.1.0.2, Objects reside in a hashtable in SGA. We can find
address of this Hash table as

SQL> select addr from x$kqrpd where indx=8;
ADDR
----------------
00000000898088F8

 The hash table starts from 64 bytes from this address. It contains start
and next addresses for this Hash bucket. But I don't see any objects that
are present exclusively in any PDB. (pluggable database).
  Does anyone know about any change in data structure of this hashtable ?
Also how objects in PDBs are stored in this hash table?

Regards,
Amit

--001a11492b2e62d37e054ec6e3df
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Hi folks,<br>=C2=A0In oracle 12.1.0.2, Objects r=
eside in a hashtable in SGA. We can find address of this Hash table as <br>=
<br><span style=3D"font-family:monospace,monospace">SQL&gt; select addr fro=
m x$kqrpd where indx=3D8;<br>ADDR<br>----------------<br>00000000898088F8<b=
r></span><br>=C2=A0The hash table starts from 64 bytes from this address. I=
t contains start and next addresses for this Hash bucket. But I don&#39;t s=
ee any objects that are present exclusively in any PDB. (pluggable database=
).<br>=C2=A0 Does anyone know about any change in data structure of this ha=
shtable ? Also how objects in PDBs are stored in this hash table?<br><br></=
div>Regards,<br></div>Amit<br></div>

--001a11492b2e62d37e054ec6e3df--
--
http://www.freelists.org/webpage/oracle-l