OCP 11g Chapter 1 exercises, ocp11g Chapter 1 exercises

OCP 11g Chapter 1 exercises, ocp11g Chapter 1 exercises

Exercise 1-1 study the DBMS in the environment

This is a written exercise with no specific solutions.

Determine the applications, application servers, and databases used in your environment. Then, focus on the database and try out the database scale and busyness. Consider the number of users, data volatility, and data volume.

Finally, consider how important they are to the Organization: How long is the downtime allowed for each application and database? How much data can be lost? Can I use financial digital quantitative analysis?

Using the research results, you can understand the importance of the DBA role.

 

Exercise 1-2 determine whether the database is a single instance or a part of a Distributed System

In this exercise, the reader runs a query to determine whether the database is an independent system or part of a larger distributed environment. you can use SQL Developer or SQL & Plus. if you still cannot use the Oracle database, but want to do this exercise again, you can go to Chapter 2 and go back to this exercise after completing the installation.

1. Connect to the database as a user SYSTEM

 

2. Check whether the instance is part of the RAC database.

SQL> select parallel from v $ instance; PARALLEL --------- NO if it is a single-instance database, NO is returned. 3. check whether the database is protected by the standby database to prevent data loss. UNPROTECTED indicates that the database is not protected. SQL> select protection_level from v $ database; PROTECTION_LEVEL ------------------------------------------------------------ UNPROTECTED if the database is not protected, UNPROTECTED 4 is returned. check whether a stream is configured in the database. If no row is configured, no SQL> select * from dba_streams_administrator; no rows selected. If no stream is configured, no rows are returned. exercise 1-3 understand the memory structure of the instance in this exercise, run the query to determine the current size of different memory structures that constitute the instance. you can use SQL Developer or SQL * Plus1. as the user SYSTEM to connect to the database. 2. displays the current, minimum, and maximum sizes of SGA components that can be dynamically set: SQL> SELECT COMPONENT, CURRENT_SIZE, MIN_SIZE, MAX_SIZE FROM V $ SGA_DYNAMIC_COMPONENTS; in this example, the actual instance does not contain a stream, therefore, the stream pool size is zero. since the instance was started, neither the large pool nor the Java pool has changed, but the size of the Shared Pool and database buffer cache has changed. only the default value of the database buffer cache is configured. This configuration is usually used in addition to the database with a large number of adjustments. 3. determine the amount of memory allocated to (and currently) the global area of the program. SQL> select name, value from v $ pgastat where name in ('maximum PGA allocated ', 'Total PGA allocated ');

NAME
--------------------------------------------------------------------------------
VALUE
----------
Total PGA allocated
69312512
Maximum PGA allocated
319397888