of list ORACLE-L
Sent: Monday, September 29, 2003 7:09
PM
Subject: RE: SEGMENT SPACE MANAGEMENT
AUTO hangs on 9.2.0.4 on Linux
And
why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic
segment space management.
Initial/next are resolved by using LMT, because
of list ORACLE-L
Sent: Monday, September 29, 2003 7:04
PM
Subject: RE: SEGMENT SPACE MANAGEMENT
AUTO hangs on 9.2.0.4 on Linux
Smaller file didn't help. Removing the SPACE MANAGEMENT clause did the
trick.
--Mladen GogalaOracle DBA
-Original Message
] [mailto:[EMAIL PROTECTED]On Behalf Of Tanel
PoderSent: Tuesday, September 30, 2003 5:49 AMTo:
Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE
MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
You still can have row migration when pctfree is
set too low. ASSM doesn't resolve
recipients of list
ORACLE-LSubject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4
on Linux
Hi,
We're still on 817 but I was wandering about those
new automatic features (Automatic Undo Management, Automatic Segment Space
management,..) how well they work ?
Anybody using
Title: Message
I have RDBMS 9.2.0.4
on RH 7.3 and Iexecuted the following command:
create tablespace
wizard
datafile
'/oradata/WIZ/wizard01.dbf' size 3072M reuse
autoextend on next
1024M maxsize 16385m
extent management
local autoallocate
segment space
management auto;
The whole system
I've had no problems with the syntax on 9.2.0.2 on Solaris, HPUX and
Tru64.
Haven't tried 9.2.0.4
Is the segment space management auto really the problem ? Or
is it
the file size.
Just run the create tablespace with a 100M or 50M initial file
size.
Hemant
At 06:44 AM 29-09-03 -0800, you wrote:
I
or removing auto segment space management
clause?
Tanel.
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 29, 2003 5:44
PM
Subject: SEGMENT SPACE MANAGEMENT AUTO
hangs on 9.2.0.4 on Linux
I have RDBMS
of list ORACLE-L
Sent: Tuesday, September 30, 2003 12:44
AM
Subject: SEGMENT SPACE MANAGEMENT AUTO
hangs on 9.2.0.4 on Linux
I have RDBMS
9.2.0.4 on RH 7.3 and Iexecuted the following
command:
create tablespace
wizard
datafile
'/oradata/WIZ/wizard01.dbf' size
recipients of list ORACLE-LSubject: Re: SEGMENT SPACE
MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Hi!
If your server process couldn't be even killed,
then probably it was waiting on kernel IO or smth like that. This is a case
when a process can't be killed just like that, even with -9
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Richard FooteSent: Monday, September 29, 2003 11:55
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Hi Mladen,
I can't help you with your problem, I haven't had
:[EMAIL PROTECTED] On Behalf Of Tanel
PoderSent: Monday, September 29, 2003 11:55 AMTo:
Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE
MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Hi!
If your server process couldn't be even killed,
then probably it was waiting on kernel
, 2003 11:55
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Hi Mladen,
I can't help you with your problem, I haven't had
the pleasure on NT or Tru64 but I just wanted to point out that you can't
forget about PCTFREE even
: SEGMENT SPACE MANAGEMENT
AUTO hangs on 9.2.0.4 on Linux
And
why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic
segment space management.
Initial/next are resolved by using LMT, because that's what takes care
of your extent sizes.
--Mladen
14 matches
Mail list logo