Sumit Das Tech Notes

ORA-01194: file 1 needs more recovery to be consistent Method 1: 1) Start the database in mount state SQL> startup mount; 2) Recover the database. SQL> recover database; If you come across below error ORA-00283:... http://neerajoracledba.blogspot.in/2014/07/ora-01194-file-1-needs-more-recovery-to.html

SQL*Plus output in nice HTML formatEvery DBA knows that: SQL*Plus is a powerful tool, but its output is often almost unreadable. Do we have to format everything carefully with col commands or change to a more comfortable GUI instead? No!... https://uhesse.com/2011/06/30/sqlplus-output-in-nice-html-format/

Skip Headers SQL*Plus® User's Guide and Reference Release 10.1 Part Number B12170-01 Home Book List Contents Index Master Index Feedback Previous Next View PDF 8 Generating HTML Reports from SQL*Plus This chapter explains how to ... https://docs.oracle.com/cd/B12037_01/server.101/b12170/ch8.htm

Get execution time of sql script in oracle sqlplus - Stack Overflow Saturday, November 14, 20158:20 AMIt old question but i have found easy way to measure time of running a script in sqlplus. You just have to add this on the beginningtiming starttimin...

Listing and Changing Oracle Hidden Parameters in 11gR1/11gR2 « YET ANOTHER ORACLE DBA Friday, September 04, 201511:01 AM Listing and Changing Oracle Hidden Parameters in 11gR1/11gR2Posted by Jay on March 11, 2011The hidden parameters start with an “_"...

It is a very common misconception that "sequential reads in SM50 means that a full table scan is executed and an index is not used". The correct definition/concept is:Direct read The term "Direct read" refers to accesses in which a maximum of one line ...