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 / 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

what are the differences of where and if in SAS?

2252


how can you record information about current session?

1101


suppose you want to audit specific activities on sensitive data. How can you achieve that?

1056


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

2164


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2686


What are the different ways you can create databases in sql server? : sql server DBA

1191


What are the steps you will take to improve performance of a poor performing query?

2897


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2216


How would you extract DDL of a table without using a GUI tool?

2533


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

1138


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

2344


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2520


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

1934


What the different components in replication and what is their use? : sql server DBA

1093


What are statistics, under what circumstances they go out of date, how do you update them?

2309