Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5414 Views
- I also Faced
- E-Mail Answers
Answer Posted / sawant
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are the different types of database objects?
What is execute immediate in oracle?
How to use select statement to count the number of rows in oracle?
What is an index associated with a constraint?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to drop an existing view in oracle?
How do I call oracle stored procedures that take no parameters?
How will you identify oracle database software release?
How to create a stored program unit?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the difference between substr and instr function in oracle?
How do I find my oracle client driver version?
Differentiate between pre-select and pre-query?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
