We had an medium-size Interleaf Application (RDM) that sits on the Oracle
7.1 system. We are new the Oracle database and need help determining the
bottlenecks. The database contains less than 200000 records with 2 large
tables of about 30000 each. Every screen in the RDM application queries
and
joins these tables. All the tables were created and are controlled by the
Interleaf
Application. What can we do to determine and reduce the bottleneck of the
application.
I was able to do the ANALYZE tbl command on one of the tables and the
results in the chained row table was 6243. This doesn't sound good. Does
this
mean that this table is in bad need of reorganizing??
If I export , do I need to physically issue the DROP Tble command and then
import? Should I export/import on a regular basis??