How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Installation 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
Table of Contents → Changes 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
Checking Installed Oracle Database Contents and Directory Location → Use 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
Table of Contents → Changes 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
Support for Daylight Saving Times → Oracle 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,
Security Considerations for Data Conversion → a 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
Common Language for All Relational Databases → All 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.
Table C-4 Sizing for Database Constructs → 127-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)).
2.1.1 Guideline for Data Modeling → required. Parent topic: Guidelines for Designing Your Application
184.108.40.206 Guideline for Partitioned Objects → For 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
11.5.1 Criteria For Frequency Histograms → histogram 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
220.127.116.11 Guideline for External Tables → marks 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
11.8.2 Criteria for Hybrid Histograms → The 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
5.7.4 Controls for Star Transformation → The 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
2.2.2 Guidelines for Application Rollout → knowledge that you derive from the testing process, the more you realize what is best for the rollout. Parent topic: Guidelines for Deploying Your Application
22.7 Views for Application Tracing → topics: 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
1.3 Prerequisites for SQL Tuning → database architecture and features. For example, not understanding Oracle Database concurrency controls
18.104.22.168 Analogy for the Optimizer → One 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
10.4.1 Sources for Optimizer Statistics → The 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
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