Go to your Virtual Machine and SQL Developer. Bring me the results of the following (make sure you only bring me the results that I need, don't give me unnecessary attributes, you will lose points): NEED QUERIES AND EXPLAIN
a) How many active processes are there on your instance? (Hint: V$BGPROCESS)
b) How many DB writer processes you may have total? (Hint: V$BGPROCESS)
Question 3 Go to your Virtual Machine and use either SQL Developer, SQL Plus, or Terminal. Bring me the results of the following (make sure you only bring me the results that I need, don't give me unnecessary information, you will lose points):
a) Shutdown database instance. How many active processes are there on your instance? Did you use terminal or SQLPlus or SQL Developer?
b) Startup database instance in NOMOUNT. How many active processes are there on your instance? Did you use terminal or SQLPlus or SQL Developer?
c) Change database instance to MOUNT. How many active processes are there on your instance? Did you use terminal or SQLPlus or SQL Developer?
d) Change database instance to OPEN. How many active processes are there on your instance? Try both terminal and SQL Developer.
a) How many active processes are there on your instance? (Hint: V$BGPROCESS)
SQL>select count(distinct(NAME)) from V$BGPROCESS where 1=1;
Ans: 295
b) How many DB writer processes you may have total? (Hint: V$BGPROCESS)
Ans: 36
a) Shutdown database instance. How many active processes are there on your instance? Did you use terminal or SQLPlus or SQL Developer?
ANS: 0 Active processes . I used SQLPlus.
b) Startup database instance in NOMOUNT. How many active processes are there on your instance? Did you use terminal or SQLPlus or SQL Developer?
Ans:295 active processes are there and i used SQLPlus.
c) Change database instance to MOUNT. How many active processes are there on your instance? Did you use terminal or SQLPlus or SQL Developer?
d) Change database instance to OPEN. How many active processes are there on your instance? Try both terminal and SQL Developer.
Ans: 295 active processes are there and i used SQLPlus.
Get Answers For Free
Most questions answered within 1 hours.