What are the factors causing the reparsing of SQL statements
in SGA?
Answer / 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 ? | 0 Yes | 0 No |
What is the difference between pre-select and pre-query?
What is the max number of columns in an oracle table?
How to upsert (update or insert into a table)?
What is null value in oracle?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Can you tell me how to add new column in existing views?how?How is possible?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
How to display the hierarchy of employee and managers without using connect by prior.
What a SELECT FOR UPDATE cursor represent.?
How to rollback the current transaction in oracle?
What happens if recursive calls get out of control?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..