Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:archivelog [2015/12/29 19:35] – [Log modus prüfen] gpipperr
+++ dba:archivelog [2015/12/29 19:36] – [Flashrecovery Area Script] gpipperr
@@ Zeile 104: / Zeile 104: @@
 <code plsql reco.sql>
-SET linesize 130 pagesize 300 recsep OFF
+set linesize 130 pagesize 300 recsep off
 ttitle  "Report Recovery Dest Parameter"  SKIP 1 -
        center "Sizes in MB" SKIP 2
+archive log list
 show parameter reco
+column limit            format a14
+column used             format a14
+column reclaimable      format a14
+column number_of_files  format a6 heading "Files"
+column used             format a12
-select 	 NAME
+select to_char(round(SPACE_LIMIT / 1024 / 1024, 2)) || ' M Limit' as limit
-	,SPACE_LIMIT
+      ,to_char(round(SPACE_USED / 1024 / 1024, 2)) || ' M in Use' as used
-	,SPACE_USED
+      ,to_char(round(SPACE_RECLAIMABLE / 1024 / 1024, 2)) || ' M' as RECLAIMABLE
-	,SPACE_RECLAIMABLE
+      ,to_char(NUMBER_OF_FILES) as NUMBER_OF_FILES
-	,NUMBER_OF_FILES
+      ,to_char(round((SPACE_USED * 100) / SPACE_LIMIT, 2), '909D00')||' %' as Used
-from V$RECOVERY_FILE_DEST
+  from V$RECOVERY_FILE_DEST
 /
 ttitle off
 </code>