I have decided to remove disqus comments. What I considered to be a bonus, that is CODE POSTING, appears to be worst than before, because the PRE tag does not work. The main reason I switched back to last week behavior is that the COMMENT FEED does not work any longer. And I hate changes […]
Month: April 2008
alert log in xml format
The alert log is in xml format in Oracle 11g. If you want to parse the content of the file and use the XML functions to retrieve the data, you can use this way : SQL> create or replace directory alert as 2 ‘/app/oracle/diag/rdbms/lsc01/lsc01/alert’; Directory created. SQL> var c clob SQL> declare 2 b bfile […]
Disqus comments
I just replaced the default wordpress comments by Disqus comments. Disqus enable you to track your comments add picture and other fancy staff. I have been looking for such a plugin for a very long time (and was too foul to develop it myself). The amazing bonus with Disqus is that you can post code! […]
oradebug tracefile_name
I have enabled tracing in a session and now I want to retrieve the name of the tracefile. Ex: my session has sid 335. How do I retrieve trace file name from sqlplus ? select pid from v$process where addr in (select paddr from v$session where sid=335); PID ———- 47 Now I can use oradebug […]
Welcome Oracle Ace Marco Gralike
blog.gralike.com Marco is one of the top expert with XML and Database. Congrats Marco for receiving the Ace trophee 🙂
To RR or to YY ?
What is worst? To use DD-MON-RR or to use DD-MON-YY? When entering the birthday of my grandfather, I will write it as 31-JUL-1912, so both formats will be fine. If I enter it 31-JUL-12, both formats will be wrong. Ok, which date will I enter now and in the future? For short-time contracts I will […]
Obfuscation contest
I have been challenged to participated (my script : lsc2.sql) and now challenged to explain my query by Chen Ok, I give a try. To make the query unreadable and unformatable I used no space, no new line, and I started by q’
Side effect of cursor sharing
Cursor sharing transform strings in bind variable. So if you do SELECT * FROM EMP WHERE ENAME=’SCOTT’; it will be transformed in SELECT * FROM EMP WHERE ENAME=:sys_b0; This sometimes improved performance of application that do not use binds, for instance. Now let’s imagine your application generates trace files. The application generates a SELECT ‘LSC-11.1011.000.1110.1.0100.000.110’ […]