Indexing issue

Former Member — Thu, 24 Jan 2008 05:57:47 GMT

Hi Gurus,

I have problem with indexing , iam writing an extractor for pulling data into BI .

where we are using one ztable .

as we ran the extractor we faced some performance issue .so i checked with the ztable its taking longer time ..

so i checked for the index where i found as in the below ....

"Index does not exist in database system ORACLE"

even now iam facing the same problem of system time out

DUMP ANALYSIS

After a specific time, the program is terminated to make the work area

available to other users who may be waiting.

This is to prevent a work area being blocked unnecessarily long by, for

example:

- Endless loops (DO, WHILE, ...),

- Database accesses with a large result set

- Database accesses without a suitable index (full table scan)

The maximum runtime of a program is limited by the system profile

parameter "rdisp/max_wprun_time". The current setting is 600 seconds. If this

time limit is

exceeded, the system attempts to cancel any running SQL statement or

signals the ABAP processor to stop the running program. Then the system

waits another 60 seconds maximum. If the program is then still active,

the work process is restarted.

Thanks,

vinay.

Re: Indexing issue

Former Member — Fri, 25 Jan 2008 04:19:32 GMT

Hi Vinay,

Please refer this link,

kindly reward if found helpful.

cheers,

Hema.