What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?

Answer Posted / braj123

select count(*) from v$session where user_name="**";

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you implement fine-grained auditing?

856


What is the difference between clustered and non-clustered index? : sql server DBA

801


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1999


what do you understand by fine-grained auditing?

859


What are the commands you'd issue to show the explain plan for "select * from dual"?

2017


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3524


what is a user-defined lock?

791


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

772


What types of replication are supported in sql server? : sql server DBA

1017


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1748


What is fill factor? : sql server DBA

932


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

853


What purpose does the model database server? : sql server DBA

859


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2134


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2446