The script being called when the Linux box is starting up is:
/etc/rc.d/init.d/oracle
It has inside calls to "dbstart" and "dbshut"; both of these scripts exist in $ORACLE_HOME/bin.
Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
Thursday, 9 June 2016
Wednesday, 1 June 2016
How to format my SQL query? (oracle)
The output from querying v$sql.sql_text is not formatted.
A nice site that will turn this output into a a formatted SQL is:
http://www.dpriver.com/pp/sqlformat.htm
A nice site that will turn this output into a a formatted SQL is:
http://www.dpriver.com/pp/sqlformat.htm
Subscribe to:
Posts (Atom)