Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL
statements in SGA?
- 1 Answers
- 4171 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 you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
What is the difference between a MESSAGEBOX and an ALERT ?
What is etl process in data warehousing? What are the different stages in 'data warehousing'?
What is a file in a database?
how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?
How to Optimize Database Queries for Performance?
What is primary key in database?
what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?
What is a hierarchical database?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
What is the role of tables in database?
What are the features of a database management system?
-
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)
