| Author |
Measure User Connections
|
|
| qa4ever 2005-09-27, 1:24 pm |
| 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
| |
| Jim Kennedy 2005-09-28, 3:25 am |
|
"qa4ever" <qa4ever@hotmail.co.uk> wrote in message
news:o4g_e.147196$dP1.504078@newsc.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
| |
| qa4ever 2005-09-28, 1:24 pm |
| 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- downwithspammersfami
ly@attbi.net> wrote in message
news:eqCdndYUv401aaT
eRVn-rg@comcast.com...
>
> "qa4ever" <qa4ever@hotmail.co.uk> wrote in message
> news:o4g_e.147196$dP1.504078@newsc.telia.net...
> default
>
> This is an Oracle newsgroup not a DB2 newsgroup. In Oracle you can have a
> logon trigger.
> (and a logoff trigger)
> Jim
>
>
| |
| qa4ever 2005-09-28, 8:26 pm |
| 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@hotmail.co.uk> wrote in message
news:uLA_e.34861$d5.190077@newsb.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- downwithspammersfami
ly@attbi.net> wrote in message
> news:eqCdndYUv401aaT
eRVn-rg@comcast.com...
a[color=darkred]
>
>
| |
| Matthias Hoys 2005-09-28, 8:26 pm |
|
"qa4ever" <qa4ever@hotmail.co.uk> wrote in message
news:3gB_e.34863$d5.189984@newsb.telia.net...
> 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
| |
| Jim Kennedy 2005-09-29, 3:25 am |
|
"qa4ever" <qa4ever@hotmail.co.uk> wrote in message
news:3gB_e.34863$d5.189984@newsb.telia.net...
> 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@hotmail.co.uk> wrote in message
> news:uLA_e.34861$d5.190077@newsb.telia.net...
> ;-)
that[color=darkred]
stored[color=darkred
]
message[color=darkre
d]
have[color=darkred]
> a
>
>
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
| |
|
| 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@hotmail.co.uk> wrote in message
news:o4g_e.147196$dP1.504078@newsc.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
>
>
|
|
|
|