Database or simply DB is an organized and structured collection of information which can be to efficiently retrieved, updated and analyzed. A simple VB code, C, excel or notepad cannot manage large number of users and files. Also easy extraction, backup and restoration of data is not possible with this approach. To counter this limitation Oracle has come up with Oracle database or Oracle RDBMS.
It is the relational database management system. The main objective of this is to store, manage and retrieve information efficiently to deliver high performance. It is also termed as RDBMS or simply Oracle.
Oracle consists of various software mechanisms to achieve maximized data concurrency, high performance for maximum productivity for multi users in database environment.
Some of the key features of Oracle DBA are:
In Oracle, there are three basic categories of physical files used to store information. These are –
|Data files||Contains the data required to start the database engine|
|Control files||Storehouse of metadata of the database used by the Oracle engine|
|Redo log files||Used to store the changes made to the database|
|Parameter files||Remains in the machine on which Oracle database server executes|
Learn Oracle DBA in 14 hrs from experts
The database consists of logical and physical structures. Because these structures are separate, the management of physical storage of data does not affect the access to logical structures.
Above mentioned information is required to get the basic understanding of the database. We have tried to cover all important parameters and terms used in Oracle.
1.1 Operating Systems A 64-bit Linux version of Oracle will not install on a 32-bit Linux or Windows 64-bit system, for example. The Oracle release notes provide information about where to find the compatibility matrix and the system requirements for the server. The disk space requirements depend on the components installed, but the base product alone does require Read More
In layman words, a data backup is a copy of your data that you keep so as to restore your original data in case of events such as data loss. Needless to say that if you are running a business or even if it's just some data on your computer that you wouldn't want to Read More
3.1 Maintenance Tasks 3.2 Consistency Checks Consistency checks validate database blocks and look for corruption in the datafiles. Consistency checks look at the physical integrity of the data blocks and rows of objects. They can also validate the structures of objects, and that the tables and indexes still have the corresponding values. Oracle checks for block corruption Read More
Monitoring for performance issues and doing the regular maintenance against the database will keep the database tuned and running faster. 4.1 Better-Performing Systems Planning the initial database design, monitoring, and maintenance are the proactive steps to achieving better-performing systems. This applies to any database environment. Along with the proactive monitoring and tuning for performance, DBAs need to deal Read More
5.1 Options for High Availability Oracle has a Maximum Availability Architecture (MAA), which includes a combination of the options with Data Guard and RAC environments. With RAC, you can apply rolling patches to eliminate downtime for patching. Additional nodes can be added to the cluster to provide more resources, since the nodes can use the CPUs and Read More
Download Interview Questions asked by top MNCs in 2019?