What is meant by recursive hints ?
Answer / sawant
Number of times processes repeatedly query the dictionary
table is called recursive hints. It is due to the data
dictionary cache is too small. By increasing the
SHARED_POOL_SIZE parameter we can optimize the size of Data
Dictionary Cache.
| Is This Answer Correct ? | 0 Yes | 1 No |
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What are the differences between blob and clob in oracle?
How to calculate date and time differences in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
When do you get a .pll extension in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
find out first highest salary?
10 Answers Verinon Technology Solutions,
How to use "in" parameter properly?
What are the benefits of ordbms?
What is Row Chaining ?
Explain the different normalization forms?
What are ddl statements in oracle?