Switch log file
jairamMar 7 2013 — edited Mar 8 2013Hi Everyone,
We are using the 9i database and during the import, we have temporarily added 2 new log groups (Each 2 gb in size) to improve the import performance. After the completion of the import we have a plan to drop those newly added log groups. In order to do that we have issue the command "Alter system switch logfile".,
but it is running more than 8 hrs., We have increased the Log_archive_max_processes value also but still it is running.,
Could anyone please suggest about how to improve the speed of switch log file operation?
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
Regards,
Jai