In oracle what is system global area and how is it organized, Database Management System

Assignment Help:

In Oracle what is system global area and how is it organized?

The SGA is a collection of shared memory fields which along with the Oracle processes constitute an Oracle instance. All SGA components allocate and deallocate space within units of granules. Granule size is determined through total SGA size. On most platforms, the size of a granule is 4 MB if the total size of SGA is less than 1 GB, and granule size is 16MB for larger SGAs. A few platform dependencies arise. For instance, on 32-bit Windows, the granule size is 8M for SGAs larger than 1GB


Related Discussions:- In oracle what is system global area and how is it organized

Illustrate the term- abstracting out common behaviour, Illustrate the term-...

Illustrate the term- Abstracting Out Common Behaviour Inheritance is not every time recognised during analysis phase of development, thus it is necessary to re-evaluate object

Calculate the record size r in bytes, An employee record has the following ...

An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];}; (i) Calculate the record size R in bytes.

Why a report generator is used, Why a report generator is used ? Report...

Why a report generator is used ? Report generator is used for print files on paper.

What do you mean through integrity constraints, What do you mean through in...

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

Unix System Administration, What Command You Use What Day of the week were ...

What Command You Use What Day of the week were you born

Describe the menu based interfaces for web clients browsing, Describe the M...

Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

View of data, how to submit answers softcopy

how to submit answers softcopy

Remove partial dependancy, , write the relational schema, and draw the new ...

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

In e-r diagram how relationship type is represented, In E-R Diagram how rel...

In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd