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 AVG


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


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

AVGCORR

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 11 of 177

AVGSyntax avg::= Text description of avg See Also: "Analytic Functions" for information on syntax … , semantics, and restrictions Purpose AVG returns average value of expr. You can use it as an aggregate … AVG(salary) "Average" FROM employees; Average -------- 6425 Analytic Example The following example … manager_id,

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

AVG *CORR *

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Avg. Disk sec/TransferDescription Average Disk Sec/Transfer calculates the average time (in seconds) of a disk transfer. If this value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Avg. Disk sec/WriteDescription Average Disk sec/Write calculates the average time (in seconds) of a data write to the disk. If this value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Avg. Disk sec/ReadDescription Average Disk sec/Read calculates the average time (in seconds) of a data read from the disk. If this value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Avg. Disk Bytes/TransferDescription Avg. Disk Bytes/Transfer calculates the average number of bytes transferred to or from

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Avg. Disk Bytes/ReadDescription Average Disk Bytes/Read calculates the average number of bytes transferred from the disk during read operations. If this value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Avg. Disk Bytes/WriteDescription Average Disk Bytes/Write calculates the average number of bytes transferred to the disk during write operations. If this value is greater than or equal to the threshold values specified by the threshold arguments, and the number of occurrences exceeds the value specified in the "Number of Occurrences" parameter, then a warning or critical alert is generated.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-00285 Avg Connect Time (secs) : numberCause: Part of status request for Connection Manager. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-00280 Max Avg Bytes/Sec : numberCause: Part of status request for Connection Manager. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30453 summary contains AVG without corresponding COUNTCause: Incremental refresh of summaries with AVG(X) requires a COUNT(X) column to be included in

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02135 agg(expr) requires corresponding AVG(expr) functionaggregate functions but omits an invocation of the AVG function on the same argument. Action: Add the AVG function to the select list.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-00284 Imm Max Avg Bytes/Sec : numberCause: Part of status request for Connection Manager. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30452 cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)refresh AVG(X). It requires both SUM(X) and COUNT(X) columns in order to in refresh STDDEV(X) or VARIANCE

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Using SQL Trace and TKPROF

Sample TKPROF Headerparse: select deptno, avg(sal) from emp e group by deptno having exists (select deptno from dept … where dept.deptno = e.deptno and dept.budget > avg(e.sal)) order by 1 Error encountered: ORA-00904 ********************************************************************************

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Query Rewrite

Query Rewrite Considerations: Aggregatesaggregates are quite similar to those for incremental refresh. For instance, if AVG(x) is in the query … , then you should store COUNT(x) and AVG(x) or store SUM(x) and COUNT(x) in the materialized view

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

CASE Examplehave to write this query as follows, SELECT AVG(foo(e.sal)) FROM emps e; In this, foo is a function … query can be rewritten as: SELECT AVG(CASE when e.sal > 2000 THEN e.sal ELSE 2000 end) FROM emps e

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

Query Rewrite Restrictionsthe expression. That is, aggregates such as AVG(AVG(x)) or AVG(x) + AVG(x) are not allowed. CONNECT BY clauses are not allowed.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

Using Other Aggregate Functions with ROLLUP and CUBEto the GROUP BY clause, for example, COUNT, AVG, MIN, MAX, STDDEV, and VARIANCE. COUNT, which is