130 pagesize 200 recsep OFF
column owner format a20
column object_name format a30
column column_name format a25
column equality_preds format 999 heading "equ"
column equijoin_preds format 999 heading "J
r Sessions on this DB" skip 2
column inst_id format 99 heading "Inst|ID"
column username format a14 heading "DB User|name"
column sid format 99999 heading "SID"
column serial# format 99999 heading "Serial"
column machine format a30 hea
of the Database" SKIP 2 -
column FLASHBACK_ON format A20
select FLASHBACK_ON
from V$DATABASE
/
column INST_ID format A4
column RETENTION_TARGET format A20
column FLASH_SIZE format A20
column ESTIMATED_SIZE format A20
ttitle "Report Flashback Size of th
rrors
------ Analyse example:
column anzahl format 9999999999
column hour format A9
column LOG_USR format A10
column ERR_NR format 999999999
column mesg format A30
SELECT COUNT (*) as anzahl
,TO_C
stats.gather_system_stats('Stop');
column sname format a20
column pname format a20
column pval2 format a20
select
sname
, pname
, pval1
, pval2
from
sys.aux_stats$;
</code>
===I... pagesize 300
set linesize 150
column name format a35
column start_time format a25
column end_time
T pagesize 1000
SET linesize 150
column SQL_TEXT format a23
column SQL_HANDLE format a20
column PARSING_SCHEMA_NAME format a14
column PLAN_NAME format a30
column ORIGIN format a16
column CREATED_TEXT format a18
column ENABLED fo
ntrolliert werden.
<code sql>
col SNAP_INTERVAL format a25
col RETENTION format a25
select DBID
,SNAP_INTERVAL
,RETENTION
,TOPNSQL
from DBA... AWR Snapshots count" skip 2
column snapshot_count format 999999 heading "Snapshot Count"
select count(*) ... "AWR Snapshots time frame" skip 2
column snap_id format 999999 heading "Snap|Id"
column start_time format
IDLE
RFS IDLE
RFS IDLE
column info format a120
prompt Check log last applied to last recei... t serveroutput on size 1000000
column dest_name format a20
column process format a10
column status format a10
column error format a20
column state format a10
column log_seq
s Laufwerk verlegt werden.
Dazu wird einfach das Format der Backupsets neu gesetzt.
<note important>Ach... plsql>
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/u02/opt/oracle/flash_recovery_area/#ORADBSID#/b... ode plsql>
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/opt/oracle/flash_re... ve registriert sind!
<code plsql>
SQL>column name format a40
SQL> SQL> select recid,SEQUENCE#,name,to_char