Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem:
select count(1) from v$rman_status takes very long time and causing
ORA-01652 Can not extend temp2 tablespace by 128.
The below statements are shown from the V$sort_usage
declare dot1st number ; dot2nd number ; dot3rd number ; comptxt varchar2 ( 255 )
select db.version_time ,db.controlfile_change# ,db.controlfile_sequence# ,dbinc.begin sys . dbms_backup_restore . createRmanOutputRow ( l0row_id => :l0row_id ,
Explanation:
Bug.5247609 RMAN slow performance during register database/open resetlogs
Note.357765.1 Ext/Mod Rman uses a lot Of Temporary Segments ORA-1652 Unable To Extend Temp Segment
Solution:
exec dbms_stats.gather_fixed_objects_stats()
References: Note 357765.1
select count(1) from v$rman_status takes very long time and causing
ORA-01652 Can not extend temp2 tablespace by 128.
The below statements are shown from the V$sort_usage
declare dot1st number ; dot2nd number ; dot3rd number ; comptxt varchar2 ( 255 )
select db.version_time ,db.controlfile_change# ,db.controlfile_sequence# ,dbinc.begin sys . dbms_backup_restore . createRmanOutputRow ( l0row_id => :l0row_id ,
Explanation:
Bug.5247609 RMAN slow performance during register database/open resetlogs
Note.357765.1 Ext/Mod Rman uses a lot Of Temporary Segments ORA-1652 Unable To Extend Temp Segment
Solution:
exec dbms_stats.gather_fixed_objects_stats()
References: Note 357765.1
No comments:
Post a Comment