:: Welcome to Shilpi Computers ::

Software Performance Issue

For better performance of software please insure that the following given indexes must be in database :-

1. Valid indexes in Commex10:- For check the indexes in database run utilcap10.exe from Commex10 folder (program folder). Connect the database and go to Commex menu and select "create/verify indexes (commex)" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

2. Valid indexes in cApex10:- For check the indexes in database run utilcap10.exe from cApex10 folder (program folder). Connect the database and go to Maintenance (cap+fo) menu and select "create/verify index" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

3. Valid indexes in DP:- For check the indexes in database run utilcap10.exe from DPORA10 folder (program folder). Connect the database and go to Nsdl (DP) menu and select "create/verify index" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

4. Valid indexes in Cdsl:- For check the indexes in database run utilcap10.exe from CDSLl10 folder (program folder). Connect the database and go to Nsdl (DP) menu and select "create/verify index" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

How to Close your books ?

Oracle Maintenance