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
MAX → Syntax max::= Text description of max See Also: "Analytic Functions" for information on syntax … , semantics, and restrictions Purpose MAX returns maximum value of expr. You can use it as an aggregate … following example determines the highest salary in the hr.employees table: SELECT MAX(salary) "Maximum … . SELECT
Max-Access → not-accessible
Max-Access → read-only Explanation Indicates the number of current associations to this application, for which it is the responder. applInboundAssociations is implemented for the Oracle server. For an Oracle server configured for dynamic single threaded processes, this value is the number of application instances, as retrieved from SESSIONS_CURRENT in V$LICENSE.
Max-Access → read-only Explanation This variable is retrieved directly from the value for PHYSICAL READS in V$SYSSTAT. It increments each time a DB Block is retrieved from the disk subsystem, but is not necessarily equal to the number of I/O requests made to the host operating system, as multiblock I/O may be used. A physical read can be viewed as an SGA Buffer Cache miss, hampering throughput (contention induction)
Max-Access → read-only Explanation Indicates the fully-qualified name of this data file. The value is retrieved from the value of FILE_NAME in DBA_DATA_FILES.
Max-Access → read-only Explanation Indicates the number of times, since database instance startup, that the system requests handles to library objects in this namespace. The value of oraDbLibraryCacheGets is retrieved from the value of GETS in V$LIBRARYCACHE.
Max-Access → read-only Explanation Indicates the number of times, since database instance startup, that non-persistent library objects (like shared SQL areas) have been invalidated. The value of oraDbLibraryCacheSumInvalidations is derived from the value of INVALIDATIONS in V$LIBRARYCACHE.
Max-Access → read-only Explanation The size in kilobytes of the variable-size portion of the SGA as shown in V$SGASTAT.
Max-Access → read-only Explanation The value of this variable is retrieved directly from the LOG_BUFFER parameter of the INIT.ORA file. Indicates the number of bytes allocated to the redo log buffer in the SGA. In a busy system, a value of 65536 or higher would not be unreasonable.
Max-Access → read-only Explanation The value of this variable is retrieved directly from the SHARED_POOL_SIZE parameter of the INIT.ORA file. Indicates the size (in bytes) of the shared pool. The shared pool contains shared cursors and stored procedures. The default is 3.5 Mbytes.
Max-Access → read-only Explanation The value of this variable is retrieved directly from the TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter of the INIT.ORA file. Indicates the number of concurrent transactions allowed per rollback segment. The default is 30.
Max-Access → read-only Explanation Displays the estimated size of this database instance (in rdbmsDbInfoSizeUnits), actually in use for database data. In the Oracle implementation, the value of rdbmsDbInfoSizeUsed is the sum of values in the BYTES field of DBA_DATA_FILES minus the sum of values in the BYTES field of DBA_FREE_SPACE. rdbmsDbInfoSizeUsed should always be less than or equal to rdbmsDbInfoSizeAllocated.
Max-Access → read-write Explanation Displays the textual identification of the contact person for this managed server, together with information indicating how to contact this person. In the Oracle implementation, the value of this variable is retrieved from the SNMP.ORA configuration file.
Max-Access → read-only Explanation Displays the number of transactions (visible to this server) upon which either COMMIT or ABORT operations have been completed since startup of this database server instance. Some database operations, such as read-only queries, may not result in the creation of a transaction. In the Oracle implementation, the value of this variable is the sum of USER ROLLBACKS and USER COMMITS
Max-Access → read-only Explanation Indicates the name of this generic listener, as retrieved from the LISTENER.ORA configuration file.
Max-Access → read-write Explanation Free-form text providing contact information for this managed listener, including name, telephone number, email address, for example. This value is retrieved from the snmp.contact. listener_name parameter of the SNMP.ORA configuration file.
Max-Access → read-write Explanation Indicates the name of the file to which this server writes log information concerning normal events, errors, and possibly periodic statistical dumps.
Max-Access → read-write Explanation Indicates the interval (in centiseconds) at which server statistic counters (a subset of Oracle Names MIB variables) are written to the log file. The default is 0, indicating that no variables are logged.
Max-Access → read-only Explanation Indicates the number of responses of all sorts this server has sent. This variable is a good general indicator of the cumulative load. The number of responses should equal the sum of the requests received.