What happens if you set the sga too low in oracle?
- 1 Answers
- 1292 Views
- I also Faced
- E-Mail Answers
Answer / Neha Kumari
If you set the System Global Area (SGA) too low in Oracle, it may lead to increased I/O operations as the SGA is used for caching database blocks. This could result in slower performance due to excessive disk read/write activity.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of save points in oracle database?
What is a Data Dictionary ?
DBMS vs. RDBMS
What are joins, explain all types of joins?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is insert all statement in sql
Does a Before form trigger fire when the parameter form is suppressed ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is logical backup in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to get maxsal , minsal, ename department wise in single query
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
Oracle General 
