ORACLE tips

FONT -- Lucida Console !!!
chcp 1251

RUSSIAN_CIS.CL8MSWIN1251
chcp 1251

для клиента виндовс NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251
для клиента линукс NLS_LANG=AMERICAN_AMERICA.CL8KOI8R

sqlplus sys/querty@xe AS SYSDBA

SELECT table_name FROM user_tables;

select to_char(to_date('19-SEP-2008','dd-mon-yyyy'),'day') from dual;
select user from dual;
select sysdate from dual;
select current_user from dual;

set ARRAYSIZE 1000;
set LINESIZE 1000;
set PAGESIZE 1000;


select level from dual connect by level < 10;
select level a from dual connect by 1 = 1;


ALTER SYSTEM SET TIMED_STATISTICS = TRUE;
ALTER SESSION SET SQL_TRACE = TRUE;

-- Created d:\oracle\product\10.2.0\admin\xe\udump\xe_ora_4916.trc

select test_connect_by.parent from persons inner join test_connect_by on persons.id = test_connect_by.child group by test_connect_by.parent;

select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr order by 2;
alter system kill session(sid, serial#);

show parameters processes
show parameters sessions

alter system set sessions=250 scope=spfile;
alter system set processes=200 scope=spfile;

select count(*) from v$session
select count(*) from v$process

quit;

orakill xe 4072