Oracle8
i
Generic Documentation Master Index
Release 8.1.5
A68826-01
Library
Product
Contents
Index
G
G number format element, SQL 2-36
gateways, SCN 33-8
GATHER_ INDEX_STATS
procedure of DBMS_STATS, STU 7-9
GATHER_DATABASE_STATS
procedure of DBMS_STATS, STU 7-9
GATHER_SCHEMA_STATS
procedure of DBMS_STATS, STU 7-9
GATHER_TABLE_STATS
procedure of DBMS_STATS, STU 7-9
GC_DB_LOCKS parameter, SPS A-6
adjusting after file operations, SPS A-18
GC_DEFER_TIME parameter, SRF 1-44
of ALTER SYSTEM, SQL 7-102
GC_FILES_TO_LOCKS parameter, PSC 1-17,
PSC 6-9,
PSC 6-11,
SPS 9-3,
SPS 9-4,
SPS 9-6,
SPS 9-14,
SPS 9-24,
SPS 14-10,
SPS 15-17,
SPS 18-11,
SRF 1-44,
STU 27-13
adding datafiles, SPS 15-12
adjusting after file operations, SPS 15-6,
SPS A-18
associating PCM locks with extents, SPS 11-15,
SPS 17-11
default bucket, SPS 15-7
fine grain examples, SPS 15-9
guidelines, SPS 15-9
hashed examples, SPS 15-8
index data, SPS 15-5
reducing false pings, SPS 15-16
room for growth, SPS 15-10
setting, SPS 15-6
syntax, SPS 15-7
GC_FREELIST_GROUPS parameter, SPS A-6,
SPS A-9
GC_LATCHES parameter, SPS A-5,
SRF 1-45
obsolete for 8.1, SPS A-5
GC_LCK_PROCS parameter, SRF 1-45
obsolete for 8.1, SPS A-5
GC_RELEASABLE_LOCKS parameter, PSC 1-18,
PSC 6-9,
SPS 9-14,
SPS 15-17,
SPS A-9,
SRF 1-46
default, SPS 15-13
GC_ROLLBACK_LOCKS parameter, PSC 6-9,
PSC 6-11,
SPS 6-9,
SPS 9-14,
SPS 9-15,
SPS 15-7,
SPS 15-13,
SPS 15-17,
SPS 18-11,
SRF 1-46,
STU 27-14
GC_ROLLBACK_SEGMENTS parameter, SPS A-6,
STU 27-14
number of distributed locks, SPS 6-9
GC_SAVE_ROLLBACK_LOCKS parameter, SPS 6-9,
SPS A-6,
SPS A-19
GC_SEGMENTS parameter, SPS A-6
GC_SORT_LOCKS parameter, SPS A-21
GC_TABLESPACES parameter, SPS A-7
gen_rep_pack, REP 6-23
General, NET 7-51
General Inter-Orb Protocol (GIOP)
see GIOP
General page
Create New Master Group property sheet, REP 2-19
Snapshot Log property sheet, REP 7-37
general recovery clause
of ALTER DATABASE, SQL 7-7,
SQL 7-12
General tab, from Create Job property sheet, PSC 6-33
generate replication support, RAR 3-8
GENERATE_REPLICATION_SUPPORT procedure
DBMS_REPCAT package, REP 2-37
generated objects
displaying for master groups, REP 2-39
generated replication objects
wrapper package, REP 2-2
generating
replication support
procedural replication, REP 8-3
replication support and migration, REP B-3
snapshot support, SPR 34 - 60,
RAR 8-142
generating lists using RMAN, SBR 4-20
generating replication support
migration and, REP B-8
generating reports, SBR 4-20,
SBR 7-5
GENXTB form
how to run, PC_ 20-12
running, PCO 12-12
use with user exits, PC_ 20-12
GENXTB utility
how to run, PC_ 20-13
use with user exits, PC_ 20-13
GET DESCRIPTOR statement, PC_ 14-14,
PCO F-51
GET_VALUE, DDS 7-3
GET_VALUE procedure, DDS 7-6
GETMISSES, V$ROWCACHE table, STU 19-20
GETS, V$ROWCACHE table, STU 19-20
gigabyte, PLS 2-21
GIOP, NET C-55
described, NET 2-14
dispatcher configuration, NET 7-63
listener configuration, NET 7-56
oracle.aurora.server.GiopServer, NET 7-52
oracle.aurora.server.SGiopServer, NET 7-52
presentation, NET 7-51
presentation layer, NET 4-13,
NET C-51,
NET C-55
GIOP presentation layer, NET 4-13
global, NET 4-9
global cache control parameters, SRF 1-10
global cache defers statistic, SRF C-10
global cache freelist wait wait event, SRF A-31
global cache freelist waits statistic, SRF C-10
global cache lock busy wait event, SRF A-31
global cache lock cleanup wait event, SRF A-31
global cache lock null to s wait event, SRF A-32
global cache lock null to x wait event, SRF A-32
global cache lock open null wait event, SRF A-32
global cache lock open s wait event, SRF A-32
global cache lock open x wait event, SRF A-33
global cache locks s to x wait event, SRF A-33
global constant parameter, SPS 18-11
and non-PCM locks, SPS 4-12
control file, SPS 6-1
description, SPS 9-13
list of, SPS 18-9
rollback segments, SPS 6-9,
SRF 1-46
same for all instances, SPS 18-9,
SPS 18-11
Global Constant parameters list, PSC 6-9
global coordinator, DDS 3-7
global data inconsistency, DDS 7-2
global database link qualifiers, NET 6-44
global database links, NET 2-36,
NET 6-22,
NET 6-44
adding link qualifiers, NET 6-46
registering with Oracle Names, NET 6-45
global database name, DDS 2-2,
PSC 1-9,
PSC 3-4,
PSC 4-8,
SAD 2-9
configuring on the listener, NET 6-71,
NET C-58
defined, NET 6-3
described, NET 1-3,
NET 4-9,
NET 5-17,
NET 6-71,
NET C-58
Global Database Name field, NET 7-71
Global Database Name option, NET 6-71,
NET 7-8
global database names
shared pool and, SCN 7-11
Global Directory Service (GDS), OAS 11-4
global dynamic performance view, SPS 18-25,
SPS 20-12,
SPS A-7
GLOBAL hint, SPS 20-12
global index, STU 26-74
dropping partition with, SAD 13-12,
SAD 13-15
splitting partition in, SAD 13-18
global indexes
partitioning, SCN 11-32
managing partitions, SCN 11-33,
SCN 11-60
summary of index types, SCN 11-34
global lock convert time statistic, SRF C-10
global lock converts (async) statistic, SRF C-10
global lock converts (non async) statistic, SRF C-10
global lock get time statistic, SRF C-10
global lock gets (async) statistic, SRF C-10
global lock gets (non async) statistic, SRF C-10
global lock release time statistic, SRF C-11
global lock releases statistic, SRF C-11
Global Names, RAR 1-3
global names
resolution, DDS 2-18
global naming, DDS 2-2
global object names, DDS 2-2
GLOBAL option
forcing a checkpoint, SPS 18-18,
SPS 21-9
verifying access to files, SPS 6-2
GLOBAL PARTITION BY RANGE clause
of CREATE INDEX, SQL 7-283
GLOBAL QUERY REWRITE system privilege, SQL 7-496,
SQL 7-497,
SQL 7-499
global schema object names, SCN 1-29,
SCN 33-6
GLOBAL TEMPORARY clause
of CREATE TABLE, SQL 7-367
global transactions, OCI 8-4
global user, DDS 1-18,
DDS 2-6,
DDS 2-12,
DDS 2-13,
SAD 23-10,
SCN 18-21,
SCN 33-18
current user links, SCN 18-21
global user security, SRF 1-40
global users, SQL 7-344,
SQL 7-427
global V$ view tables, PSC 5-1,
PSC 7-2
GLOBAL_DBNAME parameter, NET 6-71,
NET C-58
GLOBAL_NAME parameter, NET 7-8,
NET 7-71,
NET C-46
GLOBAL_NAME view, SRF 2-165
GLOBAL_NAMES initialization parameter, DDS 2-2
GLOBAL_NAMES parameter, SRF 1-47
of ALTER SESSION, SQL 7-82
of ALTER SYSTEM, SQL 7-102
globally partitioned indexes, SQL 7-283,
SQL 7-284
globals
naming conventions, DCI 2-5
glossary. See terminology
GMS
described, PSC 1-7
release 8.0 functionality, PSC 1-7
removed for 8.1, SPS A-2
goals for tuning, STU 1-9,
STU 2-12
GOTO action
in the WHENEVER statement, PC_ 9-25
of WHENEVER directive, PC_ F-120,
PCO 8-30,
PCO F-92
result of, PC_ 9-25
GOTO statement, PLS 3-15
label, PLS 3-15
misuse, PLS 3-17
restriction, PLS 6-17
syntax, PLS 11-84
GRANT ANY PRIVILEGE system privilege, SCN 30-3,
SQL 7-502
GRANT ANY ROLE system privilege, SQL 7-498
GRANT command, ADG 12 - 16,
SCN 16-4
ADMIN option, SAD 24-10
GRANT option, SAD 24-11
locks, SCN 27-29
object privileges, ADG 12 - 17,
SAD 24-10
SYSOPER/SYSDBA privileges, SAD 1-13
system privileges, ADG 12 - 16
system privileges and roles, SAD 24-9
when in effect, ADG 12 - 22
when takes effect, SAD 24-16
GRANT CONNECT THROUGH clause
of ALTER USER, SQL 7-180,
SQL 7-181
GRANT object_privileges, SQL 7-505
GRANT OPTION
about, SAD 24-11
revoking, SAD 24-13
GRANT option for EXECUTE privilege, SCN 14-14
GRANT system_privileges_and_roles statement, SQL 7-493
granted queue, SPS 8-3,
SPS 8-4
granting
execute user-defined type, SCN 14-14
privileges and roles, SCN 30-3
granting privileges and roles, ADG 12 - 16
listing grants, SAD 24-20
shortcuts for object privileges, SAD 24-3
SYSOPER/SYSDBA privileges, SAD 1-13
GRANTS
Export parameter, SUT 1-20
Import parameter, SUT 2-23
grants
exporting, SUT 1-20
importing, SUT 2-13,
SUT 2-23
GRAPHIC datatype, SUT 5-59
EXTERNAL format
SQL*Loader, SUT 5-66
SQL*Loader, SUT 5-66
GRAPHIC datatype (SQL/DS or DB2), SQL 2-25
GRAPHIC EXTERNAL datatype, SUT 5-59
greater than or equal to tests, SQL 3-5
greater than tests, SQL 3-5
GREATEST function, SQL 4-16
group
free list, SPS 11-12
MAXLOGFILES, SPS 14-4
redo log files, SPS 6-4,
SPS 14-4,
SPS 14-9
unique numbers, SPS 6-5
V$LOGFILE, SPS 6-5
group attributes, default, LEG 4-6,
LEG 4-8
GROUP BY
decreasing demand for, STU 27-7
NOSORT, STU 20-38
GROUP BY clause, PLS 5-3
of SELECT, SQL 7-549
of SELECT and subqueries, SQL 7-543
optimizing views, SCN 23-17
temporary tablespaces, SCN 3-12
group commits, SCN 8-10
group comparison conditions, SQL 5-15
group items
allowed as host variables, PCO 4-24
implicit VARCHAR, PCO 4-30
Group Items as host variables, PCO A-4
Group Membership Service (GMS), described, PSC 1-7
Group Membership Services, SPS A-8
removed for 8.1, SPS A-2
Group Membership Services (GMS), GTK 2-62
GROUP option, SPS 21-4
group owner, REP 3-19
group separator, NLS 2-19
default, NLS 2-8
NLS_NUMERIC_CHARACTERS parameter, NLS 2-19
group-based locking, SPS 8-9,
SPS 8-10
grouping
compatibility check, STU 31-16
conditions, STU 31-23
GROUPING aggregate function, PLS 5-3
GROUPING function, SQL 4-16
groups
archived redo log, SBR 15-6,
SBR 15-7
online redo log, SBR 15-6,
SBR 15-7
redo log files
LOG_FILES initialization parameter, SAD 6-10
groups, instance, SCN 26-19
growth, room for, SPS 15-10
GTRID. See transaction identifier
guess, PLS 2-17
guesses in logical rowids, SCN 12-20
staleness, SCN 12-21
statistics for, SCN 12-21
GUI, PSC 5-15
GUI, LSM
Clients Window on UNIX, LEG 2-20
Devices Window on UNIX, LEG 3-4
Devices Window on Windows NT, LEG 3-6
Edit client Dialog Box on Windows, LEG 2-22
Edit Group Dialog Box on Windows, LEG 4-6,
LEG 4-8
Groups Window on UNIX, LEG 4-6
labeling a volume on UNIX, LEG 3-14,
LEG 3-18
labeling a volume on Windows, LEG 3-15,
LEG 3-18
messages display on UNIX, LEG 4-10
mounting a volume on UNIX, LEG 3-16
mounting a volume on Windows, LEG 3-17
overview, LEG 2-10
Pending Messages Window, LEG 3-21
Server Window on UNIX, LEG 2-23
Sessions display on UNIX, LEG 4-10
Set Up Server Dialog Box on Windows, LEG 2-24
UNIX, LEG 2-11
Volumes Window, LEG 3-20
Windows NT
running, LEG 2-13,
LEG 2-14,
LEG 2-16
TCP/IP requirements, LEG 2-13
GUI, Oracle
Oracle Enterprise Manager, LEG 4-3
Guidelines, SAD 10-2
guidelines
backups
distributed database constraints, SBR 3-22
Export utility, SBR 3-22
frequency, SBR 3-18
multiplexing files, SBR 3-17
often-used tablespaces, SBR 3-19
storing old backups, SBR 3-21
structural changes, SBR 3-18
testing strategies, SBR 3-24
unrecoverable operations, SBR 3-19
whole database backups after OPEN RESETLOGS, SBR 3-19
datatype equivalencing, PCO 4-52
dynamic SQL, PCO 9-6
for dynamic SQL, PC_ 13-6
for managing rollback segments, SAD 21-2
for separate precompilations, PC_ 2-17
for the WHENEVER statement, PC_ 9-29
for transactions, PC_ 3-27
for user exits, PC_ 20-13
separate precompilation, PCO 2-27
transaction, PCO 3-31
user exit, PCO 12-13
GV$ view, SPS 18-25,
SPS 20-12,
SPS A-7
GV$ views
for parallel servers, SRF 3-2
restrictions on, SRF 3-3
GV$BH view, SPS 19-5
GV$CACHE view, SPS 19-5,
SPS 20-12
GV$CLASS_PING view, SPS 20-12
GV$FILE_PING view, SPS 20-12
GV$FILESTAT view, PSC 7-10,
PSC 7-11,
PSC 7-12,
STU 26-78
GV$LICENSE view, PSC 7-15,
PSC 7-16,
PSC 7-17,
PSC 7-18
GV$LOCK_ACTIVITY view, PSC 7-13
GV$PARAMETER view, SPS 18-25
GV$PING view, PSC 7-6,
PSC 7-7,
PSC 7-9,
SPS 19-5,
SPS 20-12
GV$PROCESS view, PSC 7-14
GV$SESSION view, PSC 7-14
Prev
Top
Next
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents
Index