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
Which autogrowth database setting is good? : sql server DBA
how can you create a user-defined lock?
what is the diffrence between core dba and apps dba?
What happens on checkpoint? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what are the performance views in an oracle rac environment?
What is replication? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
how can you communicate with operating system files from oracle?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can a session indicate its interest in receiving alerts?