What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
1613Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
1524You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
1455What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
1537Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
1512How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
1452In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
1 2780Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
1489Post New Oracle General Questions
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
What happens if the imported table already exists?
Explain about functional dependency and its relation with table design?
Explain the use of indexes option in exp command.
What are the advantages of oracle?
What is varray?
What is a dead lock in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is a cursor variable?
How do I find my oracle client driver version?
Can we call procedure inside function in oracle?
Explain how are indexes update?
How can you use check constraints for self referential integrity?
How to run create database statement?
How to define a specific record type?