Re: Datafile Resize/Max Extents Question

Thanks for the response...

I'm not working at Agilent. We're an Agilent customer using their scientific instrumentation and of course the Chemstore/Chemstation product.

I have to say that we're not particularly happy with the technical competence of the gentleman from Agilent that came and set-up this product for us. I wasn't part of the company when the database was implemented.

If I could ask one more question: If I resize my datafiles for this tablespace, and one day in the future all of the datafiles reach the MAX_EXTENT I have set for them, will it be possible to add more datafiles to the tablespace? I think I read in the documentation somewhere that this could cause a problem.

Thanks again, gary.

ganesh_at_gtfs-gulf.com (Ganesh Raja) wrote in message news:<a8aed4.0112190555.210c6e2a_at_posting.google.com>...
> Comments Below....
>
> klokwerks_at_yahoo.com (Gary Luck) wrote in message news:<1b60dac2.0112181014.3e13c49b_at_posting.google.com>...
> > Firstly, I'm new to Oracle and I'd like to thank everyone that contributes to
> >
> > this newsgroup- you have helped me immensely.
> >
> > I have an Agilent Chemstor database running Oracle 7.3.4 on NT 4.0SP6a. When
>
> Are u working in Agilent ???
>
> >
> > it was initially set up, the main data collecting tablespace was created
> >
> > thusly:
> >
> > 15 datafiles of 2GB each
> > 'last' datafile set to extend to 16GB by 1GB increments
> >
> > The company is only doing cold backups right now- once every Sunday afternoon
> >
> > the database is manually shutdown and backed up to tape using Backup Exec
> >
> > 8.6. After testing disaster recovery scenarios with Backup Exec it was found
> >
> > that using hot backups, the database was not recoverable. When I was hired,
> >
> > I was tasked with making hot backups work. I have written a sql script to
> >
> > perform the hot backups and run nightly using NT's 'at' command. This is
> >
> > running wonderfully on a replica test box I have been using. The only
> >
> > problem is, it is taking a little over five hours nightly because of all of
> >
> > the 'empty' data I'm backing up. There is one datafile that has been filled
> >
> > and one other that is about half-filled(1GB). So essentially, I'm backing up
> >
> > 30GB to get 3GB of data.
> >
> > On my test system I resized the empty datafiles to 200MB each and set extents
> >
> > of 200MB to a maximum size of 2GB each. I used Oracle's Storage Manager to
> >
> > do this and it worked seemlessly.
> >
> > My question is this(finally):
> >
> > This will give me about 135 extents for this single tablespace- is that too
> >
> > many?
>
> The Number of Extents do not Have any significance in performance of
> the DB. U will get the same performance if it 1 or 100 or 1000
> Extents.
>
> Also, should I use Server Manager or SQLplus to resize the datafiles
> >
> > instead of Storage Manager?
>
> That also makes no difference bcos Storage manager inturn uses the SQL
> Statments to do the task for u.
>
> > What should I do about the 'last' datafile that
> >
> > is set to extend to 16GB? That seems inexcuseable to me.
>
> That is surely inexcusable and will fail in Winnt as the Max Size of a
> File Supported by NT on NTFS is only 4GB. So It will stall the oracle
> one day.
>
> My Two Cents worth Do not Say Autoextend to u'r Files... Always Check
> to see how they grow and extend them uerself... U will have more
> control... And dont give Maxsize unlimited.
>
> >
> > Again, thanks to all.
>
> No probs Buddy we are for each other....
>
> >
> > Later, gary.
> > klokwerks_at_yahoo.com
>
>
>
> Regards,
> Ganesh R
Received on Sun Dec 30 2001 - 11:33:35 CST