sql.bsq

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 20 Nov 1998 21:26:16 GMT
Message-ID: <01be14cb$ad7e3a40$0300a8c0@WORKSTATION>

Here's a cute feature:

Extract 1: from the Oracle 8.0 Tuning Manual p. 15-34

---

---

The SQL.BSQ file is run when you issue the CREATE DATABASE statement. This
file contains the actual table definitions that make up the Oracle Server. The views
that you use as a DBA are based on these tables. Oracle Corporation recommends
that users strictly limit their modifications to SQL.BSQ.

         If necessary, you can increase the value of the following storage parameters:

	INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE, FREELISTS,
	FREELIST GROUPS, and OPTIMAL.

Extract 2: From the Oracle 8.0.5 Readme file

---

1.6 SQL.BSQ

---

For performance reasons, due to the large number of objects in a typical
installation, some customers have noticed performance improvements by

making modifications to sql.bsq before installation. An example of this is
increasing initial extents. Do not do this as it may jeopardize customer supportability.

--
Jonathan Lewis Received on Fri Nov 20 1998 - 15:26:16 CST