| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000?
Queries will automatically go in parallel if you have partitioned tables and
your queries don't use the partition key unless you use a global index. I
read that there was 250 simultaneous sessions. If you have lots of
partitioned tables with lots of users querying these tables without
specifying the partition key, I think you'll hit a performance problem
pretty quickly just on maxing out cpu.
What kinds of indexes do you have on the partitioned tables? I use bitmaps
on the partitioned tables and they fly. Very small, helps performance alot.
Mike
> We were hoping to improve query performance with parallel although it =
> may not be necessary in all circumstances. Regarding parallel is it =
> better to pick and choose what activities are performed in parallel? I =
> think we've basically defaulted it on after our performance improved in =
> the areas we were concerned about. What about V$PARAMETER error? Is =
> that significant? It keeps showing up in the alert log.=20
>
> We had two occassions last week when I had to reboot the server. The =
> first was recorded in the logs I provided. The second was when I =
> arrived in the morning Friday and couldn't log in. I couldn't find any =
> errors recorded anywhere. We installed 9.2.0.5 on Tuesday the 27th.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tanel P=F5der
> Sent: Tuesday, August 03, 2004 10:46 AM
> To: oracle-l_at_freelists.org
> Subject: Re: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on
> Windows 2000?
>
>
> It seems that, you are using parallel query and =
> cursor_sharing=3Dforce|similar
> here, it might be that the problem occurs when all of these features
> "collide". Do you need your query to run in parallel? (parallel option
> triggers lots of bugs, including data/query result corruption ones, in =
> my
> experience).
>
> Tanel.
>
> ----- Original Message -----=20
> From: "Freeman, Donald" <dofreeman_at_state.pa.us>
> To: "Oracle-L (E-mail)" <oracle-l_at_freelists.org>
> Sent: Tuesday, August 03, 2004 5:26 PM
> Subject: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows =
> 2000?
>
>
> > I am finally getting to practice some of the tracing functionality =
> that =3D
> > is discussed here and ran into something I haven't seen dicussed here. =
> =3D
> > We had a complaint about a query that performs inconsistently and I =
> =3D
> > enabled my session trigger on user logon to capture it. The server =
> =3D
> > failed at a point shown below. The first entry is the alert log =
> entry. =3D
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Aug 03 2004 - 10:36:51 CDT
 |
 |