Interested to Buy Any Domain ? << Click Here >> for more details...
How would you determine what sessions are connected and what
resources they are waiting for?
- 2 Answers
- 8737 Views
- I also Faced
- E-Mail Answers
Answer Posted / santo
Query v$sesstat or v$waitstat views.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what do you understand by fine-grained auditing?
what functionality does oracle provide to secure sensitive information?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you communicate with operating system files from oracle?
What is dbcc? : sql server DBA
how can you find out if a table can be redefined?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you connect from 10g user to 11g user??
Explain materialized views and how they are used.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
