. Three of them have pct_increase of 50%,
the rest - 0. Should I consider changing the
pct_increase to 0 in all tablespaces in order to get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS though?
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote
information without value - there are so many things I haven't seen
yet,
like lizards playing chess or Cary taking a quick shower).
oh the questions and thoughts this brings to mind!
as in:
has Mogens SEEN Cary taking a shower? or does he infer that Cary takes
long showers by the amount of
Well, no I haven't seen him actually take a shower, but one must hope
that the sound of running water for 42 minutes followed by silence for
another 21 minutes must mean that water has run down Cary and not just
down the drain.
And although I haven't seen him take the shower, we're many
Well, regardless of Mr. Millsap's hygiene and the details of how he
maintains it, you *have* seen an unretouched photograph of a lizard playing
chess, with my son...
...and the lizard was cheating by taking too much time to make his first
move and eventually forfeited. Never turn your back on a
. Three of them have pct_increase of 50%,
the rest - 0. Should I consider changing the
pct_increase to 0 in all tablespaces in order to get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS though?
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote
Tim,
thanks for the info. We do have a number of DMTS in
the database. Three of them have pct_increase of 50%,
the rest - 0. Should I consider changing the
pct_increase to 0 in all tablespaces in order to get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS
pct_increase of
50%,
the rest - 0. Should I consider changing the
pct_increase to 0 in all tablespaces in order to
get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS though?
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote
Haven't seen this error since Oracle7...
If the message is hitting the alert.log, then chances are good it is
coming from SMON. SMON is attempting to acquire the ST (a.k.a. Space
transaction) enqueue in preparation for coalescing free space in some
tablespaces. However, if it is unable to
Hi all:
I'm seeing the ora-01575 error in the alert logfile.
The article on the metalink refers to the parameter
which I think is obsolete in the ORacle version we are
running (8.1.7). What does this error refer to? Any
thoughts? references?
thanks
gene
__
Do
Chris,
The query is showing 99.19% of the sorts done in
memory.
thank you
Gene
--- [EMAIL PROTECTED] wrote:
Are you doing a lot of sorting with a small
sort_area_size set?
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
as well).
Tanel.
thanks for the info. We do have a number of DMTS
in
the database. Three of them have pct_increase of
50%,
the rest - 0. Should I consider changing the
pct_increase to 0 in all tablespaces in order to
get
rid of this ora 1575? Wouldn't I want to have
to 0 in all tablespaces in order to get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS though?
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
Haven't seen this error since Oracle7...
If the message is hitting the alert.log, then
chances
Are you doing a lot of sorting with a small sort_area_size set?
That's what Note:33567.1 in Metalink seems to point to. Since this
involves the ST enqueue it is probably also a good idea to see if you
can switch to locally managed tablespaces. Switch temp over first.
You might want to run a
Hi All,
Oracle 8.0.5
AIX 4.3.3
We have a database that showed an ORA-1575 every minute for 30 minutes this
morning.
This was just after startup when a whole bunch of batch processes kick in
as well
Documentation just says retry the operation (smon tried every minute and
eventually succeeded
objects more carefully and
appropriately...
Hope this helps...
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 1:48 AM
Hi All,
Oracle 8.0.5
AIX 4.3.3
We have a database that showed an ORA-1575 every minute for 30
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: Re: ORA-1575
[EMAIL PROTECTED
16 matches
Mail list logo