Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
ARCHIVELOG | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

ARCHIVE AREA FULL – CONNECT INTERNAL UNTIL FREED

  • Posted by Arjun Raja
  • On June 29, 2009
  • 0 Comments
When a database is running in ARCHIVELOG mode, if the area which stores the archivelogs on disk gets full, the database comes to a halt and can be accessed only as a sysdba. The error message when you try to connect as a normal user is ‘ CONNECT INTERNAL UNTIL FREED’ If the following parameter […]
Read More
 

Script- Track redo generation by day

  • Posted by Gavin Soorma
  • On June 20, 2009
  • 2 Comments
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;
Read More