Using Advisors to Optimize Database Performance About the SQL Advisors The SQL advisors examine a given SQL statement or a set of SQL statements and provide recommendations to improve efficiency. These advisors can make various types of recommendations, such as creating SQL profiles (a[r]
SEE ALSO: ■ "Overview of Disks, Disk Groups, and Failure Groups" on page A-3 ■ _Oracle Database Storage Administrator's Guide_ for more information about the FORCE option TRANG 2 Automat[r]
You can collect the statistics manually using the DBMS_STATS procedure from SQL*Plus or using EM Database Control. Manually Collecting Stats Using SQL*Plus Collecting manual statistics is useful for tables and indexes whose storage characteristics change frequently or that need to be a[r]
A number of software publishers have produced database management systems that conform (with varying degrees of accuracy) to the relational paradigm; Oracle is only one. IBM was perhaps the first company to commit major resources to it, but its product (which later developed into DB[r]
of primary keys and foreign keys. A primary key is the unique identifier of a row in a table, either one column or a concatenation of several columns (known as a composite key). Every table should have a primary key defined. This is a requirement of the relational paradigm. Note that the O[r]
■ Note Before you attempt to run a shell script, ensure that it’s executable. Use the chmod command to achieve this: chmod 750 <script> dba_setup Usually, you’ll set a common set of operating system variables and aliases in the same manner for every database server. When[r]
as the DBA “Upgrade” exam because you can upgrade to the latest Oracle Database 11 g OCP certification from the Oracle10 g OCP certification. In order to take this exam, Oracle Corporation must have already certified you as an Oracle
616 Chapter 11 N Understanding Network Architecture Use the Actions drop-down list to start or stop the listener as well as perform other actions such as tracing. Click the Edit button to configure the listener (see Figure 11.18). You use the tabs across the top of the listener admini[r]
To earn the OCA, you’ve taken two exams so far and possibly some instructorled or online courses. The next step, the OCP, requires one instructorled or online course plus exam 1Z0053: Oracle Database 11g Administration II. This book covers all the requirements for 1Z0053 and can be an invaluable sup[r]
Limit the users who have administrative privileges Grant administrative privileges to user accounts cautiously. Some powerful administrative privileges and roles to exercise caution with include the following: SYSDBA This gives the grantee the highest level of privileges with the O[r]
Grid Computing Critical to the concept of Grid computing is virtualization. This means that at all levels there is a layer of abstraction between what is requested and what is provided. In the Oracle Grid environment, end users ask for an application service and let the Grid work out wh[r]
redo log entries, the current log file is marked as ACTIVE, if it is still needed for instance recovery, or INACTIVE, if it is not needed for instance recovery; the next log file in the sequence is reused from the beginning of the file and is marked as CURRENT. Ideally, the information in a red[r]
Offers Hands-On Administrative Experience Although a number of books have been published in the last decade on the subject of Oracle data- base administration, there has been a surprising lack of the blending of the concepts of the Oracle database with the techniques needed t[r]
Using disk groups, you can define one or more groups of disks as a logical unit that Ora- cle views as a single unit of storage. This concept is similar in nature to the way that some operating systems, including various flavors of Unix, define volume groups. Oracle manages the storage de[r]
Several components are critical to this goal, and all of them are covered in depth after we introduce the Oracle Architecture, Oracle 11g upgrade issues, and tablespace planning in Part I. A welldesigned logical and physical database architecture will improve performance and ease administration by p[r]
Introduction his book is designed to be read from beginning to end by those new to PL/SQL. Part I covers PL/SQL fundamentals. Part II covers the backbone of the programming language, which consists of functions, procedures, packages, triggers, and large objects. Part III dives into some advanc[r]