Sumário Itens Encontrados: 7111 Introduction to Oracle Database 12c R1 & R2 New Features (DBA and Developer)2 Basic Index Principles (Beginner Developer and Beginner DBA)3 Pluggable Databases, Disk Implementation Methodology, and ASM (DBA)4 Tuning the Database with Initialization Parameters (DBA)5 Tuning with Enterprise Manager Cloud Control (DBA and Developer)6 Using EXPLAIN, TRACE, and SQL Plan Management (Developer and DBA)7 Basic Hint Syntax (Developer and DBA)8 Query Tuning (Developer and Beginner DBA)9 Table Joins and Other Advanced Tuning (Advanced DBA and Developer)10 Using PL/SQL to Enhance Performance (Developer and DBA)11 Oracle Cloud, Exadata, Tuning RAC, and Using Parallel Features12 The V$ Views (Developer and DBA)13 The X$ Tables and Internals Topics (Advanced DBA)14 Using Statspack and the AWR Report to Tune Waits, Latches, and Mutexes15 Performing a Quick System Review (DBA)16 Monitor the System Using Unix Utilities (DBA)A Key Initialization Parameters (DBA)B The V$ Views (DBA and Developer)C The X$ Tables (DBA)IndexAcknowledgmentsIntroductionOracle Database 12cR1 (12.1.0.1)Increased Size Limit to 32K for VARCHAR2 and NVARCHAR2Partial IndexesInvisible ColumnsMultiple Indexes on the Same Column ListFetch First x RowsPluggable Databases (PDBs)Oracle Database Cloud Service (Database as a Service)PDB Level: MEMORY_LIMIT and MEMORY_MINIMUM (12cR2)Change Compression at Import TimeAdaptive Query OptimizationPGA_AGGREGATE_LIMITConcurrent Execution for UNION/UNION ALLInvoker Rights Function Can Be Results CachedNew DBMS_UTILITY.EXPAND_SQL_TEXTDefault for Columns Based on SequenceMultiple SSD Devices for Smart Flash CacheConcurrent Cost-Based Optimizer Statistics GatheringEnhanced System StatisticsResource Manager for Runaway QueriesAutomatic Data Optimization (ADO)Global Index Maintenance: Drop and Truncate Partition OperationsASM Disk ScrubbingOnline Capability ImprovementsData Guard ImprovementsRMAN ImprovementsOracle Database 12cR1 (12.1.0.2)In-Memory DatabaseAdvanced Index CompressionAutomatic Big Table CachingFDA Support for Container DatabasesFull Database CachingJSON SupportFIPS 140 Parameter for EncryptionPDB Subset CloningRapid Home ProvisioningâCreating âGold ImagesâOracle Database 12cR2 (12.2)Application DevelopmentEnhanced Features to Reduce Costs and Issues for Migration to OracleAvailabilityBig DataCompression and ArchivingOracle RAC and Grid InfrastructureSecurityNew Background Processes in 12cExadataâNew with Exadata X6!Version Comparison ChartNew Features ReviewReferencesBasic Index ConceptsInvisible IndexesMultiple Types of Indexes on the Same Column(s)Concatenated IndexesSuppressing IndexesUsing the NOT EQUALOperators: <>, !=Using IS NULLor IS NOT NULLUsing LIKEUsing FunctionsComparing Mismatched Data TypesSelectivityThe Clustering FactorThe Binary HeightAdditional Details Concerning BLEVELand Index HeightUsing HistogramsFast Full ScansSkip-ScansTypes of IndexesB-Tree IndexesBitmap IndexesHash IndexesIndex-Organized TablesReverse Key IndexesFunction-Based IndexesPartitioned IndexesNew 12cR2 Features for Partitioned IndexesBitmap Join IndexesFast Index RebuildingRebuilding Indexes OnlineTips ReviewPluggable Databases (New in Oracle 12c)CDB or PDB Created ObjectsCreating a PDB: Many Ways to Do ItGreat Pluggable Database CommandsALTER SYSTEM While in a PDB and Other Nice CommandsUsing In-Memory (IM) with Pluggable DatabasesOther 12cR2 Features with Pluggable DatabasesSubset Standby (New in Oracle 12cR2)Disk ArraysUse Disk Arrays to Improve Performance and AvailabilityHow Many Disks Do You Need?What Are Some of the RAID Levels Available?The Newer RAID 5Solid-State DisksASM Storage Management (Striping/Mirroring)Setup and Maintenance of the Traditional FilesystemWhat Is the Cost?Storing Data and Index Files in Separate LocationsAvoiding I/O Disk ContentionThe 12c Heat Map and Automatic Data Optimization (ADO)12c I/O Performance Tracking Views (Outliers)Oracle Bigfile TablespacesASM IntroductionCommunication Across IT RolesASM InstancesASM Initialization ParametersASM Installation in 12cSrvctl EnhancementsASM Rebalance EnhancementsASM Fast Mirror ResyncASM Filter DriverASM and PrivilegesASM and MultipathingBigfile and ASMAvoiding Disk Contention by Using PartitionsGetting More Information About PartitionsOther Types of PartitioningPartitioned Indexes (Local)Other Partitioning OptionsIndex PartitioningExporting PartitionsEliminating Fragmentation (Only If NeededâCareful!)Using the Correct Extent SizeAvoiding Chaining by Setting PCTFREE CorrectlyUsing Automatic Segment Space Management (ASSM)Increasing the Log File Size and LOG_CHECKPOINT_INTERVALfor SpeedDetermining If Redo Log File Size Is a ProblemDetermining the Size of Your Log Files and Checkpoint IntervalOther Helpful Redo Log CommandsStoring Multiple Control Files on Different Disks and ControllersOther Disk I/O Precautions and TipsIssues to Consider in the Planning StagesWhen Upgrading to Oracle Database 12cUsing SEC_CASE_SENSITIVE_LOGONCrucial Memory Initialization Parameters for PerformancePDB Level: MEMORY_LIMIT and MEMORY_MINIMUMIn-Memory Database (INMEMORY_SIZE)Changing the Initialization Parameters Without a RestartModifying an Initialization Parameter at the PDB LevelInsight into the Initialization Parameters from Oracle UtilitiesViewing the Initialization Parameters with Enterprise ManagerIncreasing Performance by Tuning the DB_CACHE_SIZEUsing V$DB_CACHE_ADVICE in Tuning DB_CACHE_SIZEMonitoring the V$SQLAREA View to Find Bad QueriesSetting DB_BLOCK_SIZE to Reflect the Size of Your Data ReadsSetting SGA_MAX_SIZE to 25 to 50 Percent of the Size Allocated to Main MemoryTuning the SHARED_POOL_SIZE for Optimal PerformanceUsing Stored Procedures for Optimal Use of the Shared SQLAreaSetting the SHARED_POOL_SIZE High Enough to Fully Use the DB_CACHE_SIZEKeeping the Data Dictionary Cache Objects CachedKeeping the Library Cache Reload Ratio at 0 and the Hit Ratio Above 95 PercentUsing Available Memory to Determine If the SHARED_POOL_SIZE Is Set CorrectlyUsing the X$KSMSP Table to Get a Detailed Look at the Shared PoolPoints to Remember About Cache SizeWaits Related to Initialization ParametersUsing Oracle Multiple Buffer PoolsPools Related to DB_CACHE_SIZE and Allocating Memory for DataModifying the LRU AlgorithmPools Related to SHARED_POOL_SIZE and Allocating Memory for StatementsTuning PGA_AGGREGATE_TARGET and PGA_AGGREGATE_LIMITModifying the Size of Your SGA to Avoid Paging and SwappingUnderstanding the Oracle OptimizerHow Optimization Looks at the DataCreating Enough DispatchersHave Enough Open Cursors (OPEN_CURSORS)Donât Let Your DDLStatements Fail (DDL_LOCK_TIMEOUT)Two Important Exadata Initialization Parameters (Exadata Only)Top 25 Initialization ParametersInitialization Parameters over the YearsFinding Undocumented Initialization ParametersUnderstanding the Typical ServerModeling a Typical ServerSizing the Oracle Applications DatabaseOracle Enterprise Manager Basics and Accessing OEM via Oracle CloudStarting with All Targets and Other GroupingsMonitoring and Tuning Using the OEM Performance MenuPerformance Tab: Top ActivityPerformance Tab: SQL| SQLPerformance AnalyzerPerformance Tab: Real-Time ADDMPerformance Tab: SQL| Access AdvisorPerformance Tab: Manage Optimizer StatisticsPerformance Tab: AWR | AWR AdministrationPerformance Tab: ASH AnalyticsMonitoring and Tuning Using the OEM Administration MenuDatabase Administration Tab: Storage|TablespacesDatabase Administration Tab: In-Memory Central and Initialization ParametersDatabase Administration Tab: All Initialization ParametersDatabase Administration Tab: Resource Manager (Consumer Groups)Monitoring and Tuning Using the OEM Database or Cluster Database MenuDatabase Tab: Job ActivityCluster Database Tab: Configuration|Database TopologyMonitoring the HostsMonitoring the Application Servers and Web ApplicationsReal Application Testing (Database Replay)SummaryThe Oracle SQLTRACE UtilitySimple Steps for SQLTRACE with a Simple QueryThe Sections of a TRACE OutputDigging into the TKPROF OutputUsing DBMS_MONITORSetting Trace Based on Session ID and Serial NumberSetting Trace Based on Client IdentifierSetting Trace for the Service Name/Module Name/Action NameEnabled Tracing ViewsTRCSESS Multiple Trace Files into One FileUsing EXPLAIN PLAN AloneAn Additional EXPLAIN Example for a Simple QueryEXPLAIN PLANâRead It Top to Bottom or Bottom to Top?Tracing/Explaining Problem Queries in Developer ProductsImportant Columns in the PLAN_TABLE TableUsing DBMS_XPLANInitialization Parameters for Undocumented TRACEUsing Stored OutlinesDropping Stored OutlinesUsing SQLPlan Management (SPM) and SPM ExampleSPM TermsUsing SPMUsing Fixed SQLPlan BaselinesDropping a PlanConverting from Stored Outlines to SQLPlan ManagementAdaptive Plans (12c New Feature) and SPMTop Hints UsedUse Hints SparinglyFix the Design FirstAvailable Hints and GroupingsExecution PathAccess MethodsQuery Transformation HintsJoin OperationsParallel ExecutionOther HintsSpecifying a HintSpecifying Multiple HintsWhen Using an Alias, Hint the Alias, Not the TableThe HintsThe Oracle Demo Sample HR SchemaThe FIRST_ROWS HintThe ALL_ROWS HintThe FULLHintThe INDEX HintThe NO_INDEX HintThe INDEX_JOIN HintThe INDEX_COMBINE HintThe INDEX_ASC HintThe INDEX_DESC HintThe INDEX_FFS HintThe ORDERED HintThe LEADING HintThe NO_EXPAND HintThe DRIVING_SITE HintThe USE_MERGE HintThe USE_NLHintThe USE_HASH HintThe QB_NAME HintThe PUSH_SUBQ HintThe PARALLELHintThe NO_PARALLELHintThe PARALLEL_INDEX HintThe APPEND HintThe NOAPPEND HintThe CACHE HintThe NOCACHE HintThe RESULT_CACHE HintThe CURSOR_SHARING_EXACT HintThe INMEMORY and NO_INMEMORY and Other IM HintsThe USE_INVISIBLE_INDEXES HintThe CONTAINERS HintThe WITH_PLSQLHintSome Miscellaneous Hints and NotesUndocumented HintsUsing Hints with ViewsNotes on Hints and Stored Outlines (or SQLPlan Baselines)Why Isnât My Hint Working?Hints at a GlanceWhich Queries Do I Tune? Querying V$SQLAREA and V$SQLViewsSelecting from the V$SQLAREA View to Find the Worst QueriesSelecting from the V$SQLView to Find the Worst QueriesOracle 12c Views for Locating Resource-Intensive Sessions and QueriesSelecting from V$SESSMETRIC to Find Current Resource-Intensive SessionsViewing Available AWR SnapshotsSelecting from the DBA_HIST_SQLSTAT View to Find the Worst QueriesWhen Should I Use an Index?Selecting Query Text from the DBA_HIST_SQLTEXT ViewSelecting Query EXPLAIN PLAN from the DBA_HIST_SQL_PLAN ViewWhat If I Forget the Index?Creating an IndexInvisible IndexChecking the Index on a TableIs the Column Properly Indexed?What If I Create a Bad Index?Exercising Caution When Dropping an IndexIndexing the Columns Used in the SELECT and WHEREUsing the Fast Full ScanMaking the Query âMagicallyâ FasterCaching a Table in MemoryUsing the Result CacheChoosing Among Multiple Indexes (Use the Most Selective)The Index MergeIndexes That Can Get SuppressedVirtual ColumnsThe âCuriousâ ORUsing the EXISTS Function and the Nested SubqueryThat Table Is Actually a View!SQLand Grand Unified TheoryTuning Changes in Oracle Database 12cOracle 12c Adaptive Query OptimizationAdaptive StatisticsOracle 12c Changes in Statistics Gathering and Two New HistogramsOracle 12c Changes in SQLPlan ManagementOracle Automatic SQLTuningEnsuring the Tuning User Has Access to the APIsCreating the Tuning TaskMaking Sure the Task Can Be Seen in the Advisor LogExecuting the SQLTuning TaskChecking Status of the Tuning TaskDisplaying the SQLTuning Advisor ReportReviewing the Report OutputTuning SQLStatements Automatically Using SQLTuning AdvisorEnabling Automatic SQLTuning AdvisorConfiguring Automatic SQLTuning AdvisorViewing Automatic SQLTuning ResultsUsing SQLPerformance Analyzer (SPA)Database Replay (capture/replay)Set Up Source Database for Database Replay CapturePrepare to Capture WorkloadCapture the WorkloadPrepare the Workload for ReplayProcess the Workload for ReplayPrepare to Replay the WorkloadExecute the Workload ReplaySQLPerformance AnalyzerCreate a SQLTuning SetCreate an Analysis TaskExecute Analysis TaskQuery SQLPerformance Analyzer Advisor TasksCancel an Executing SQLPerformance Analyzer Analysis TaskRemove SQLPerformance Analyzer Analysis TaskDetermine Active SQLTuning SetsRemove SQLTuning SetDrop SQLTuning SetJoin MethodsNESTED LOOPS JoinsSORT-MERGE JoinsCLUSTER JoinsHASH JoinsINDEX-MERGE JoinsTable Join Initialization ParametersSORT-MERGE and HASH Join ParametersA Two-Table Join: Equal-Sized Tables (Cost-Based)A Two-Table INDEXED Join: Equal-Sized Tables (Cost-Based)Forcing a Specific Join MethodEliminating Join Records (Candidate Rows) in Multitable JoinsA Two-Table Join Between a Large and Small TableThree-Table Joins: Not as Much FunBitmap Join IndexBest Uses for the Bitmap Join IndexThird-Party Product TuningExample 1Example 2Example 3Tuning Distributed QueriesWhen You Have Everything TunedMiscellaneous Tuning SnippetsExternal TablesSnapshot Too Old: Developer Coding IssueSet Event to Dump Every Wait14 Hours to 30 Seconds with the EXISTS OperatorTuning at the Block Level (Advanced)Key Sections of a Block DumpA Brief Look at an Index Block DumpTuning Using Simple Mathematical TechniquesTraditional Mathematical AnalysisSeven-Step MethodologyDeriving Performance EquationsPattern InterpretationMathematical Techniques ConclusionsLeverage the PL/SQLFunction Result Cache to Improve Performance (Improved in 12c)Define PL/SQLSubprograms in a SQLStatement (New in 12c)Reference Sequences Directly in PL/SQLExpressionsIdentity Columns (New in 12c)Max Size Increase to 32K for VARCHAR2, NVARCHAR2, and RAW Data Types (New in 12c)Allow Binding PL/SQL-Only Data Types to SQLStatements (New in 12c)Use Named Parameters in SQLFunction CallsSimplify Loops with the CONTINUE StatementLeverage Compile-Time Warnings to Catch Programming Mistakes (Improved in 12c)Increase Performance with Native CompilationMaximize Performance with the Optimizing CompilerUse DBMS_APPLICATION_INFO for Real-Time MonitoringLog Timing Information in a Database TableReduce PL/SQLProgram Unit Iterations and Iteration TimeUse ROWID for Iterative ProcessingStandardize on Data Types, IF Statement Order, and PLS_INTEGEREnsure the Same Data Types in Comparison OperationsOrder IF Conditions Based on the Frequency of the ConditionUse the PLS_INTEGER PL/SQLData Type for Integer OperationsReduce the Calls to SYSDATEReduce the Use of the MOD FunctionImprove Shared Pool Use by Pinning PL/SQLObjectsPinning (Caching) PL/SQLObject Statements into MemoryPinning All PackagesIdentify PL/SQLObjects That Need to Be PinnedUse and Modify DBMS_SHARED_POOL.SIZESFind Large ObjectsGet Detailed Object Information from DBA_OBJECT_SIZEGet Contiguous Space Currently in the Shared PoolFind Invalid ObjectsFind Disabled TriggersUse PL/SQLAssociative Arrays for Fast Reference Table LookupsFind and Tune the SQLWhen Objects Are UsedConsider Time Component When Working with DATE Data TypesUse PL/SQLto Tune PL/SQLUnderstand the Implications of PL/SQLObject LocationUse Rollback Segments to Open Large CursorsActive Transaction Management: Process Large Quantities of DataUse Temporary Database Tables for Increased PerformanceLimit the Use of Dynamic SQLUse Pipelined Table Functions to Build Complex Result SetsLeave Those Debugging Commands Alone!The âLook and Feelâ: Just for the BeginnersPL/SQLExampleCreate a Procedure ExampleExecute the Procedure from PL/SQLExampleCreate a Function ExampleExecute the GET_CUST_NAME Function from SQLExampleCreate a Package ExampleDatabase Trigger Example Using PL/SQLThe March to the Cloud (Past and Present)The Oracle CloudExadata Database MachineExadata Terminology and the BasicsExadata StatisticsExadata Storage Expansion Rack BrieflySmart ScansFlash CacheStorage IndexesHybrid Columnar CompressionI/O Resource ManagementUse All Oracle Security Advantages with ExadataBest PracticesSummary: Exadata = Paradigm Shift!Oracle Database Appliance (ODA)SuperCluster Using the M7 SPARC ChipOther Oracle Hardware to ConsiderOracle Big Data Appliance X6-2ZFS Storage ServersStorageTek Modular Library SystemParallel DatabasesReal Application Clusters (RAC)Oracle RAC ArchitectureInternal Workings of the Oracle RAC SystemRAC Performance Tuning OverviewRAC Cluster Interconnect PerformanceFinding RAC Wait EventsâSessions WaitingRAC Wait Events and Interconnect StatisticsCluster Interconnect TuningâHardware TierBasic Concepts of Parallel OperationsParallel DMLand DDLStatements and OperationsManaging Parallel Server Resources and Parallel Statement QueuingParallelism and PartitionsInter- and Intra-operation ParallelizationExamples of Using Inter- and Intra-operations (PARALLELand NO_PARALLELHints)Creating Table and Index Examples Using Parallel OperationsMonitoring Parallel Operations via the V$ ViewsUsing EXPLAIN PLAN and AUTOTRACE on Parallel OperationsUsing the SET AUTOTRACE ON/OFF CommandTuning Parallel Execution and the Initialization ParametersParallel LoadingOptimizing Parallel Operations in RACObjectives of Parallel OperationsRAC Parallel Usage ModelsParallel Initialization ParametersV$ Views for Viewing Parallel StatisticsCreate Table AsParallel Index BuildsPerformance Considerations and SummaryOther Parallel NotesOracle Documentation Is OnlineCreating and Granting Access to V$ ViewsObtaining a Count and Listing of All V$ ViewsGetting a Listing for the X$ Scripts That Make Up the V$ ViewsExamining the Underlying Objects That Make Up the DBA_ ViewsUsing Helpful V$ ScriptsBasic Database InformationBasic Automatic Workload Repository (AWR) InformationBasic Licensing InformationDatabase Options Installed in Your DatabaseSummary of Memory Allocated (V$SGA)Querying V$IM_SEGMENTS After Setting the INMEMORY_SIZEAutomatic Memory Management and MEMORY_TARGETDetailed Memory Allocated (V$SGASTAT)Detailed Memory Allocated (V$SGASTAT) for a PDB vs. Root CDBFinding spfile.ora/init.ora Settings in V$PARAMETERModifying an Initialization Parameter at PDB LevelDetermining If Data Is in Memory (V$SYSSTAT & V$SYSMETRIC)Determining Memory for the Data Dictionary (V$ROWCACHE)Determining Memory for the Shared SQLand PL/SQL(V$LIBRARYCACHE)Querying V$CONTAINERS and V$PDBS for Container InformationQuerying V$CONTAINERS When Using Pluggable DatabasesQuerying V$PDBS for Pluggable Database InformationIdentifying PL/SQLObjects That Need to Be Kept (Pinned)Finding Problem Queries by Monitoring V$SESSION_LONGOPSFinding Problem Queries by Querying V$SQLAREAFinding Out What Users Are Doing and Which Resources They Are UsingFinding Out Which Objects a User Is AccessingGetting Detailed User InformationUsing IndexesIdentifying Locking IssuesKilling the Problem SessionFinding Users with Multiple SessionsQuerying for Current ProfilesFinding Disk I/O IssuesChecking for Privileges and RolesWait Events V$ ViewsSome of the Major V$ View CategoriesIntroducing the X$ TablesMisconceptions About the X$ TablesGranting Access to View the X$ TablesCreating V$ Views and X$ Tables in 12cThe X$ Tables Comprising the V$ ViewsObtaining a List of All the X$ Tables in 12cObtaining a List of All the X$ Indexes in 12cUsing Hints with X$ Tables and IndexesMonitoring Space Allocations in the Shared PoolCreating Queries to Monitor the Shared PoolORA-04031 ErrorsLarge Allocations Causing ContentionShared Pool FragmentationLow Free Memory in Shared and Java PoolsLibrary Cache Memory UseHigh Number of Hard ParsesMutex/Latch Waits and/or SleepsMiscellaneous X$ Table NotesObtaining Information About Redo Log FilesSetting Initialization ParametersCase 1Case 2Case 3Case 4Case 5Exploring Buffer Cache/Data Block DetailsBuffer StatusesSegments Occupying Block BuffersHot Data Blocks and the Causes of Latch Contention and Wait EventsObtaining Database- and Instance-Specific InformationEffective X$ Table Use and StrategyOracle Internals TopicsTracesDBMS_TRACE PackageEventsDumpsORADEBUGtrcsess UtilityReading the Trace FileWait Information and Response TimeRecursive CallsModule InfoCommitUnmapBind VariablesErrorsSome Common X$ Table GroupsSome Common X$ Table and Non-V$ Fixed View AssociationsCommon X$ Table JoinsX$ Table Naming Conventions (My Favorite Section of This Book!)X$ Table Naming Conventions with CON_ID, and INMEMORYFuture Version Impact in 12cR2Whatâs New in 12cR2 (12.2) Statspack and the AWR ReportInstalling StatspackSecurity of the PERFSTAT AccountPost-InstallationGathering StatisticsRunning the Statistics ReportThe Automatic Workload Repository (AWR) and the AWR ReportManually Managing the AWRAWR Automated SnapshotsAWR Snapshot ReportsRun the AWR Report in Oracle Enterprise Manager Cloud ControlInterpreting the Statspack and AWR Report OutputThe Header Information and Cache SizesThe Load ProfileInstance EfficiencyShared Pool StatisticsTop Wait EventsOracle BugsThe Life of an Oracle Shadow ProcessTop SQLStatementsInstance Activity StatisticsTablespace and File I/O StatisticsSegment StatisticsAdditional Memory StatisticsUNDO StatisticsLatch and Mutex StatisticsTuning and Viewing at the Block Level (Advanced)Dictionary and Library Cache StatisticsSGA Memory StatisticsNondefault Initialization ParametersTop 15 Things to Look for in AWR Report and Statspack OutputManaging the Statspack DataUpgrading StatspackDeinstalling StatspackQuick Notes on the New ADDM ReportScripts in 12cR2Total Performance Index (TPI)Education Performance Index (EPI)System Performance Index (SPI)Memory Performance Index (MPI)Top 25 âMemory Abuserâ Statements TunedTop 10 âMemory Abusersâ as a Percent of All StatementsBuffer Cache Hit RatioDictionary Cache Hit RatioLibrary Cache Hit RatioPGA Memory Sort RatioPercentage of Data Buffers Still FreeUsing the Result Cache EffectivelyPinning/Caching ObjectsDisk Performance Index (DPI)Top 25 âDisk-Read Abuserâ Statements TunedTop 10 Disk-Read Abusers as Percentage of All StatementsTables/Indexes Separated or Using ASMMission-Critical Table ManagementKey Oracle Files SeparatedAutomatic Undo ManagementUsing Pluggable Databases EffectivelyOverall System Review ExampleRating SystemExample System Review Rating CategoriesItems Requiring Immediate ActionOther Items Requiring ActionSystem Information ListMemory-Related ValuesDisk-Related ValuesCPU-Related ValuesBackup- and Recovery-Related InformationNaming Conventions and/or Standards and Security Information QuestionsDBA Knowledge RatingOther Items to Consider in Your TPI and System ReviewUnix/Linux UtilitiesUsing the sar Command to Monitor CPU Usagesar âu (Check for CPU Bogged Down)The sar âd Command (Find I/O Problems)The sar âb Command (Check the Buffer Cache)The sar âq Command (Check the Run Queue and Swap Queue Lengths)Using the sar and vmstat Commands to Monitor Paging/SwappingUsing sar âp to Report Paging ActivitiesUsing sar âw to Report Swapping and Switching ActivitiesUsing sar âr to Report Free Memory and Free SwapUsing sar âg to Report Paging ActivitiesUsing sar âwpgr to Report on Memory ResourcesFinding the Worst User on the System Using the top CommandMonitoring ToolsUsing the uptime Command to Monitor CPU LoadUsing the mpstat Command to Identify CPU BottlenecksCombining ps with Selected V$ ViewsCPU/Memory Monitoring Tool (Task Manager) on WindowsUsing the iostat Command to Identify Disk I/O BottlenecksUsing iostat âd for Disk Drives sd15, sd16, sd17, and sd18Using iostat âDUsing iostat âxCombining iostat âx with Logic in a Shell ScriptUsing the ipcs Command to Determine Shared MemoryUsing the vmstat Command to Monitor System LoadMonitoring Disk Free SpaceThe df CommandThe du CommandMonitoring Network Performance with netstatModifying the Configuration Information FileOther Factors That Affect PerformanceOther Sources to Improve PerformanceObsoleted/Desupported Initialization ParametersDeprecated Initialization ParametersTop 20 Initialization Parameters Not to ForgetTop 13 Undocumented Initialization Parameters (As I See It)Bonus 11 Undocumented Initialization ParametersListing of Documented Initialization Parameters (V$PARAMETER)Listing of Undocumented Initialization Parameters (X$KSPPI/X$KSPPCV)Additional Oracle Applications NotesConcurrent ManagersApplicationsâFinding Module-Specific PatchesDiagnostics Data Collection: EBS AnalyzersWeb Server TuningTimeoutsDatabase Initialization Parameter SizingTop 10 Reasons Not to Write a BookCreation of V$ and GV$ Views and X$ TablesA List of Oracle 12c (12.2.0.0.1) GV$ ViewsA List of Oracle 12c (12.2.0.0.1) V$ ViewsOracle 12c Scripts for the X$ Tables Used to Create the V$ ViewsOracle 12cR2 X$ Tables Ordered by NameOracle 12cR2 X$ IndexesOracle 12cR2 V$ Views Cross-Referenced to the X$ Tables