Answer / kittu

Hi,

First query

select username, sid#, serial from v$session where
username='ur_username';

if rows are get selected, then kill the process, by issuing
following statement:

alter system kill session 'sid, serial#';

after that issue the following statement:

drop user username cascade;

Answer / raja

DROP USER 'USER_NAME' CASCADE;

Answer / vikram

Remove from masseger or else tell him logout fom massenger.

Answer / suman

DROP USER USERNAME CASCADE;

what is asm?

0 Answers   Oracle,

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

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

2 Answers  

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

What is dbcc? : sql server DBA

0 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

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?

1 Answers  

---