Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C01319FB28C for ; Tue, 26 Sep 2006 00:00:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 37638-08 for ; Tue, 26 Sep 2006 00:00:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 43F529FB232 for ; Tue, 26 Sep 2006 00:00:22 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id 30so533209ugc for ; Mon, 25 Sep 2006 20:00:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=tlFIeRLfPnnJbNnA6rEueYcD/3e/f/2Ghfuo6mURoxvJhybenarPtL11x2J0qO241ptmU18CGc43eZq+yYcKYDWuliX69DvV9alqFNxfhagW3+GLBYGajyeopHEhS9jhKsM0p1l1PIA+ya7/lTyGhaqdE5e38k/xQ7EdviLXq+E= Received: by 10.67.89.5 with SMTP id r5mr213813ugl; Mon, 25 Sep 2006 20:00:21 -0700 (PDT) Received: by 10.66.223.9 with HTTP; Mon, 25 Sep 2006 20:00:21 -0700 (PDT) Message-ID: Date: Tue, 26 Sep 2006 00:00:21 -0300 From: "Marcelo Costa" To: "GURON Rawender" Subject: Re: User session information catalog views Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_58113_30031315.1159239621620" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.575 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/283 X-Sequence-Number: 23197 ------=_Part_58113_30031315.1159239621620 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi do you can search in: http://www.postgresql.org/docs/8.1/interactive/catalogs.html Here you go learning how thats information are stored. [],s Marcelo. 2006/9/25, GURON Rawender : > > I am new to PostgreSQL and have long experience of administering Oracle > database. I am looking for user sessions information in a PostgreSQL. > Basically I am after dynamic performance views equivalent to Oracle's > v$session, v$process, v$session_wait etc. Can someone guide me in right > direction because I could not find any relevant information in the manual. > > Thanks > Rawender Guron > IMPORTANT NOTICE: This e-mail and any attachment to it are intended only > to be read or used by the named addressee. It is confidential and may > contain legally privileged information. No confidentiality or privilege is > waived or lost by any mistaken transmission to you. The RTA is not > responsible for any unauthorised alterations to this e-mail or attachment to > it. Views expressed in this message are those of the individual sender, and > are not necessarily the views of the RTA. If you receive this e-mail in > error, please immediately delete it from your system and notify the sender. > You must not disclose, copy or use any part of this e-mail if you are not > the intended recipient. > -- Marcelo Costa ------=_Part_58113_30031315.1159239621620 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi do you can search in:

http://www.postgresql.org/docs/8.1/interactive/catalogs.html

Here you go learning how thats information are stored.

[],s

Marcelo.

2006/9/25, GURON Rawender <Rawender_GURON@rta.nsw.gov.au>:
I am new to PostgreSQL and have long experience of administering Oracle database. I am looking for user sessions information in a PostgreSQL. Basically I am after dynamic performance views equivalent to Oracle's v$session, v$process, v$session_wait etc. Can someone guide me in right direction because I could not find any relevant information in the manual.
 
Thanks
Rawender Guron
IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Views expressed in this message are those of the individual sender, and are not necessarily the views of the RTA. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient.



--
Marcelo Costa ------=_Part_58113_30031315.1159239621620--