DanBrother的部落格

Enable SQL Trace For a Single Oracle DB User

-- Create Logon Trigger
create trigger t_scott_logon_trace after logon on scott.schema

Symptom: SYS_OP_C2C Causing FULL Table Scan Instead of Index Range Scan

SYS_OP_C2C is the implicit function that is used to convert the column between NCHAR and CHAR;

PL/SQL Interpreted & Native Compilation Comparison Testing

Oracle 11g: PL/SQL native compilation know-how

Start with Oracle 11gR1, PL/SQL native compiler can generate native code (machine code) directly, instead of translating it to C programs and have the C compiler generate native code as of Oracle 9i and 10g do.

Query sessions that are being locked:
select s.username as username,
s.program as program,

For AWR (Automatic Workload Repository) Report (generated by running $ORACLE_HOME/rdbms/admin/awrrpt.sql), it's convenient to have SQL IDs listed for tuning any particular sql statement.