Jayesh Pande

-- Utilisation (MB) du FRA 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; -- FRA Occupants SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; -- Location and size of the FRA show parameter db_recovery_file_dest -- Size, used, Reclaimable SELECT   ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,   ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,   ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,   SUM(B.PERCENT_SPACE_USED)  AS PERCENT_OF_SPACE_USED FROM   V$RECOVERY_FILE_DEST A,   V$FLASH_RECOVERY_AREA_USAGE B GROUP BY   SPACE_LIMIT,   SPACE_USED ,   SPACE_RECLAIMABLE ; -- After that you can resize the FRA with: -- ALTER SYSTEM SET db_recovery_file_dest_size=xxG; -- Or change the FRA to a new location (new archives w...

If you ever want to empty it you can use this chain of commands. # free && sync && echo 3 > /proc/sys/vm/drop_caches && free              total        used        free      shared     buffers      cached Mem:        1018916      980832       38084           0       46924      355764 -/+ buffers/cache:      578144      440772 Swap:       2064376         128     2064248              total        used ...

   DNS Configuration for SCAN IP Set the Domainname:             # domainname rac1.com             # domainname >/etc/defaultdomain Write the zone information in /etc/named.conf             # vi /etc/named.conf options {         directory "/var/named";         };         zone "rac1.com"{         type master;         file "rac1domain.for";                         };         zone "1.168.192.in-addr.arpa"{         type maste...