pruningclusterware

565IndexNumbers1/app/oracledirectorypath,21/app/oracle/adrcidirectory,721/app/oracle/arch1directory,2871/app/oracle/diag/rdbms/orcl11/orcl11/tracepath,685/app/oraclestring,292Aacceptedcolumn,213accesscontrolentries(ACEs),250,251accesscontrollists.
SeeACLsACCESSPARAMETERS,330,334ACEs(accesscontrolentries),250,251ACLs(accesscontrollists),494creating,250–251maintaining,253–254ordering,256–257querying,254–256security,475Actionselement,492active(network-based)databaseduplication,288–298performing,292–297prerequisites,289–290process,297–298spfileclause,290–292adaptivecursorsharingmonitoring,174newfeatures,172–174overview,173–174addcolumncommand,119add_deviceprocedure,314add_filterprocedure,39ADD_PRIVILEGEprocedure,251ADD_STS_REFprocedure,196add_sts_refprocedure,196add_subset_rulesprocedure,339add_table_rulesprocedure,339add_tables_rulesprocedure,340add_window_group_memberprocedure,109ADDM.
SeeAutomaticDatabaseDiagnosticMonitorADDMperformanceanalysissummarytable,223administer_sql_managementobjectprivilege,211ADR.
SeeautomaticdiagnosticrepositoryADRbase,61ADRControlInterface,63ADRhomes,61adrcicommand-linetool,3incidentspackaging,70–73viewing,68–70listingtracefiles,68options,66settinghomepath,64–65usinginbatchmode,64incommand-linemode,63–64inscripts,64viewing,66–68adrci-helpcommand,63adrcihomepath,68AdvancedEncryptionStandard(AES),319advancedtablecompressionoptionnewfeatures,153–156compressingunstructureddata,155–156implementing,154–155overview,154storage/performancegains,154566INDEXadvisefailurecommand,86AdvisorCentrallink,159AES(AdvancedEncryptionStandard),319AFTEREACHROWsection,474AFTERstatement,469AFTERSTATEMENTtrigger,474AlertDetailspage,75alertlog,viewing,66–68alertsubdirectory,62alert-tailcommands,68alert$ORACLE_SID.
logcommand,64ALERT_NOTIFICATIONStable,554alert.
logfile,393ALIASINFOsection,401allclause,308alloption,315ALLparameter,492allprivilegesfromclause,306ALL_DETAIL_RELATIONSview,528ALL_MVIEW_DETAIL_PARTITIONview,528ALL_MVIEW_DETAIL_RELATIONSview,529ALL_MVIEW_DETAIL_SUBPARTITIONview,528ALL_MVIEWSview,528all-inclusivebackup,277allocationunit(AU),381,385–386alterstatement,169altercommands,171alterdatabaserecovermanagedstandbydatabasecancelcommand,419alterdatabaserecovertologicalstandbydatabase_namecommand,427alterdatabasesettransactionreadonlycommand,419alterdiskgroupdiskonlinecommand,393alterdiskgroup.
.
.
checkcommand,380alterdiskgroupcommand,382alterdiskgroupdiskcommand,391alterdiskgroup.
.
.
mountrestrictcommand,366alterflashbackcommand,117ALTERINDEXcommand,486,490alterindex.
.
.
visiblestatement,130alterprocedurestatement,170ALTERPROFILEcommand,236altersessionstatement,168altersystemcommand,9ALTERSYSTEMcommand,230altersystemflushshared_poolstatement,180ALTERSYSTEMprivilege,240ALTERSYSTEMSETENCRYPTIONKEYcommand,242altersystemstatement,104altersystemsyntax,372altertablecommand,120ALTERTABLEcommand,489ALTERTABLEMOVEoption,242altertablestatement,113altertablespaceshrinktempfilecommand,134alteruserstatement,24ALTERUSERstatement,231alter_paramprocedure,142analyze_current_performanceprocedure,344anykeyword,535ANYDATAqueue,338APEX(ApplicationExpress),4,505–507APP_SUPPORTdatabase,256applicationdevelopment,newfeatures/enhancements,445–513APEX,505–507Java,508–513overview,445PHPsupport,507–508PL/SQL,445–469triggers,469–474XMLDB,475–505ApplicationExpress(APEX),4,505–507ApplyPatchlink,54ApplyPatchpage,55APPLY_BYTES_SENTcolumn,344APPLY_DBLINKcolumn,344APPLY_MESSAGE_SENTcolumn,344APPLY_NAMEcolumn,344APPLY_SETprocedure,433apxconf.
sqlscript,505567INDEXFinditfasterathttp://superindex.
apress.
comarchival(long-term)backups,139,276–281backup.
.
.
keepcommand,276–277creating,278–280overview,277–278restoring,280–281archivelogstorage,logicalstandby,436–437archivedredologs,deleting,285–288asclause,149asofclause,137as_offormulation,121ASM.
Seeautomatedstoragemanagementasm_backup.
mdbfile,405asm_diskstringparameter,377ASM_HOMEdirectory,371asm_preferred_read_failure_groupsinitializationparameter,374asmcmdcommands,395–400cpcommand,398–400lscommand,395lsctcommand,396lsdgcommand,395–396lsdskcommand,396–397asmcmdutility,409ASMUpgrade.
logfile,370ASSIGN_ACLprocedure,252assmtablespace,516ASYNCoption,490AU(allocationunit),381,385–386au_sizeattribute,384AUD$table,228AUDITROLEBYACCESSinitializationparameter,228AUDITSYSTEMBYACCESSinitializationparameter,228AUDIT_TRAILinitializationparameter,226auditing,unauthorizedaccess,264AUTHIDCURRENT_USERfunction,462AUTO_MERGE_THRESHOLDprocedure,354autoextendonmaxsizeunlimitedclause,22automatedalerts,356–357automateddatabasemaintenancetasks,105–110defaultresourcemanagerplan,107–108maintenancewindows,106–109modifying,108tasks,105–106trackingjobruns,109–110AutomatedMaintenanceTaskstab,157automatedstoragemanagement(ASM),361–413asmcmdcommands,395–400cpcommand,398–400lscommand,395lsctcommand,396lsdgcommand,395–396lsdskcommand,396–397fastrebalance,366metadatabackup/restore,400–409asmcmdutility,409md_backupcommand,400–401md_restorecommand,401–402,409misconceptions,362OracleDirectNFS,410–413disabling,413NICbonding,413performance,413settingup,410–412validating,412osasmgroup,363–366overview,361preferredreads,374–395AUsizes,385–386diskgroupattributes,381–385fastmirrorresync,389–395monitoring,375RDBMScompatibility,386–389restrictedmode,376–381setup,374–375RMANand,362sysasmprivilege,363–366upgradingmanually,366–367rollingupgrades,371–373usingDBUA,367–370AutomaticDatabaseDiagnosticMonitor(ADDM),167advisorfindings,215database,214Finditfasterathttp://superindex.
apress.
com568INDEXDBMS_ADDMpackage,216–217instance,214newfeatures,214–217runningoverspecifictimeperiods,214specifyingtypeoftask,215automaticdiagnosticrepository(ADR),2,3,58–62IncidentPackagingService(IPS),61incidents,60problems,60structure/locationof,61–62automaticmemorymanagement,8adopting,101–103afterdatabasecreation,102–103atdatabasecreationtime,101–102initializationparameters,101monitoringmemoryallocation,103–104automaticnativePL/SQLcompilationnewfeatures,168–171recompilingdatabasesfor,170–171settingup,169–170using,168–169AutomaticOptimizerStatisticsCollectiontask,105automaticprogramglobalareamanagement,100AutomaticSegmentAdvisortask,105Automaticsharedmemorymanagement,100AutomaticSQLTuningAdvisortasks,105identifyingcandidatesfor,192implementing,192–193managing,193–194newfeatures,190–197running,192SQLAccessAdvisor,194–197accessingintermediateresults,196DBMS_ADVISORprocedures,196–197partitioning,195automaticstoragemanagement(ASM)databaserolefor,5filesystem,310privilegesgroupfor,5sysasmprivilegefor,258automaticworkloadrepository(AWR)baselines.
SeeAWRbaselinesAUTOMATIC_WORKLOAD_REPOSITORYpackage,218AUTOTASKtasks,105Availabilitytab,156,157averageactivesessionssection,223AWR(automaticworkloadrepository)baselinesmetricthresholds,221movingwindowbaselines,218–219newfeatures,217–219one-time,219–220renaming,220repeating,220settingexpirationdatesfor,220BB4I_DONATIONS_JOUtable,469backedup.
.
.
timestodevicetypepolicy,287background_dump_dest,core_dump_destinitializationparameters,59background_dump_destinitializationparameter,10backupandrecoveryactivedatabaseduplication,288–298performing,292–297prerequisites,289–290process,297–298spfileclause,290–292blockmediarecovery,265–270compressingbackupdata,155metadata,400–409asmcmdutility,409md_backupcommand,400–401md_restorecommand,401–402,409overview,265recoverycatalogs,299–307merging,299–302movingtootherdatabases,302virtualprivatecatalogs,302–307undodata,288backupcommand,89backupcontrolfiles,restoringtostandby,309backupdatabasecommand,279569INDEXFinditfasterathttp://superindex.
apress.
combackup.
.
.
deleteinputcommand,285backupfileaccessibilitygroups,310–311backup.
.
.
keepcommand,276,277backupshredding,258,288backup.
.
.
validatecommand,87,281backup-basedduplication,288badpackets,settinglevelofinformationcapturedfor,262badCntvariable,474bannerpage,settingupforunauthorizedaccess,264baserecoverycatalog,257BaselineMetricThresholdspage,159baselinetemplatesgenerating,219–220newfeatures,219–220renamingAWRbaselines,220settingexpirationdatesforAWRbaselines,220templatedictionaryviews,220baselinesAWR,217–219movingwindowbaselines,218–219one-time,219–220renaming,220repeating,220settingexpirationdatesfor,220SQLplancapturing,208–209displaying,211evolving,210–211managing,213–214BasicFilesmigratingtoSecureFiles,526–527versusSecureFiles,516–517batchmode,usingadrcicommand-linetoolin,64bdumpdiagnosticdirectory,3BEFOREEACHROWsection,474beforescnclause,117BEFOREstatement,469beforetimestampclause,117binaryLOBs(BLOBs),516BinaryXMLType,475,481bindpeeking,172bind-awarecursormatching,173bind-sensitive,173BLOBsupport,SQL*Plus,150BLOB_CONTENTcolumn,516BLOBs(binaryLOBs),516blockchangetracking,311,428–429blockmediarecovery,265–270block,409blockrecovercommand,266BONUScolumn,556buckets,192,348bypassvalue,STATUScolumn,185BZIP2algorithm,273Ccflag,395coption,395cachememory,178cacheoption,518cacheparameter,518cache_idvalue,179calibratemode,38cancel_replayprocedure,44capturefiles,39CAPTURE_BYTES_RECEIVEDcolumn,343capture_idvalue,45CAPTURE_MESSAGE_CREATE_TIMEprocedure,354capture_nameargument,340,341capture_userargument,340capturingSQLplanbaselines,208–209SQLworkload,49–50workloadanalysis,44–46typesofdatacaptured,39cascadeoption,transaction_backoutprocedure,124casesec_case_sensitive_logonparameter,12casesensitivity,233–234catalogprivilege,306catproc.
sqlscript,3catupgrd.
sqlscript,19570INDEXcdumpdiagnosticdirectory,3cdumpsubdirectory,62CenterforInternetSecurity(CIS),230changecommand,278changedb_unique_namecommand,309changefailurecommand,89ChangeManagementPack,56change.
.
.
nokeepcommand,280characterlargeobject(CLOB),358,475,516checkclause,380checkcommand,361checklogicalclause,87checkers.
SeechecksCHECKNAMEargument,83checks,80–88manual,82–88DatabaseControl,85DBMS_HMpackage,82–85RMANvalidatecommand,88overview,81typesof,81–82CIS(CenterforInternetSecurity),230clientcache,188client_namecolumn,108client_nameparameter,108client_result_cache_lagparameter,11,189client_result_cache_sizeparameter,11,189clients,automatedalertsfor,356–357CLOB(characterlargeobject),358,475,516CloneOracleHomelink,56cloning,56ClusterReadyServices(CRS),59ClusterSynchronizationServices(CSS),362clusterverifyutility(cluvfy),33clusterwaredirectory,27cluvfy(clusterverifyutility),33CMON(connectionmonitor),141cmp_converge_local_winsconvergeoption,147CMP_SCAN_MODE_CUSTOMvalue,349CMP_SCAN_MODE_CYCLICvalue,349CMP_SCAN_MODE_FULLvalue,349CMP_SCAN_MODE_RANDOMvalue,349collectingprivatestatistics,205–206columns,encrypting,433COM(complete)ZIPfile,71,72combinedcaptureandapply,342–344command-linemode,usingadrcicommand-linetoolin,63–64comp_tbltable,154comparefunction,348,350comparingdata,144–146comparision_metricparameter,52comparisonmaintenance,350–351recheckingprior,351–352compatibilityparameter,275compatibleattribute,388compatibleparameter,8,387compatible.
asmattribute,381compatible.
rdbmsattribute,381compensatingtransaction,123,124complete(COM)ZIPfile,71,72compositelist-hashpartitioning,552compositelist-listpartitioning,553compositelist-rangepartitioning,553compositerange-rangepartitioning,127,554–555compoundtriggers,469–474compressforalloperationsclause,154compressfordirect_loadoperationsoption,154compresskeyword,523compressoption,154compression,314–318backupdata,155DataPumpexportdata,155networkdata,156redologdata,429–430SecureFiles,523–525compressionattribute,429COMPRESSIONparameter,315compression=alloption,315compression=data_onlyoption,318configurationparameters,RMAN,273–274configurearchivelogdeletionpolicycommand,286configurecommand,308571INDEXFinditfasterathttp://superindex.
apress.
comconfiguregroupcommand,310configureprocedure,213configure_poolprocedure,142configuringAPEX,505–506archivedredologdeletionpolicies,285–287databaseresidentconnectionpooling(DRCP),142–143RMANwithoutdatabaseconnections,308–309synchronouscapture,339–341connectcatalogcommand,306connectcommand,149connectidentifierclause,310connectoption,250connectprivileges,252connectrole,5CONNECTTOUSERNAMEIDENTIFIEDBYclause,233connect_time_scaleparameter,44connectionclassattribute,142connectionmonitor(CMON),141ConnectionTimeScalereplayoption,44connection_idparameter,43connection_overrideparameter,43ContentRepositoryAPIforJavaTechnology(JSR-170),475CONTINUEstatement,445control_management_pack_accessinitializationparameter,161convergeprocedure,146,147convergingdata,146–147shareddatabaseobjects,352–353convertingtophysicalstandby,425physicalstandbytologicalstandby,427–428tosnapshotstandby,422–425copy_fileprocedure,362copy_sqlwkld_to_stsprocedure,196COPY_SQLWKLD_TO_STSprocedure,196–197core_dump_destfile,10core_dump_destinitializationparameter,10COUNTRY_IDcolumn,198cpcommand,327,398–400CPUs(criticalpatchupdates),54,55createcountsuccesscolumn,183createdatabaseSQLstatement,101creatediskgroupcommand,382creatediskgroupsyntax,390createflashbackstatement,115,116CREATEINDEXcommand,129,492createpfilefrommemorystatement,136createpfilefromspfilestatement,136createrestorepointcommand,137createscriptcommand,271createsessionprivilege,5createtableas(CTAS),19,153,526createtablestatement,544createtablesyntax,329CREATETRIGGERstatement,469CreateUser-ReportedProblemlink,74CREATE_ACLprocedure,250create_analysis_taskprocedure,50create_baselineprocedure,217create_comparisonprocedure,349create_extended_statsfunction,199,200create_sqlsetprocedure,49create_stgtab_sqlsetprocedure,50create_sync_captureprocedure,340create_virtual_catalogprocedure,307create_windowprocedure,109CreateDateIndexprocedure,488CreateNumberIndexprocedure,487CREATION_DATEcolumn,480CREATION_DATEtable,554criticalpatchupdates(CPUs),54,55cross-sessionfunctionresultcache,458–462CRS(ClusterReadyServices),59CSS(ClusterSynchronizationServices),362CTAS(createtableas),19,153,526current_diff_countcolumn,DBA_COMPARISON_SCAN_SUMMARYview,146cursor_sharinginitializationparameter,172572INDEXcursor_sharingparameter,172CUSTtable,316CUST_TATE_PROVINCEcolumn,199cust.
compress.
dmpfile,317cust.
dmpfile,318custompackaging,77CUSTOMERtable,316customizingfast-startfailoverevents,440–441Ddflag,396datablocksidentifyingcorrupt,267recoveringallcorrupt,268–270recoveringspecificcorrupt,267–268datacorruption,protectingagainst,97datadictionary,151,488–489DATAdiskgroup,384datadivergence,46DataEncryptionStandard(DES),225DataGuard,415–444configuringarchivedredologdeletionpoliciesinsetup,286–287newfeaturesDataGuardBroker,437–444logicalstandby,432–437physicalstandby,416–418,426–432real-timequerystandby,418–421snapshotstandby,421–426overview,415–416RMANintegrationwith,307–311backupfileaccessibilitygroups,310–311blockchangetrackingsupport,311configuringRMANwithoutdatabaseconnections,308–309restoringbackupcontrolfiletostandby,309resynchronizingrecoverycatalogs,310TDE,259DataGuardBroker,437–444command-lineinterface,438detectinglost-writeconditionsusingphysicalstandby,443fast-startfailover,440–441heterogeneousOSDataGuardconfiguration,443–444properties,442–443storagevendorsolutions,444DataGuardcommand-lineinterface(DGMGRL),428DataManipulationLanguage(DML)activity,153DataMovementtab,156datapartitioningschemes,128DataPump,313–335APIenhancements,313–314compressionenhancements,314–318encryption,258,319–322exportdata,compressing,155exporting/importingpartitions,326–328externaltablesbasedon,329–335ignoringerrors,329overview,313remappingdata,323–325remappingtable,325reusingdumpfiles,322DataRecoveryAdvisor(DRA),57,77,88–96managingthroughRMAN,89–95DatabaseControl,95repairadvice,90–91repairingfailures,91–92repairingmissingdatafileproblems,92–94viewingfailures,89SQLTestCaseBuilder,96datawarehousing,515–563LOBstorage,516–527newfeatures,527–538materializedview,529–532PCT,528–529pivotoperators,532–537unpivotoperators,537–538OracleMultimedia,561–563DICOMsupport,561–562imageprocessing,562ORDDICOMtype,562SecureFilessupport,562–563overview,515–516573INDEXFinditfasterathttp://superindex.
apress.
compartitioning,538–561extendedcomposite,552–555interval,546–552PartitionAdvisor,539–544pruningcapabilities,561reference,544–546system,559–561virtualcolumn-based,556–558data_onlyoption,315DATA_OPTIONSparameter,329data_remapprocedure,313+DATA/ASMTESTING/DATAFILEdirectory,399databaseadministration,214allowingDDLlockstowaitforDMLlocks,128comparingdata,144–146convergingdata,146–147datapartitioningschemes,128databaseresidentconnectionpooling(DRCP),139–143explicitlockingoftables,128–129initializationparameterfiles,136–137invisibleindexes,129–133read-onlytables,133restorepoints,137–139temporarytablespacemanagement,133–136virtualcolumns,125–127databaseautomation,99–110automateddatabasemaintenancetasks,105–110automaticmemorymanagement,100–104DatabaseConfigurationAssistant(DBCA),7,13–16databaseconnections,262–263DatabaseConsole,245–248DatabaseControl,53,85ADDMperformanceanalysissummarytable,223averageactivesessionssection,223customizedDatabasePerformancepage,222–223managingAutomaticSQLTuningAdvisortasksusing,193managingDRAwith,95newfeatures,222–223databasecreation,8–17backgroundprocesses,16DBCAenhancements,13–16initializationparameters,8–13PL/SQLpackages,17DatabaseDiagnosticPack,160,161databasedirectory,6databaseduplicationcommand,290databasefailure,81databaselevel,177databaselinks,233–234DatabasePerformancepage,222–223databaserepair,81DatabaseReplay,1,35–46workloadanalyzingcapture/replay,44–46capturing,39–41preparingreplayof,43–44preprocessing,41replaying,42–43typesofdatacapturedin,39databaseresidentconnectionpooling(DRCP),139–143,507configuring,142–143enabling/disabling,141–142monitoring,143overview,140DatabaseTuningPack,160,161DatabaseUpgradeAssistant(DBUA),1,24–25,367–370database_roleattribute,435database_rolecolumn,423datafilelocations,choosing,2db_block_checkingparameter,11,97db_block_checksuminitializationparameter,97DB_BLOCK_SIZEparameter,483db_cache_sizeparameter,101DB_CPOOL_INFOconnectionpooling,143db_create_file_destparameter,298db_file_name_convertclause,292db_file_name_convertparameter,291574INDEXdb_file_name_convert'string_pattern'option,292db_flashbackretention_targetparameter,138db_lost_write_protectinitializationparameter,97DB_NAME=PRIMARY_DATABASEinitializationfile,416DB_NAME=PRIMARY_DATABASEDRinitializationfile,416db_securefileinitializationparameter,525–526db_securefileparameter,11db_ultra_safeinitializationparameter,97db_ultra_safeparameter,11–12db_unique_nameparameter,310,418DBAviews,forsynchronouscapture,341DBA_ACL_NETWORKSview,254DBA_ALERT_HISTORYview,356DBA_/ALL_/USER_XML_INDEXESview,485DBA_AUTOTASK_HISTORYview,109DBA_AUTOTASK_OPERATIONview,108DBA_AUTOTASKS_TASKview,105DBA_COMPARISONview,353DBA_COMPARISON_SCAN_SUMMARYview,146DBA_FLASHBACK_ARCHIVE_TABLESview,120DBA_FLASHBACK_ARCHIVE_TSview,120DBA_FLASHBACK_TRANSACTION_REPORTview,125DBA_FLASHBACK_TRANSACTION_STATEview,125DBA_INDEXEStable,132DBA_LOGSTDBY_UNSUPPORTEDview,427DBA_NETWORK_ACL_PRIVILEGEview,254DBA_OUTSTANDING_ALERTSview,356DBA_PLSQL_OBJECT_SETTINGSview,170DBA_RSRC_CONSUMER_GROUPSresourceplan,107DBA_RSRC_PLAN_DIRECTIVESresourceplan,107DBA_SALARIESpackage,497DBA_SCHEDULER_JOBview,436DBA_SQL_PATCHESview,80DBA_SQL_PLAN_BASELINESview,213DBA_STREAMS_NEWLY_SUPPORTEDview,357DBA_STREAMS_TP_COMPONENTview,346DBA_STREAMS_TP_COMPONENT_LINKview,346DBA_STREAMS_TP_COMPONENT_STATview,346DBA_STREAMS_TP_DATABASEview,346DBA_STREAMS_TP_PATH_BOTTLENECKview,346DBA_STREAMS_TP_PATH_STATview,346DBA_TAB_PENDING_STATStable,205DBA_USERSview,233DBA_USERS_WITH_DEFPWDview,233DBA_WORKLOAD_*views,46dba_workload_connection_mapparameter,42DBA_WORKLOAD_CONNECTION_MAPtable,38DBA_WORKLOAD_CONNECTION_MAPview,43DBA_WORKLOAD_REPLAYStable,45DBA_WORKLOAD_REPLAYSview,46dba.
xmlcontrollist,253dba.
xmlfile,251DBCA(DatabaseConfigurationAssistant),7,13–16DBMS_COMPARISIONpackage,143DBMS_ADDMpackage,17,216–217DBMS_ADVISORpackage,215DBMS_ADVISORprocedures,196–197DBMS_AUTO_TASK_ADMINpackage,17,194DBMS_AUTOTASK_ADMINpackage,105DBMS_CAPTURE_ADM.
ALTER_SYNC_CAPTUREprocedure,339DBMS_COMPAREpackage,144DBMS_COMPARISIONpackage,17DBMS_COMPARISION.
CREATE_COMPARISONprocedure,349DBMS_COMPARISION.
RECHECKfunction,351DBMS_COMPARISONpackage,146comparison,349–350comparisonmaintenance,350–351575INDEXFinditfasterathttp://superindex.
apress.
comconvergingshareddatabaseobjects,352–353recheckingpriorcomparison,351–352requirements,348supporteddatabaseobjecttypes,348DBMS_CONNECTION_POOLpackage,17DBMS_CRYPTOpackage,239DBMS_DATApackage,313DBMS_DGPL/SQLpackage,441DBMS_FGApackage,435dbms_file_transferPL/SQLpackage,362DBMS_flashbackpackage,125DBMS_FLASHBACKtable,123DBMS_HMpackage,17,82–85DBMS_JAVApackage,508DBMS_JAVA.
runjava()function,508dbms_java.
set_output()function,509DBMS_JOBpackage,359DBMS_LOB.
SETOPTIONSstoredprocedure,522DBMS_LOGSTDBY.
APPLY_SETprocedure,434DBMS_LOGSTDBY.
APPLY_UNSETprocedure,437DBMS_MVIEW.
EXPLAIN_REWRITEprocedure,531DBMS_NETWORK_ACL_ADMINpackage,250DBMS_OBFUSCATION_TOOLKITpackage,239DBMS_OUTPUTpackage,471dbms_outputpackage,509DBMS_OUTPUTprocedure,520DBMS_OUTPUT.
PUT_LINE()method,452,459DBMS_RANDOMpackage,324DBMS_REDEFINITIONpackage,195DBMS_REDEFINITION.
COPY_TABLE_DEPENDENTSprocedure,152DBMS_RESULT_CACHEpackage,17DBMS_RESULT.
CACHE_FLUSHprocedure,180DBMS_RLSpackage,435DBMS_SCHEDULERpackage,109DBMS_SCHEDULERscheduler,435DBMS_SCHEDULER.
SET_ATTRIBUTEprocedure,435dbms_server_alert.
set_thresholdprocedure,356DBMS_SPACE.
USED_SPACEprocedure,519DBMS_SPMpackage,17,210–211DBMS_SPM.
ALTER_SQL_PLAN_BASELINEfunction,214DBMS_SPM.
EVOLVE_SQL_PLAN_BASELINEfunction,210DBMS_SPSpackage,208DBMS_SQLpackage,465DBMS_SQLDIAGpackage,17DBMS_SQL.
FETCH_ROWS()clause,465DBMS_SQLPApackage,17DBMS_SQL.
parse()function,469DBMS_STATSpackage,199DBMS_STATSprocedure,203DBMS_STATS.
GATHER_DICTIONARY_STATSprocedure,20DBMS_STREAMS_ADMpackage,338DBMS_STREAMS_ADM.
SET_UP_QUEUEprocedure,339DBMS_STREAMS_ADM.
SPLIT_STREAMSprocedure,354DBMS_STREAMS_ADVISOR_ADMpackage,344–345dbms_utility.
format_call_stack()method,452DBMS_WORKLOADpackage,40DBMS_WORKLOAD_CAPTUREpackage,17DBMS_WORKLOAD_CAPTURE.
GET_CAPTURE_INFOprocedure,40DBMS_WORKLOAD_REPLAYpackage,17DBMS_WORKLOAD_REPOSITORYpackage,217DBMS_XDBpackage,495DBMS_XMLINDEXpackage,487,490DBMS_XMLINDEX.
SYNCINDEXcommand,490DBMS_XMLSCHEMA.
INPLACEEVOLVEprocedure,499DBMS_XPLANpackage,211dbmsupgin.
sqlscript,171dbmsupgnv.
sqlscript,170576INDEXDBMS-WORKLOAD_REPOSITORYpackage,218DB-onlinemode,82DBUA(DatabaseUpgradeAssistant),1,24–25,367–370dbverifyutility,267ddcommand,377DDLlocks,128ddl_lock_timeoutparameter,11,128decryptkeyword,523decryptoption,523deduplicatereservedsyntax,520deduplicationoption,520defaultclause,151defaultcolumnvaluefunctionality,151defaultresourcemanagerplan,107–108DefaultView,222DEFAULT_DOCStable,519DEFAULT_MAINTENANCE_PLANresourceplan,107defaults,226–229DELAYoption,263delayingdatabaseconnections,262–263deletearchiveloginputcommand,285deleteforcecommand,288deletetransaction,113DELETE_*procedures,217delete_database_prefsprocedure,203delete_filterprocedure,40delete_finding_directiveprocedure,217delete_pending_statsprocedure,204DELETE_PRIVILEGEprocedure,253delete_schema_prefsprocedure,203delete_table_prefsprocedure,203delete_table_statisticsprocedure,205deletingarchivedredologs,285multicolumnstatistics,201pendingstatistics,206departitionvalue,PARTITION_OPTIONSparameter,326department_idcolumn,173departmentstable,113dependentobjects,minimalinvalidationof,152dependenttablesclause,546DES(DataEncryptionStandard),225describeincidenttype,70descriptionparameter,250*_destinitializationparameters,61dest_allvalue,437dest_events_tablevalue,437destinations,354,355detailkeyword,92DetailedChartSettingssection,222DETAILOBJ_PCTcolumn,529/dev/shmparameter,104dg_over.
txtfile,409DGMGRL(DataGuardcommand-lineinterface),428DGNAME=DATA:DATA_NEWoption,402diagdirectory,408diagnosticdata,70diagnostic_destparameter,3,10,62DICOM(DigitalImagingandCommunicationsinMedicine),561,562diffXMLparameter,500DigitalImagingandCommunicationsinMedicine(DICOM),561,562DirectNetworkFileSystem(NFS),361,410DIRECTORYvalue,260disablefast_startfailoverinterface,439DisableSecuritySettingsbox,15DISABLEDkeyword,469disablingDRCP,141–142flashbackdataarchives,118–119OCIconsistentclientcache,190OracleDirectNFS,413disasterrecovery(DR)solution,415disk_readscomparisonmetric,52disk_repair_timeattribute,381DiskgroupMonitor(GMON),391DiskgroupMount/Dismountbutton,379block,409577INDEXFinditfasterathttp://superindex.
apress.
comdiskgroup_name.
failuregroupnameparameter,374diskgroupsattributes,381–385checks,380–381maintenance,377–379DISKSINFOsection,401dismountdiskgroupcommand,407dismountoperation,379DISPLAYparameter,242DISPLAY_SQL_PLAN_BASELINEfunction,211displayingdatabasereleaseinformation,263–264SQLplanbaselines,211DLL(dynamiclinklibrary)loader,168DML(DataManipulationLanguage)activity,153DMLlocks,128DMLtriggers,172DML_CONDITIONparameter,341DOCStable,333docs_d_etablespace,243docs_d1datafiles,398DOCS_D1tablespace,546docs_d4datafile,400DOCS_DPtable,333docs_drtable,425DOCUMENT_CATEGORYcolumn,553documentstable,322donations%RECTYPEtype,473downgrading,afterupgradetoOracleDatabase11g,25–26DR(disasterrecovery)solution,415DRA.
SeeDataRecoveryAdvisorDRCP.
Seedatabaseresidentconnectionpoolingdropcatalogcommand,307dropcolumnDDLcommand,119dropcommand,361dropdiskgroupcommand,378dropflashbackdataarchivecommand,116DROPoption,263DROP_ACLprocedure,253drop_baselineprocedure,217drop_baseline_templateprocedure,220drop_comparisonprocedure,351drop_extended_statisticsfunction,201,202drop_sql_patchprocedure,80DROP_UNUSED_RULE_SETSparameter,341dropjavatool,510droppingdatabaseconnections,262–263synchronouscapture,341virtualprivatecatalogs,307dualencryptionmode,320dumpfiles,reusing,322duplicatecommand,47duplicatedatabasecommand,289durationattribute,109durationcolumn,431durationparameter,40DYNAMICcolumn,434dynamiclinklibrary(DLL)loader,168dynamicstoredscript,271dynamicsymmetry,465–469EEBDA_ALERT_NOTIFICATIONStable,547EDBA_PO_XMLINDEXview,486edba_remapfunction,323edba_remap_ssnpackage,324EDBA_SECURITYBinaryXMLTypetable,478EDBA_UPDATEdatabase,435elapsed_timeparameter,52emergencyhotpatching(onlinedatabasepatching),55enablefast_startfailoverinterface,439enableprocedure,108enabledcolumn,213ENABLEDkeyword,469enablingDRCP,141–142flashbackdataarchives,118–119OCIconsistentclientcache,190PL/SQLfunctionresultcache,187rollingupgrades,372578INDEXencryptkeyword,243ENCRYPTED_COLUMNS_ONLYparameter,319,321encrypted.
dmpfile,322encryptionchoosingmode,320–322columns,433options,245SecureFiles,522–523specifying,319tables,433tablespaces,433encryptionenabledoption,334ENCRYPTIONparameter,319ENCRYPTION_ALGORITHMparameter,319ENCRYPTION_MODEoptions,320ENCRYPTION_PASSWORDparameter,319encryption_wallet_locationparameter,240end_dateparameter,251EnterpriseDatabase,security,225–239basiccompliancetoindustrysecurityrecommendations,230–231databaselinks,233–234defaults,226–229delayedfailedlogins,229PASSWORDVERSIONScolumn,232,264passwords,226,239upgradeimplications,231EnterpriseManagerDatabaseConsole,244–248PolicyTrendOverviewscreen,247tablespaceencryption,245–247TransparentDataEncryption,245newfeaturesAvailabilitytab,157DatabaseDiagnosticPack,160DatabaseTuningPack,160LogMinertool,159–160RelatedLinkssection,158–159Servertab,157–158errorsignoring,329logging,SQL*Plus,147–149estd_db_timecolumn,104estimate_percentparameter,202/etc/fstabdirectory,410/etc/groupfile,366/etc/mtabfile,410/etc/oratabfile,366eventmessages,SQLApply,437event_log_destparameter,437EVOLVE_PRESERVE_VALIDITYparameter,500EVOLVE_SCAN_DATAparameter,500evolve_sql_planbaselinefeature,211evolvingSQLplanbaselines,210–211EXCLUDEADDoption,493EXCLUDEREMOVE(ALL)option,492exclusivelock(X),150execdbms_result_cache.
flushprocedure,185execdbms_result_cache.
invalidate(ABC','TESTTAB')procedure,185execdbms_result_cache.
memory_reportprocedure,185executeprivilege,123execute_analysis_taskprocedure,51execute_catalog_roleprivilege,39execute_tuning_taskprocedure,51execution_typeparameter,51existsNodeoperator,500EXITstatement,445exputility,313expdputility,320exp/impoption,242expiredvalue,STATUScolumn,185explainplan,viewingresultcachewith,179–180explain_sql_testcasefunction,96explicitlockingoftables,128–129Exportattribute,411exportstatistics,203export_awrprocedure,44export_sql_testcaseprocedure,96export_sql_testcase_dir_by_incfunction,96export_sql_testcase_dir_by_txtfunction,96export_table_statisticsprocedure,206579INDEXFinditfasterathttp://superindex.
apress.
comexportingpartitions,326–328statisticspreferences,203expressionstatistics,197,201–202extendedcompositepartitioning,552–555list-hash,552list-list,553list-range,553range-range,554–555extendedstatistics,197extensionattribute,199externaltables,basedonDataPump,329–335Ffoption,399failures,81repairing,91–92viewing,89fastmirrorresync,389–395diskrepairtime,390–391online/offlinedisks,391–395fastrebalance,366fast_start_failovercondition,440fast-startfailovercustomizingevents,440–441initiatingfromapplications,441forMaximumPerformancemode,432FastStartFailoverAutoReinstateproperty,442FastStartFailoverLagLimitproperty,442FastStartFailoverPmyShutdownproperty,442faultmanagement,57–98adrcicommand-linetool,63–73listingtracefiles,68packagingincidents,70–73settinghomepath,64–65usinginbatchmode,64usingincommand-linemode,63–64viewingalertlog,66–68viewingincidents,68–70viewinglistofcommands,66automaticdiagnosticrepository(ADR),58–62IncidentPackagingService(IPS),61incidents,60problems,60structure/locationof,61–62checks,80–88manual,82–88overview,81typesof,81–82DRA,88–96managingthroughRMAN,89–95SQLTestCaseBuilder,96improvementsin,96–98SupportWorkbench,73–80homepage,73–74resolvingproblemswith,74–78SQLRepairAdvisor,78–80FBDA.
SeeflashbackdataarchivesFCACHE_DEMO.
TEST()method,458FDAP(FlashbackDataArchiverProcess),112fg1failgroup,375fg2failgroup,375FGA(fine-grainedauditing),435FileTransferProtocol(FTP),forOracleXMLDB,494filesystem_like_loggingoption,518FINDING_NAMEcolumn,215fine-grainedauditing(FGA),435fine-graineddependencymanagement,152finish_captureprocedure,40fixedcolumn,213FLAGparameter,500flashrecoveryarealocations,2flashbackarchiveadministersystemprivilege,115FlashbackDataArchiverProcess(FDAP),112flashbackdataarchives(FBDA),111–122accessingolderdata,120–121altering,117–118benefitsof,114–115creating,115–117580INDEXdefined,112–114enabling/disabling,118–119generatingreports,122ILM,122limitationsof,119monitoring,120flashbackprivilege,123flashbacktransactionbackout,110,122–125prerequisitesfor,123TRANSACTION_BACKOUTprocedure,124–125TRANSACTION_BACKOUTreports,125FOLLOWSclause,150,469fordb_unique_nameoption,308FORloop,464forstandbyclause,298FORALLstatements,463–465,472forceoption,177forcevalue,db_securefileparameter,525foreveroption,backup.
.
.
keepcommand,277formatclause,279FREQ=MINUTELYparameter,491fromactivedatabaseclause,289frombackupsetoption,268FROMclause,481,531fromtagoption,268FS_FAILOVER_STATUScolumn,443FTP(FileTransferProtocol),forOracleXMLDB,494ftpprocess,415fulltag,402full.
dmpfile,316full.
dmp.
gzfile,316functioncalls,named/mixedargumentsin,451Ggflag,395goption,395gather_stats_taskjob,192gather_table_statsprocedure,205gatheringmulticolumnstatistics,200–201gcoption,395gen_dpstoredprocedure,331,334generalizedinvocation,455,457generatedalwaysasclause,126generatingbaselinetemplates,219–220reportswithflashbackdataarchives,122get_replay_infofunction,45get_client_attributesprocedure,194get_fileprocedure,362get_Match()method,450get_Matching_Orders()function,467get_p1_resourcesprocedure,110,194GET_PARAMfunction,202get_prefsfunction,202get_productIdfunction,187get_reportprocedure,216global_dbnameparameter,416glogin.
sqlfile,147,149GMOD()method,459GMON(DiskgroupMonitor),391goldimages,56grantcatalogdatabasecommand,304grantcommand,306XMLtag,257graphicaluserinterfaces(GUIs),244GridControl,53guaranteedrestorepoint,138GUIs(graphicaluserinterfaces),244GV$table,396GV$ASM_DISKGROUPview,395GV$ASM_DISKGROUP_STATview,395gzipoperatingsystemutility,155HHflag,397hardwaresecuritymodules(HSMs),259–260healthchecks.
SeechecksHealthMonitor,80health_group,107HelloOracle.
jarclass,509helloracle.
Mainclass,511highcompression,524highoption,523histograms,usingforNET_TIMEOUTattributes,430581INDEXFinditfasterathttp://superindex.
apress.
comhmsubdirectory,62homedirectory,61homepath,ADRsetting,64–65tracefiles,68HR_EMPLOYEEStable,556hr.
sperrorlogtable,148hr.
SYS_FBA_HIST_70308historytable,114HSMs(hardwaresecuritymodules),259–260HTTP,forOracleXMLDB,494Iidentifierargument,453identifyingcandidatesforAutomaticSQLTuningAdvisortasks,192corruptdatablocks,267minimumrequiredcheckpointSCN,357–359backgroundprocessnamechanges,357supportforOracleScheduler,359supportfortransparentdataencryption,358supportforXMLTypevaluesasCLOBs,358newlysupportedtables,357ifrflag,398ignorevalue,db_securefileparameter,526ignorecaseoption,232ignoringerrors,329ILM(informationlifecyclemanagement),122,538imageprocessing,OracleMultimedia,562imputility,313implementingAutomaticSQLTuningAdvisortasks,192–193OLTPtablecompression,154–155importcatalogcommand,299importstatistics,203import_awrprocedure,44importingpartitions,326–328statisticspreferences,203STSintotestsystems,50inearlierOracleDatabasereleases,307INOUTargument,462in_clauseoperation,534inactivity_timeoutparameter,142incarnationcommand,305incidentfilesanddumpsretentionpolicy,60incidentmetadataretentionpolicy,60incidentpackages,57IncidentPackagingConfigurationpage,77IncidentPackagingService(IPS),57,61incidentsubdirectory,62incidents,60packaging,70–73viewing,68–70INCLUDEADD(ALL)option,492INCLUDEADDparameter,492includingcontentsoption,378incpkgsubdirectory,62incremental(INC)ZIPfile,71,72indexhint,129informationlifecyclemanagement(ILM),122,538init()method,455initqcommand,27init$ORACLE_SID.
orafile,367initializationparameters,8–13automaticmemorymanagement,101creatingfilesfrommemory,136–137db_ultra_safe,11–12ddl_lock_timeout,11diagnostic_dest,10memory-related,8–9optimizer-related,12–13PL/SQLnativecompilation,9–10resultcache-related,10–11SecureFiles-related,11security-related,12values,inactivedatabaseduplication,293initialize_replayprocedure,42initiatingfast-startfailoverfromapplications,441init.
orafile,101in-placeschemaevolution,499–500inPlaceEvolveprocedure,500582INDEXinsertcommand,114,560insert_finding_directiveprocedure,216insert_parameter_directiveprocedure,216insert_segment_directiveprocedure,216insert_sql_directiveprocedure,216installoptions,3–4installingOracleDatabase,6–8instanceADDM,newfeatures,214integratingRMANandDataGuard,429interpretedvalue,168intervalpartitioning,128,546–552INTERVAL=30parameter,491Intraunitinlining,190invalidvalue,STATUScolumn,185invisibleindexes,129–133checkingvisibilitystatus,132–133creating,129–130howoptimizertreats,131–132makingexistingindexesinvisible,130I/OChartSettings,222ipccreatepackagecommand,71IPS(IncidentPackagingService),57,61ipscommand,65ipscreatepackagecommand,72ipscreatepackageproblemcommand,72ipscreatepackageproblemkeycommand,72ipscreatepackagetimecommand,72ipsgeneratecommand,72ipsgeneratepackagecommand,71irsubdirectory,62IS_BIND_SENSITIVEcolumn,174is_grantparameter,249iSQL*Plus,1iSQL*Plusinterface,159ITYP_NAMEcolumn,485JJARsupport,508–510jarasresourceoption,510jarsasdbobjectoption,510jarsasdbobjectsoption,508Javadropjavatool,510JARsupport,508–510JITcompiler,508loadjavatool,510nativecompilation,508ojvmjavatool,511–512ojvmtctool,512–513JavaCommunityProcess(JCP)program,475java.
lang.
ClassNotfoundExceptioncommand,512JCP(JavaCommunityProcess)program,475JIT(just-in-time)compiler,508job_queue_processesinitializationparameter,359job_queue_processesparameter,11JSERVER_CPprefix,509JSERVER_SCHEMAprefix,509JSR-170(ContentRepositoryAPIforJavaTechnology),475just-in-time(JIT)compiler,508KKflag,396kb2.
dbffile,328KB:P_PLSQLpartition,328keepclause,134keepforeveroption,276,278keepidentityclause,427keepoption,276,277keepuntilsysdate+1clause,279keepuntiltimeclause,278keep_duplicateoption,523KEEP_DUPLICATESclause,477keep_duplicatesoption,518KR.
DBAEXPERT.
COMprincipal,261Llargeobject(LOB)storage,516–527SecureFilesversusBasicFiles,516–517compression,523–525db_securefileinitializationparameter,525–526583INDEXFinditfasterathttp://superindex.
apress.
comDBMS_LOB.
SETOPTIONSstoredprocedure,522deduplication,518–522encryption,522–523migratingfromBasicFilesto,526–527performance,517–518prefetching,527requirements,516largeobjects(LOBs),11LATE_NIGHT_WINDOWpackage,109LCRs(logicalchangerecords),342ldap.
orafile,248LGWR(logwriterprocess),430libodm11.
sofile,411libodm11.
so.
ORIGfile,411LineItemselement,492listcommand,308listfailurecommand,86listfailure.
.
.
detailcommand,89listincarnationcommand,299listoption,510listrestorepointallcommand,280listener.
orafile,416listfileoption,510listingtracefilesinADRhomepath,68LIVE_FEEDpackage,470LIVE_FEED.
enqueue()function,471,474LNS(logwriternetworkserver),431load_plans_from_cursor_cachefunction,209load_plans_from_sqlsetfunction,209load.
ctlshellscript,519loadingSTS,49–50loadjavaprogram,508loadjavatool,510load.
kshshellscript,519LOBencryption,258LOBstorage.
SeelargeobjectstorageLOBs.
SeelargeobjectsLOCATORcolumn,482locktablecommand,128logwriterprocess(LGWR),430log_archive_dest_1parameter,430log_archive_dest_nparameter,430,436log_archive_dest_state_ninitializationparameter,439log_archived_dest_nparameter,285log_auto_del_retention_targetparameter,436log_auto_deleteinitializationparameter,436log_file_name_convertparameter,291loggingclause,518logicalchangerecords(LCRs),342logicalrecoveryfeature,123logicalstandbyconvertingphysicalstandbyto,427–428SQLApply,432–437archivelogstorage,436–437DBMS_SCHEDULERscheduler,435dynamicallysettingparameters,434eventmessages,437FGA,435TDE,433VPD,435logins,delayedfailed,229LogMinertool,157,159–160,258logsoption,277LogShippingproperty,439LOGSTDBY$EVENTStable,437logwriternetworkserver(LNS),431long-termbackups.
Seearchivalbackupslost-writedetection,97–98,443lscommand,395lsctcommand,396lsdgcommand,395–396lsdskcommand,396–397lsnrctlstatusoutput,494Mmaintenancewindows,106–109ManagementPackAccesspage,161manualchecklist,90manualchecks,82–88DatabaseControl,85DBMS_HMpackage,82–85RMANvalidatecommand,88ManualPGAmemorymanagement,100Manualsharedmemorymanagement,100584INDEXmanuallyloadedplans,208mat_viewrewriteaccessoperation,531materializedviewqueryrewrites,530–532refreshmechanism,529–530materializedviews,onlinereorganizationof,152maxfunction,432max_lifetime_per_sessionparameter,142MAX_NUM_BUCKETSparameter,349max_sizeparameter,142max_think_timeparameter,142max_uses_per_sessionparameter,142MaximumPerformancemode,432MAXSALARYfunction,498md_backupcommand,400,401md_restorecommand,400,401–402,409meantimetorecovery(MTTR),88mediumcompression,523mediumoption,523memoryallocation,monitoring,103–104memoryoption,136memoryscript,297memory_max_sizeparameter,101memory_max_targetparameter,9memory_reportprocedure,178memory_targetparameter,9memory-relatedparameters,8–9mergepartitioncommand,560mergestatement,338mergevalue,PARTITION_OPTIONSparameter,326merge_streamsprocedure,354merge_streams_jobprocedure,355mergingrecoverycatalogs,299–302mergingstreams,354messagetracking,355–356messQueuecollection,471metadata,backingup/restoring,400–409asmcmdutility,409md_backupcommand,400–401md_restorecommand,401–402,409metadata_onlycompressionoption,315MetaLink,8,54METHODvalue,260MetricAnalysis,159MetricandPolicySettingspage,159MIGRATEclause,260MIGRATEUSINGwalletpasswordclause,260migratingfromBasicFilestoSecureFiles,526–527MIN_REQUIRED_CAPTURE_CHANGE#view,357MIN_ROWS_IN_BUCKETparameter,350min_sizeparameter,142minimumrequiredcheckpointSCN,identifying,357–359backgroundprocessnamechanges,357supportforOracleScheduler,359supportfortransparentdataencryption,358supportforXMLTypevaluesasCLOBs,358mixedarguments,infunctioncalls,451mkstorecommand,240mode(-mode)option,69Modeargument,452modeparameters,129Modereplayoption,44MODE_STATUScolumn,392modify_baseline_window_sizeprocedure,218modify_snapshot_settingsprocedure,219MONDAY_WINDOWschedulewindow,106monitoringadaptivecursorsharing,174ASMpreferredreads,375DRCP,143flashbackdataarchives,120memoryallocation,103–104Mountattribute,411mountoperation,361,379/mount_point/app/directory,2MOUNT_STATUScolumn,392MTTR(meantimetorecovery),88585INDEXFinditfasterathttp://superindex.
apress.
commulticolumnstatisticscreating,199–200deleting,201gathering,200–201newfeatures,197–201multisectionbackups,274–276Nnamechanges,backgroundprocess,357nameparameter,40namedarguments,infunctioncalls,451Namesparameter,transaction_backoutprocedure,124NAS(network-attachedstorage),361NationalElectricalManufacturersAssociation(NEMA),561nativecompilation,446,508nativevalue,168nativecompileoption,510NEMA(NationalElectricalManufacturersAssociation),561net_timeoutattribute,431NET_TIMEOUTattributes,usinghistogramsfor,430net_timeoutparameter,430networkdata,compressing,156networkinterfacecard(NIC)bonding,413network-attachedstorage(NAS),361network-awaredatabaseduplication.
Seeactivedatabaseduplicationnevervalue,db_securefileparameter,526newvalue,STATUScolumn,185newdgoption,402newDonRec_t()function,473newlysupportedtables,identifying,357NIC(networkinterfacecard)bonding,413nls_timestamp_formatprocedure,350command,511nounregisterclause,301no_result_cachehint,177nocacheoption,518nocascadeoption,transaction_backoutprocedure,124nocascade_forceoption,transaction_backoutprocedure,124nodgoption,402nofilenamecheckclause,291noforceoption,377nokeepoption,280nologgingoption,527nonconflict_onlyoption,transaction_backoutprocedure,124nonevalue,PARTITION_OPTIONSparameter,326norepairoption,380NOSALToption,523notbackedup,2timesclause,286notnullconstraint,151nowaitparameters,129NUM_FRESH_PCT_PARTITIONScolumn,529NUM_FRESH_PCT_REGIONScolumn,529NUM_PCT_TABLEScolumn,529NUM_STALE_PCT_PARTITIONScolumn,529NUM_STALE_PCT_REGIONScolumn,529NUMBERdatatype,447numtoymintervalfunction,547Numtxnsparameter,transaction_backoutprocedure,124OOBJECT_NAMEcolumn,531ObserverConnectIdentifierproperty,442OCIclientcache,189OCIconsistentclientcache,175enabling/disabling,190mechanicsof,189–190newfeatures,188–190OCI_ATTR_ACCESS_BANNER,263OCI_ATTR_AUDIT_BANNER,264oci_attr_default_lobprefetch_sizevariable,527OCI_NO_RESULT_CACHEmodevalue,190OCI_RESULT_CACHEmodevalue,190oci_result_cache_max_rset_rowsparameter,190oci_result_cache_max_rset_sizeparameter,190oci_result_cache_max_sizeparameter,190586INDEXOCISessionGet()method,142OCISessionPoolCreate()method,507OCIStmtExecute()mode,190OCM(OracleConfigurationManager),3,4,74ODM(OracleDiskManager),410OEMDatabaseControl,160OFA(OptimalFlexibleArchitecture),1offlineattack,234offline_capablecolumn,82ojvmjavatool,511,512ojvmtctool,512–513OLTP(onlinetransactionprocessing),153OLTP(onlinetransactionprocessing)tablecompression,154–155OMF(OracleManagedFiles)filesystem,310ONCOMMIToption,490onlineapplicationmaintenance,150–152onlinedatabasepatching,55onlinedatabasepatching(emergencyhotpatching),55onlineindexes,150onlineoption,391onlinetransactionprocessing(OLTP),153onlinetransactionprocessing(OLTP)tablecompression,154–155open_modecolumn,423OPEN-FORstatement,465operatingsystemcommandline,37OPERATIONcolumn,531optimalflexiblearchitecture,2–3OptimalFlexibleArchitecture(OFA),1optimizerstatisticscollectionadaptivebaselinemetricthresholds,221ADDM,214–217advisorfindings,215DBMS_ADDMpackage,216–217instanceanddatabase,214runningoverspecifictimeperiods,214specifyingtypeoftask,215AWRbaselines,217–219baselinetemplates,219expressionstatisticsforfunctionsandexpressions,201–202multicolumnstatistics,197–201creating,199–200deleting,201gathering,200–201newfeatures,197–221pendingstatistics,204–206privatestatistics,205–206SPM,207–214capturingbaselines,208–209displayingbaselines,211evolvingbaselines,210–211managingbase,212–213managingbaselines,213–214selectingbaselines,209–210statisticspreferences,202–203optimizer_capture_plan_baselinesparameter,208optimizer_capture_sql_plan_baselinesparameter,12optimizer_features_enableparameter,51optimizer_private_statisticsparameter,13optimizer_use_invisible_indexesparameter,13,131optimizer_use_private_statisticsparameter,204optimizer_use_sql_baselinesparameter,13optimizer-relatedparameters,12–13Optionsparameter,transaction_backoutprocedure,124ORA$AUTOTASK_SUB_PLANresourceplan,107$ORA_CRS_HOME/installdirectory,32ora_hashfunction,349ORA-00000returncode,441ORA-16646returncode,441ORA-16666returncode,441ORA-16817returncode,441ORA-16819returncode,441ORA-16820returncode,441ORA-16829returncode,441OracleAdvisedRecovery,95OracleApplicationExpress(APEX).
SeeApplicationExpressOracleAuditVault,259587INDEXFinditfasterathttp://superindex.
apress.
comOraclebaselocation,choosing,2OracleCallInterface,security,261–264badpackets,262databaseconnections,262–263databasereleaseinformationdisplay,263–264serverconnectionattempts,263unauthorizedaccess,264OracleClusterware,26–34preparationforupgrade,27preupdate.
shscript,27–28runInstaller,28–34OracleConfigurationManager(OCM),3,4,74OracleDataGuard,26OracleDataMiningoption,3OracleDataPump,505OracleDatabase,1–56backup.
.
.
keepcommandin,276–277installing,6–8newfeaturesindatabasecreation,8–17patching,53–55inserverinstallation,2–6patching,53–56RealApplicationTestingfeature,35–53DatabaseReplay,35–46SPA,47–53upgradingto,17–34compatibilityfactor,18withDBUA,24–25downgrading,25–26OracleClusterware,26–34performancetesting,25rollingupgradeenhancements,26upgradepath,18–24virtualprivatecatalogsinearlierreleases,307OracleDirectNFS,410–413disabling,413NICbonding,413performance,413settingup,410–412validating,412OracleDiskManager(ODM),410OracleEnterpriseManager,39OracleHotStandby,415OracleKerberos,261OracleManagedFiles(OMF)filesystem,310OracleMultimedia,561–563DICOMsupport,561–562imageprocessing,562ORDDICOMtype,562SecureFilessupport,562–563OraclePatchPrerequisiteCheckerpage,55OracleRealApplicationCluster(RAC)environment,61OracleRealApplicationTesting,4OracleScheduler,359OracleSQLDeveloper,4OracleStreams,337–359combinedcaptureandapply,342–344DBMS_COMPARISONpackage,348–353comparison,349–350comparisonmaintenance,350–351convergingshareddatabaseobjects,352–353recheckingpriorcomparison,351–352requirements,348supporteddatabaseobjecttypes,348destinations,354–355identifyingminimumrequiredcheckpointSCN,357–359backgroundprocessnamechanges,357supportforOracleScheduler,359supportfortransparentdataencryption,358supportforXMLTypevaluesasCLOBs,358overview,337–338StreamsPerformanceAdvisor,344–345synchronouscapture,338–342configuring,339–341DBAviewsfor,341dropping,341restrictionson,338–339topology,345–347588INDEXusabilityimprovements,355–357automatedalertsforclientsandthresholds,356–357identifyingnewlysupportedtablesview,357messagetracking,355–356OracleUniversalInstaller,2OracleWallet,240–242OracleWarehouseBuilder,4OracleXMLDB,493–500FTPfor,494HTTPfor,494in-placeschemaevolution,499–500settingupservlet,494–495validatingPL/SQLwebservice,497–499XMLDBwebservice,495–497OracleXMLDBoption,4oracle_baseenvironmentvariable,370ORACLE_BASEenvironmentalvariable,61$ORACLE_BASE/admin/$ORACLE_SIDdirectories,59$ORACLE_BASE/cfgtoollogs/dbua/logsdirectory,370$ORACLE_BASE/diagdirectory,3$ORACLE_BASE/diag/rdbms/$INSTANCE_NAME/$ORACLE_SID/alertdirectory,59$ORACLE_BASE/diag/rdbms/$INSTANCE_NAME/$ORACLE_SID/tracedirectory,59ORACLE_DATAPUMPdriver,329ORACLE_HOMEdirectory,366ORACLE_HOMEparameter,503$ORACLE_HOME/apexdirectory,505$ORACLE_HOME/bindirectory,367$ORACLE_HOME/dbsdirectory,410$ORACLE_HOME/libdirectory,413$ORACLE_HOME/logvalue,61$ORACLE_HOME/rdbms/admindirectory,19$ORACLE_HOME/rdbms/admin/dbmscmp.
sqlfile,349$ORACLE_HOME/rdbms/admin/utlpwdmg.
sqlfile,235ORACLE_LOADERdriver,329ora:containsXPathfunctions,487/oradataDirectNFSmountpoint,412/oradata/DBATOOLS/directory,400oranfstabfile,410orapwpasswordfile,232oratabfile,367orawsvkeyword,495orawsvservlet,495orcldatabase,3orclinstance,10ORDAUDIOdatatype,561ORDDICOMtype,562ORDDOCdatatype,561orderbyclause,534ORDER_CATEGORYcolumn,544ORDER_DETAILtable,545ORDER_HEADERcolumn,544ORDER_KEY,482orderingaccesscontrollists(ACLs),256–257ORDIMAGEdatatype,561ORDVIDEOdatatype,561origincolumn,213originalplanbaseline,210osasmgroup,363–366osasmoperatingsystemgroup,5osasmUnixgroup,366osdbagroup,366osopergroup,366OUTargument,462override_priorityprocedure,110owmutility,242ownnameargument,199Pp_compressionparameter,334p_compression=>'enabled'parameter,333p_encryptionparameter,333p_encryption=>'enabled'parameter,333P_PLSQLpartition,327p_plsql.
dmpfile,327pack_stgtab_sqlsetprocedure,50PackageDetailspage,77package.
functionfile,323589INDEXFinditfasterathttp://superindex.
apress.
comPACKAGE.
FUNCTIONpackage,498package.
function_namevalue,323packagingincidents,70–73PAM(PluggableAuthenticationModules),54PARALLELoption,331parameter_value_convertclause,291PARAMETERSclause,483PARAMSargument,83ParchPrerequisiteCheckfeature,53parse_REvariable,449partialanalysisADDM,214PartitionAdvisor,539–544partitionbyreference(foreign_keyname)keyword,544partitionbysystemclause,559partitionchangetracking(PCT),528–529partitionmanagement,100PARTITION_OPTIONSparameter,326PARTITION_OPTIONS=DEPARTITIONoption,328partitioning,538–561exporting/importingpartitions,326–328extendedcomposite,552–555list-hash,552list-list,553list-range,553range-range,554–555interval,546–552PartitionAdvisor,539–544pruningcapabilities,561reference,544–546SQLAccessAdvisor,195system,559–561virtualcolumn-based,556–558passwordfileclause,290passwordoption,320password_verify_functionprofile,236PASSWORD_VERSIONScolumn,231–232,264passwordscasesensitivity,230–234changingdatabaseaccount,237–239changingdefaults,232–233creatingverificationfunction,235–236hashalgorithm,226PatchAdvisorpage,54PatchCachepage,55Patchrecommendationsbyfeature,55patchsets,53patching,53–56ChangeManagementPack,56cloning,56emergencyhotpatching(onlinedatabasepatching),55newfeatures,53–55Pathattribute,411pathsubsetting,492–493pathtable,482PATHTABLEoption,483PATHIDcolumn,482PATHIDpathindex,482PATHSoption,492PaymentCardIndustry(PCI),225PCI(PaymentCardIndustry),225PCT(partitionchangetracking),528–529PEND_TABLE_NAMEcolumn,491pendingstatisticsdeleting,206makingavailabletooptimizer,204–205newfeatures,204testing,206PerformRecoverypage,95performancecomparison,46performancedivergence,46performancemanagement,167–223AutomaticSQLTuningAdvisortasks,190–197DatabaseControl,222–223optimizerstatisticscollection,197–221PL/SQLperformance,168–174resultcachingfunctionality,175–190PerformancePageSettingspage,222Performancetab,155performancetesting,upgradetoOracleDatabase,11g,25permittedvalue,db_securefileparameter,526pfileparameter,291PGA(programglobalarea),8590INDEXpga_aggregate_targetinitializationparameter,9pga_targetparameter,100PHPsupport,507–508physicalpackage,71physicalstandbyactivedatabaseduplication,416–418convertingtologicalstandby,427–428convertingtosnapshotstandby,425detectinglost-writeconditionsusing,443lost-writedetection,97–98usingforrollingupgrades,426–432blockchangetracking,428–429convertingtologicalstandby,427–428fast-startfailoverforMaximumPerformancemode,432preparingprimarydatabase,426redologs,428–430RMAN,429usinghistogramsforNET_TIMEOUTattributes,430pivot(expression)asAliassyntax,534pivotoperation,533pivotoperators,532–537pivotxmlkeyword,535pivot_in_clauseoperation,535planbaselines,207plan_retention_weeksparameter,212PLAN_TABLEcolumn,531PLS_INTEGERdatatype,446PL/SQL,445–469CONTINUEstatement,445cross-sessionfunctionresultcache,458–462dynamicsymmetry,465–469FORALLstatements,463–465functioncalls,451generalizedinvocation,455–457nativecompilation,446regularexpressions,449–451sequenceswithoutdual,446SIMPLE_INTEGERdatatype,446–449subprograminlining,451–454plsqldirectory,9PL/SQLfunctionresultcache,175enabling,187example,187–188newfeatures,186–190OCIconsistentclientcache,188–190PL/SQLnativecompilationparameter,9–10PL/SQLpackages,17PL/SQLperformanceadaptivecursorsharing,172–174automaticnativecompilation,168–171recompilingdatabasesfor,170–171settingup,169–170using,168–169DMLtriggers,172newfeatures,168–174plsql_codetypeparameter,168plsql_code_typecolumn,170plsql_code_typeinitializationparameter,9plsql_code_typeparameter,169plsql_function_tobject,457plsql_native_library_dirinitializationparameter,9plsql_native_library_sbdir_countparameter,9plsql_optimization_levelinitializationparameter,190PLSQL_OPTIMIZE_LEVELallowedvalues,454PLSQL_OPTIMIZE_LEVELparameter,452plsql_procedure_tobject,457plsql_subprogram_tobject,457plsql_subprogram_tprint_doc()memberprocedure,457PluggableAuthenticationModules(PAM),54PLW-05011warningcode,454PLW-06004warningcode,454PLW-06005warningcode,454PolicyGroupEvaluationErrorspage,158PolicyGroupEvaluationResultspage,158PolicyGroupLibrarypage,158PolicyGroupslink,158PolicyTrendOverviewscreen,247poly_order_headersfunction,468POLY_ORDER_HEADERStable,465591INDEXFinditfasterathttp://superindex.
apress.
compool_nameprocedure,141pooledserver,139Post-UpgradeStatusTool,24pragmainlinedirective,190pragmaINLINEdirective,452,453pragmaINLINE()method,450precedingclause,150predicatestring(-p)option,69PreferredReadFailureGroups,375preferredreads,ASM,374–395AUsizes,385–386diskgroupattributes,381–385fastmirrorresync,389–395monitoring,375RDBMScompatibility,386–389restrictedmode,376–381settingup,374–375PREFERRED_READcolumn,375prepare_replayprocedure,44prependjarnamesoption,508,510preprocessingworkload,41preserveclause,138preserve_commit_orderparameter,434PRESERVE_ENCRYPTIONapplyparameter,358preservingrestorepoints,138preupdate.
shscript,27,28Pre-UpgradeInformationTool,22preventativemechanism,207previewoption,91primarydatabase,435primarykeyconstraintrelationship,123principalparameter,250print_doc()method,457privatecachedfunction,462privatestatistics,collecting,205–206privilegeparameter,250proactivechecks,81ProblemDetailpage,76problemkey,60problems,57,60missingdatafile,repairing,92–94resolvingwithSupportWorkbench,74–78procedureinlining,190process_captureprocedure,41proddatabase,10product_descriptionsparameter,202product_descriptionstable,205programglobalarea(PGA),8ProvisioningPack,54PROXY_SIDcolumn,343PROXY_SERIALcolumn,343pruning,partition,561PUBLICobject,495publicstatistics,204publishpoints,195publishsettings,205publish_pending_statisticsprocedure,206publish_pending_statsprocedure,204publishedvalue,STATUScolumn,185purgeallclause,117PURGE_TIMEparameter,351put_fileprocedure,362Qq_nameparameter,181QUANTITY_RENTEDcolumn,534queryrewritecommand,530queryrewrites,materializedview,530–532query_rewrite_integrityinitializationparameter,530queryingaccesscontrollists,254–256queue_nameargument,340quickpackaging,77quotaparameter,116RRAC(RealApplicationCluster),10,61,167RANDOMfunction,234RC_BACKUP_DATAFILEview,276RC_BACKUP_SETview,276RCBG(resultcachebackground),16rcpcommand,398rcp/rshprocess,415RDBMScompatibility,386–389rdbmsdirectory,3reactivechecks,81reactivemechanism,207readonlyclause,altertablestatement,133592INDEXreaderfarm,421read-onlytables,133RealApplicationCluster(RAC),10,61,167RealApplicationTestingfeatureDatabaseReplay,35–46SQLperformanceanalyzer,47–53analyzingworkload,51capturingworkload,49–50comparingperformance,51–53creatingtasks,50–51real-timequerystandby,418–421designing,421starting,419validating,419–421REASONcolumn,356REBUILDcommand,493recheckfunction,351recompilingdatabases,forautomaticnativePL/SQLcompilation,170–171recover.
.
.
blockcommandpreconditionsforusing,266–267recoveringallcorruptdatablocks,268–270recoveringspecificcorruptdatablocks,267–268recovercommand,310recovercorruptionlistcommand,268recoverycatalogs,299–307merging,299–302movingtootherdatabases,302resynchronizing,310virtualprivatecatalogs,302–307creating,303–306dropping,307inearlierOracleDatabasereleases,307managing,306–307recoverypointobjectives(RPOs),424redologscompressingdata,429–430transportmechanism,428RedoCompressionproperty,442redundancyattribute,381REF_PTN_CONSTRAINT_NAMEcolumn,545Referenceelement,492referencepartitioning,128,544–546refreshmechanism,materializedview,529–530REGEXP_COUNT()method,449REGEXP_INSTR()method,449REGEXP_SUBSTR()method,449registerdatabaseclause,306registerprivilege,306registeringphysicalstandbydatabaseswithRMAN,429regularexpressions,449–451rejectlimitclause,329RelatedLinkssection,158–159relies_onclause,187RELIES_ON()procedure,459,462remapcommand,409remap_connectionprocedure,42REMAP_DATAparameter,323,324remap_ssnfunction,324REMAP_TABLEoption,325remappingdata,323–325tables,325remove_window_group_memberprocedure,108removingstandbysites,309statisticspreferences,203rename_baselineprocedure,220renamingbaselines,220standbysites,309RENTAL_TYPEsubquery,537repairfailurecommand,86repairoperation,348repairpreviewcommand,91REPAIR_TIMERcolumn,391repairingfailures,91–92missingdatafileproblems,92–94repairs,81repeat_intervalspecification,490rep.
jarfile,512593INDEXFinditfasterathttp://superindex.
apress.
comreplayfiles,41replaymode,43ReplaySpeedreplayoption,44replay_connectionparameter,43replay_dirparameter,42replay_nameparameter,42replay_reportprocedure,45replay_typeparameter,45replayingworkloadanalysis,44–46initializingreplaydata,42preparingfor,43–44remappingexternalconnections,42–43resolvingexternalreferences,42startingreplayclients,43reportfailurecommand,91reportschemacommand,308report_analysis_taskparameter,52reportsgeneratingwithflashbackdataarchives,122SPA,52–53repositoryevents,475Requestorelements,492resetlogsoption,98resolveoption,250resolveprivileges,252restorecommand,310restorecontrolfilecommand,309restorepointoption,276restorepoints,137–139creatingarchivalbackupswith,139creatingasofSCN,137–138creatingasoftimestamps,137–138preserving,138restore_defaultsprocedure,142restoringarchivalbackups,280–281backupcontrolfilestostandby,309restrictedmode,376–381diskgroupchecks,380–381diskgroupmaintenance,377–379restrictedstart-upoption,376resultcache,10resultcachebackground(RCBG),16resultcache-relatedparameters,10–11resultcachingfunctionalityenhancingperformancewith,175–184examples,180–184SQLqueryresultcache,175–178viewingwithexplainplan,179–180intraunitinlining,190managing,185–186newfeatures,175–190PL/SQLfunctionresultcache,186–190enabling,187example,187–188OCIconsistentclientcache,188–190result_cacheclause,187result_cachehint,177RESULT_CACHEkeyword,458result_cacheoperator,182result_cacheoptimizerhint,181result_cacheoption,187result_cache_max_resultparameter,178result_cache_max_sizeinitializationparameter,175result_cache_max_sizeparameter,176result_cache_modeparameter,10,176result_cache_remote_expirationinitializationparameter,178result_cache_sizeparameter,103ResultCacheoperator,176resynchronizingrecoverycatalogs,310retentionparameter,116retentionperiod,113returning_typeattribute,457REUSE_DUMPFILEoption,322reusingdumpfiles,322revokecatalogcommand,306revokecommand,306reysnccatalogcommand,310RMANandASM,362integrationwithDataGuard,307–311,429backupfileaccessibilitygroups,310–311blockchangetrackingsupport,311configuringRMANwithoutdatabaseconnections,308–309594INDEXrestoringbackupcontrolfiletostandby,309resynchronizingrecoverycatalogs,310managingDRAthrough,89–95DatabaseControl,95repairadvice,90–91repairingfailures,91–92repairingmissingdatafileproblems,92–94viewingfailures,89registeringphysicalstandbydatabaseswith,429rmancommand,307RMANmanagementarea,270–288archival(long-term)backups,276–281backup.
.
.
keepcommand,276–277creating,278–280overview,277–278restoring,280–281archivedredologdeletionpolicies,286–287archivedredologfailoverfeature,287–288backupshredding,288configurationparameters,273–274multisectionbackups,274–276optimizedbackingupofundodata,288substitutionvariables,270–272validatecommand,281–284options,284sectionsizeclause,283–284validatingwith,282–283RMANvalidatecommand,88rman11recoverycatalog,301rollingupgrades,26,371–373enabling,372step-by-stepapproach,372–373usingphysicalstandbyfor,426–432blockchangetracking,428–429convertingtologicalstandby,427–428fast-startfailoverforMaximumPerformancemode,432preparingprimarydatabase,426redologs,428–430RMAN,429usinghistogramsforNET_TIMEOUTattributes,430rootupgradescript,32row-levelsecurity(VPD),435RPOs(recoverypointobjectives),424rule_set_nameargument,340run_checkprocedure,82run_modecolumn,85runInstaller,6,28–34runjavacommand,511runjava()function,509runjavaoption,510runjavaserver_file_systemcommand,511RUNNAMEargument,83SSflag,396soption,397SALARYcolumn,556saleshistory(SH)database,233SALToption,523SALTvalue,226Sarbanes-Oxley(SOX),225SCAN_IDparameter,351SCAN_MODEparameter,349SCAN_PERCENTparameter,349SchedulerCentralpage,159schemaname.
table_name.
column_namevalue,322Schematab,156SCN(systemchangenumber),137–138scpcommand,398scripts,usingadrcicommand-linetoolin,64sec_*initializationparameters,261SEC_CASE_SENSITIVE_LOGONinitializationparameter,230SEC_MAX_FAILED_LOGIN_ATTEMPTSinitializationparameter,263sec_max_failed_login_attemptsparameter,12SEC_PROTOCOL_ERROR_FURTHER_ACTIONdatabaseinitializationparameter,262SEC_PROTOCOL_ERROR_TRACE_ACTIONdatabaseinitializationparameter,262SEC_RETURN_SERVER_RELEASE_BANNERcontrol,263595INDEXFinditfasterathttp://superindex.
apress.
comSEC_USER_UNAUTHORIZED_ACCESS_BANNERparameter,264secondaryindexes,487–489sectionparameter,52sectionsizeclause,283–284sectionsizecommand,275sectionsizeoption,87sectionsizevalues,275SECTION_SIZEcolumn,276SecureConfigurationoption,15SecureHashAlgorithm(SHA-1),225secureshell(SSH),290SECURE_DOCStable,516SECURE_DUP_MEDIUMtable,523SECUREFILEoption,477SecureFilesversusBasicFiles,516–517compression,523–525db_securefileinitializationparameter,525–526DBMS_LOB.
SETOPTIONSstoredprocedure,522deduplication,518–522encryption,522–523migratingfromBasicFilesto,526–527performance,517–518prefetching,527requirements,516supportforinOracleMultimedia,562–563SecureFiles-relatedparameter,11security,225–264EnterpriseDatabase,225–239databaselinks,233–234defaults,226–229delayedfailedlogins,229industryrecommendations,230–231PASSWORD_VERSIONScolumn,232,264passwords,226–239upgradeimplications,231EnterpriseManager,244–248PolicyTrendOverviewscreen,247tablespaceencryption,245–247TDE,245OracleCallInterface,261–264badpackets,262databaseconnections,262–263databasereleaseinformationdisplay,263–264serverconnectionattempts,263unauthorizedaccess,264OracleKerberos,261overview,225sysdbastrongauthentication,261tablespaceencryption,239–244caveats,242OracleWallets,240–242UTL_*networkaccesspackages,248–260control,249–257DataPumpencryption,258LOBencryption,258OracleAuditVault,259RMANbackupshredding,258RMANvirtualprivatecatalogs,258sysasmprivilegeforASM,258TDE,258–260security-relatedparameters,12SELECTANYDICTIONARYrole,234selectanytransactionprivilege,123SELECTclause,481selectdbms_result_cache.
statusfromdualprocedure,185selectdistinctrental_typefromrental_typesquery,536selectforupdatestatement,133SELECTstatement,131,446SELECT_CATALOG_ROLErole,234Serverattribute,411serverconnectionattempts,settingmaximumnumberof,263serverinstallation,2–6components,4installoptions,3–4optimalflexiblearchitecture,2–3privilege,5–6role,5–6serverresultcache,175Servertab,156,157–158596INDEXserver_file_systemoption,512sessionpurityattribute,142session-levelcaching,177setclause,293setdbidcommand,308setencryptioncommand,288seterrorloggingcommand,148sethomepathcommand,65setparameter,291set_attributeprocedure,109set_debugprocedure,314set_default_task_parameterprocedure,215set_global_prefsprocedure,202set_message_trackingprocedure,355set_pi_resourcesprocedure,110set_table_prefsprocedure,204set_up_queueprocedure,338setoptionsprocedure,522setPropertiesmethod,562SETTINGcolumn,434sftp/scpprocess,416SGA(sharedglobalarea),8sga_max_sizeparameter,104sga_targetinitializationparameter,9sga_targetparameter,101SH(saleshistory)database,233shschema,198SHA-1(SecureHashAlgorithm),225shareddatabaseobjects,143,352–353sharedexclusivelocks(SX),150sharedglobalarea(SGA),8shared_pool_sizeparameter,101SH.
CUSTtable,316showalertcommand,67showalert-tail,68,100commandshowallcommand,273showbasecommand,64showcommand,308SHOWcommand,428showconfigurationverbosecommand,440showfast_startfailoverinterface,439showfast_startfailoverstatuscommand,440showhm_runcommand,83showhomepathcommand,65showhomescommand,65showincidentcommand,60showparametermemorycommand,103showreportcommand,84showtracefilecommand,65shredding,backup,288shrinkspaceclause,134shrinkingtemporarytablespace,134–135SI_DEMOpackage,448simpletriggers,470SIMPLE_INTEGERdatatype,446–449site_nameclause,308skip_constraint_errorsoption,329SMCO(spacemanagementcoordinator),16snapshotstandby,415,421–426SNAPSHOT_STANDBY_REQUIRED_prefix,424SoftwareandSupporttab,156SoftwareLibraryfeature,53SOX(Sarbanes-Oxley),225SPA.
SeeSQLPerformanceAnalyzerspacemanagementcoordinator(SMCO),16space_budget_percentparameter,212space.
sqlscript,520SpecifyHomeDetailspage,28sperrorlogtable,148spfileclause,290–292spfileparameter,291spfile.
.
.
parameter_value_convert'string_pattern'option,292spfile.
.
.
set'string_pattern'option,292split_streamsprocedure,354splittingstreams,354SPM.
SeeSQLPlanManagementspnc_commandsfile,9spoolcommand,68SQLAccessAdvisor,195–197SQLApply,logicalstandby,432–437archivelogstorage,436–437DBMS_SCHEDULERscheduler,435dynamicallysettingparameters,434eventmessages,437FGA,435TDE,433VPD,435597INDEXFinditfasterathttp://superindex.
apress.
comSQLmanagementbase,13SQLPerformanceAnalyzer(SPA),1,25,35,47–53analyzing,51capturingworkload,49–50comparingperformance,51–53creatingtasks,50–51SQLplanbaselineevolutionphase,208SQLPlanManagement(SPM),25,167baselinescapturing,208–209displaying,211evolving,210–211managing,213–214selecting,209–210managingbase,212–213newfeatures,207–214SQLqueryresultcacheadministering,176–178newfeatures,175–178SQLRepairAdvisor,77,78–80SQLTestCaseBuilder,96SQLTuningAdvisor,211SQLtuningset(STS),49–50SQLWorksheet,159SQL*Plus,147–150BLOBsupport,150defaultsettingsinexecutable,149errorlogging,147–149sqlnet.
orafile,240sqlnet.
oraparameter,261sqlset_ownerparameter,49SSH(secureshell),290StagePatchlink,54StagePatchpage,55stagetabtable,50staleindex,489STALEvalue,490stale_percentparameter,202stale_toleratedinitializationparameter,530standbycontrolfiles,restoringbackupcontrolfilesto,309standbysites,308–309start_captureprocedure,40start_dateparameter,250start_poolprocedure,141start_replayprocedure,44startupcommand,18startuprestrictcommand,366STATEcolumn,344statisticspreferences,202–203STATUScolumn,185stop_poolprocedure,140storageclause,243storage/performancegains,154storeassecurefilekeyword,516storeinclause,551streampath,345STREAM_NAMEargument,341Streamsmanagement,100streamsmerging/splitting,354StreamsPerformanceAdvisor,344–345Streams_trackingdefaultlabel,355strippingattribute,381stronghashalgorithm,226STS(SQLtuningset),49–50sts_nameattribute,197subprograminlining,451–454substitutionvariables,RMAN,270–272SUGGESTED_ACTIONcolumn,356SUMMARYcolumn,92SUM(QUANTITY_RENTED)subquery,537SUNDAY_WINDOWschedulewindow,106supplementallogging,123SupportWorkbench,73–80homepage,73–74resolvingproblemswith,74–78SQLRepairAdvisor,78–80SupportWorkbenchfacility,63switchcommand,420SX(sharedexclusivelocks),150symboltable,154sync_docs_capturecapture,340,341SYNC_DOCS_RULE_SETrules,341synchronizationmode,44synchronizationparameter,44598INDEXsynchronouscapture,338–342configuring,339–341DBAviewsfor,341dropping,341restrictionson,338–339sysdatabase,259SYS_CONTEXT()clause,462SYS_DEFAULT_CONNECTION_POOLdefaultconnectionpool,141SYS71294_EDBA_PO_XM_PATH_TABLEview,486/sys/aclsdirectory,250/sys/acls/dba.
xmlfile,253sysasmprivilege,149,258,363–366sysasmrole,361sysasmsystemprivilege,5SYS.
AUD$table,228sysdbaconnection,261sysdbapassword,289sysdbaprivilege,5sysdbarole,231sysdbastrongauthentication,261sysoperconnection,261sysoperprivilege,364sysoperrole,231systemchangenumber(SCN),137–138systemdatabase,259systempartitioning,559–561system_moving_windowbaseline,167system_moving_windowwindow,218SYSTEM.
LOGSTDBY$EVENTStable,437System.
out.
println()function,509systimestamp-interval'60'minuteexpression,121TTflag,396toption,397table_exportobject,314tablesaddingvirtualcolumnsto,126–127creatingwithvirtualcolumns,126encrypting,433explicitlockingof,128–129read-only,133remapping,325tablespaceencryption,239–244caveats,242withDatabaseConsole,245–247OracleWallet,240–242tablespaces,encrypting,433tagoverlaglimitvalue,443tagunderlaglimitvalue,443tailcommands,68tailoption,68tarcommand,290TDE.
SeeTransparentDataEncryptiontemptablespace,135templatedictionaryviews,220TEMPLATEINFOsection,401temporaryarchivalbackup,279temporarytablespacemanagement,133–136shrinking,134–135specifying,135–136test()procedure,448TEST()procedure,459test_executeparameter,51testingpendingstatistics,206textnodelimits,505text-basedpersistence,476think_time_auto_correctparameter,44ThresholdConfiguration,159ThresholdType,221thresholds,automatedalertsfor,356–357ThroughputChartSettings,222timecommand,229Timehintparameter,transaction_backoutprocedure,124TIMEOUTargument,83TIMESTAMPWITHTIMEZONEformat,250timestamps,creatingrestorepointsasof,137–138timexcommand,229/tmpdirectory,68/tmp/kb2.
dbffile,328tnsnames.
orafile,416toappliedonstandbyclause,287toshippedonallstandbyclause,287599INDEXFinditfasterathttp://superindex.
apress.
comtoshippedonstandbyclause,287to_number(VALUE)clause,487tracefiles,inADRhomepath,68TRACEparameter,262tracesubdirectory,62trackingmaintenancejobruns,109–110TRANSACTION_BACKOUT,124–125TransparentDataEncryption(TDE),358withDataGuard,259withDatabaseConsole,245encryptingcolumns,433encryptingtables,433encryptingtablespaces,433withHSMs,259–260withLogMinersupport,258transparentdataencryption(TDE)feature,239transparentencryptionmode,320TRANSPORT_DATAFILESoption,328TRANSPORTABLEoption,326TRANSPORTABLE=ALWAYSoption,326transportingSTS,50transport-offmode,439transport-onmode,439triggers,469–474compound,469–474DISABLEDkeyword,469ENABLEDkeyword,469FOLLOWSclause,469U%Uparameter,279udumpdiagnosticdirectory,3unauthorizedaccess,264undodata,optimizedbackingupof,288undotablespace,17undo_managementinitializationparameter,17UNDO_SQLcolumn,122unionallcommand,529UNITcolumn,434unpack_stgtab_sqlsetprocedure,50unpivotoperators,537–538unregistercommand,309untilclause,289updatestatement,114updatetransaction,113UpgradeAutomaticStorageManagementInstanceradiobutton,368upgradecatalogcommand,301upgrade_setparameter,49upgradingASMmanually,366–367rollingupgrades,371–373usingDBUA,367–370toOracleDatabase11g,17–34compatibilityfactor,18withDBUA,24–25downgrading,25–26OracleClusterware,26–34performancetesting,25rollingupgradeenhancements,26upgradepath,18–24upper_portparameter,252UPPER(SUBSTR())function,487usagereport,177US.
DBAEXPERT.
COMprincipal,261UseAutomaticMemoryManagementoption,16UserDirectedRecovery,95USER$table,234user_dump_destfile,10user_dump_destinitializationparameter,10,59user_dump_destparameter,61USER_TAB_PARITITIONSview,545USER/DBA_ENCRYPTED_COLUMNSview,523USINGclause,243UTL_*networkaccesspackages,248–260control,249–257accesscontrolentries(ACEs),251accesscontrollists(ACLs),250–257assigninghosts,252–253DataPumpencryption,258LOBencryption,258600INDEXOracleAuditVault,259RMANbackupshredding,258RMANvirtualprivatecatalogs,258sysasmprivilegeforASM,258TDEwithDataGuard,259withHSMs,259–260withLogMinersupport,258UTL_FILEpackage,248UTL_HTTPpackage,248UTL_HTTP.
REQUESTprocedure,252UTL_INADDRpackage,250UTL_SMTPpackage,248UTL_TCPpackage,248utlpwdmg.
sqlscript,235utlu111i.
sqlscript,19utlu111s.
sqlscript,19VV$table,396V$ARCHIVE_DESTview,430V$ASM_ATTRIBUTEview,382V$ASM_CLIENTview,389V$ASM_DISKview,375,391V$ASM_DISK_IOSTATview,375V$ASM_OPERATIONview,391V$ASM_TEMPLATEview,403V$BACKUP_DATAFILEview,276V$BACKUP_SETview,276V$CPOOL_CC_STATSconnectionpooling,143V$CPOOL_STATconnectionpooling,143V$DATABASEview,357V$DATABASE_BLOCK_CORRUPTIONview,267V$DIAG_INFOview,62V$DNFS_CHANNELSview,412V$DNFS_FILESview,412V$DNFS_STATSview,412V$ENCRYPTION_WALLETview,241V$FS_FAILOVER_STATSdynamicview,441V$HM_FINDINGview,85V$HM_RECOMMENDATIONview,85V$HM_RUNview,83V$LOGMNR_CONTENTSview,258V$REDO_DEST_RESP_HISTOGRAMdynamicview,430V$RESULT_CACHE_*view,175V$RESULT_CACHE_DEPENDENCYview,185V$RESULT_CACHE_MEMORYview,185V$RESULT_CACHE_OBJECTSview,179V$RESULT_CACHE_STATISTICSview,185V$SQL_CS_HISTOGRAMview,174V$SQL_CS_SELECTIVITYview,174V$SQL_CS_STATISTICSview,174V$STREAMS_MESSAGE_TRACKINGview,355validatebackupsetcommand,281validatecommand,82options,284sectionsizeclause,283–284validatingwith,282–283validationcombinedcaptureandapply,344OracleDirectNFS,412PL/SQLwebservice,497–499real-timequerystandby,419–421withvalidatecommand,282–283XMLDBwebservice,495–497VALUEcolumn,483variable,456/var/opt/oracle/oratabfile,366verify_function_11Gfunction,235versions_betweenclause,122VIDEO_RENTAL_PIVOT_TABLEtable,537viewingalertlog,66–68failures,89incidents,68–70listofadrcicommands,66RMANconfigurationinformation,308views,Streamstopology,346–347virtualcatalog,258virtualcolumn-basedpartitioning,128,556–558601INDEXFinditfasterathttp://superindex.
apress.
comvirtualcolumns,125–127,200addingtotables,126–127creatingtableswith,126limitationsof,127virtualkeyword,126virtualprivatecatalogs,302–307creating,303–306dropping,307inearlierOracleDatabasereleases,307managing,306–307RMAN,258visible|invisibleclause,129VPD(row-levelsecurity),435Wwaitparameters,129WAW(write-after-write)relationship,123webservicePL/SQL,validating,497–499XMLDB,validating,495–497WEEKEND_WINDOWschedulewindow,106WEEKNIGHT_WINDOWschedulewindow,106WHENclause,445WHEREclause,197,481whereclauses,337window_nameargument,108window_sizeparameter,219workloadanalyzingcapture/replay,44–46capturing,39–41preparingreplayof,43–44preprocessing,41replaying,42SQL,49–51typesofdatacapturedin,39workload_nameattribute,197WR()method,451wrcexecutable,43wrcmode,38write-after-write(WAW)relationship,123XX$SECURITYCLASStable,478XDBWEBSERVICESrole,494XDB$ACLtable,482XDB_WEBSERVICES_OVER_HTTProle,494XDB_WEBSERVICES_WITH_PUBLICrole,495xdbconfig.
xmlfile,493XDK.
SeeXMLdeveloper'skitXMLDB,475–505ACLsecurity,475BinaryXMLType,475–481JSR-170,475Oracle,493–500HTTPfor,494in-placeschemaevolution,499–500settingupservlet,494–495validatingPL/SQLwebservice,497–499validatingwebservice,495–497OracleXMLDB,FTPfor,494repositoryevents,475XDK,502–505OracleDataPump,505textnodelimits,505XMLDifffunction,502–503XMLPatchfunction,503–505XMLIndex,481–493components,481–482maintenance,486–491pathsubsetting,492–493pathtable,482–486secondaryindexes,487–489use,481XQuery,500–502XMLdeveloper'skit(XDK),502–505OracleDataPump,505textnodelimits,505XMLDifffunction,502–503XMLPatchfunction,503–505XMLCastfunction,501–502xmldiffcommand-lineinterface,500602INDEXxmldiffcommand-lineutility,503XMLDifffunction,502,503XMLExistsfunction,500–501XMLIndex,481–493components,481–482maintenance,486–491pathsubsetting,492–493pathtable,482–486secondaryindexes,487–489use,481XMLPatchfunction,502,503–505XMLTYPESTOREASSECUREFILEBINARYXMLsyntax,477XMLTypevalues,supportforasCLOBs,358XMLTYPENAMEparameter,488XQuery,500–502Yyearly_backupscript,271ZZLIBalgorithm,273