How can you find out how many users are currently logged into the database?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

How to uncatalog backup?

0 Answers  


You see a wait on lms process in statspack, what does that mean?

0 Answers  


You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

0 Answers  


You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

0 Answers  


What are the skills required for oracle dba?

0 Answers  






What is oracle log switch?

0 Answers  


How many control files should you have?

0 Answers  


Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

0 Answers  


What skills do you need to be an administrator?

0 Answers  


What is tkprof and how is it used?

0 Answers  


What is explain plan and how is it used?

0 Answers  


What is the difference between internal & external schema?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)