Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4426 Views
- I also Faced
- E-Mail Answers
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 |
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Explain the types of exception?
How to add a new column to an existing table with a default value?
Can we write insert statement in function in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is use of oracle?
What is the use of Redo Log Information ?
What is oracle instant client?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is oracle thin client?
How do you store pictures in a database?
Oracle General 
