| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locally managed tablespaces
This is curious because I don't have this problem. Is this a bug on earlier
versions or a platform difference? We're running O8.1.6 on Solaris 2.6 with
Veritas. I've got 1GB datafiles which can hold 8 extents of 128M. Actually
the size of the datafiles are 1GB + 64K for the 4 db block overhead needed
for Veritas (my blocks are 16K). Are you taking into account the db blocks
needed for datafile overhead? (Normal=1, raw=2, Veritas=4...)
Give this a try: Create a test tablespace of 1GB plus the necessary db block overhead. Then create a test table with an initial extent of 512M. Then try to allocate another extent to see if it fits. If not extend the datafile by another 2 db blocks and try it again. Let us know what happens. Good luck.
Steve Orr
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Madhavan
Amruthur
Sent: Monday, June 19, 2000 12:11 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Locally managed tablespaces
Hi Jared,
Thanks for the mail.
Yes, larger datafiles is an option but we wanted to create 2G datafiles as a
standard here and about extent sizes we have created tablespaces based on
small, medium and large and the large tablespaces are going to host 3
partitions of data which is about 55G.
If we have 10M extents that would mean 100*15 = 1500 extents for a segment
and a total of 4500 extents.
But is this normal behaviour for locally managed tablespaces that an extent from each datafile is grabbed?
Thanks for your help.
Regards,
Madhavan
IBM Corporation
>From: Jared Still <jkstill_at_bcbso.com>
>To: Madhavan Amruthur <mad012000_at_hotmail.com>
>CC: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Locally managed tablespaces
>Date: Mon, 19 Jun 2000 10:03:25 -0700 (PDT)
>
>
>Use smaller extent sizes and larger data files.
>
>You don't mention how many objects are in the tablespaces.
>
>4m extents would give you about 10,000 extents. Not
>excessive if spread over a few objects.
>
>Jared
>
>On Mon, 19 Jun 2000, Madhavan Amruthur wrote:
>
> > Hi,
> > We created our tablespaces as locally managed and we have about 4
> > tablespaces that are 40G. According to note
> > 111666.1 on Metalink one extent from each datafile is used for storage
> > management and we have 200M uniform
> > extent size which means we lose 4G over a 40G tablespace with 20 data
> > files. We have 4 tablespaces with 40G
> > and that means 16G. We also have other tablespaces 20G.
> >
> > Is there a better way to do it other than converting it into a dict
> > managed tbs with uniform extent size?
> >
> > Thanks for your help in advance.
> > Regards,
> >
> > Madhavan
> > IBM Corporation
> > Integrated Technology Services
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Madhavan Amruthur
> > INET: mad012000_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
>Jared Still
>Certified Oracle DBA and Part Time Perl Evangelist ;-)
>Regence BlueCross BlueShield of Oregon
>jkstill_at_bcbso.com - Work - preferred address
>jkstill_at_teleport.com - private
>
>
-- Author: Madhavan Amruthur INET: mad012000_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Mon Jun 19 2000 - 14:19:19 CDT
 |
 |