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 ----- Original Message ----- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 03, 2004 11:20 AM Subject: RE: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000? > 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tanel P=F5der > Sent: Tuesday, August 03, 2004 10:46 AM > To: oracle-l@xxxxxxxxxxxxx > 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@xxxxxxxxxxx> > To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx> > 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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------