A quick question on File size in Unix

Joel Garry · *nix forums Guru Joined: 24 Mar 2005 Posts: 1044

When I was having a problem imp'ing a large file in 8i, someone at O
support mentioned there were still rumors of unproven bugs at 2G
limits. My problem turned out to be a problem with NFS (actually,
biod's) with cp'ing files over about 10G. So, sorry for possible
myth-mongering, but there you go. I've also spent a couple of years
with hp-ux and windows with ~30G exp files on the same NFS devices, so
there you go (I just assumed the exp generation was slower than cp, so
didn't show the problem).

Sybrand's comment about waking Murphy is worth listening to. Perhaps
it should be bedding Murphy :-)

Another thing to consider, when I changed data files from 1 big and a
bunch of smaller to a bunch of 2G files, RMAN backup was better able to
utilize parallelization (5 hours v 4 hours).

The create database defaults are different from the link you listed if
you generate sql scripts with the wizard.

Note 119507.1 on metalink explains MAXDATAFILES in detail, including
that one way to increase it is to recreate the controlfile. The
Database Administrator's Guide mentions you can add datafiles up to the
value of the init parameter db_files, and that will expand the
controlfile over MAXDATAFILES. But of course, you need to bounce to
change db_files, so that doesn't get you much over create controlfile
noresetlogs.

jg
--
@home.com is bogus. "This workaround should only be used following due
consideration to how it may effect the ability to recover and as such
should not be made public even after 10G goes production." - From a
public metalink problem doc.

Sybrand Bakker · *nix forums Guru Joined: 03 Apr 2005 Posts: 1766

On 10 Feb 2005 06:05:42 -0800, lambu999@yahoo.com wrote:

Frank van Bortel · *nix forums Guru Joined: 19 Apr 2005 Posts: 804

lambu999@yahoo.com wrote:

lambu999@yahoo.com · *nix forums beginner Joined: 10 Feb 2005 Posts: 17

1) Oracle 9i manual:

Link:
http://download-east.oracle.com/docs/html/A90347_02/ch1_admi.htm#92496

-----------------------------------------------------------
"Table 1-5 lists the Oracle9i file size limits specific to UNIX.

Table 1-5 File Size Limits

File Type Maximum Size
========= ============
Datafiles 4,194,303 multiplied by the value of the DB_BLOCK_SIZE

Import/Export file 2,147,483,647

SQL*Loader file 2,147,483,647"
------------------------------------------------------------

My question: I thought the 2GB limit for Export/Import was gone in 8i?

2) The section also deals about control file parameters. Is it true
that from 9i onwards the control file does not have to be recreated if,
say MAXDATAFILES is reached? Does the control file expand dynamically?
(I dont see the answer there. I am sure it is a simple question)

Thanks,
Ram.

Google