getting performance data

From: Nigel Campbell <nigelc_at_Cognos.COM>
Date: 18 Mar 1995 17:04:09 GMT
Message-ID: <3kf3q9$oh0_at_gatekeeper.cognos.com>

In SQL Server, I am able to obtain information such as cpu, session id etc via references to variables (_at__at_spid), virtual tables (sysproceses) etc. Is there any way to determine the cpu time for a statement as well as the o/s and oracle sid/pid without having to have access to V$ tables?

--
Nigel Campbell		  Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Desktop Division            FAX: (613) 738-0002             3755 Riverside Dr.
Cognos Incorporated	    MCI: nigel campbell || 3074729  Ottawa, Ontario
UUnet: nigelc_at_cognos.COM                                    CANADA  K1G 3Z4

Received on Sat Mar 18 1995 - 18:04:09 CET

This message: [ Message body ]
Next message: PS: "Re: Access - ODBC - Oracle Integrity?"
Previous message: Andy Lau: "drop table owned by PUBLIC"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message