Database Administration

Question: Discuss about theDatabase Administration. Answer: Generation of a Real Life Scenario using Dedicated and Shared Server Figure 1: Dedicated and shared server system (Source: ORACLE - DBA Tips Corner, 2016) The database administrators are facing a problem regarding the increased number of connection and their databases. The most of the system are using the traditional method i.e. the dedicated server that processes the request of the client. Sometimes the server processes are called shadow process, the process consumes memory for each process, and thus more memory is required for more number of connections (ORACLE - DBA Tips Corner, 2016). If we think of system, with five clients that accesses the database and if a dedicated server is used the 4 dedicated servers are required for processing the request at a time and if each process takes 8 mb of memory then 32 mb of memory would be required for the scenario. However, if the user increases to 100 then 800 mb of memory would be required but using shared server the client can be handled using two shared server processes. When the user spend time in editing the data and less time in fetching sql query from the database an OLTP environment i s created. In this case, the dedicated servers sits idle consuming the memory of the server. Multiple thread servers can share the server process between the clients and increase the efficiency of the system (Bryla Loney, 2013). The multiple thread servers can also manage the situation where the client continuously connects and disconnects the database. Thus in most of the places like in office environment more number of shared servers are used along with a dedicated server that manages the shared servers. The shared servers can be increased with the increase in the demand and the extra servers are deleted when the demand decreases. List of all default path used in Oracle folder Install-path- It represents the installation directory for the directory server enterprise edition of the software. The software is installed in the below directory of the install-path. E.g. the directory server is installed in install-path/ds6/ (Jashnani et al., 2014). E.g: when the installation is made from a zip file the install-path is the current-directory/dsee7 and when the installation is made from a native package the default installation-path is /opt/SUNdsee7 Instance-path- It represents the full path for an instance of Directory Proxy Server or Directory Server. E.g: The instance path is nevertheless found on a local file system. On Solaris system, the /var directory is used. serverroot- It represents the parent directory of the Identity Synchronization for location of the windows installation (Reed Acar, 2013). E.g: It depends on the installation and the concept of the serverroot does not exists on the Directory Proxy Server or the Directory Server isw-hostname- It represents the Identity Synchronization for instance directory in windows Eg: It depends on the installer /path/to/cert8.db- It represents the file name and default path for the client certificate database for Identity synchronization in windows. E.g: current-working-dir/cert8.db serverroot/isw-hostname/logs/- It represents the default path of the Identity synchronization for the local log files in windows for the system manager, central logger and each connector (Jashnani et al., 2014). E.g: It depends on the installer serverroot/isw-hostname/logs/central/- It represents the default path of the Identity Synchronization for the central logs of windows. E.g: It depends on the installer Figure 2: Logical Storage structure in Oracle (Source: Created by author) The above diagram represents the logical storage structure used in Oracle and the sizes are represented in blocks for the each part. The database of the oracle stores data in blocks and one logical data block represents the specific number of bytes of the physical disk space (Greenwald, Stackowiak Stern, 2013). The data blocks are the smallest storage units that the Oracle database can allocate or use. The extent represents the set of logically contiguous data blocks that is allocated for the storage of the specific type of information (Bryla Loney, 2013). The segment represents the set of extents allocated for a specific object of the database, such as a table. E.g: the data of the employees are stored in the own data segment, whereas the index of the employees are stored in its own index segment. References Bryla, B., Loney, K. (2013).Oracle Database 12c The Complete Reference. McGraw-Hill Osborne Media. Greenwald, R., Stackowiak, R., Stern, J. (2013).Oracle essentials: Oracle database 12c. " O'Reilly Media, Inc.". Jashnani, P., Williams, D., Kamath, A., Khosla, R. (2014). Oracle Database Installation Guide, 12c Release 1 (12.1) for Oracle Solaris E50818-06. ORACLE - DBA Tips Corner. (2016). Idevelopment.info. Retrieved 16 November 2016, from https://www.idevelopment.info/data/Oracle/DBA_tips/Networking/NET_1.shtml Reed, E. E., Acar, T. I. (2013).U.S. Patent No. 8,468,330. Washington, DC: U.S. Patent and Trademark Office.