What are the factors causing the reparsing of SQL
statements in SGA?
- 1 Answers
- 3454 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 |
What is a functional dependency in the dbms?
What database does facebook use?
What are the types of database lock?
What does a database contain?
What are the 4 main objects of a database?
Define ddl interpreter.
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??
Define atomicity and aggregation.
What is data independence and also explain its types?
How can we check whether A S M instance is up or down?
Is sql is a dbms?
Explain what are triggers and rules?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
