What are the factors causing the reparsing of SQL
statements in SGA?
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 sql rdbms?
What are the types of database?
What do you understand by the view and mention the steps to create, update and drop a view?
What is a database management system and give examples?
What's the difference between clustered and non-clustered indexes?
How do you use a database worksheet?
Mention some disadvantages of query?
What are the database skills?
Why not phenix, the zelinka/otwinoski libraries, etc?
What are indexes ? What are the advantages ? (Phone Screen)
What are the features of rdbms?
RDBMS file system can be defined as
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)