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
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
Title: Message
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.
I assume you already tried to isolate the problem,
by creating smaller file or
Title: Message
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 with ASSM.
Cheers
Richard
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients
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
GogalaOracle DBA
-Original Message-From: [EMAIL 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
13 matches
Mail list logo
