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


Please Help Members By Posting Answers For Below Questions

Which autogrowth database setting is good? : sql server DBA

774


how can you create a user-defined lock?

828


what is the diffrence between core dba and apps dba?

2326


What happens on checkpoint? : sql server DBA

796


How would you best determine why your MVIEW couldn't FAST REFRESH?

2066


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

796


what are the performance views in an oracle rac environment?

817


What is replication? : sql server DBA

861


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.

2319


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

1717


how can you communicate with operating system files from oracle?

797


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

833


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?

1767


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?

3188


how can a session indicate its interest in receiving alerts?

790