What are the factors causing the reparsing of SQL
statements in SGA?
- 1 Answers
- 3785 Views
- I also Faced
- E-Mail Answers
Answer / guest
Due to insufficient Shared SQL pool size.
Monitor the ratio of the reloads takes place while
executing SQL statements. If the ratio is
greater than 1 then increase the SHARED_POOL_SIZE.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to pass values from one table to another by using Bulk collect?
What is different keys in dbms?
What do you mean by denormalization?
Define database lock and its types.
What is the main difference between union and union all?
Explain the difference between primary and foreign key?
Which dbms is best?
What are the three levels of data abstraction?
i need query for displaying the eno,ename in a table from row 2 to row 5
What are the basic elements of Base configuration of an oracle Database ?
Define join types.
what is the difference between unique and primary key
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
