Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4488 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 |
How to start a specific oracle instance?
What are the types of partitions in oracle?
what is the scripts in data base?
8. Display the client name and order date for all orders using the natural join keywords.
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
How to define a sub function?
Can we commit inside a function in oracle?
Can anyone give me information about oracle certification
What is a package ? What are the advantages of package ?
How to set up autotrace for a user account?
Is insert autocommit in oracle?
Please explain oracle left join with an example?
Oracle General 
