Q

Q date format element, SQL 2-46

QMARK - oracle.xml.parser.v2.ElementDecl.QMARK, JPR 4-33

QMNn background process, SCN 1-19, SCN 8-14, SCN 72

interval statistics, SCN 78

window of execution, SCN 73

QSM, SMS 22-1

qualifiers

using subprogram names as, PLS 2-38

when needed, PLS 2-36, PLS 2-40

queries, SQL 5-19, SQL 7-572

ad hoc, SCN 188

association with cursor, PCO 5-12

association with cursors, PC_ 6-11

avoiding the use of indexes, STU 12-7

capturing as views, ADG 2-15

comments in, SQL 5-19

composite indexes, SCN 10-24

compound, SQL 5-21

defined, STU 4-48

optimization of, STU 4-91

ORs converted to, STU 4-71

correlated

left correlation, SQL 7-576

default locking of, SCN 237

define phase, SCN 21

defined, SQL 5-19, STU 4-47

describe phase, SCN 21

dictionary views, SRF 1-40

distributed, DDS 1-34, SCN 404, SQL 5-26, STU 9-30, STU 9-40

application development issues, DDS 3-3

distributed or remote, DDS 1-33, SCN 404

dynamic, ADG 8-4

enabling parallelism for, DWG 18-6

ensuring the use of indexes, STU 12-6

errors in distributed queries, ADG 9-46

fetching rows, SCN 21

forwarding, PC_ 3-14

grouping returned rows on a value, SQL 7-578

hierarchical. See hierarchical queries

hints, SRF 1-86

hints in, SQL 5-19

in DML, SCN 12

incorrectly coded, PC_ 6-8

index scans parallelized by partition, SCN 161

inline views, SCN 10-17

join, SQL 5-22

kinds of, PC_ 6-6

location transparency and, DDS 1-45, SCN 415

locking rows during, SQL 7-580

merged with view queries, SCN 10-15

multirow, PCO 5-7

optimizing IN subquery, STU 4-78

optimizing view queries, STU 4-76

ordering output, NLS 2-28

ordering returned rows, SQL 7-580

outer joins in, SQL 7-576, SQL 7-577

parallel processing, SCN 158

pass-through SQL, DDS 9-7

phases of, SCN 215

post-processing, DDS 3-4

processing, SCN 21

read consistency of, SCN 1-31, SCN 216

referencing multiple tables, SQL 5-22

remote, DDS 3-4

requirements for, PC_ 6-7

restricting results of, SQL 7-577

returning more than one row, PC_ 6-7

SAMPLE clause

cost-based optimization, SCN 139, STU 4-19

select lists of, SQL 5-19

selecting from a random sample of rows, SQL 7-574

selecting from specified partitions, SQL 7-575

selectivity of, STU 4-25

set membership, ADO 6-18

single-row versus multirow, PC_ 6-8, PCO 5-8

sorting results, SQL 5-21

speeding up with temporary tables, ADG 2-11

star queries, DWG 16-2, STU 4-62

stored as views, SCN 1-22, SCN 10-12

syntax, SQL 5-19

table scans parallelized by rowid, SCN 160

temporary segments and, SCN 4-20, SCN 21

top-level, SQL 5-19

top-N, SQL 2-61

transparency, DDS 2-32

triggers use of, SCN 104

unnesting, ADO 6-12

varrays, ADO 6-14

query, PCO 5-7

explicit describe, OCI 4-13

query column

SQL trace, STU 6-13

QUERY command, NET 6-59, NET 11-14

A.SMD record, NET 7-11, NET 11-14, NET A-42

CNAME.SMD, NET 11-14, NET A-42

DLCR.TDBMS.OMD record, NET 11-14, NET A-42

DL.RDBMS.OMD, NET 11-14, NET A-42

NS.SMD, NET 11-14, NET A-42

of NAMESCTL, reference, NET A-42

V1ADD.NPO.OMD, NET 11-14, NET A-42

query delta joins, DWG 19-13

query entry return limit, OID 5-17

query plans, STU 5-2

query rewrite, GTK 2-12, SCN 10-18

and dimensions, SQL 7-278

and function-based indexes, SQL 7-93

and rule-based optimization, SQL 7-93

consistency level, SQL 7-93, SQL 7-116

controlling, DWG 19-28

correctness, DWG 19-26

defined, SQL 7-572

disabling, SQL 7-93, SQL 7-116

dynamic predicates in security policies, SCN 326

enabling, DWG 19-4, DWG 19-5, SQL 7-93, SQL 7-116

hints, DWG 19-5, DWG 19-28

matching join graphs, DWG 8-18

methods, DWG 19-8

parameters, DWG 19-5

privileges, DWG 19-6

