How-to find sqls NOT using bind variables?

Sometimes we need to get to know which sqls do not use bind variables. Here we can see how to find it out by using procedures.
 
create table t1 as select sql_text from v$sqlarea;
 
alter table t1 add sql_text_wo_constants varchar2(1000);
 
create or replace function
remove_constants( p_query in varchar2 ) return varchar2
as
    l_query long;
    l_char  varchar2(1 char);
    l_in_quotes boolean [...]

How-To Efficiently Truncate/Drop A Table With Many Extents

Scenario:
When we drop or truncate a large table, it is very slow sometimes.
 
Why slow?
1. When a truncate is issued, the checkpoint process does a complete scan (till 9204) of the buffer cache.  All of the dirty buffers of the object in the buffer cache are written down to disk.  All of the clean buffers [...]