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

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2072


how can you connect from 10g user to 11g user??

1942


What is the default fill factor value? : sql server DBA

863


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?

3213


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2448


how can you get actual data change values from previous transactions in oracle?

847


how can you enable flashback feature?

744


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

861


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

1739


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2225


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

857


What would you do with an "in-doubt" distributed transaction?

1683


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?

2612


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2228


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1955