Interested to Buy Any Domain ? << Click Here >> for more details...
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 3 Answers
- 6422 Views
- I also Faced
- E-Mail Answers
Answer Posted / braj123
select count(*) from v$session where user_name="**";
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what is grd?
how can you get actual data change values from previous transactions in oracle?
What is the default port no on which sql server listens? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How can you control the amount of free space in your index pages? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is a user-defined lock?
What is replication? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
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.
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is the use of recording information about current session?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
