What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
Answer Posted / diksha
select count(*) from v$session where username like ''
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what do you understand by fine-grained auditing?
What the different topologies in which replication can be configured? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the steps you will take to improve performance of a poor performing query?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Query processing is slow(eg select query)how will u solve that
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is asm?
What is replication? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is dcl? : sql server DBA