Hi, Mungkin dengan query ini bisa membantu Anda ;
SELECT s.machine, ROUND (BITAND (s.ownerid, 65535)) parent_session_sid, ROUND (BITAND (s.ownerid, 16711680) / 65536) parent_session_instid, s.saddr, s.SID, s.serial#, s.audsid, s.paddr, s.user#, s.username, s.command, s.ownerid, s.taddr, s.lockwait, s.status, s.server, s.schema#, s.schemaname, s.osuser, s.process, s.terminal, UPPER (s.program) program, s.TYPE, s.sql_address, s.sql_hash_value, s.prev_sql_addr, s.prev_hash_value, s.module, s.module_hash, s.action, s.action_hash, s.client_info, s.fixed_table_sequence, s.row_wait_obj#, s.row_wait_file#, s.row_wait_block#, s.row_wait_row#, s.logon_time, s.last_call_et, s.pdml_enabled, s.failover_type, s.failover_method, s.failed_over, s.resource_consumer_group, s.pdml_status, s.pddl_status, s.pq_status, s.current_queue_duration, s.client_identifier, p.program "OSProgram", p.spid, p.pid FROM v$session s, v$process p WHERE ( (s.username IS NOT NULL) AND (NVL (s.osuser, 'x') <> 'SYSTEM') AND (s.TYPE <> 'BACKGROUND') ) AND (p.addr(+) = s.paddr) ORDER BY "PROGRAM", ownerid Regards, Defry --- On Mon, 3/23/09, Awaluddin Hamid <[email protected]> wrote: From: Awaluddin Hamid <[email protected]> Subject: Re: [indo-oracle] how to get computer name in Forms To: [email protected] Date: Monday, March 23, 2009, 3:54 AM cicilia maharani wrote: > > Hi.. > > tanya dounk.. ada yang punya pengalaman mencari computer name di forms > 6i... > > forms 6i saya running di oracle apps... > Sepertinya belum ada BUILTIN di forms yg berfungsi untuk mengambil lokal informasi (Misalnya IP, host, dsb). Untuk fungsi2 seperti ini, saya sih biasanya pake fungsi yg ada di database (Misalnya dengan SYS_CONTEXT) . Yg perlu diperhatikan adalah karena query thd fungsi tsb akan compile error jika di-eksekusi ketika build, maka harus dibuat agar compile terjadi ketika runtime (Biasanya dengan dynamic sql). > > > thanks > CMIIW, AH [Non-text portions of this message have been removed]
