Measure User Connections

#1

Hi

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?

Question relates to both Windows and Unix server.
Assume latest version of Oracle.

I want to avoid installing an extensive amounts of tools, just using default
setup tools

If you're familiar to DB2 I would the same kind of answer for it.

Thank you,
QA4Ever

#2

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote

Quote:

Hi

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?

Question relates to both Windows and Unix server.
Assume latest version of Oracle.

I want to avoid installing an extensive amounts of tools, just using
default
setup tools

If you're familiar to DB2 I would the same kind of answer for it.

Thank you,
QA4Ever

This is an Oracle newsgroup not a DB2 newsgroup. In Oracle you can have a
logon trigger.
(and a logoff trigger)
Jim

#3

Hi All/Jm

Yes I know this is an Oracle newsgroup, thank you for pointing that out ;-)

Could you or somebody else give me some more info on how to create that
trigger or if there is a simpler way of just call some SQL statement that
returns number of users, for example in MS SQL Server you "execute stored
procedure sp_who" and it will list all currently logged on users.

Thank you,
QA4Ever

Could you give
"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> wrote

Quote:

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote in message
news

4g_e.147196$dP1.504078 (AT) newsc (DOT) telia.net...
Hi

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?

Question relates to both Windows and Unix server.
Assume latest version of Oracle.

I want to avoid installing an extensive amounts of tools, just using
default
setup tools

If you're familiar to DB2 I would the same kind of answer for it.

Thank you,
QA4Ever

This is an Oracle newsgroup not a DB2 newsgroup. In Oracle you can have a
logon trigger.
(and a logoff trigger)
Jim

#4

Is there a free online knowledgebase that one can search if you get stuck on
the Oracle dialect of the SQL language?

Found the online search resource for DB2 and SQL Server but none for Oracle.

Thanks,
QA4Ever

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote

Quote:

Hi All/Jm

Yes I know this is an Oracle newsgroup, thank you for pointing that out
;-)

Could you or somebody else give me some more info on how to create that
trigger or if there is a simpler way of just call some SQL statement that
returns number of users, for example in MS SQL Server you "execute stored
procedure sp_who" and it will list all currently logged on users.

Thank you,
QA4Ever

Could you give
"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> wrote in message
news:eqCdndYUv401aaTeRVn-rg (AT) comcast (DOT) com...

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote in message
news

4g_e.147196$dP1.504078 (AT) newsc (DOT) telia.net...
Hi

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?

Question relates to both Windows and Unix server.
Assume latest version of Oracle.

I want to avoid installing an extensive amounts of tools, just using
default
setup tools

If you're familiar to DB2 I would the same kind of answer for it.

Thank you,
QA4Ever

This is an Oracle newsgroup not a DB2 newsgroup. In Oracle you can have
a
logon trigger.
(and a logoff trigger)
Jim

#5

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote

Quote:

Is there a free online knowledgebase that one can search if you get stuck
on
the Oracle dialect of the SQL language?

Found the online search resource for DB2 and SQL Server but none for
Oracle.

Thanks,
QA4Ever

http://tahiti.oracle.com
Free registration needed

HTH
Matthias

#6

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote

Quote:

Is there a free online knowledgebase that one can search if you get stuck
on
the Oracle dialect of the SQL language?

Found the online search resource for DB2 and SQL Server but none for
Oracle.

Thanks,
QA4Ever

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote in message
news:uLA_e.34861$d5.190077 (AT) newsb (DOT) telia.net...
Hi All/Jm

Yes I know this is an Oracle newsgroup, thank you for pointing that out
;-)

Could you or somebody else give me some more info on how to create that
trigger or if there is a simpler way of just call some SQL statement
that
returns number of users, for example in MS SQL Server you "execute
stored
procedure sp_who" and it will list all currently logged on users.

Thank you,
QA4Ever

Could you give
"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> wrote in
message
news:eqCdndYUv401aaTeRVn-rg (AT) comcast (DOT) com...

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote in message
news

4g_e.147196$dP1.504078 (AT) newsc (DOT) telia.net...
Hi

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?

Question relates to both Windows and Unix server.
Assume latest version of Oracle.

I want to avoid installing an extensive amounts of tools, just using
default
setup tools

If you're familiar to DB2 I would the same kind of answer for it.

Thank you,
QA4Ever

This is an Oracle newsgroup not a DB2 newsgroup. In Oracle you can
have
a
logon trigger.
(and a logoff trigger)
Jim

otn.oracle.com and free registration.
select * from v$session; will tell you what sessions are logged on.You can
look at the Oracle Reference Guide, the V$ tables. The SQL Reference book
and the create trigger command will tell you all about creating triggers.
Look at logon and log off triggers.

Jim

#7

Hi

you could set audit_trail=true, and you have a result in the table sys.Aud$
not a ascii file.

If you want the result in a external ascii file you shuld cosnider useing
external tables. trigger to external table=ascii file ?

regards

SEJ

"qa4ever" <qa4ever (AT) hotmail (DOT) co.uk> wrote

Quote:

Hi

How do I log (to ascii file) or monitor active concurrent database
connections to a database and server instance ?

Question relates to both Windows and Unix server.
Assume latest version of Oracle.

I want to avoid installing an extensive amounts of tools, just using
default
setup tools

If you're familiar to DB2 I would the same kind of answer for it.

Thank you,
QA4Ever

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Measure User Connections

comp.database.oracle comp.database.oracle

Measure User Connections - 09-27-2005 , 01:21 PM

Re: Measure User Connections - 09-27-2005 , 08:42 PM

Re: Measure User Connections - 09-28-2005 , 12:52 PM

Re: Measure User Connections - 09-28-2005 , 01:27 PM

Re: Measure User Connections - 09-28-2005 , 02:37 PM

Re: Measure User Connections - 09-28-2005 , 08:28 PM

Re: Measure User Connections - 12-08-2005 , 05:35 AM