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
- 8597 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
how can you connect from 10g user to 11g user??
how does an oracle clusterware manage crs resources?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is dbcc? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What types of replication are supported in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
how can you schedule a job in database?
what are the performance views in an oracle rac environment?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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
