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
- 8603 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh
You can use v$session and v$locks to view this. If you want
to see which process is taking long time you can query
v$session_longops
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Where do you find the default index fill factor and how to change it? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How to start SQL Server in minimal configuration mode?
what are the types of connection load-balancing?
What authentication modes does sql server support? : sql server DBA
. 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?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different types of indexes available in sql server? : sql server DBA
who owns the operating system files created by the utl_file package?
What the different types of replication and why are they used? : sql server DBA
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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Explain materialized views and how they are used.
