Archive for August, 2010

You can add custom components to CRS if you have a need. You basically need a program (perhaps as simple as a shell script) that accepts three command line arguments: start stop check Below is an example of a shell script that you can register. 1 2 3 4 5 6 7 8 9... »

You can use the following example if you need to total numbers over a group in a given file. We first show our sample file… 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 14:30:57 oracle@emgrid01 ~ >cat list.txt steve:61 steve:14 becky:57... »

Simple today. I just wanted to ensure I had this in case I need to cut and paste it later 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 #!/home/oracle/local/bin/python   import cx_Oracle, string   connection = cx_Oracle.connect(mode = cx_Oracle.SYSDBA)   cursor = connection.cursor()... »

I recently spoke with an Oracle DBA. He mentioned they had a third party application that was generating gobs of redo by updating rows to their existing values, i.e., update t set c = c. This bothered me, as my understanding was that other than recursive SQL such as extent allocation, block cleanout, or... »