Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

945


how can you create a user-defined lock?

971


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2067


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

2306


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

2239


how to restore files with rman?

2255


what is the role of dip user in our database?

2371


What are the commands used in dcl? : sql server DBA

1012


What are the different types of upgrades that can be performed in sql server? : sql server DBA

1165


What happens on checkpoint? : sql server DBA

1041


how can you process messages in order asynchronously?

940


how can you initialize log miner?

1091


what is the diffrence between core dba and apps dba?

2521


What are the different types of database compression introduced in sql server 2008? : sql server DBA

1051


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

943