What is the recommended interval at which to run statspack
snapshots, and why?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different pseudo commands? Explain in general?
What is the difference between substr & instr functions?
primary key is foreign key for the same table?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
waht is the difference between primary key and super key?
Define Transaction ?
how to find the second highest salary in a given table????
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the difference between a hot backup and a cold backup in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col