#oracle-wtf

[11:42] <Aleksey2> How do you say is not bigger then[11:42] <Aleksey2> AND updated_at !>= TO_DATE('12-01-2006','MM-DD-YYYY') does not work[11:43] <rizzo> uhh.[11:43] <rizzo> <[11:43] <rizzo> ?[11:43] * rizzo waits for it
Tags: nub wtf oracle

Keep Oracle Docs Handy

As I just shared in #oracle, it really helps to have a handy bookmark to the Oracle documentation library for your release. Oracle really does a good job with its documentation and making it easily available and searchable.

today in #oracle

[10:09] <rizzo> ok the ts_free script I have shows total bytes at 871,713,865,728[10:10] <rizzo> yeah one tablespace alone is 223gb[10:25] -->| gehdan (n=gehdan@xxxxxxxxxxxxx.de) has joined #oracle[10:43] <teite> rizzo: ok thats quite big ;)[10:43] <rizzo> yeah it's a pain in the ass[10:55] <gehdan> what are you guys talking about?[10:55] <gehdan> sforget... [Read More]

Bind Your Variables or Die

NOTE: I'm re-pasting this from an internal wiki page I wrote up for our new developers who may not be aware of such a thing as bind variables and how they can greatly improve performance and scalability.Most know that using bind variables help greatly with performance when dealing with an... [Read More]