Answer / diksha

select count(*) from v$session where username like ''

Answer / kishore

select count(*),username from v$session where group by username;

Answer / braj123

select count(*) from v$session where user_name="**";

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

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

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

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

0 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---