Skip to Content
0
Former Member
Mar 11, 2009 at 09:11 AM

Issue with background job--taking more time

24 Views

Hi,

We have a custom program which runs as the background job. It runs every 2 hours.

Itu2019s taking more time than expected on ECC6 SR2 & SR3 on Oracle 10.2.0.4. We found that it taking more time while executing native SQL on DBA_EXTENTS. When we tried to fetch less number of records from DBA_EXTENTS, it works fine.

But we need the program to fetch all the records.

But it works fine on ECC5 on 10.2.0.2 & 10.2.0.4.

Here is the SQL statement:

EXEC SQL PERFORMING SAP_GET_EXT_PERF.

SELECT OWNER, SEGMENT_NAME, PARTITION_NAME,

SEGMENT_TYPE, TABLESPACE_NAME,

EXTENT_ID, FILE_ID, BLOCK_ID, BYTES

FROM SYS.DBA_EXTENTS

WHERE OWNER LIKE 'SAP%'

INTO

: EXTENTS_TBL-OWNER, :EXTENTS_TBL-SEGMENT_NAME,

:EXTENTS_TBL-PARTITION_NAME,

:EXTENTS_TBL-SEGMENT_TYPE , :EXTENTS_TBL-TABLESPACE_NAME,

:EXTENTS_TBL-EXTENT_ID, :EXTENTS_TBL-FILE_ID,

:EXTENTS_TBL-BLOCK_ID, :EXTENTS_TBL-BYTES

ENDEXEC.

Can somebody suggest what has to be done?

Has something changed in SAP7 (wrt background job etc) or do we need to fine tune the SQL statement?

Regards,

Vivdha