From the course: Oracle Database 12c: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Shared pool

Shared pool - Oracle Database Tutorial

From the course: Oracle Database 12c: Administration

Start my 1-month free trial

Shared pool

“

- [Narrator] Now it's time to peek inside the SGA and get on a first name basis with all of those individual caches. Starting off with The Shared Pool, and no, I don't mean the same kind of pool you share with your fellow vacationers while staying at your favorite beach resort. In an Oracle context, the Shared Pool is the most important area inside the SGA that is used to cache non-user data. That is, stuff other than the actual database rows from our actual tables. So, what is there to cache other than rows, you may ask? Well, there are various other database construct that, if shared among users, would speed up the performance of various database activities. In order to do that, the Shared Pool, in itself, is divided into yet another subset of caches. Please bear with me. I don't want you to be scared. Remember the hierarchy. We have the Oracle Instance. Inside we have a logical component known as the SGA. Upon database setup, we define the size for the SGA. Such as, I want my SGA…

Contents