---

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

---