rozbor, oprava elektroniky, zdrojový kód, unix, oracle a chaotické poznámky z oblastí do ktorých občas zabŕdnem
select userid, userhost, count(0)
from aud$
group by userid, userhost
order by 3;
select * from sys.aud$ where userid = 'S_OPER';select 'alter system kill session '''||a.sid||','||a.serial#||''';'||' '|| a.module KILL_CMD
from v$session a, v$process p
where p.addr=a.paddr and a.status <> 'KILLED' and type <>'BACKGROUND' and a.module like 'rman%'
order by module;
SELECT s.SID, USERNAME AS "User", PROGRAM, MODULE, ACTION, LOGON_TIME "Logon", l.*
FROM V$SESSION s, V$ENQUEUE_LOCK l
WHERE l.SID = s.SID AND l.TYPE = 'CF' AND l.ID1 = 0 AND l.ID2 = 2;
oracle@serv:~$ . oraenv
ORACLE_SID = [] ? DB1
The Oracle base remains unchanged with value /u01/app/oracle
oracle@serv:~$ sqlplus / as sysdba
-- najdi trace
SQL> select value from v$diag_info where name = 'Diag Trace';
VALUE
----------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/db1/DB1/trace
-- aj ine cesty SELECT * FROM V$DIAG_INFO;
sqlplus / as sysdba
shutdown immediate
startup mount
alter database rename file '/d1/ora/DB1/data01.dbf' to '/d2/ora/DB1/data01.dbf';
alter database open
sql> alter tablespace DATA offline;
> mv /d1/oracle/DB1/data01.dbf /d2/oracle/DB1/data01.dbf
sql> alter tablespace DATA rename datafile '/d1/ora/DB1/data01.dbf' to '/d2/ora/DB1/data01.dbf';
sql> alter tablespace DATA online;
with aa as (
select meno, datum, chyba
from tabulka_chyb)
select * from aa
order by datum desc, meno, chyba
sudo apt-get install lsdvd
