What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
Answer Posted / kishore
select count(*),username from v$session where group by username;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
What are statistics, under what circumstances they go out of date, how do you update them?
what functionality does oracle provide to secure sensitive information?
How to start SQL Server in minimal configuration mode?
who owns the operating system files created by the utl_file package?
what is grd?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you initialize log miner?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Why does Oracle not permit the use of PCTUSED with indexes?
suppose you want to audit specific activities on sensitive data. How can you achieve that?