autoextend locally managed tablespaces

Printable View

06-24-2003, 06:00 PM
valetudinaria

autoextend locally managed tablespaces

Hello,
Can Locally managed tablespaces be autoextended ?. Is there any reason why one would not autoextend locally managed tablespaces?.
Thanks,
V
06-24-2003, 06:46 PM
davey23uk

yes they can, go to http://tahiti.oracle.com and read up on them

and I wouldnt use them if I was short of diskspace, autoextend can be very useful but some people dont like it
06-24-2003, 11:24 PM
SANJAY_G

Re: autoextend locally managed tablespaces

Quote:

Originally posted by valetudinaria
Hello,
Can Locally managed tablespaces be autoextended ?. Is there any reason why one would not autoextend locally managed tablespaces?.
Thanks,
V

No harm if you have enough disk space and monitoring the growth of the datafiles.
06-25-2003, 05:02 AM
TomazZ

sanjay, davey,
you are saying no harm, if enough disk space.
Can you, please, elaborate on what can be wrong when there is not enough disk space.
Because I am doing this all the time and have no problems.
06-25-2003, 05:08 AM
abhaysk

OS will shoot at you.
06-25-2003, 05:12 AM
SANJAY_G

Quote:

Originally posted by TomazZ
sanjay, davey,
you are saying no harm, if enough disk space.
Can you, please, elaborate on what can be wrong when there is not enough disk space.
Because I am doing this all the time and have no problems.

Well, if you do not have enough space then it won't be able to grow. You will end up with error.
06-25-2003, 05:22 AM
jovery

My personal opinion is that if your going to use autoexend on any object is to make sure you set an upper limit. It just protects the database/application from some nutter running a rouge process that unexpectedly consumes all your disk space.

Just my opinion :)

BTW Happy Birthday Sanjay !
06-25-2003, 05:32 AM
TomazZ

Quote:

Originally posted by SANJAY_G
Well, if you do not have enough space then it won't be able to grow. You will end up with error.

And if you don't have autoextend enabled you will end up with error as well, when object would want to grow more.
No difference here - you have to monitor and rearrange storage timely both ways.
06-25-2003, 05:41 AM
Giani

In our shop we are supporting production databases only but not dev environment;)
So never ever use autoextend on your production environment...
but we recommend our dev DBA to use autoextend on their environment.
What do you think Mr, Hanky?;)
06-25-2003, 05:42 AM
abhaysk

Quote:

Originally posted by TomazZ
And if you don't have autoextend enabled you will end up with error as well, when object would want to grow more.
No difference here - you have to monitor and rearrange storage timely both ways.

Suerly theres a difference, Its ok if any application fail due unable to extend...but if you set AUTOEXTEND ON with UNLIMITED option....Due some erratic application...your DISK might end up to be FULL...

So the later case will COST you much then former.

So always Limit Size(Max Size) as suggested by Jovery ( Upper Limit be Set )...

you have some monitioring tools to check up the size regularly...
when size approching threshold limits, put alarms or mail services to send the message...the File needs to be looked into..and so.

I feel this is better approch then jus keeping AUTOEXTEND ON UNLIMITED...

Abhay.
06-25-2003, 05:43 AM
pando

We have been using autoextend on since Oracle 7, no problems at all. Regarding unlimited clause, probably inexperienced would use that
06-25-2003, 05:49 AM
TomazZ

Ok, I admit, I have 2GB datafile limit.
But, nevertheless, I got a full volume with few datafiles like this.
No problem here.
06-25-2003, 09:02 AM
SANJAY_G

Quote:

Originally posted by jovery
BTW Happy Birthday Sanjay !

Thanks, Jim.

Cheers..
06-25-2003, 09:28 AM
Rohit

:)********* Wish you a Very Happy BirthDay Sanjay .**********:)
06-25-2003, 09:44 AM
marist89

The sun is the same in a relative way, but you're older.
Shorter of breath and one day closer to death.

-- Pink Floyd, Time
06-25-2003, 09:49 AM
TomazZ

I like this optimistic approach ;)

Cheers, Sanjay
06-25-2003, 10:04 AM
jovery

Quote:

Originally posted by marist89

The sun is the same in a relative way, but you're older.
Shorter of breath and one day closer to death.

-- Pink Floyd, Time

You must be a bundle of laughs at a party Jeff :)
06-25-2003, 10:44 AM
marist89

Just having one of those days... :(
06-25-2003, 10:49 AM
DaPi

Sanjay - HAPPY BIRTHDAY ! ! ! !

(Jeff - have you tried rebooting?)
06-25-2003, 11:04 AM
adewri

Happy B'Day Sanjay :D
06-25-2003, 12:20 PM
valetudinaria

locally managed tablespaces

Hi Guys,
Thanks for the response.

appreciate your help,
Thanks,
V
06-26-2003, 01:11 AM
SANJAY_G

Thanks guys..
Jeff, that was good one. Here is another one I got from a friend yesterday..

Quote:

"Artificial intelligence is a wonderful thing. I told my computer that today is my birthday, and it said that I needed an upgrade."

:) :)