RE: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000?
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Aug 2004 13:09:23 -0400
The tables are not partitioned but we are using RAID 10 striped and =
mirrored. Are parallel and partitioning 'locked' together? Is their no =
value to parallel unless the tables are partitioned? We are moving =
toward it but haven't done it yet.=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Michael McMullen
Sent: Tuesday, August 03, 2004 11:41 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
----- 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 =
=3D
> may not be necessary in all circumstances. Regarding parallel is it =
=3D
> better to pick and choose what activities are performed in parallel? =
I =3D
> think we've basically defaulted it on after our performance improved =
in =3D
> the areas we were concerned about. What about V$PARAMETER error? Is =
=3D
> that significant? It keeps showing up in the alert log.=3D20
>
> We had two occassions last week when I had to reboot the server. The =
=3D
> first was recorded in the logs I provided. The second was when I =3D
> arrived in the morning Friday and couldn't log in. I couldn't find any =
=3D
> 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=3DF5der
> 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 =3D
> cursor_sharing=3D3Dforce|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 =
=3D
> my
> experience).
>
> Tanel.
>
> ----- Original Message -----=3D20
> 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 =
=3D
> 2000?
>
>
> > I am finally getting to practice some of the tracing functionality =
=3D
> that =3D3D
> > is discussed here and ran into something I haven't seen dicussed =
here. =3D
> =3D3D
> > We had a complaint about a query that performs inconsistently and I =
=3D
> =3D3D
> > enabled my session trigger on user logon to capture it. The server =
=3D
> =3D3D
> > failed at a point shown below. The first entry is the alert log =3D
> entry. =3D3D
>
>
> ----------------------------------------------------------------
> 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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
