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

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How would you determine what sessions are connected and what
resources they are waiting for?

Question Posted / santo

Answer Posted / santo

Query v$sesstat or v$waitstat views.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2612

What is a system database and what is a user database? : sql server DBA

1190

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.

2124

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2557

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2430

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2042

How can you control the amount of free space in your index pages? : sql server DBA

1297

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4412

How would you go about verifying the network name that the local_listener is currently using?

3194

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2319

what functionality does oracle provide to secure sensitive information?

969

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1001

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

1115

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2472

What purpose does the model database server? : sql server DBA

1150