http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14250/oci03typ.htm#sthref399

http://www.sql.ru/forum/actualthread.aspx?tid=445867&hl=merge

http://sql.ru/forum/actualthread.aspx?tid=193719

Анализ результатов tkprof
http://web.archive.org/web/20061009162217/http://ln.com.ua/~openxs/projects/oracle/ora059.html
( more )

http://www.oradba.com.ru/tuning/optimizer/tips/t2_sqltrace.shtml

Для своей сессии
SQL> alter session set sql_trace = true;

Или

SQL> alter session set events '10046 trace name context forever, level где Level:0 Выключить трейс (default ( Read more... )

create or replace procedure who_called_me( owner out varchar2 ( Read more... )

select * from v$session where sid = (select sid from v$mystat where rownum = 1)

with
2 data as
3 (select null m#, 1 n# from dual union all
4 select null, 5 from dual union all
5 select null, 3 from dual union all
6 select 1, 2 from dual union all
7 select 2, 4 from dual)
8 select
9 *
10 from
11 data
12 order by
13 1, 2;

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE CL8MSWIN1251;
SHUTDOWN;
STARTUP;
QUIT;http://www.sql.ru/forum/

http://www.oracle.com/database/product_editions.html

Что установлено на данном инстансе:
select * from v$option