Home » RDBMS Server » Server Administration » Segment Space management (9.2.0.6.0-IBM AIX)
Segment Space management [message #315375] Mon, 21 April 2008 05:52 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

The paramater SEGMENT SPACE MAMAGEMENT for UNDO Tablespace at my TEST database is "MANUAL".

How can I change the parameter "SEGMENT SPACE MAMAGEMENT" from "MANUAL" to "AUTO"?

Please suggest.



Pokhraj.
Re: Segment Space management [message #315377 is a reply to message #315375] Mon, 21 April 2008 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do it:
SQL> create undo tablespace undo2 datafile 'C:\ORACLE\BASES\MIKA\UNDOTBS02.DBF' size 10m
  2  segment space management auto;
segment space management auto
*
ERROR at line 2:
ORA-30024: Invalid specification for CREATE UNDO TABLESPAC

Regards
Michel
Re: Segment Space management [message #315379 is a reply to message #315375] Mon, 21 April 2008 06:00 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

So how can I change the parameter ?
please suggest me the solution for the same.

Pokhraj
Re: Segment Space management [message #315380 is a reply to message #315375] Mon, 21 April 2008 06:07 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
The paramater SEGMENT SPACE MAMAGEMENT for UNDO Tablespace at my TEST database is "MANUAL"


WHats the output of
SQL>show parameter undo_management

Re: Segment Space management [message #315381 is a reply to message #315375] Mon, 21 April 2008 06:09 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

The parameter for sho paramater undo_management is "AUTO"
Re: Segment Space management [message #315382 is a reply to message #315375] Mon, 21 April 2008 06:12 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
SO the segment space management is auto.

From where did you see it is manual?
Re: Segment Space management [message #315386 is a reply to message #315375] Mon, 21 April 2008 06:22 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

select tablespace_name, SEGMENT_SPACE_MANAGEMENT
from dba_tablespaces;
Re: Segment Space management [message #315390 is a reply to message #315375] Mon, 21 April 2008 06:40 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
So its the default.
system,undo temp have manual segment space management.

and extent management is local.
Re: Segment Space management [message #315400 is a reply to message #315379] Mon, 21 April 2008 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
So how can I change the parameter ?

You can't, you can't change, you can't create with auto, manual is mandatory.

Regards
Michel
Re: Segment Space management [message #315480 is a reply to message #315375] Mon, 21 April 2008 12:52 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
But if we create undo /temp tablespace later on then it is possible to specify segment space management to auto.

But why oracle defaults system tablespace to manual when there are benefits of automatic segment space management?
Re: Segment Space management [message #315483 is a reply to message #315375] Mon, 21 April 2008 12:56 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>But why oracle defaults system tablespace to manual when there are benefits of automatic segment space management?

So are you claiming that you know better than Oracle how manage Oracle's resources?

SYSTEM is Oracle's tablespace & you should not waste your precious thoughts being concerned about how Oracle manages its own resources.

You seem to face enough challenges of your own making without trying to do Oracle's job too.
Re: Segment Space management [message #315486 is a reply to message #315375] Mon, 21 April 2008 13:05 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Hey Ana,
I asked a simple question.
Why oracle does not follow what it recommends?
I know system is a special tablespace but it does grow as any other tablespace.

Does it mean the concept of bitmaps is not applicable to it?
Re: Segment Space management [message #315491 is a reply to message #315375] Mon, 21 April 2008 13:16 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Does it mean the concept of bitmaps is not applicable to it?
Why do you care?

How will the answer one way or the other change your behavior?

What prevents you from generating a SELECT against objects in SYSTEM tablespace & reporting object_type & COUNT(*) to answer your own question?
Re: Segment Space management [message #315567 is a reply to message #315375] Mon, 21 April 2008 22:25 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi Varu
>But if we create undo /temp tablespace later on then it is possible to specify segment space management to auto

Could you please let me know the COMMAND for the same?

pokhraj
Re: Segment Space management [message #315574 is a reply to message #315567] Tue, 22 April 2008 00:33 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read my first post?
Michel Cadot wrote on Mon, 21 April 2008 12:57
You can't do it:
SQL> create undo tablespace undo2 datafile 'C:\ORACLE\BASES\MIKA\UNDOTBS02.DBF' size 10m
  2  segment space management auto;
segment space management auto
*
ERROR at line 2:
ORA-30024: Invalid specification for CREATE UNDO TABLESPAC

Regards
Michel



Did you read all my posts?

IT IS NOT POSSIBLE!

Is this clear?

Regards
Michel
Previous Topic: Mail from Oracle procedure
Next Topic: recover deleted records
Goto Forum:
  


Current Time: Sun Dec 04 20:22:08 CST 2016

Total time taken to generate the page: 0.08273 seconds