RE: Oracle 9.2 changes in INIT
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 08 Jun 2004 15:21:15 -0400
The table must be a hold over and the documentation department has not
been updated with the changes.
I show the following
OS Oracle BKsize MAX
Extents
OpenVMS 7.3-2 8.1.7.4 2k 2147483645
RedHat2.1 u3 9.2.0.5.0 8K 2147483645
RedHat2.1 u3 10.1.0.2.0 8k 2147283645
All info displayed using TOAD.
All databases created with the dbca for the basic database and the
saved scripts.
Ron
>>> Jacques.Kilchoer@xxxxxxxxx 06/08/2004 2:09:18 PM >>>
Weren't those numbers the maximum number of extents for a segment in
7.1
(before unlimited extents)?
Table 7-6 Maximum Number of Extents for Each Database
Typical Block Sizes Number of Extents
2 KB 121
4 KB 255
8 KB 504
16 KB 1032
32 KB 2070
_____
Jared.Still@xxxxxxxxxxx
Niall,
You obviously missed a cue when planning your database.
It should have been created with a 32k blocksize, allowing
2070 extents in your database. ;)
Seriously though, I don't understand the purpose of table 7-6 at all.
Was this doc written April 1st?
Jared
-----------------
On the other hand it has had some nice howlers in there from time to
time. My favourite reason for running oracle on unix is that according
to the 9i documentation there is a limit on the number of extents for
*the database* of (assuming an 8k block size) 504.
http://tinyurl.com/2l5ye refers.
Not sure how the data dictionary gets created since I have more than
504 segments owned by sys in my 9.2 database, so I'd have to fit
several segments in the same extent not even all segments should fity
in 1 extent works :(
-
Niall Litchfield
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
