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

[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