Intermediate SQL Color Coded SQL, UNIX and Database Essays

30Apr/106

A better way to find literal SQLs in ORACLE 10g

Not sure if it is news, but here we go …

I was recently looking at hard parsing SQL statements overtaking one of my systems and needed to find literal SQLs that caused the problem.

The traditional way to look for literal SQLs in ORACLE (at least as it was for me) is to search for statements that are exactly the same in the first N symbols, something like:

SELECT substr(sql_text, 1, 80), COUNT(1)
FROM v$sql
GROUP BY substr(sql_text, 1, 80)
HAVING COUNT(1) > 10
ORDER BY 2
/
27Apr/101

How to reduce the size of AIX Memory. Quickly

This seems to be a rather odd exercise – why would you ever agree to have less memory on your system to run programs ?

But, of course it makes sense in a few special cases – testing how much memory your programs really need as well as validating how the system will behave if less memory is available (not every system is privileged to start with 32Gb+ of RAM).

13Apr/102

Hello world!

Well, this seems like not the first post, but the blog has been in the works for some time.

It is finally up and running, so …

Hello World! đŸ˜‰

Filed under: Uncategorized 2 Comments