Oracle Press Books...specifically Oracle 10g - The Complete Reference as
well as the OCP Certification Reference Book
-----Original Message-----
From: tyrone.curtis
[mailto:oracledba-ezmlmshield-x37434565.[Email address protected]
Sent: Saturday, October 30, 2004 11:13 AM
To: LazyDBA Discussion
Subject: Re: Questions on how to get started in Oracle
Hello everyone,
I am new to Oracle. My future goal is become certified. I would like
information on the best way to get started on reaching this goal. I read
some information on the Oracle website, however the information is
overwhelming. Please advise on some really good books, training,
experience etc. ????? . Thanks
----- Original Message -----
From: "Weller Robert "
<oracledba-ezmlmshield-x91101633.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, October 30, 2004 6:10 AM
Subject: RE: tablespaces
> At some places, midrange storage performed with SAN environments
> where the ability to identify multiple drives to place files is not
> controllable by the midrange or DBA. It is a virtual type of storage and
> having or knowing what drives are used for your files is almost
impossible.
>
> Bob W.
>
>
>
> -----Original Message-----
> From: Justin Cave (DDBC)
> [mailto:oracledba-ezmlmshield-x66088950.[Email address protected]
> Sent: Friday, October 29, 2004 5:21 PM
> To: LazyDBA Discussion
> Subject: RE: tablespaces
>
>
> Depends on the situation and what you call a "difference"
>
> From a performance perspective, it doesn't matter how many files you
> have, what matters is how many disk drive you can put to work
> simultaneously. Striping one large file over many drives is probably
> the most efficient approach. If you cannot stripe the file across
> multiple disks, putting smaller files on separate drives is an
> alternative, but you will likely run into situations where the "hot"
> blocks are in one of these files, so you can spend a lot of time on I/O
> balancing.
>
> From a recovery perspective, having reasonable and standard file sizes
> is a good thing. If you had a failure and you have one 100 GB data
> file, you have to restore the entire file from tape. If you only lost a
> 2 or 4 GB file, on the other hand, you don't have to worry. If files
> are standard sizes, it also makes moving them around easier, which is
> quite helpful when a RAID array fails and you need to spread the lost
> files over your other drives.
>
> Justin Cave
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>
> -----Original Message-----
> From: Carlos Barrera
> [mailto:oracledba-ezmlmshield-x97762876.[Email address protected]
> Sent: Friday, October 29, 2004 5:01 PM
> To: LazyDBA Discussion
> Subject: tablespaces
>
> Hi all,
>
> Based on your experience, is there a difference if I use only 1
> datafile
> or 10 or 20 or n (all on the same disk) for a single tablespace?
>
> Also is there a benefit if the datafiles for 1 tablespace are on
> different disks?
>
> Oracle version is 8.0.5.
>
>
> Regards.
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------------------------------------------------------------------------
-----------------
> ***National City made the following annotations
> --------------------------------------------------------------------------
-----------------
> This communication is a confidential and proprietary business
communication. It is intended solely for the use of the designated
recipient(s). If this communication is received in error, please contact
the sender and delete this communication.
>
============================================================================
===============
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page