The CPU cycles on...

[standardtom]

An SQL statement I started running three hours ago has only just now finished.

And it only inserted 85 frippin' rows.

I feel very cheated.

Comments

[cincycub.livejournal.com]

OMG, I'd say there's somethin wrong there...

[standardtom.livejournal.com]

It was pretty cobbled-together anyway. But I still didn't expect it to take THAT long.

It was comparing the results of a function-within-a-function to a large IN clause.

[cincycub.livejournal.com]

Oh wow. Maybe it's time to rewrite :)

[standardtom.livejournal.com]

Rewrite?

The horror!

;-)

[zoxobear.livejournal.com]

Oracle $ $ $

[standardtom.livejournal.com]

Description of Oracle's worldview:

"Come into my parlor, said the spider to the fly."

[zoxobear.livejournal.com]

Oracle + Toad = Pie

[standardtom.livejournal.com]

I <3 Toad!

I use it every day.

[mississippicub.livejournal.com]

thats screwed up

[standardtom.livejournal.com]

Yeah.

But then, I am t3h 1n3ff1c13nt c0d3r!

[quirkstreet.livejournal.com]

I feeeeel your pain.

[standardtom.livejournal.com]

God I love that user icon.

But I digress... :-)

[quirkstreet.livejournal.com]

Well, thank you.

And it even exists in a larger format somewhere ... [leer]

[standardtom.livejournal.com]

Well now.

If I ask real nice, could I see the large-format version? My LJ email address works just fine. :-D

[nfotxn.livejournal.com]

Uh, how much data are you dealing with?

[standardtom.livejournal.com]

It actually was sifting through a lot of data, and doing some pretty involved subqueries inside a PL/SQL function. And the more I look at it, I'm beginning to think that my query was contending with someone else's that was running at the same time.

[biguyfriend.livejournal.com]

I was going to ask you if you were on your own db or on one that was shared by everyone? Plus, how many tables were involved here? anyway, I feel your pain...I am beginning to hate ALL queries... Hugs buddy, ya know I love ya.

[standardtom.livejournal.com]

Hey :-)

It was most definitely a shared db... it was the main Oracle database that the whole university shares. So, it had occurred to me that I might have been contending with someone else.

Also, it wasn't but two or three tables. A lot of the actual activity was being generated most likely by the PL/SQL function, which was doing something with addresses that's pretty intensive.

Of course I know you love me. Ditto. :-D

[shawnsyms.livejournal.com]

I want to give you a birthday gift in the flesh some day soon.

xoxo