Re: ora 1575?

. 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

Re: ora 1575?

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

Re: ora 1575?

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

Re: ora 1575?

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

Re: ora 1575?

. 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

Re: ora 1575?

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

Re: ora 1575?

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

Re: ora 1575?

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

ora 1575?

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

Re: ora 1575?

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

Re: ora 1575?

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

Re: ora 1575?

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

Re: ora 1575?

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

ORA-1575

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

Re: ORA-1575

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

Re: ORA-1575

Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Re: ORA-1575 [EMAIL PROTECTED