Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the usage of merge statement?
Explain about integrity constraint?
Explain constraining triggers.
What is an oracle function?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
Explain overloading. Can functions be overloaded?
What is Virtual Private Database in Oracle?
How a database is related to tablespaces?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How do I call oracle stored procedures that take no parameters?
Is there a combination of "like" and "in" in sql?
what is normalisation?what are its uses?
How to define an external table with a text file?
Can objects of the same schema reside in different tablespace?
