Are there performancebenefits to reorganizing database-using export/import?

I am using Oracle 9.2.0.5 on HP UNIX 11i. Since it is a production
system, I cannot change version of Oracle any time soon, so please do
not suggest that.

I have a production database using Oracle 9.2.0.5, which has been
running for last 3 years since it was upgraded from 8.1.7. At that
time we had done full export of 8.1.7 database and then created 9.2.
instance and then imported all the application schemas.

Load on our database has been increasing and there are constant
pressures from management to improve performance. We have looked at
indexes many times, have lots of memory for SGA and have tuned various
init.ora parameters. We utlize three pools buffer, keep and recycle.
Being a third party packages, we cannot rewrite queries. Avg CPU
Utilization (6 CPU"s) is 30%, memeory utilization is 60% (we have 24
GB memeory on the server), so I do not see we are taxing any
resources, i..e, adding more CPU's and memory should not help.

Application is a mix of OLTP and reporting, it is definitely more read
than write.

Are there any benefits to reorganize database using export/import,
i.e., we will do a full export of existing database and then delete
all objects from application schemas and do schema imports. We will
run the dbms_Stats again to recomputed statistics. Of course, we will
test all of that in a test environment before making change sin
production.

I have heard different views on reorganization. Some people say it is
useless, some people say it can improve performance since data will be
compacted in fewer blocks.
Appreciate your feedback.
.

Relevant Pages

  • Re: Connecting to an Oracle database
    ... PL/SQL Release 2.3.4.0.0 - Production ... I now succeded to connect to the database in Delphi with the ADO ... > use it to connect to the database and immediately after you connect Oracle ... > conform to their programming paradigm. ...
    (borland.public.delphi.database.ado)
  • Re: Oracle SE licensing question
    ... Each one of us needs to host an instance of database on our PC/laptop. ... Each developer also needs to connect database instance hosted on other ... Is there free/cheap Oracle licensing scheme that we can take advantage ... which should be based on your production needs. ...
    (comp.databases.oracle.misc)
  • Re: Different databases or different schemas?
    ... Even if I'm using Oracle since some year, ... about the use of differents schema instead of different DBs. ... production environment, I create 3 different databases on the same ... developing and production on the same database, ...
    (comp.databases.oracle.server)
  • Re: Different databases or different schemas?
    ... Even if I'm using Oracle since some year, ... production environment, I create 3 different databases on the same ... individual Oracle installations and databases on each one. ... My question is about the convenience to create 3 schemas on 1 ...
    (comp.databases.oracle.server)
  • Re: Oracle 10g R2
    ... > I am download a free copy of new database Oracle 10g R2 from Oracle site. ... In this case it will be totally free to deploy into production. ... License' saying you can develop and evaluate, ...
    (comp.databases.oracle.server)