Re: Modifying sql.bsq ??

From: Yuk Hon Johnny Chan <jychan_at_corp.hp.com>
Date: 1995/09/01
Message-ID: <4279pf$7fj_at_hpcc48.corp.hp.com>#1/1


Alon Cohen (orc3_at_datasrv.co.il) wrote:
: I am about to do a reorg of a Oracle 7.1.4 (on hp-ux)
: whose present system objects are quite large and fragmentated:
: C_OBJ# 200M 22 extents
: C_COBJ# 88M 30 extents
: CON$ 17M 16 extents.
 

: Our users are suffering from serious performance problems -
: for various reasons. I would like to eliminate the problem
: of our huge data dictionary by altering the sql.bsq at the
: time of the create database, but I've heard that there is
: potential corruption risk. Has anyone changed the initials/
: nexts of the critical segments (above line 365 in the sql.bsq)

i've done it on two production databases and have not seen any problems. i would not expect any problems.

: and lived to tell about it? Also, any idea to the extent (pun)
: to which the data dictionary segment sizes play in performance?

probably not a whole lot since ideally, most of that is cached into the data dictionary cache. i don't have any quantitative numbers to back that up, though.

Johnny Chan
Indepedent Oracle Specialist Received on Fri Sep 01 1995 - 00:00:00 CEST

Original text of this message