2012-10-18から1日間の記事一覧
SQL*Plus でログインしてサーバープロセスの PID を確認して、 [oracle@localhost ~]$ sqlplus neo/zion SQL> select s.sid, s.serial#, p.spid from v$session s, v$process p where p.addr = s.paddr and s.sid = sys_context('USERENV','SID'); SID SERIA…
[oracle@localhost ~]$ sqlplus neo/zion SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 17 17:50:41 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Pro…
SQL> alter session set sql_trace=true; Session altered. SQL> select to_char(sysdate,'yyyymmddhh24miss') from dual; TO_CHAR(SYSDAT -------------- 20121017170716 SQL> exit [oracle@localhost ~]$ cd app/oracle/diag/rdbms/orcl/orcl/trace/ [orac…