Question

Go to your Virtual Machine and SQL Developer. Bring me the results of the following (make...

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.

Homework Answers

Answer #1

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.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Save your select statements as a script. Place the semicolon at the end of each SQL...
Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your select statements from 1 to 8 in your script and comment out each number. Include your name and student number as a comment at the top of your script. The name of the script has to be Assignment1_JohnSmith. Instead of JohnSmith use your First Name and Last Name. Upload your script trough Blackboard. Use SQL Developer to create the My...
GIVE ME QUERIES: d) List Order IDs and the associated Customer Full Names for orders that...
GIVE ME QUERIES: d) List Order IDs and the associated Customer Full Names for orders that are ordered from either 'VIRGINIA' or 'NEW YORK'. I want you to connect three tables with SQL JOINS and use WHERE clause to filter certain customers. (Hint: Customer Table and Order Table are connected by Customer ID and Customer Table and State Table can be connected by CUST_STATE and ST, use those conditions in your JOINs) e) Find me the Product Names from the...
REALITY CHECK: The Patient Merry-Go-Round The following is a letter that a frustrated patient with complex...
REALITY CHECK: The Patient Merry-Go-Round The following is a letter that a frustrated patient with complex medical issues wrote to her consulting physician. When I went to your office, it was with great hopes that someone was finally going to piece together all of the bizarre symptoms I have been experiencing over the last several months and get to the cause of my pain. I was quite frankly shocked by how I was treated as a patient—especially one experiencing a...
1.Establishing the virtual Management: As known, managing virtual staff requires a different method or approach than...
1.Establishing the virtual Management: As known, managing virtual staff requires a different method or approach than managing local staff. Due to that reason, Golden Scent has developed a strategic plan to successfully manage its virtual staff in the USA. Identify the suitable manager. to make sure our work will proceed as we planned, Golden Scent willrecruit a virtual manager with the essential skills and knowledge required to manage virtual employees. Find the skilled people to work with. Since not everyone...
Answer the following question for any pilgrimage of your choice 1) What is name of your...
Answer the following question for any pilgrimage of your choice 1) What is name of your pilgrimage site? 2) Where is located? 3) Can you make a pilgrimage at any time or does it need to be on a certain day to coincide with a celebration/ceremony/time of year? 4) Can you visit alone or must you be with a group? 5) Do you know anyone that has been to this place? 6) If so, asked them for five things you...
Hey i just read your comment and you just need to answer do you agree or...
Hey i just read your comment and you just need to answer do you agree or disagree with ir and explain My Teacher gave this answer and we need to response this answer You need to response this answer why you agree with it or why you disagree and explain You have Two Answer you need to response on your own word Reactions may include: feedback, agreements, disagreements, etc. with supporting facts, material, citations, etc. to support your reaction (or...
Question 1: Group by and Aggregates: Write SQL statements to answer the following questions using Assignment...
Question 1: Group by and Aggregates: Write SQL statements to answer the following questions using Assignment 4’s schema (Customer-Invoice-Line-Product-Vendor). Make sure that your SQL script runs without any errors. Submit your answers in a .SQL file. 1 (2 Points) - Find the count of distinctvendors thatsupplied products that are priced lowerthan 185? 2 (2 Points) - For each vendor, find their product that has the lowest product quantity. Your output should include vendor code, vendor name, product description and product...
Design a FSM for a Vending Machine In this task, you will design a FSM for...
Design a FSM for a Vending Machine In this task, you will design a FSM for a simple (albeit strange) vending machine of office supplies. The vending machine sells three possible items, each at a different cost: Item Cost Pencil 10 cents Eraser 20 cents Pen 30 cents The vending machines accepts nickels (worth 5 cents), dimes (worth 10 cents), and quarters (worth 25 cents). Physically, it is only possible to insert a single coin at a time. The vending...
5. Once the Veracious is clear of the Earth's gravity, NASA operating procedure calls for the...
5. Once the Veracious is clear of the Earth's gravity, NASA operating procedure calls for the firing of the quark fusion quantum accelerator to boost velocity to 90 percent of the speed of light. After that, no acceleration by either fusion reactor will operate except for of course corrections and the return trip to Earth. At the rate of 0.9c then, how many years will it take for you to reach your destination? (Ignore the month it takes to safely...
Complete the following activities and then post your responses in the Activity #5 discussion forum (link...
Complete the following activities and then post your responses in the Activity #5 discussion forum (link below). Consider a short multiple choice quiz with three items, and each item has four choices (only one of the choices is correct). Suppose that you are taking this quiz but you are completely and utterly unprepared for it. That means that you only option for the quiz is to guess the answers. Suppose you are thinking about the first item: what's the probability...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT