Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


Q

Q date format element, SQL 2-41
QMNn background process, SCN 1-20, SCN 8-13, SCN 19-6
interval statistics, SCN 19-11
window of execution, SCN 19-7
QSM, SMS 22-1
qualifier
using subprogram name as, PLS 2-37
when needed, PLS 2-35, PLS 2-39
Queries
pass-through SQL, DDS 7-7
queries, SQL 5-18, SQL 7-544
ad hoc, SCN 26-31
association with cursor, PCO 5-12
association with cursors, PC_ 6-11
avoiding the use of indexes, STU 6-7
comments in, SQL 5-18
composite indexes, SCN 10-22
compound, SQL 5-20
defined, SCN 23-4
optimization of, SCN 23-27
ORs converted to, SCN 23-10
correlated
left correlation, SQL 7-547
default locking of, SCN 27-26
define phase, SCN 16-12
defined, SCN 23-3, SQL 5-18
describe phase, SCN 16-12
dictionary views, SRF 1-45
distributed, DDS 1-11, SQL 5-25, STU 8-1, STU 8-10
application development issues, DDS 4-3
distributed or remote, DDS 1-11, SCN 33-11
during prepare phase, DDS 3-3
enabling parallelism for, STU 26-8
ensuring the use of indexes, STU 6-6
errors in distributed queries, ADG 10 - 47
fetching rows, SCN 16-12
forwarding, PC_ 3-14
grouping returned rows on a value, SQL 7-549
hierarchical. See hierarchical queries
hints, SRF 1-88
hints in, SQL 5-18
in DML, SCN 16-3
incorrectly coded, PC_ 6-8
index scans parallelized by partition, SCN 26-5
inline views, SCN 10-16
join, SQL 5-21
kinds of, PC_ 6-6
location transparency and, DDS 1-15, SCN 33-15
locking rows during, SQL 7-551
merged with view queries, SCN 10-14
multirow, PCO 5-7
optimizing IN subquery, SCN 23-17
optimizing view queries, SCN 23-15
ordering output, NLS 2-25
ordering returned rows, SQL 7-551
outer joins in, SQL 7-547, SQL 7-548
parallel processing, SCN 26-2
passthrough SQL, DDS 7-3
phases of, SCN 27-5
post-processing, DDS 4-3
processing, SCN 16-12
read consistency of, SCN 1-32, SCN 27-5
referencing multiple tables, SQL 5-21
remote, DDS 4-3
remote execution, DDS 4-3
requirements for, PC_ 6-7
restricting results of, SQL 7-548
returning more than one row, PC_ 6-7
SAMPLE clause
cost-based optimization, SCN 22-16
select lists of, SQL 5-18
selecting from a random sample of rows, SQL 7-546
selecting from specified partitions, SQL 7-546
selectivity of, SCN 23-51
set membership
optimizing, ADG 18 - 20
single-row versus multirow, PC_ 6-8, PCO 5-8
sorting results, SQL 5-20
star queries, SCN 24-14
stored as views, SCN 1-24, SCN 10-11
syntax, SQL 5-18
table scans parallelized by rowid, SCN 26-4
temporary segments and, SCN 4-18, SCN 16-12
top-level, SQL 5-18
top-N, SQL 2-56
transparency, DDS 2-25
triggers use of, SCN 20-23
unnesting, ADG 18 - 13
VARRAY, ADG 18 - 16
queries parallelized statistic, SRF C-14
query, NET 6-36, NET 8-17, PCO 5-7
explicit describe, OCI 4-13
query column, SQL trace, STU 14-13
QUERY command, NET 6-36, NET 8-17
A.SMD record, NET 6-68, NET 8-17, NET A-45
CNAME.SMD, NET 8-17, NET A-45
DLCR.TDBMS.OMD record, NET 8-17, NET A-45
DL.RDBMS.OMD, NET 8-17, NET A-45
NS.SMD, NET 8-17, NET A-45
of NAMESCTL, reference, NET A-45
V1ADD.NPO.OMD, NET 8-17, NET A-45
query delta joins, STU 31-11
query plan, STU 13-1
query rewrite, SCN 10-17
and dimensions, SQL 7-260
and function-based indexes, SQL 7-87
and the rule-based optimizer, SQL 7-87
consistency level, SQL 7-88
correctness, STU 31-18
defined, SQL 7-544
disabling, SQL 7-87, SQL 7-106
dynamic predicates in security policies, SCN 30-23
enabling, SQL 7-87, SQL 7-106, STU 31-3, STU 31-4
hints, STU 31-4, STU 31-21
initialization parameters, STU 31-4
matching join graphs, STU 29-6
methods, STU 31-6
privileges, STU 31-4
QUERY REWRITE system privilege, SQL 7-496, SQL 7-497, SQL 7-499
query. See SQL query
query server process
about, SAD 4-13
tuning, STU 21-14
query work area, PLS 5-16
QUERY_REWRITE_ENABLED parameter
of ALTER SESSION, SQL 7-87
of ALTER SYSTEM, SQL 7-106
QUERY_REWRITE_INTEGRITY parameter
of ALTER SESSION, SQL 7-88
querying
recovery catalog, SBR 7-2
queue
deferred transactions, REP 2-4
queue messages wait event, SRF A-45
queue monitor process (QMNn), SCN 1-20, SCN 8-13, SCN 19-6
interval statistics, SCN 19-11
window of execution, SCN 19-7
queue size, adjusting for connection requests, NET 8-13
queue subscribers, definition, ADQ 1-23
queue tables
downgrading, MIG 12-31
upgrading, MIG 7-29
queue tables, definition, ADQ 1-15
QUEUE_PRIVILEGES view, SRF 2-179
queues, definition, ADQ 1-15
queuesize, NET 3-14, NET 6-70
QUEUESIZE parameter, NET 6-70, NET 8-13
for adjusting listener queue size, NET 3-14, NET 6-70, NET 8-13
queuing, SCN 19-2
DBMS_AQADM package, ADQ 3-9, SPR 5 - 1
exception handling, SCN 19-11
exporting queue tables, SCN 19-12
instance affinity, SCN 19-10
publish/subscribe support, SCN 19-10
event publication, SCN 20-18
queue level access control, SCN 19-9
queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6
interval statistics, SCN 19-11
window of execution, SCN 19-7
queue tables, SCN 19-4, SCN 19-12
recipients, SCN 19-5
rule-based subscriptions, SCN 19-5, SCN 19-6
subscription lists, SCN 19-5
remote databases, SCN 19-9
queuing system, DDS 5-3
quiescing
and fine grained quiesce, REP A-3
master groups, REP 2-22
replicated schemas, SPR 34 - 75, RAR 8-160
QUIT command
of LSNRCTL, reference, NET A-8
of NAMESCTL, reference, NET A-47
see STOP command for CMCTL
see STOP NOW command for CMCTL
QUOTA clause
of ALTER USER. See CREATE USER.
of CREATE USER, SQL 7-427
quotas
listing, SAD 23-22
revoking from users, SAD 23-14
revoking tablespace access and, SCN 29-14
setting to zero, SAD 23-14, SCN 29-14
SYS user not subject to, SCN 29-14
tablespace, SAD 23-13, SCN 1-43, SCN 29-13
temporary segments ignore, SCN 29-14
tablespace quotas, SAD 9-3
temporary segments and, SAD 23-14
unlimited, SAD 23-14
viewing, SAD 23-24
quotation marks
escaping, SUT 5-20
filenames, SUT 5-19
SQL string, SUT 5-19
table names and, SUT 1-25, SUT 2-29
use with database object names, SUT 5-19
quoted identifier, PLS 2-6



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index