• Article Type: General
• Product: Aleph
• Product Version: 20

Problem Symptoms:
* Several users in Acquisitions report the system is slow
* It takes the system up to one minute to react
* Troubleshooting in PC and logs did not reveal any problems.

Cause:
Missing Oracle index z68_id6

Resolution:
The lack of Oracle indexes can be a major cause of slowness.

* Util a 17/14 for xxx50 shows a missing z68_id6 for table z68

Enter Table Name : z68

Defined in file_list:
__________________________________________________________
IND z68_id 600K 0K TS2X
IND z68_id1 800K 0K TS2X
IND z68_id2 200K 0K TS2X
IND z68_id3 200K 0K TS2X
IND z68_id4 100K 0K TS2X
IND z68_id6 600K 0K TS2X
IND z68_id7 10M 0K TS3X
__________________________________________________________

Exist in the Database:

INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
--------------- ------- ---------- ----------- --------------------
Z68_ID VALID NORMAL UNIQUE Z68_REC_KEY
Z68_ID1 VALID NORMAL NONUNIQUE Z68_ORDER_NUMBER
Z68_ID2 VALID NORMAL NONUNIQUE Z68_SUB_LIBRARY
Z68_ID3 VALID NORMAL NONUNIQUE Z68_ORDERING_UNIT
Z68_ID4 VALID NORMAL NONUNIQUE Z68_ORDER_STATUS_DATE_X
Z68_ID7 VALID NORMAL NONUNIQUE Z68_TARGET_ID

*** Remark: Z68_ID6 is not included in the above list

* Create the missing index z68_id6 with util a/17/2

Category: System Management (500)

Subject: Oracle (500)

• Article last edited: 10/8/2013