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@(protected) >
To: <oracle-l@(protected) >
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.
>
> 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@(protected)
> [mailto:oracle-l-bounce@(protected)]On Behalf Of Tanel P�der
> Sent: Tuesday, August 03, 2004 10:46 AM
> To: oracle-l@(protected)
> 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=force|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 -- --
> From: "Freeman, Donald " <dofreeman@(protected) >
> To: "Oracle-L (E-mail) " <oracle-l@(protected) >
> 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 =
> > is discussed here and ran into something I haven 't seen dicussed here. > =
> > We had a complaint about a query that performs inconsistently and I > =
> > enabled my session trigger on user logon to capture it. The server > =
> > failed at a point shown below. The first entry is the alert log > entry. =
>
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
