Responsiveness of Server at high CPU load - Database Discussions
This is a discussion on Responsiveness of Server at high CPU load - Database Discussions ; Rick Denoire wrote > >4. there is a significant design flaw in Oracle that allows it to be > >saturated by a single, errant query > > That worries me a lot. Why worry about smelly statements? If you, in ...
 |
| | LinkBack | Thread Tools | Display Modes |
|
#81
12-19-2003, 01:14 AM
| |||
| |||
 Re: Responsiveness of Server at high CPU load > >4. there is a significant design flaw in Oracle that allows it to be > >saturated by a single, errant query > > That worries me a lot. Why worry about smelly statements? If you, in ignorance or stupidity, perform a cartesian join on a VLT or something similar, Oracle will do what you ask. It will use all the resources at its disposal to do it. And if you do not have a cap on the resource limits that Oracle is to put to use, it will push the hardware to its limits. Calling that a design flaw is BS. -- Billy  |
|
#82
12-19-2003, 01:14 AM
| |||
| |||
| Re: Responsiveness of Server at high CPU load
Rick Denoire <100.17706@germanynet.de> wrote > >4. there is a significant design flaw in Oracle that allows it to be > >saturated by a single, errant query > > That worries me a lot. Why worry about smelly statements? If you, in ignorance or stupidity, perform a cartesian join on a VLT or something similar, Oracle will do what you ask. It will use all the resources at its disposal to do it. And if you do not have a cap on the resource limits that Oracle is to put to use, it will push the hardware to its limits. Calling that a design flaw is BS. -- Billy |
|
#83
12-19-2003, 11:29 AM
| |||
| |||
| Re: Responsiveness of Server at high CPU load
Why not use statspack do determine those queries (hopefully they use binds), and then tune 'em. On Thu, 18 Dec 2003 23:13:05 +0100, Rick Denoire <100.17706@germanynet.de> wrote: >People don't know which queries are running. They access the DB via a >Web GUI, which was programmed in PHP. It was developed by a >contractor, who came, worked, and disappeared. > >Bye >Rick Denoire > > > ........ We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email |
|
#84
12-19-2003, 11:29 AM
| |||
| |||
| Re: Responsiveness of Server at high CPU load
Why not use statspack do determine those queries (hopefully they use binds), and then tune 'em. On Thu, 18 Dec 2003 23:13:05 +0100, Rick Denoire <100.17706@germanynet.de> wrote: >People don't know which queries are running. They access the DB via a >Web GUI, which was programmed in PHP. It was developed by a >contractor, who came, worked, and disappeared. > >Bye >Rick Denoire > > > ........ We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email |
|
#85
12-19-2003, 11:29 AM
| |||
| |||
| Re: Responsiveness of Server at high CPU load
Why not use statspack do determine those queries (hopefully they use binds), and then tune 'em. On Thu, 18 Dec 2003 23:13:05 +0100, Rick Denoire <100.17706@germanynet.de> wrote: >People don't know which queries are running. They access the DB via a >Web GUI, which was programmed in PHP. It was developed by a >contractor, who came, worked, and disappeared. > >Bye >Rick Denoire > > > ........ We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email |
|
#86
12-19-2003, 11:31 AM
| |||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||
| Re: Responsiveness of Server at high CPU load
Join instead  On Thu, 18 Dec 2003 01:17:39 +0100, Rick Denoire <100.17706@germanynet.de> wrote: >Sybrand Bakker > > >>Preferred course of action: >>1 fix your statements >>2 fix your statements >>3 fix your statements >>4 stop symptom fighting >>if all fails ... >>look in to using resource plans > >Mr. Bakker, you might be so right. I will analyze the statement more >thoroughly. It has something like > >select these, those >from this, that >where this IN (select .... from
| |||||||||||||||||||||||||||||||
Linear Mode
