GeekInterview.com
Series: Subject: Topic:
Question: 6 of 36

what is SGA? Where it is located? Why the system performance will be slow after loading the oracle?

Asked by: Interview Candidate | Asked on: Sep 5th, 2006
Showing Answers 1 - 2 of 2 Answers
manish hoiyani

Answered On : Sep 18th, 2006

sga stands fro system global area.. which is the part of the oracle instance(includes memory struture and background processes). for faster executon and better performance everthing comes in the sga.

so sga is located in oracle instance,,, which itself consist of two parts.

1>database buffercache: which stores the recently executed database blocks,, when user fires a query oracle  searches that block in dictionary  and stores it into buffer cache.. so if the next time when the user fires the same query ...  users gets output from the buffer cache itself.. no need for parsing again..  only fetch and execute will work.

2> redolog buffer: it stores all the changes made in the database,, and also all DMLs,,  when user fires an commit statement,, lgwr back process writes it into the redolog files.. which can be used for recovery of database during  instance crash .

when u install an oracle in ur machine ,,, system will become slow because of the unstructured sga configuration and also ur system configuration ,  once the oracle instance instants starts .. oracle itself will allocate the space from system .

for example : if u have system confi 512 mb and if will install oracle  with specified sga congi.   obviously system performance will go low.

so in order to increase the system performance,,,  use the system configu  should be well enough to run the oracle instance.... and also allocates  enough space for sga....

  
Login to rate this answer.
NAGARAJ OCP

Answered On : Dec 27th, 2011

Dont install oracle on C:(or on which drive you installed OS). Its not sure that it gives you great result, it better result then previous one.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.