From oracle-l-bounce@freelists.org Fri Jul 29 13:37:55 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6TIbsEi031678 for ; Fri, 29 Jul 2005 13:37:54 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6TIbpIP031667 for ; Fri, 29 Jul 2005 13:37:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0DE501D9828; Fri, 29 Jul 2005 13:37:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30831-07; Fri, 29 Jul 2005 13:37:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B29C1D97DC; Fri, 29 Jul 2005 13:37:43 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5946C.882C62A0" Subject: RE: Newbie DBA question Date: Fri, 29 Jul 2005 11:37:11 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C4502361378@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Newbie DBA question thread-index: AcWUbAclZOrHCQxgQ1WGlopZqGU14AAAHZdA From: "Allen, Brandon" To: , "Oracle-L" X-archive-position: 23068 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5946C.882C62A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Bryan, =20 You can run statspack snapshots every hour, then run reports comparing = each hourly snapshot and it will show you the transactions/sec in the = top "Load" section. No init setting required for this, but you'll want = timed_statistics=3Dtrue in order to gather other useful stats. =20 Regards, Brandon -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of Bryan Wells Sent: Friday, July 29, 2005 11:32 AM To: Oracle-L Subject: Newbie DBA question All: =20 I need to find Peak transactions/queries per hour . is there an init = setting that needs to be modified before i can gather this information? --=20 Bryan S Wells=20 bunjibry@gmail.com=20 Privileged/Confidential Information may be contained in this message or = attachments hereto. Please advise immediately if you or your employer do = not consent to Internet email for messages of this kind. Opinions, = conclusions and other information in this message that do not relate to = the official business of this company shall be understood as neither = given nor endorsed by it. ------_=_NextPart_001_01C5946C.882C62A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Bryan,
 
You=20 can run statspack snapshots every hour, then run reports comparing = each=20 hourly snapshot and it will show you the transactions/sec in the top = "Load"=20 section.  No init setting required for this, but you'll want=20 timed_statistics=3Dtrue in order to gather other useful = stats.
 
Regards,
Brandon
-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of Bryan Wells
Sent: Friday, July 29, 2005 11:32=20 AM
To: Oracle-L
Subject: Newbie DBA=20 question

All:
 
I need to find Peak transactions/queries = per=20 hour .  is there an init setting that needs to be = modified before i can gather this information?

-- =
Bryan S=20 Wells
bunjibry@gmail.com =

Privileged/Confidential Information may be contained in this message = or attachments hereto. Please advise immediately if you or your employer = do not consent to Internet email for messages of this kind. Opinions, = conclusions and other information in this message that do not relate to = the official business of this company shall be understood as neither = given nor endorsed by it.

 ------_=_NextPart_001_01C5946C.882C62A0-- -- http://www.freelists.org/webpage/oracle-l