public username on logical standby database
From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Wed, 29 Feb 2012 10:32:00 -0500
Message-ID: <CADmQEr5zuO0s-ZV690zB9h1hdRBv6YjHK1u5E0uEM_Lf6PEGMQ_at_mail.gmail.com>
Hi Folks,
Greetings. When i query my logical standby database, i find username "public" in v$session. the schemaname is public, program is oracle_at_primaryboxname (TNS V1-V3) and status is inactive. Any ideas? I am on 11.2 SLES 6 both primary and logical standby. Is it part of the logical standby processes?
query: select * from v$session where username is not null and username <> 'SYS' thanks for your help.
Date: Wed, 29 Feb 2012 10:32:00 -0500
Message-ID: <CADmQEr5zuO0s-ZV690zB9h1hdRBv6YjHK1u5E0uEM_Lf6PEGMQ_at_mail.gmail.com>
Hi Folks,
Greetings. When i query my logical standby database, i find username "public" in v$session. the schemaname is public, program is oracle_at_primaryboxname (TNS V1-V3) and status is inactive. Any ideas? I am on 11.2 SLES 6 both primary and logical standby. Is it part of the logical standby processes?
query: select * from v$session where username is not null and username <> 'SYS' thanks for your help.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 29 2012 - 09:32:00 CST