An error occurred while updating disk io failure
You should also look at the logic involved in the application getting the error message. If they can mention a few of these and describe how they used them, even better.Expected answer: SQLCODE returns the value of the error number for the last error encountered. The tkprof tool is a tuning tool used to determine cpu and execution times for SQL statements.The SQLERRM returns the actual error message for the last error encountered. Expected Answer: There are 12 types of triggers in PL/SQL that consist of combinations of the BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and ALL key words: BEFORE ALL ROW INSERT AFTER ALL ROW INSERT BEFORE INSERT AFTER INSERT etc. You use it by first setting timed_statistics to true in the initialization file and then turning on tracing for either the entire database via the sql_trace parameter or for the session using the ALTER SESSION command. This indicates you need to tune the sort area parameters in the initialization files. What parameters control copy latches When you get excessive contention for the copy latches as shown by the "redo copy" latch hit ratio. What happens if the constraint name is left out of a constraint clause The Oracle system will use the default name of SYS_Cxxxx where xxxx is a system generated number. How can this be prevented or mitigated This is caused by large or long running transactions that have either wrapped onto their own rollback space or have had another transaction write on part of their rollback space.If they include the SQL routines provided by Oracle, great, but not really what was asked. Describe the use of PL/SQL tables Expected answer: PL/SQL tables are scalar arrays that can be referenced by a binary integer. However if you also have chained rows this can hurt performance. How do you set up tablespaces during an Oracle installation?