Results for COLLECT


1 to 20 of 350 results. Prev  Next
Results per page:   20  | 40 | 60


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Restrictions on BULK COLLECTThe following restrictions apply to the BULK COLLECT clause: You cannot bulk collect into an … associative array that has a string type for the key. You can use the BULK COLLECT clause only in server … supported in client-side programs. All targets in a BULK COLLECT INTO clause must be collections, as the … emp.sal%TYPE;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Using FORALL and BULK COLLECT TogetherYou can combine the BULK COLLECT clause with a FORALL statement, in which case, the SQL engine bulk … BULK COLLECT INTO enums; The column values returned by each execution are added to the values … ... BULK COLLECT statement in a FORALL statement. Otherwise, you get the error implementation … restriction: cannot use FORALL and

Enterprise Manager Getting Started with the Oracle Standard Management Pack, 9i Release 2 (9.2.0.2)

Post-Installation Configuration

Configuring Oracle Intelligent Agent to Collect DataPerformance Manager and Capacity Planner require the use of the Intelligent Agent data gathering service. For monitoring operating system data, the Oracle Intelligent Agent must be installed on the same node as the operating system you are monitoring. For monitoring other target types, such as databases, the Oracle Intelligent Agent can run on the same node as the target you are monitoring, or it

Enterprise Manager Getting Started with the Oracle Diagnostics Pack, 9i Release 2 (9.2.0.2)

Introduction to Oracle Capacity Planner

Selecting the Classes of Data to Collectperformance data that you want to collect for that target: In collection view, select and connect to … target to show the classes of data you can collect. Select one of the classes for the target. Figure 4 … the classes below the target in the tree view. You can collect data from none, some, or all displayed … sources A data source

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Capacity Planner Messages

VTP-0091: Error getting collect settings.Cause: An error has occurred while attempting to get the collection settings from the Data Gatherer. Action: Retry the operation. If it fails again, contact Oracle Support Services.

Enterprise Manager Getting Started with the Oracle Management Pack for Oracle Applications, 9i Release 2 (9.2.0.2)

Introduction to Oracle Capacity Planner

Selecting the Classes of Data to Collectperformance data that you want to collect for that target: In collection view, select and connect to … target to show the classes of data you can collect. Select one of the classes for the target. Figure 4 … the classes below the target in the tree view. You can collect data from none, some, or all displayed … sources A data source

Enterprise Manager Getting Started with the Oracle Diagnostics Pack, 9i Release 2 (9.2.0.2)

Post-Installation Configuration

Configuring Oracle Intelligent Agent to Collect DataPerformance Manager and Capacity Planner require the use of the Intelligent Agent data gathering service. For monitoring operating system data, the Oracle Intelligent Agent must be installed on the same node as the operating system you are monitoring. For monitoring other target types, such as databases, the Oracle Intelligent Agent can run on the same node as the target you are monitoring, or it

Objects for OLE, 9i Release 2 (9.2.0.2)

Using the PL/SQL Bulk Collect Feature

Using the PL/SQL Bulk Collect FeatureFeedback Using the PL/SQL Bulk Collect Feature This feature enables the selecting bulk of data in single … (\"BEGIN select ENAME bulk collect into:ENAMES from emp; END;\") 'here OraParameter object returns

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Capacity Planner Messages

VTP-0090: Error getting collect options.Cause: An error has occurred while attempting to get the collection options from the Data Gatherer. Action: Retry the operation. If it fails again, contact Oracle Support Services.

Application Developer's Guide, 9i Release 2 (9.2.0.2)

Performance Tuning

Should I collect statistics on my tables?Answer: Yes. Collecting statistics on your tables enables Oracle to do cost-based analysis. This helps Oracle choose the most efficient execution plan for your queries. See Also: \"Optimizing Queries with Statistics\" in this chapter.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05649 Error: duplicate request id in start collect requestCause: An internal error has occurred while attempting to process a historical data file. Action: it may be possible to continue utilizing the Data Gatherer. Save all files in the $OHOME/network/agent/reco directory and contact Oracle Support Services before continuing.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05607 Error: failed to process start collect requestCause: An internal error has occurred while attempting to process a historical data file. Action: it may be possible to continue utilizing the Data Gatherer. Save all files in the $OHOME/network/agent/reco directory and contact Oracle Support Services before continuing.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Retrieving Query Results into Collections with the BULK COLLECT ClauseThe keywords BULK COLLECT tell the SQL engine to bulk-bind output collections before returning them … clauses. Here is the syntax:... BULK COLLECT INTO collection_name[, collection_name]... The SQL … NumTab; -- no need to initialize names NameTab; BEGIN SELECT empno, ename BULK COLLECT INTO enums … CoordsTab; BEGIN SELECT loc

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Capacity Planner Messages

VTP-0110: In order to collect historical data, at least one data item non-key column must be selected.Cause: An attempt was made to create a user-defined class with only one column in the class. This column is used as the key, resulting in no data items in the class. Action: Add at least one other data item to the class for collection.

Administration, 9i Release 2 (9.2.0.2)

Real Application Clusters Management Tools Error Messages

PRKI-2114 \"Cannot collect and verify hardware information for all the nodes. Press abort to exit the…Cause: Failure to connect to the remote nodes while adding a node to a cluster. Failure to collect … use\"). Also, verify the we have permission to start temporary service on remote nodes that will collect VIA information, in case VIA was chosen.

Enterprise Manager Database Tuning with the Oracle Tuning Pack, 9i Release 2 (9.2.0.2)

Collecting the Data

Specifying the Class Data to Collectinformation it needs to collect class data automatically. The selected tuning categories for a tuning session … determine the classes you should collect as well as which class options you should collect. When you … have entered data correctly in a Collect Options dialog box, a check mark is displayed at the

Error Messages, 9i Release 2 (9.2.0.2)

ORA-07500 to ORA-09857

ORA-09834 snyGetPortSet: failed to collect info on a port.Cause: The PORT_STATUS system called failed. Possible operating system error. Action: Contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-23345 table \" string \".\" string \" not registered to collect statisticsthat was not registered to collect statistics. Action: Call DBMS_REPCAT.REGISTER_STATISTICS to register the table.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00432 implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statementsCause: SELECT statement contains both the FORALL and BULK COLLECT INTO phrases. Action: Do not use … FORALL and BULK COLLECT INTO together in SELECT statements.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 22 of 52

Related Topics\"Retrieving Query Results into Collections with the BULK COLLECT Clause\" Copyright © 1996, 2002


Was this page helpful?