Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 2022319601B2 for ; Tue, 29 Oct 2013 19:05:48 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Tue, 29 Oct 2013 19:05:48 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E102726DC4; Tue, 29 Oct 2013 14:05:46 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@gmail.com; dkim-adsp=none (insecure policy) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id P8uInYUYxX5x; Tue, 29 Oct 2013 14:05:46 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6956262F1; Tue, 29 Oct 2013 14:05:05 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 29 Oct 2013 14:04:24 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7350625DDA for ; Tue, 29 Oct 2013 14:04:24 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FkKsTPwDDqYX for ; Tue, 29 Oct 2013 14:04:24 -0400 (EDT) Received: from mail-pd0-f172.google.com (mail-pd0-f172.google.com [209.85.192.172]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3912625DD3 for ; Tue, 29 Oct 2013 14:04:23 -0400 (EDT) Received: by mail-pd0-f172.google.com with SMTP id w10so195816pde.31 for ; Tue, 29 Oct 2013 11:04:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=p6B0iOKSSlTgW1FTeGkFNx5XPf35gx6Mf5FSARafDqs=; b=SH1AlXu0NsP1Mkx37biGUbAG0YblSSeUczwjhRfNYXg5JsV3o9wueTfoduiOgyVyo9 nWnGqEVfghlt5wxBhlyVRmSBoniCtqY8qLiilixT1BS4bPlPKTtmTeHz6fMnq6UIEPbX AH1oHydaSDt8+1BWyNrtjkk03igBsYaMMUgQPeCvxuBArhzQzzx1dWRVs1F2S/1jq2wh fNVTnlpWcaPrpANUbBAYMGMHInzjkLnD79k2SODq3wIvr3rpgwpkkfTr0k+62P5oGfmY TwbopIysQ0X2rVmHSFo/bfL1wmptRqJBE+elB5mENbCAmX8A2bpBfYYXLuWj8F1E4VV8 zoBA== X-Received: by 10.66.196.168 with SMTP id in8mr1762194pac.18.1383069863216; Tue, 29 Oct 2013 11:04:23 -0700 (PDT) MIME-Version: 1.0 Received: by 10.70.15.100 with HTTP; Tue, 29 Oct 2013 11:04:03 -0700 (PDT) In-Reply-To: References: <1382989718.62206.YahooMailNeo@web122102.mail.ne1.yahoo.com> From: Jared Still Date: Tue, 29 Oct 2013 11:04:03 -0700 Message-ID: Subject: Re: How to check number of Concurrent session from AWR To: Ls Cheng Cc: Sanjay Mishra , "oracle-l@freelists.org" Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 51175 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l On Tue, Oct 29, 2013 at 10:42 AM, Ls Cheng wrote: > is the stat "logons current" from v$sysstat what you are looking for? OP: "What is best way to check max number of concurrent session reported in a specific AWR snapshot. " Answer: you can't Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com -- http://www.freelists.org/webpage/oracle-l