Re: Datafile Resize/Max Extents Question

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 Wed Dec 19 2001 - 07:55:30 CST