RE: ?Problem with resize

From: Sam P. Roberts (ZADCO ITIS) <roberts_at_zadco.co.ae>
Date: Wed, 17 Jan 2001 07:59:36 +0400
Message-Id: <10743.126852@fatcity.com>

I'm talking UNIX/SOLARIS and OLTP and FILE SYSTEM and what I do.=20 Instead of One datafile of 2gb, I have 4 512-M datafiles, this is = because I
believe you can improve I/O throughput.
The reason for this is that Solaris takes exclusive write locks at the = file
level (for consistency), therefore multiple write requests will result = in
queueing, hence reduced throughput. This is my take, I'm open to = discussion.
Just out of interest, does anybody know if this is the same on = MICROSLOP NT Regards

Sam

P.S. nice one sachin

-----Original Message-----
From: Armstead, Michael A [mailto:maa25681_at_GlaxoWellcome.com] Sent: Tuesday, January 16, 2001 10:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: ?Problem with resize

Saroj,

We generally resize until a file gets close to 2Gb. Then we will add a = file.
There have been problems using different applications with files over = 2Gb.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline

> -----Original Message-----
> From: Dash, Saroj (CAP,CEF) [SMTP:Saroj.Dash_at_gecapital.com]
> Sent: Tuesday, January 16, 2001 5:06 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ?: ?Problem with resize

>=20

> Please Tell me I will go for resizeing a datafile or adding a new
> datafile.
> Which is better.

>=20

> Saroj.

>=20

> -----OE=B3'=CCf=81fbfZ=81[fW-----
> =8D=B7=8Fo=90l: Trassens, Christian [mailto:CTrassens_at_uni2.es]
> '-=90M"=FAZz: Tuesday, January 16, 2001 PM 05:31
> ^=B6=90=E6: Multiple recipients of list ORACLE-L
> OE=8F-=BC: RE: ?Problem with resize

>=20

> Hi,

>=20

> create_bytes and bytes will differ if you resize a datafile.=20
>=20
> There are bugs. I don't know which you found. I had one in early =
version
> of
> 7.3 on NT and another one resizing RBS on AIX in 7.3.4.....and so on =
(
> generally in 7.3 ). However, if you refer to the difference of those
> fields
> as a bug, you are wrong.

>=20

> Regards.

>=20


> > -----Mensaje original-----

> > De:	Dash, Saroj  (CAP,CEF) [SMTP:Saroj.Dash_at_gecapital.com]

> > Enviado el:	martes 16 de enero de 2001 7:40

> > Para:	Multiple recipients of list ORACLE-L

> > Asunto:	?Problem with resize

> >=20

> > Hello all,

> >=20

> >  I found one Oracle Bug while resizing a datafile.

> > Please suggest me what to do.

> >=20

> > After resizeing a datafile please see the column bytes size and

> > create_bytes

> > size in v$datafile.

> >=20

> > In my opinion both are must be same but it shows different.

> >=20

> > Help .

> > Saroj.

> >=20

> > --=20

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > --=20

> > Author: Dash, Saroj  (CAP,CEF)

> >   INET: Saroj.Dash_at_gecapital.com

> >=20

> > 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).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Trassens, Christian
> INET: CTrassens_at_uni2.es

>=20


> 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).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com

>=20


> 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).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Armstead, Michael A
  INET: maa25681_at_GlaxoWellcome.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 Received on Tue Jan 16 2001 - 21:59:36 CST