Read or Download Oracle Applications DBA Field Guide (18) PDF
Best databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can constantly come up over the ideal meanings of phrases, misunderstandings that may have a major impression at the good fortune of your database initiatives. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating team, sign up for dependency.
Additional info for Oracle Applications DBA Field Guide (18)
Without them you cannot open the data files to access the data within the database. • Data files: Contain the data of the database • Online redo log files: Allow for instance recovery of the database. If the database crashes and does not lose any data files, the instance can recover the database with the information in these files. There are other files which are not officially part of the database but are important to the successful running of the database. These are: • Parameter file: Used to define how the instance will be configured when it starts up • Password file: Allows users to connect remotely to the database and perform administrative tasks • Archive log files: Contain an ongoing history of the redo generated by the instance.
The territory is DENMARK, which sets the time format, date format, and numeric and monetary conventions. The character set of WE8MSWIN1252 instructs Oracle Net to convert character information to this character set. This is an environment variable in UNIX and a registry setting in Windows. You can query the actual NLS settings of your current session by: select * from nls_session_parameters; Refer to the Globalization Support Guide for valid languages, territories, character sets, and more information about language support.
The entries in the control file specify the physical files that the database comprises. When you add additional files to your database, the control file is automatically updated. The location of the control files is specified in an initialization parameter. To protect against failure of the database due to the loss of the control file, you should multiplex the control file on at least three different physical devices. By specifying multiple files through the initialization parameter you enable the Oracle database server to maintain multiple copies of the control file.