Oracle Database Administration

Software information Patch 13390677: 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER Product                Oracle Database - Enterprise Edition Oracle Server - Standard Edition Hide Release      Oracle 11.2.0.4.0 Platform IBM AIX on POWER Systems (64-bit) Size        7.3 GB Download software  from oracle support 1.        Oracle 11.2.0.4 Database Software Installation 2.        Navigate to directory where database software was unzipped 3.        As root user, run rootpre.sh 4.        As Oracle user, ensure all ORCALE* and TNS* variables are unset 5.        Create required install directory 6.        Ensure Xwindows settings are correct 7....

http://gavinsoorma.com/2009/07/script-monitor-flashback-logs/ PROMPT How Far Back Can We Flashback To (Time)? PROMPT select to_char(oldest_flashback_time,'dd-mon-yyyy hh24:mi:ss') "Oldest Flashback Time" from v$flashback_database_log; PROMPT PROMPT How Far Back Can We Flashback To (SCN)? PROMPT col oldest_flashback_scn format 99999999999999999999999999 select oldest_flashback_scn from v$flashback_database_log; PROMPT PROMPT Flashback Area Usage SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; PROMPT col ROUND(SPACE_LIMIT/1048576) heading "Space Allocated (MB)" format 999999 col round(space_used/1048576) heading "Space Used (MB)" format 99999 col name Heading "Flashback Location" format a40 select name, round(space_limit/1048576),round(space_used/1048576) from v$RECOVERY_FILE_DEST;