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
how can you implement fine-grained auditing?
What is the difference between clustered and non-clustered index? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what do you understand by fine-grained auditing?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is a user-defined lock?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is fill factor? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What purpose does the model database server? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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?