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?



What SQL query from v$session can you run to show how many sessions are logged in as a particular u..

Answer / saraswathi muthuraman

SQL> select count(SID),USERNAME from v$session group by
USERNAME;

14
14 raghavan
2 P_21533
1 Saras

4 rows selected.

SQL>

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Oracle General Interview Questions

How to resolve name conflicts between variables and columns?

0 Answers  


how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,


What are the set operators union, union all, minus & intersect meant to do?

0 Answers  


What is the dynamic sql in oracle?

0 Answers  


What's dateware house and what's clustor with practicle example

0 Answers  


Describe the types of sub query?

0 Answers  


What is the purpose of tables, private synonyms and public synonyms in Oracle?

0 Answers   HCL,


IS it possible to built the oracle database without setting the kernal parameters?

0 Answers   EDS,


How do I limit the number of oracle database connections generated by weblogic server?

0 Answers  


Does oracle database need java?

0 Answers  


How to filter out duplications in the returning rows using oracle?

0 Answers  


Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)