RE: Implement Parallel Processing on DB Warehouse

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 11 Feb 2004 10:25:19 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860763A928B@ENHBGPRI11.PA.LCL>

"I was just kidding. Don't take me too seriously, please."=20

I know, this would be too tedious if didn't have a sense of humor<g>.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Wednesday, February 11, 2004 10:13 AM To: oracle-l_at_freelists.org
Subject: Re: Implement Parallel Processing on DB Warehouse

On 02/11/2004 09:55:25 AM, "Freeman, Donald" wrote:
> "Flushing is harmful"

>=20

> ?? In response, I am flushing the shared_pool on this test instance =20
> so
> =3D
> that I can get baseline timing info. I understand that if I do it as =20
> a
> =3D
> matter
> of course I am losing the benefit of having parsed, reusable code and
> =3D
> data already in memory.

Data will stay in memory, but parsed, reusable code and data dictionary =

entries will not. That is, generally speaking, why flushing is =20 considered harmful.

>=20
>=20

> "Hint is ignored because of incorrect syntax"

>=20

> That's what I get for using a bargain table book for reference. I =3D
> thought I would be able to tell when something wasn't appropriate for
> a =3D
> 9i database. I tried your suggestions and it worked although I didn't
> =3D
> get the results I wanted. Once I parallized that index I more than =3D
> quadrupled the time it took to perform that query from about .4
> seconds =3D
> to 1.7 seconds. It doesn't look like this is something I can throw =20
> at
> =3D
> the database but will have to implement on a case by case, query by =
=3D
> query basis. I was probably a little unrealistic to project '1 week'
> to =3D
> implement parallelism <g>. I've been working on this one little test =20
> =3D
> statement nearly that long.=3D20

Well, CBO became a smartass with release 9.2 and if it isn't choosing parallel path, there might be a good reason for it.

>=20
>=20

> "With how many zeroes do you spell "grateful"?"

>=20


> As many as you want!  $0000000000000000000000000000. With zeros you

> can =3D
> never have enough! I appreciate the time you took to answer my
> question =3D
> and, of course, would help you move furniture if called upon. It's
> not =3D
> likely that you would ever need Oracle advice from me. I rely on
> these =3D
> lists extensively for answers but try to do as much of my homework as
> I =3D
> can before I use up bandwidth asking for an easily obtained answer.
> I've =3D
> only been on this list for about a week but I believe I recognize =20
> some
> =3D
> of the names from the IOUG forum on Compuserve from about five years =20
> =3D
> ago.=3D20

I was just kidding. Don't take me too seriously, please.=20

---

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
-----------------------------------------------------------------

Received on Wed Feb 11 2004 - 09:25:19 CST