Objects hash table in SGA

From: Amit Jaiswal <amit11103427_at_gmail.com>
Date: Fri, 5 May 2017 19:00:08 +0530
Message-ID: <CAN7WjxaiVoW60EAzL9yuZGucCfODcZ123tpik-c8dJ0g5Prsag_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 05 2017 - 15:30:08 CEST