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;

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2401

---

which background process invoke at the time of upgradation tell me???

2663

---

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

1923

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4387

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1989

---

How can you control the amount of free space in your index pages? : sql server DBA

1237

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1024

---

how can you find out if a table can be redefined?

964

---

How would you go about verifying the network name that the local_listener is currently using?

3161

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2188

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1872

---

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

2411

---

how can you create a user-defined lock?

962

---

What are statistics, under what circumstances they go out of date, how do you update them?

2195

---

How do you trace the traffic hitting a sql server? : sql server DBA

1467

---