Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, santhoshreddy.

Asked: October 28, 2016 - 4:53 am UTC

Last updated: November 30, 2016 - 2:07 pm UTC

Version: r12

Viewed 1000+ times

You Asked

Hi Tom,
I would like to know how many SGA Created inside instance when data base starts?
Here instance mean instance only i.e to which we mount database.

Also please let me know if you answer the questions posted in reviews,perhaps i wil get doubts after your explanation.

Thank you.

and Chris said...

Each instance has a single SGA. Though SGA has many components.

Take a look at this diagram on the Database Architecture tab:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/poster/OUTPUT_poster/poster.html

If you want to know more, check the Concepts Guide:

http://docs.oracle.com/database/121/CNCPT/memory.htm#GUID-24EDB8CD-8279-4CED-82AF-642FC01A4A73

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

santhoshreddy podduturi, November 30, 2016 - 6:16 am UTC

Does Oracle Recommends to create multiple instances(multiple SGA) for single Database on a single Machine?
Chris Saxon
November 30, 2016 - 10:45 am UTC

No. If you want multiple instances for a single database then you're looking at RAC. Each instance should be on its own machine.

A reader, November 30, 2016 - 1:29 pm UTC

In Rac,is every Instance installed in single machine or different machines?
Chris Saxon
November 30, 2016 - 2:07 pm UTC

Each instance is on a different machine.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.