RE: Just a General Question on System Tablespace.
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Chris.Stephens@xxxxxxx>, <niall.litchfield@xxxxxxxxx>, <hemantkchitale@xxxxxxxxx>
- Date: Wed, 19 Jan 2011 14:20:11 -0500
Hmmm, I keep a year, there should be a cutoff somewhere. If that is over 32G,
then you indeed answered my question.
Also, I'm not sure what changed, or how much of a hassle upgrading is, but it
can go into another tablespace.
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: Stephens, Chris [mailto:Chris.Stephens@xxxxxxx]
Sent: Wednesday, January 19, 2011 1:26 PM
To: Patterson, Joel; niall.litchfield@xxxxxxxxx; hemantkchitale@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; sheldonquinny@xxxxxxxxx
Subject: RE: Just a General Question on System Tablespace.
"I do have to wonder however, especially if you do not use dictionary managed
tablespaces, what is causing the system tablespace to grow (beyond 32G if your
on 8K blocksize)?"
Sys.aud$?
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Wednesday, January 19, 2011 12:21 PM
To: niall.litchfield@xxxxxxxxx; hemantkchitale@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; sheldonquinny@xxxxxxxxx
Subject: RE: Just a General Question on System Tablespace.
If you ask me, and I am not statistics guru, in either case, one is enough.
Wasting any datafile is kind of mistake ...
Its kind of like (the opposite?) saying you can't win the lotto if you don't
play, but buying two tickets is not doubling your odds, its wasting your money.
I do have to wonder however, especially if you do not use dictionary managed
tablespaces, what is causing the system tablespace to grow (beyond 32G if your
on 8K blocksize)?
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Niall Litchfield
Sent: Wednesday, January 19, 2011 1:09 PM
To: hemantkchitale@xxxxxxxxx
Cc: Oracle-L Freelists; sheldonquinny@xxxxxxxxx
Subject: Re: Just a General Question on System Tablespace.
How do you calculate that? And as a follow up are all your tablespaces bigfile?
On 19 Jan 2011 15:54, "Hemant K Chitale"
<hemantkchitale@xxxxxxxxx<mailto:hemantkchitale@xxxxxxxxx>> wrote:
It is acceptable to have more than datafile for SYSTEM. Technically, this adds
one more point of failure : "there's a higher probability of an administrator
mistakenly removing any 1 of 2 files than 1 of 1 file".
Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone
>
> On Jan 19, 2011 3:44 PM, "Sheldon Quinny"
> <sheldonquinny@xxxxxxxxx<mailto:sheldonquinny@xxxxxxxxx>> wrote:
>
> Hi Folks,
>
> I ...
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is
addressed and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If the reader of this message is
not the intended recipient or the employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify us
immediately by email reply.
Other related posts: