Skip to main content

Oracle database check db_recovery_file_dest_size usage


db_recovery_file_dest_size usage


The following scripts will check space utilization for db_recovery_file_dest_size:
col name     format a32
col size_mb  format 999,999,999
col used_mb  format 999,999,999
col pct_used format 999


select
   name,
   ceil( space_limit / 1024 / 1024) size_mb,
   ceil( space_used / 1024 / 1024) used_mb,
   decode( nvl( space_used, 0),0, 0,
   ceil ( ( space_used / space_limit) * 100) ) pct_used
from
    v$recovery_file_dest
order by
   name desc;


*********************************



set lines 100
col name format a60

select
   name,
   floor(space_limit / 1024 / 1024) "Size MB",
   ceil(space_used / 1024 / 1024)   "Used MB",
from
   v$recovery_file_dest
order by
   name;

Labels:

Comments

Post a Comment

Popular posts from this blog

Oracle Database How much redo generated per hour

Track the Amount of Redo Generated per Hour / Day  Amount of Redo Generated per Hour SELECT  Start_Date,   Start_Time,   Num_Logs, Round(Num_Logs * (Vl.Bytes / (1024 * 1024)),2) AS Mbytes, Vdb.NAME AS Dbname FROM (SELECT To_Char(Vlh.First_Time, 'YYYY-MM-DD') AS Start_Date, To_Char(Vlh.First_Time, 'HH24') || ':00' AS Start_Time, COUNT(Vlh.Thread#) Num_Logs FROM V$log_History Vlh GROUP BY To_Char(Vlh.First_Time,  'YYYY-MM-DD'), To_Char(Vlh.First_Time, 'HH24') || ':00') Log_Hist, V$log Vl ,  V$database Vdb WHERE Vl.Group# = 1 ORDER BY Log_Hist.Start_Date, Log_Hist.Start_Time; Redo generated Per day: select trunc(completion_time) rundate ,count(*)  logswitch ,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)" from v$archived_log group by trunc(completion_time) order by 1;
3 comments
Read more

Check long running UNIX process

To check how many seconds have elapsed since a process started you can use this small shell script: #!/bin/bash init=`stat -t /proc/$1 | awk '{print $14}'` curr=`date +%s` seconds=`echo $curr - $init| bc` name=`cat /proc/$1/cmdline` echo $name $seconds save it on a file called sincetime and give permissions for your user to run it and put it in your $path. Than, the command: sincetime <pid> will return the name of the process with the given pid and its age in seconds. Find Out How Long A Process Has Been Running In Linux ps command has different format specifiers (keywords) that may be used to control the output format. We are going to use the following two keywords to find the uptime of an active process. etime – elapsed time since the process was started, in the form [[DD-]hh:]mm:ss. etimes – elapsed time since the process was started, in seconds. First, you need to find out the PID of a process. The following comm...
Post a Comment
Read more