RE: performance impact

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Mon, 28 Apr 2003 14:07:01 -0800
Message-ID: <F001.0058AD3C.20030428140701@fatcity.com>

How about asking your backup guy ?

We are doing backup with 16 threads in parallel. So when planning a large database we think to the backup time and the restore time.

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>

-----Original Message-----
Sent: Monday, April 28, 2003 5:02 PM
To: Multiple recipients of list ORACLE-L

For a 400 GB tablespace, which one is better?

1. 200 2GB datafiles
2. 100 4GB datafiles
3. 50 8GB datafiles
4. 25 16GB datafiles

[64-bit Oracle 9i on Solaris 9]

Thanks,
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>

---

This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com

---

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
  INET: roger_xu_at_dp7uptx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: stephane.paquette_at_standardlife.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Mon Apr 28 2003 - 17:07:01 CDT