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
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
how can you connect from 10g user to 11g user??
What is the default fill factor value? : sql server DBA
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?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you get actual data change values from previous transactions in oracle?
how can you enable flashback feature?
What purpose does the model database server? : sql server DBA
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
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
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?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
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.