- any other use of the work is strictly prohibited. - It’s the person who believes in you when the world gives up on you.. - It’s the person who walks in when the world walks out.. - I am one of the lucky ones in the world. - What Are Some of the RAID Levels Available. - Setup and Maintenance of the Traditional File System. - Check Status of the Tuning Task. - Order IF Conditions Based on the Frequency of the Condition. - Reduce the Use of the MOD Function. - Internal Workings of the Oracle RAC System. - Some of the Major V$ View Categories. - Obtaining a List of the X$ Tables That Make Up the V$ Views. - 869 Oracle 10g Scripts of the x$ Tables Used to Create the V$ Views. - You continue to be one of the leaders of the Oracle pack!. - “Trinity” Ratini, Bob Reczek, Sheila Reiter, Alex Reyderman, Mark Riedel, Marie Robertson,Holly Robinson, Jamie Rocks, John Rowland, Sean Ryan, Johnny Sadkauskas, Gurdeep Saini, Alwyn “The Machine” Santos, Sabina Schoenke, Chad Scott, Burk Sherva, Jolene Shrake, Garrett Sienkiewicz, John Smiley, David Smith, Brian Sneed, Ed Stayman, Jack Stein, Jenny Tao, Kim Tate, Bob Taylor, Shashi Tewari, Chris Thoman, Graham Thornton, Jeff Tieri, Dave “Torch” Trch, Joe Trezzo, Joel Tuisl, Tom Usher, Dave Ventura, Jon Vincenzo, Barry Wiebe, Ted Williams, Nicole Wilson, Joel. - Adrienne (Sky’s the Limit) Trezzo, Sean Tucker, David Tuson, Vicky Tuttle, Razi Ud-Din, Paul Ungaretti, Lisa Vaas, Lupe Valtierre, Petri Varttinen, Jussi Vira, Jarmo Viteli, Matt Vranicar, Oleg Wasynczuk, Lori Wachtman, Bill Weaver, Jim Weber, Mike Weber, Huang Wei, Erich Wessner, Steve Wilkenson, Dennie Williams, Donna Williams, John Wilmott, Marcus Wilson, Jeremiah Wilton, Oprah Winfrey, Wayne Wittenberger, Ron Wohl, Randy Womack, Marcia Wood, Jacqueline Woods, Chris Wooldridge, Don Woznicki, David Wright, Lv Xueyong, Stan Yellott, Janet Yingling Young, Tony Ziemba, Mary Ann Zirelli, Edward Zhu, Chris Zorich, and Andreas Zwimpfer.. - “Oh the Internet, I have it on my laptop.” The Internet is estimated only in Petabytes (you can fit several in your Oracle database if you remove the duplication of data). - 696 Security of the PERFSTAT Account. - In a 2001 “Teenage Mutant Ninja Turtles,” the Gaminator video game had a “3 Googolhertz” processor.. - When I left Oracle in 1982 (after working there for about five and one half years), we had just finished Version 3 of the database. - I believe that a lot of the parser code in the current database may still be mine. - The first commercial version of the software is sold to. - Some of the views in Table 1-2 will display data only in the ASM instance. - Internal overhead allocations for metadata (such as for data structures for processes and sessions) are now included in the value of the SHARED_POOL_SIZE parameter. - Therefore any change in the value of SGA_TARGET affects only the sizes of the auto-tuned components.. - V$SGA_DYNAMIC_COMPONENTS Information about the dynamic components of the SGA. - The optimizer statistics collection has been improved with each version of the Oracle database.. - all Scheduler jobs in the database. - In Data Pump, all of the work is performed by the database. - UNKNOWN Unable to determine the SID of the holder.. - STATE The state of the current session’s wait event. - An Apache HTTP server is included with the database server so that you can start working with the OEM out of the box, thus requiring “zero startup time.” The Oracle Enterprise Manager repository, job, and event subsystems are now configured automatically, eliminating the need for manual setup.. - If you don’t use an index, you will read all of the blocks in the table.. - Prior to the introduction of skip-scan functionality, queries could only use the index if the leading column of the index was used in the WHERE clause. - The same holds true if the third column of the index is used in the WHERE clause:. - In the following example, a part of the index is used. - The ROWID is a pointer directly to the physical location of the individual row.. - Some of the most common problems will be discussed in the following sections.. - All of these functions will cause the value of the column to be altered. - By comparing the number of distinct keys to the number of rows in the table (as shown in the Num_Rows column of USER_INDEXES), you can determine the selectivity of the index.. - If the value of the Clustering_Factor column value is close to the number of leaf blocks in the index, the data is well ordered in the table. - Analyzing the index or the table will provide the binary height of the index. - Use the blevel column in the USER_INDEXES view to check the binary height of the indexes.. - Each bucket will contain information about the value of the column(s) and the number of rows.. - As is also shown in the figure, most of the width-balanced buckets contain only 3 rows. - Consequently, all of the buckets in the histogram contain the same number of rows. - Since all of the columns in the SQL statement are in the index, a fast full scan is available.. - The values of the indexed columns are stored in an index. - ROWIDs are not associated with the rows in the table because of the structure of the table.. - If a partition is truncated, added, split, dropped, etc., the global partitioned indexes will need to be rebuilt unless you specify the UPDATE GLOBAL INDEXES clause of the ALTER TABLE command when modifying the table.. - In the most recent releases of the Oracle Database, you have been given a whole new toolbox.. - Prior to the advent of the storage area network (SAN), a LUN was exactly the address (number) for the disk drive.. - What Are Some of the RAID Levels Available?. - We will discuss this further in the reducing fragmentation section of the chapter.. - In a traditional tablespace, three positions in the ROWID were used to identify the relative file number of the row. - Oracle Managed Files (OMF) was first introduced in version 9i of the database. - db_cache_size This value determines the size of the cache. - According to the Oracle Admin Guide for 10.2, you can use ASMLib to access block devices: “The purpose of ASMLib, which is an optional add-on to ASM, is to provide an alternative interface for the ASM-enabled kernel to discover and access block devices.” On most Unix systems character devices are shown as /dev/rdsk or /dev/raw/raw on Linux. - In the previous example, consider the event of a disk failure in failure group flgrp1, which will induce a rebalance—the contents (data extents) of the failed disk are reconstructed using the redundant copies of the extents from the partnered disk. - CSS is used to heartbeat the health of the ASM instances. - A database created under the constructs of ASM will be striped by default and mirrored as specified in the SAME methodology (i.e., the I/O load is evenly distributed and balanced across all disks within the diskgroup). - Data is entered into all three partitions of the table:. - We selected all records from all of the partitions in the preceding example. - Each partition value in the VALUES clause must be unique among all partitions of the table.. - You can specify any of the following as new physical attributes for the partition:. - the partitioning key is the leading edge of the index.. - Use extent sizes that are multiples of the database block size.. - Try to use the outer edge of the disk (the fastest part on many disk types) for the redo logs.. - When a transaction is rolled back, a snapshot of the data is applied. - If you have variable disk partitioning (and are able to “slice” the disk easily), then raw devices become a choice for write-intensive, sequentially accessed data and redo log files not included in backup procedures.. - What will be the initial size of the database?. - What will be the future size of the database and what is the rate of growth?. - When you are in the system planning stage, ensure that you find out all of the. - information related to the current and future use of the system. - The following query can be used to find the current settings of the key initialization parameters on your database (if SGA_TARGET is set to a non-zero value, then some of these parameters will be set to zero):. - DB_CACHE_SIZE is the first parameter to look at in the initialization parameter file because it’s the most crucial parameter in Oracle. - Oracle Enterprise Manager provides a graphical view of the data in V$DB_CACHE_ADVICE.. - The DB_BLOCK_SIZE is the size of the default data block size when the database is created. - Full table scans are limited to the maximum I/O of the box (usually 64K, but as high as 1M on many systems). - The data dictionary cache portion of the shared pool operates in a manner similar to the DB_CACHE_SIZE when caching information. - Using Stored Procedures for Optimal Use of the Shared SQL Area. - However, keep in mind the only time the SQL statement being executed can use a statement already in the shared SQL area is if the statements are identical (meaning they have the same content exactly—the same case, the same number of spaces, etc. - Measure hit ratios for the row cache (data dictionary cache) of the shared pool with the V$ROWCACHE view. - Explanations of each of the columns are listed in the next section.. - This may help diagnose a problem or show overuse of the shared pool.. - Use the following list to help interpret the contents of the V$LIBRARYCACHE view:. - Measure hit ratios for the library cache of the shared pool with the V$LIBRARYCACHE view. - Consider the following query for a more accurate picture of the shared pool. - I will cover each of the two separately.. - DB_CACHE_SIZE refers to the total size in bytes of the main buffer cache (or memory for data) in the SGA. - Oracle 10g Release 2 automatically does this right out of the box.. - The LGWR (log writer) also updates the SCN in the control files and datafiles with the SCN of the checkpoint.. - The following is a brief description of the columns in the x$ksppi &. - A partial output listing of the initialization parameters is shown here:. - Intel.) The following table does not include guidelines for Oracle Applications.. - Oracle recommends via Metalink Note 216205.1 (written by Oracle Applications Development) the SGA settings shown in Table 4-1. - If you do set the initialization parameter SGA_TARGET to allow Oracle to use Automatic Shared Memory Management (ASMM), you can query the view V$SGA_DYNAMIC_COMPONENTS to see where (i.e., buffer cache, shared pool, etc.) the memory is being allocated. - Measure hit ratios for the data dictionary row cache of the shared pool with the V$ROWCACHE view. - Thanks to Randy Swanson, who did the update for this chapter in the 9i version of the book.. - In addition to monitoring, there are spectacular screens that will show you where a problem is, down to the “latch wait” or “global cache cr transfer wait.” The tools for running the AWR Report (covered in detail in Chapter 14) are included, as are tools to change the init.ora or spfile.ora file
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt