Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!sjc70.webusenet.com!news.usenetserver.com!sn-xit-02!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: is it possible to query an oracle database to find out how hard it's working? Date: Mon, 02 Feb 2004 16:08:35 -0800 Organization: ATS Message-ID: <1075766856.295809@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <9b12ed8d.0402021433.208be14c@posting.google.com> In-Reply-To: <9b12ed8d.0402021433.208be14c@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 26 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253505 Adam Monsen wrote: > The only measure (that I've heard) of how hard an Oracle database is > working is the current CPU load on the box. > > For instance, a DBA would tell me: "spiffy, the Oracle server has two > 0% idle CPUs! We need to kill some sessions or tune queries." > > I assume they're getting the information by running 'top' or 'sar' > from a shell on spiffy. > > Is there an SQL query or PL/SQL code block that could be run to > determine some measure of how busy a database server is? This would be > quite useful to predetermine if some expensive queries would be > possible before actually starting them. In addition to Brian's advice ... look at the DBMS_RESOURCE_MANAGER built-in package. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)