33 lines
739 B
Markdown
33 lines
739 B
Markdown
|
```sql
|
||
|
|
|
||
|
|
tbsql sys/password 콘솔에서 DB 로그인
|
||
|
|
set linesize 200;
|
||
|
|
alter session set nls_date_format='YYYYMMDD HH24:MI:SS';
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
select snap_id,
|
||
|
|
to_char(begin_interval_time, 'yyyymmdd hh24:mi:ss') as begin_interval_time,
|
||
|
|
to_char(end_interval_time, 'yyyymmdd hh24:mi:ss') as end_interval_time,
|
||
|
|
THREAD#
|
||
|
|
from _tpr_snapshot
|
||
|
|
order by begin_interval_time desc
|
||
|
|
|
||
|
|
exec dbms_tpr.report_text('20231130 12:00:30', '20231130 12:00:50', instance_no=>'1', 'node0_20231130.tpr');
|
||
|
|
|
||
|
|
exec dbms_tpr.report_text_id('5779', '5779' , 1, 'node0_20231130_11-12.tpr');
|
||
|
|
exec dbms_tpr.report_text_id('5782', '5782' , 0, 'node1_20231130_11-12.tpr');
|
||
|
|
|
||
|
|
|
||
|
|
SELECT INSTANCE_NUMBER FROM V$INSTANCE;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- 로그 확인
|
||
|
|
tblog
|
||
|
|
cd ..
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
```
|