restrictions, DWG 8-19

when it occurs, DWG 19-6

QUERY REWRITE system privilege, SQL 7-523, SQL 7-526

query. See SQL query

query server process

about, SAD 4-17

tuning, STU 21-15

query work areas, PLS 5-16

QUERY_REWRITE_ENABLED initialization parameter, SRF 1-99

QUERY_REWRITE_ENABLED parameter, DWG 19-5

of ALTER SESSION, SQL 7-93

of ALTER SYSTEM, SQL 7-116

QUERY_REWRITE_INTEGRITY parameter

of ALTER SESSION, SQL 7-93

of ALTER SYSTEM, SQL 7-116

querying

audit log, OID 5-24

critical events, OID 5-24

recovery catalog, RMN 4-2

Queue (string) not found - error, ADQ D-14

Queue Level Access Control, ADQ 8-11

queue monitor process (QMNn), SCN 1-19, SCN 8-14, SCN 72

interval statistics, SCN 78

window of execution, SCN 73

queue monitor processes, SAD 4-13

Queue object is invalid - error, ADQ D-13

Queue Privilege, Granting, ADQ 9-47, ADQ 9-50

Queue Propagation, Scheduling, ADQ 9-65

Queue Propagation, Unschedule, ADQ 9-69

Queue Subscribers and Their Rules, Selecting, ADQ 10-37

queue subscribers, definition, ADQ 7-6

Queue Subscribers, Selecting, ADQ 10-35

Queue Table (string) not found - error, ADQ D-11

Queue Table Messages, Selecting, ADQ 10-21

Queue Table must be specified - error, ADQ D-13

Queue Table, Creating, ADQ 9-5

queue tables

downgrading, MIG 13-39

upgrading, MIG 7-34

Queue Tables in User Schema, Selecting, ADQ 10-25

Queue Tables, Altering, ADQ 9-14

queue tables, definition, ADQ 1-17

Queue Tables, Dropping, ADQ 9-17

Queue Type, Verifying, ADQ 9-72

QUEUE_PRIVILEGES view, SRF 2-160

queue_type, ADQ 2-5

QueueProperty must be specified - error, ADQ D-13

queues

multi-consumer, SCN 70

single consumer, SCN 70

Queues for Which User Has Any Privilege, Selecting, ADQ 10-17

Queues for Which User Has Queue Privilege, Selecting, ADQ 10-19

Queues In User Schema, Selecting, ADQ 10-28

Queues, Altering, ADQ 9-30

Queues, Creating, ADQ 9-20

queues, definition, ADQ 1-17

Queues, Dropping, ADQ 9-33

Queues, Point-to-Point, ADQ 12-39

Queues, Starting, ADQ 9-36

Queues, Stopping, ADQ 9-39

queuesize, NET 5-6, NET 7-12

QUEUESIZE parameter, NET 7-12

for adjusting listener queue size, NET 7-12

for adjusting listener queuesize, NET 5-6

QueueTable object is invalid - error, ADQ D-13

QueueTableProperty must be specified - error, ADQ D-13

queuing, SCN 66

DBMS_AQADM package, SPR 5-1, ADQ 4-4

exception handling, SCN 78

exporting queue tables, SCN 79

instance affinity, SCN 77

publish-subscribe support, SCN 77

event publication, SCN 99

queue level access control, SCN 76

queue monitor process, SCN 1-19, SCN 8-14, SCN 72

interval statistics, SCN 78

window of execution, SCN 73

queue tables, SCN 70, SCN 79

recipients, SCN 71

rule-based subscriptions, SCN 72

subscription lists, SCN 71

remote databases, SCN 76

quiescing, REP 2-20

and fine grained quiesce, REP A-7

master groups, SPR 37-83, RAR 8-149

QUIT command

of CMCTL, NET A-83

of LSNRCTL, NET A-8

of NAMESCTL, NET A-44

quit()

function of UTL_SMTP, SPR 65-13

QUOTA clause

of ALTER USER. See CREATE USER

of CREATE USER, SQL 7-453

quotas

listing, SAD 22-25

revoking from users, SAD 22-17

revoking tablespace access and, SCN 293

setting to zero, SAD 22-17, SCN 293

SYS user not subject to, SCN 293

tablespace, SAD 22-17, SCN 1-42, SCN 292

temporary segments ignore, SCN 293

tablespace quotas, SAD 9-3

temporary segments and, SAD 22-17

unlimited, SAD 22-17

viewing, SAD 22-27

quotation marks

escaping, SUT 5-20

filenames, SUT 5-19

SQL string, SUT 5-19

table names and, SUT 1-26, SUT 2-27

use with database object names, SUT 5-18

quoted identifiers, PLS 2-6