Answer Posted / 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;

how can you create a user-defined lock?

1001

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2014

---

how can you connect from 10g user to 11g user??

2094

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1092

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1021

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2446

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1962

---

What happens on checkpoint? : sql server DBA

1069

---

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

2175

---

How to start SQL Server in minimal configuration mode?

7928

---

when does an alert gets signaled?

1022

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2422

---

What is fill factor? : sql server DBA

1227

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1974

---

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

2043

---