Database administration notes by govt.pptx

This one is good

1. Database Administration topic Usage and Configuration of oracle share Server

2. Server CONFIGURATION Dedicated server process shared server Process

3. Oracle Server configuration Dedicated Server Process: A server process can be either a dedicated server process, where one server process services only one user process . Shared Server Process: A server process can be either a shared server process, where a server process can service multiple user process.

4. Dedicated server process

5. Oracle shared server process

6. Benefits of oracle shared servers reduces the number of processes against an instances Increases the number of users Achieve load balancing Reduces the number of idle server processes Reduces memory usage Reduce system overhead

7. connecting

8. Processing a request

9. The sga and pga

10. Configuring oracle shared Required parameters Dispatchers SHARED_SERVERS Opti onal parameters MAX_dispatchers Max_SHARED _ SERVERS Share_server_dispatchers

11. dispatchers

12. SHARED_SERVERS

13. MAX_dispatchers

14. Max_SHARED_SERVERS

15. Share_server_dispatchers