Oracle Dba Discussion Board

[KOTC]

em applications run avutunai o oracle db lo ela telusukovali?

[peru_edaite_enti]

[quote name='STFU' timestamp='1367345237' post='1303686644']
is there any way to find out how many user are connected?

active users kadhu just a list

active ki idi use cheyachu anukunta [color=#282828][font=helvetica, arial, sans-serif]SELECT MACHINE, PROGRAM, COUNT(*) FROM V$SESSION GROUP BY MACHINE, PROGRAM;[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]ani motham end of the day lo a database ki entha mandi connect ayaru ani teluskovtaniki netstat tho cheyacha,inka em ayina unnai listener log ante koncham dig cheyale ala kakunda[/font][/color]
[/quote]


Inactive vi kanapadava danto?\

nen aite, like select username, machine, program, osuser, process from v$session chesta..

[KOTC]

[quote name='CBZ' timestamp='1367346031' post='1303686745']
Inactive vi kanapadava danto?\

nen aite, like select username, machine, program, osuser, process from v$session chesta..
[/quote]


col ip_address format a16

select
username,
osuser,
terminal,
utl_inaddr.get_host_address(terminal) IP_ADDRESS
from
v$session
where
username is not [color=navy][b]null[/b][/color]
order by
username,
osuser;


https://forums.oracle.com/forums/thread.jspa?threadID=589498

[KOTC]

inactive kanpadav anukunta

[peru_edaite_enti]

[quote name='STFU' timestamp='1367346376' post='1303686797']



col ip_address format a16

select
username,
osuser,
terminal,
utl_inaddr.get_host_address(terminal) IP_ADDRESS
from
v$session
where
username is not [color=navy][b]null[/b][/color]
order by
username,
osuser;


https://forums.oracle.com/forums/thread.jspa?threadID=589498
[/quote]


Idi try chesa indaka, ip address func is not working

[peru_edaite_enti]

[quote name='STFU' timestamp='1367346554' post='1303686821']
inactive kanpadav anukunta
[/quote]

Status !='ACTIVE' ani kotti chudu em ostado chudam

[KOTC]

[quote name='CBZ' timestamp='1367346598' post='1303686831']
Idi try chesa indaka, ip address func is not working
[/quote]


same ip addres not working

e e applications link ayyai ani chusava idi use chesi

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]SELECT MACHINE, PROGRAM, COUNT(*) FROM V$SESSION GROUP BY MACHINE, PROGRAM;[/background][/size][/font][/color]

[peru_edaite_enti]

[quote name='STFU' timestamp='1367346706' post='1303686855']



same ip addres not working

e e applications link ayyai ani chusava idi use chesi

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]SELECT MACHINE, PROGRAM, COUNT(*) FROM V$SESSION GROUP BY MACHINE, PROGRAM;[/background][/size][/font][/color]
[/quote]

Chusa, cognos ani, works cheduler ani ochayi naku

[KOTC]

[quote name='CBZ' timestamp='1367346788' post='1303686874']
Chusa, cognos ani, works cheduler ani ochayi naku
[/quote]


example ippudu ma production database oka 20 applications run avutai

a list ela chudali any idea?

[peru_edaite_enti]

[quote name='STFU' timestamp='1367347015' post='1303686906']


example ippudu ma production database oka 20 applications run avutai

a list ela chudali any idea?
[/quote]


SET LINESIZE 100
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45

SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND';

select username, program from v$process;


ivi chudu.. emanna ostunnayo ledo

[KOTC]

[quote name='CBZ' timestamp='1367347933' post='1303687060']
SET LINESIZE 100
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45

SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND';

select username, program from v$process;


ivi chudu.. emanna ostunnayo ledo
[/quote]


v$process,v$session inka chala vati tho kanukovachu anukunta kani manaki correct sql dorkatam ledhu anthe

thanks though

[peru_edaite_enti]

[quote name='STFU' timestamp='1367348984' post='1303687187']
v$process,v$session inka chala vati tho kanukovachu anukunta kani manaki correct sql dorkatam ledhu anthe

thanks though
[/quote]

yep... nen eveninng maa SME gani folder lo etiki chepta ...

[KOTC]

[quote name='CBZ' timestamp='1367349078' post='1303687202']
yep... nen eveninng maa SME gani folder lo etiki chepta ...
[/quote]


vakey

[CheGuevara]

evaridaggara aina oracle certification related dumps or practice tests unnaya.....or ekkada doukutayo cheppandi...

[Gachibowli_Diwakar]

[img]http://www.desigifs.com/sites/default/files/king_bemmi_recordit2.gif?1290371037[/img]