You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for FOR


1 to 20 of 12493090 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Fusion Middleware Installation Guide for Oracle JDeveloper - Contents, 11g Release 1 (11.1.1.9)

Fusion Middleware Installation Guide for Oracle JDeveloper - Contents

ContentsInstallation Guide for Oracle JDeveloper 1 Oracle JDeveloper System Requirements 1.1 Recommended … Multiuser Environment 13.3 Configuring Terminal Server Clients for Running Oracle JDeveloper 14 Using … WebLogic Server 14.2 Configuring Oracle WebLogic Server for ADF 15 Oracle JDeveloper Accessibility

Grid Infrastructure Installation and Upgrade Guide for Linux, Release 19c

Table of Contents

Table of ContentsChanges in this Release for Oracle Grid Infrastructure New Features Support for Dry-Run Validation … Using Oracle Fleet Patching and Provisioning Resupport of Direct File Placement for OCR and Voting Disks … Optional Install for the Grid Infrastructure Management Repository Deprecated Features Desupported … for

Database Installation Guide for Linux, Release 19c

Checking Installed Oracle Database Contents and Directory Location

Checking Installed Oracle Database Contents and Directory LocationUse these steps to check the contents and directory location of an Oracle Database installation: Go to $ORACLE_HOME/oui/bin. Start Oracle Universal Installer. $./runInstaller Click Installed Products to display the Inventory dialog box on the Welcome screen. Select an Oracle Database product from the list to check the installed contents. Click Details to find additional information about an installed

Database Installation Guide for Linux, Release 19c

Table of Contents

Table of ContentsChanges in this Release for Oracle Database New Features Root Scripts Automation Support for Oracle … Other Changes 1 Oracle Database Installation Checklist Server Hardware Checklist for Oracle … Database Installation Operating System Checklist for Oracle Database Installation on Linux Server … Configuration Checklist

SQL Language Reference, Release 19c

Data Types

Support for Daylight Saving TimesOracle Database automatically determines, for any given time zone region, whether daylight saving … is in effect and returns local time values accordingly. The datetime value is sufficient for Oracle … to determine whether daylight saving time is in effect for a given region in all cases except … effect. For example,

SQL Language Reference, Release 19c

Data Type Comparison Rules

Security Considerations for Data Conversiona database for execution. Dynamic SQL is frequently associated with the built-in PL/SQL package … dynamically constructed SQL text may be passed as argument. For example: EXECUTE IMMEDIATE 'SELECT … who can explicitly set globalization parameters for a session can decide what text is produced by … sensitive data. See Also: Oracle

SQL Language Reference, Release 19c

SQL Standards

Common Language for All Relational DatabasesAll major relational database management systems support SQL, so you can transfer all skills you have gained with SQL from one database to another. In addition, all programs written in SQL are portable. They can often be moved from one database to another with very little modification.

SQL Language Reference, Release 19c

Oracle Compliance with FIPS 127-2

Table C-4 Sizing for Database Constructs127-2. That standard is no longer published. However, for users whose applications depend on … compliance are listed in Table C-4. Table C-4 Sizing for Database Constructs Database Constructs … approximate numeric column. Note 3: The Oracle limit for the maximum row length is based on the maximum … 4000 bytes: 2(254) + 231 + (999(4000)).

SQL Tuning Guide, Release 19c

SQL Performance Methodology

2.1.1 Guideline for Data Modelingrequired. Parent topic: Guidelines for Designing Your Application

SQL Tuning Guide, Release 19c

Gathering Optimizer Statistics

13.3.2.3 Guideline for Partitioned ObjectsFor partitioned tables and indexes, DBMS_STATS can gather separate statistics for each partition … and global statistics for the entire table or index. Similarly, for composite partitioning, DBMS_STATS … can gather separate statistics for subpartitions, partitions, and the entire table or index. To

SQL Tuning Guide, Release 19c

Histograms

11.5.1 Criteria For Frequency Histogramshistogram buckets (default 254 ). For example, the sh.countries.country_subregion_id column has 8 … database creates frequency histograms from a full table scan. For all other sampling percentage

SQL Tuning Guide, Release 19c

Gathering Optimizer Statistics

13.3.2.5 Guideline for External Tablesmarks statistics on external tables as stale. If new statistics are required for an external table … , for example, because the underlying data files change, then regather the statistics. For external … tables, use the same DBMS_STATS procedures that you use for internal tables. Note that the scanrate … which

SQL Tuning Guide, Release 19c

Histograms

11.8.2 Criteria for Hybrid HistogramsThe only differentiating criterion for hybrid histograms as compared to top frequency histograms is … (default is 254 ). The criteria for top frequency histograms do not apply. This is another way to … frequency or height-balanced histograms. See Also: \" Criteria For Top Frequency Histograms

SQL Tuning Guide, Release 19c

Query Transformations

5.7.4 Controls for Star TransformationThe STAR_TRANSFORMATION_ENABLED initialization parameter controls star transformations. This parameter takes the following values: true The optimizer performs the star transformation by identifying the fact and constraint dimension tables automatically. The optimizer performs the star transformation only if the cost of the transformed plan is lower than the alternatives. Also, the optimizer attempts

SQL Tuning Guide, Release 19c

SQL Performance Methodology

2.2.2 Guidelines for Application Rolloutknowledge that you derive from the testing process, the more you realize what is best for the rollout. Parent topic: Guidelines for Deploying Your Application

SQL Tuning Guide, Release 19c

Performing Application Tracing

22.7 Views for Application Tracingtopics: Views Relevant for Trace Statistics You can display the statistics that have been gathered … 22.7.1 Views Relevant for Trace Statistics You can display the statistics that have been gathered … DBA_ENABLED_AGGREGATIONS Accumulated global statistics for the currently enabled statistics V$CLIENT_STATS Accumulated … statistics

SQL Tuning Guide, Release 19c

Introduction to SQL Tuning

1.3 Prerequisites for SQL Tuningdatabase architecture and features. For example, not understanding Oracle Database concurrency controls

SQL Tuning Guide, Release 19c

Query Optimizer Concepts

4.1.3.3 Analogy for the OptimizerOne analogy for the optimizer is an online trip advisor. A cyclist wants to know the most efficient … calculate the efficiency for each subroute separately. For example, the trip advisor may estimate one … statistics, the better the advice. For example, if the advisor is not frequently notified of traffic

SQL Tuning Guide, Release 19c

Optimizer Statistics Concepts

10.4.1 Sources for Optimizer StatisticsThe optimizer uses several different sources for optimizer statistics. The sources are as follows … the cursor is marked for reparsing, then the optimizer uses actual row counts from the previous

SQL Tuning Guide, Release 19c

Managing SQL Profiles

26.1.2 Concepts for SQL Profiles… SQL Profiles and Execution Plans The SQL profile contains supplemental statistics for the entire … cardinalities. For example, if a SQL profile exists for SELECT * FROM t WHERE x=5 AND y=10, then the … statistics Oracle Exadata Database Machine System Overview Parent topic: Concepts for SQL Profiles