Oracle8i Generic Documentation Master Index

G number format element, SQL 2-41

gap sequences

applying the logs to standby database, SBY 3-12, SBY 5-13, SBY 5-20

causes of, SBY 3-5

copying the logs in, SBY 3-10, SBY 5-12

description, SBY 1-17

identifying the logs in, SBY 3-9, SBY 5-11, SBY 5-42

preventing, SBY 3-7

garbage collection

in replication, OID 10-10

modifying intervals in replication, OID 10-12

GATHER_ INDEX_STATS procedure

in DBMS_STATS package, STU 8-6

GATHER_DATABASE_STATS procedure

in DBMS_STATS package, STU 8-6

GATHER_SCHEMA_STATS procedure

in DBMS_STATS package, STU 8-6

GATHER_TABLE_STATS procedure

in DBMS_STATS package, STU 8-6

GC_DB_LOCKS parameter, PSC A-8

adjusting after file operations, PSC A-20

GC_DEFER_TIME initialization parameter, SRF 1-39

GC_DEFER_TIME parameter, PSA 1-10

of ALTER SYSTEM, SQL 7-110

GC_FILES_TO_LOCKS initialization parameter, SRF 1-40

GC_FILES_TO_LOCKS parameter, DWG 18-44, PSA 1-8, PSA 1-10, PSA 3-9, PSA 7-7, PSA 7-10, PSC 5-20, PSC 5-31

1 to 1 examples, PSA 9-4

adding data files, PSA 9-8

adjusting after file operations, PSA 9-2, PSC A-20

associating PCM locks with extents, PSA 8-9, PSC 7-21

default bucket, PSA 9-3

fixed examples, PSA 9-4

guidelines, PSA 9-5

index data, PSA 7-14

reducing false pings, PSA 9-12

room for growth, PSA 9-6

setting, PSA 9-2

syntax, PSA 9-2

GC_FREELIST_GROUPS parameter, PSC A-8, PSC A-11

GC_LATCHES initialization parameter: obsolete

GC_LATCHES parameter, PSC A-7

obsolete for 8.1, PSC A-6

GC_LCK_PROCS initialization parameter: obsolete

GC_LCK_PROCS parameter

obsolete for 8.1, PSC A-6

GC_RELEASABLE_LOCKS initialization parameter, SRF 1-41

GC_RELEASABLE_LOCKS parameter, PSA 1-10, PSC A-11

default, PSA 9-8

GC_ROLLBACK_LOCKS initialization parameter, SRF 1-42

GC_ROLLBACK_LOCKS parameter, DWG 18-45, PSA 1-8, PSA 1-10, PSA 9-3, PSA 9-9, PSC 7-7

default setting for, PSA 9-9

GC_ROLLBACK_SEGMENTS parameter, DWG 18-45, PSC A-8

number of distributed locks, PSC 7-7

GC_SAVE_ROLLBACK_LOCKS parameter, PSC 7-7, PSC A-8, PSC A-21

GC_SEGMENTS parameter, PSC A-8

GC_SORT_LOCKS parameter, PSC A-23

GC_TABLESPACES parameter, PSC A-8

General Inter-Orb Protocol

described, NET 3-16

presentation, NET 3-16

general recovery clause

of ALTER DATABASE, SQL 7-7, SQL 7-12

General tab, from Create Job property sheet, PSG 7-21

generate replication support, RAR 3-8

generating

replication support

procedural replication, REP 6-4

replication support and migration, MIG G-3, MIG G-9

generating lists using RMAN, RMN 1-24

generating reports, RMN 1-24, RMN 4-5

generic connectivity

architecture, DDS 8-3

Oracle and non-Oracle on same machine, DDS 8-4

Oracle and non-Oracle on separate machines, DDS 8-3

configuration, DDS 8-6

creating initialization file, DDS 8-7

data dictionary

translation support, DDS C-2

datatype mapping, DDS 8-5

definition, DDS 1-6, DDS 8-2

DELETE statement, DDS 8-6

editing initialization file, DDS 8-7

error tracing, DDS A-5

Heterogeneous Services, DDS 6-6

INSERT statement, DDS 8-6

non-Oracle data dictionary access, DDS C-2

ODBC connectivity requirements, DDS 8-12

OLE DB (FS) connectivity requirements, DDS 8-15

interfaces, DDS 8-16

OLE DB (SQL) connectivity requirements, DDS 8-14

restrictions, DDS 8-5

setting parameters for ODBC source, DDS 8-9

UNIX, DDS 8-10

Windows NT, DDS 8-9

setting parameters for OLE DB source, DDS 8-11

SQL execution, DDS 8-5

supported functions, DDS 8-6

supported SQL syntax, DDS 8-5

types of agents, DDS 8-2

UPDATE statement, DDS 8-6

GENXTB form

how to run, PC_ 20-12

use with user exits, PC_ 20-12

GENXTB utility

how to run, PC_ 20-13

use with user exits, PC_ 20-13

geographic

partitioning method, PSA 5-13

GET DESCRIPTOR statement, PC_ 14-14, PCO F-52

get_host_address()

function of UTL_INADDR, SPR 62-2

get_raw(), get_text(), get_line()

as a function UTL_TCP, SPR 66-11

GET_VALUE procedure, DDS 9-3, DDS 9-6, DDS 9-7

getAddress() - oracle.jms.AQjmsAgent.getAddress(), JPR 2-25

getAdtPayload() - oracle.jms.AdtMessage.getAdtPayload(), JPR 2-6

getAdtPayload() - oracle.jms.AQjmsAdtMessage.getAdtPayload(), JPR 2-9

getAncops() - oracle.ODCI.ODCIQueryInfo.getAncops(), JPR 3-53

getArgtype() - oracle.ODCI.ODCIArgDesc.getArgtype(), JPR 3-4

getArray() - oracle.ODCI.ODCIArgDescList.getArray(), JPR 3-7

getArray() - oracle.ODCI.ODCIColInfoList.getArray(), JPR 3-15

getArray() - oracle.ODCI.ODCIObjectList.getArray(), JPR 3-43

getArray() - oracle.ODCI.ODCIRidList.getArray(), JPR 3-58

getArray(long, int) - oracle.ODCI.ODCIArgDescList.getArray(long, int), JPR 3-7

getArray(long, int) - oracle.ODCI.ODCIColInfoList.getArray(long, int), JPR 3-15

getArray(long, int) - oracle.ODCI.ODCIObjectList.getArray(long, int), JPR 3-43

getArray(long, int) - oracle.ODCI.ODCIRidList.getArray(long, int), JPR 3-58

getAttrDecls() - oracle.xml.parser.v2.ElementDecl.getAttrDecls(), JPR 4-34

getAttribute(String) - oracle.xml.parser.v2.XMLElement.getAttribute(java.lang.String), JPR 4-94

getAttributeNode(String) - oracle.xml.parser.v2.XMLElement.getAttributeNode(java.lang.String), JPR 4-94

getAttributes() - oracle.xml.parser.v2.XMLElement.getAttributes(), JPR 4-95

getAttributes() - oracle.xml.parser.v2.XMLNode.getAttributes(), JPR 4-107

getAttrPresence() - oracle.xml.parser.v2.AttrDecl.getAttrPresence(), JPR 4-8

getAttrType() - oracle.xml.parser.v2.AttrDecl.getAttrType(), JPR 4-8

getBaseType() - oracle.ODCI.ODCIArgDescList.getBaseType(), JPR 3-7

getBaseType() - oracle.ODCI.ODCIColInfoList.getBaseType(), JPR 3-15

getBaseType() - oracle.ODCI.ODCIObjectList.getBaseType(), JPR 3-43

getBaseType() - oracle.ODCI.ODCIRidList.getBaseType(), JPR 3-58

getBaseTypeName() - oracle.ODCI.ODCIArgDescList.getBaseTypeName(), JPR 3-8

getBaseTypeName() - oracle.ODCI.ODCIColInfoList.getBaseTypeName(), JPR 3-16

getBaseTypeName() - oracle.ODCI.ODCIObjectList.getBaseTypeName(), JPR 3-44

getBaseTypeName() - oracle.ODCI.ODCIRidList.getBaseTypeName(), JPR 3-58

getBoolean(String) - oracle.jms.AQjmsMapMessage.getBoolean(java.lang.String), JPR 2-87

getBooleanProperty(String) - oracle.jms.AQjmsAdtMessage.getBooleanProperty(java.lang.String), JPR 2-10

getBooleanProperty(String) - oracle.jms.AQjmsMessage.getBooleanProperty(java.lang.String), JPR 2-103

getByte(String) - oracle.jms.AQjmsMapMessage.getByte(java.lang.String), JPR 2-87

getByteProperty(String) - oracle.jms.AQjmsAdtMessage.getByteProperty(java.lang.String), JPR 2-10

getByteProperty(String) - oracle.jms.AQjmsMessage.getByteProperty(java.lang.String), JPR 2-103

getBytes(String) - oracle.jms.AQjmsMapMessage.getBytes(java.lang.String), JPR 2-88

getChar(String) - oracle.jms.AQjmsMapMessage.getChar(java.lang.String), JPR 2-88

getChildNodes() - oracle.xml.parser.v2.DTD.getChildNodes(), JPR 4-26

getChildNodes() - oracle.xml.parser.v2.XMLNode.getChildNodes(), JPR 4-108

getChildrenByTagName(String) - oracle.xml.parser.v2.XMLElement.getChildrenByTagName(java.lang.String), JPR 4-95

getChildrenByTagName(String, String) - oracle.xml.parser.v2.XMLElement.getChildrenByTagName(java.lang.String, java.lang.String), JPR 4-95

getCipherSuite() - oracle.security.ssl.OracleSSLSession.getCipherSuite(), OAS F-36

getCipherSuite() - oracle.security.ssl.SSLSocketSession.getCipherSuite(), OAS F-50

getClientID() - oracle.jms.AQjmsConnection.getClientID(), JPR 2-45

getColname() - oracle.ODCI.ODCIArgDesc.getColname(), JPR 3-4

getColname() - oracle.ODCI.ODCIColInfo.getColname(), JPR 3-12

getColtypename() - oracle.ODCI.ODCIColInfo.getColtypename(), JPR 3-12

getColtypeschema() - oracle.ODCI.ODCIColInfo.getColtypeschema(), JPR 3-13

getColumnNumber(int) - oracle.xml.parser.v2.XMLParseException.getColumnNumber(int), JPR 4-119

getCompleteName() - oracle.jms.AQjmsDestination.getCompleteName(), JPR 2-67

getCompleteTableName() - oracle.jms.AQjmsDestination.getCompleteTableName(), JPR 2-67

getContentElements() - oracle.xml.parser.v2.ElementDecl.getContentElements(), JPR 4-34

getContentType() - oracle.xml.parser.v2.ElementDecl.getContentType(), JPR 4-34

getCpucost() - oracle.ODCI.ODCICost.getCpucost(), JPR 3-20

getCreationTime() - oracle.security.ssl.OracleSSLSession.getCreationTime(), OAS F-36

getCreationTime() - oracle.security.ssl.SSLSocketSession.getCreationTime(), OAS F-50

getCurrentJmsSession() - oracle.jms.AQjmsConnection.getCurrentJmsSession(), JPR 2-46

getDBConnection() - oracle.jms.AQjmsSession.getDBConnection(), JPR 2-178

getDefaultCipherSuites() - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.getDefaultCipherSuites(), OAS F-33

getDefaultCipherSuites() - oracle.security.ssl.OracleSSLSocketFactoryImpl.getDefaultCipherSuites(), OAS F-47

getDefaultValue() - oracle.xml.parser.v2.AttrDecl.getDefaultValue(), JPR 4-8

getDeliveryMode() - oracle.jms.AQjmsProducer.getDeliveryMode(), JPR 2-134

getDescriptor() - oracle.ODCI.ODCIArgDescList.getDescriptor(), JPR 3-8

getDescriptor() - oracle.ODCI.ODCIColInfoList.getDescriptor(), JPR 3-16

getDescriptor() - oracle.ODCI.ODCIObjectList.getDescriptor(), JPR 3-44

getDescriptor() - oracle.ODCI.ODCIRidList.getDescriptor(), JPR 3-59

getDisableMessageID() - oracle.jms.AQjmsProducer.getDisableMessageID(), JPR 2-134

getDisableMessageTimestamp() - oracle.jms.AQjmsProducer.getDisableMessageTimestamp(), JPR 2-135

getDoctype() - oracle.xml.parser.v2.DOMParser.getDoctype(), JPR 4-17

getDoctype() - oracle.xml.parser.v2.XMLDocument.getDoctype(), JPR 4-75

getDocument() - oracle.xml.parser.v2.DOMParser.getDocument(), JPR 4-17

getDocumentElement() - oracle.xml.parser.v2.XMLDocument.getDocumentElement(), JPR 4-76

getDouble(String) - oracle.jms.AQjmsMapMessage.getDouble(java.lang.String), JPR 2-89

getDoubleProperty(String) - oracle.jms.AQjmsAdtMessage.getDoubleProperty(java.lang.String), JPR 2-11

getDoubleProperty(String) - oracle.jms.AQjmsMessage.getDoubleProperty(java.lang.String), JPR 2-104

getElement(long) - oracle.ODCI.ODCIArgDescList.getElement(long), JPR 3-8

getElement(long) - oracle.ODCI.ODCIColInfoList.getElement(long), JPR 3-16

getElement(long) - oracle.ODCI.ODCIObjectList.getElement(long), JPR 3-44

getElement(long) - oracle.ODCI.ODCIRidList.getElement(long), JPR 3-59

getElementDecls() - oracle.xml.parser.v2.DTD.getElementDecls(), JPR 4-26

getElementsByTagName(String) - oracle.xml.parser.v2.XMLDocument.getElementsByTagName(java.lang.String), JPR 4-76

getElementsByTagName(String) - oracle.xml.parser.v2.XMLElement.getElementsByTagName(java.lang.String), JPR 4-96

getElementsByTagName(String, String) - oracle.xml.parser.v2.XMLElement.getElementsByTagName(java.lang.String, java.lang.String), JPR 4-96

getEncoding() - oracle.xml.parser.v2.XMLDocument.getEncoding(), JPR 4-76

getEntities() - oracle.xml.parser.v2.DTD.getEntities(), JPR 4-26

getEnumeration() - oracle.jms.AQjmsQueueBrowser.getEnumeration(), JPR 2-147

getEnumerationValues() - oracle.xml.parser.v2.AttrDecl.getEnumerationValues(), JPR 4-8

getErrorNumber() - oracle.jms.AQjmsException.getErrorNumber(), JPR 2-78

getException(int) - oracle.xml.parser.v2.XMLParseException.getException(int), JPR 4-119

getExpandedName() - oracle.xml.parser.v2.NSName.getExpandedName(), JPR 4-39

getExpandedName() - oracle.xml.parser.v2.XMLAttr.getExpandedName(), JPR 4-57

getExpandedName() - oracle.xml.parser.v2.XMLElement.getExpandedName(), JPR 4-96

getExpandedName(int) - oracle.xml.parser.v2.SAXAttrList.getExpandedName(int), JPR 4-45

getFactory() - oracle.ODCI.ODCIArgDesc.getFactory(), JPR 3-4

getFactory() - oracle.ODCI.ODCIArgDescList.getFactory(), JPR 3-8

getFactory() - oracle.ODCI.ODCIArgDescRef.getFactory(), JPR 3-10

getFactory() - oracle.ODCI.ODCIColInfo.getFactory(), JPR 3-13

getFactory() - oracle.ODCI.ODCIColInfoList.getFactory(), JPR 3-16

getFactory() - oracle.ODCI.ODCIColInfoRef.getFactory(), JPR 3-18

getFactory() - oracle.ODCI.ODCICost.getFactory(), JPR 3-20

getFactory() - oracle.ODCI.ODCICostRef.getFactory(), JPR 3-23

getFactory() - oracle.ODCI.ODCIFuncInfo.getFactory(), JPR 3-25

getFactory() - oracle.ODCI.ODCIFuncInfoRef.getFactory(), JPR 3-28

getFactory() - oracle.ODCI.ODCIIndexCtx.getFactory(), JPR 3-30

getFactory() - oracle.ODCI.ODCIIndexCtxRef.getFactory(), JPR 3-33

getFactory() - oracle.ODCI.ODCIIndexInfo.getFactory(), JPR 3-35

getFactory() - oracle.ODCI.ODCIIndexInfoRef.getFactory(), JPR 3-38

getFactory() - oracle.ODCI.ODCIObject.getFactory(), JPR 3-40

getFactory() - oracle.ODCI.ODCIObjectList.getFactory(), JPR 3-44

getFactory() - oracle.ODCI.ODCIObjectRef.getFactory(), JPR 3-46

getFactory() - oracle.ODCI.ODCIPredInfo.getFactory(), JPR 3-48

getFactory() - oracle.ODCI.ODCIPredInfoRef.getFactory(), JPR 3-51

getFactory() - oracle.ODCI.ODCIQueryInfo.getFactory(), JPR 3-53

getFactory() - oracle.ODCI.ODCIQueryInfoRef.getFactory(), JPR 3-56

getFactory() - oracle.ODCI.ODCIRidList.getFactory(), JPR 3-59

getFactory() - oracle.ODCI.ODCIStatsOptions.getFactory(), JPR 3-61

getFactory() - oracle.ODCI.ODCIStatsOptionsRef.getFactory(), JPR 3-64

getFirstChild() - oracle.xml.parser.v2.XMLNode.getFirstChild(), JPR 4-108

getFlags() - oracle.ODCI.ODCIFuncInfo.getFlags(), JPR 3-25

getFlags() - oracle.ODCI.ODCIPredInfo.getFlags(), JPR 3-48

getFlags() - oracle.ODCI.ODCIQueryInfo.getFlags(), JPR 3-53

getFlags() - oracle.ODCI.ODCIStatsOptions.getFlags(), JPR 3-61

getFloat(String) - oracle.jms.AQjmsMapMessage.getFloat(java.lang.String), JPR 2-89

getFloatProperty(String) - oracle.jms.AQjmsAdtMessage.getFloatProperty(java.lang.String), JPR 2-11

getFloatProperty(String) - oracle.jms.AQjmsMessage.getFloatProperty(java.lang.String), JPR 2-104

getId() - oracle.security.ssl.OracleSSLSession.getId(), OAS F-36

getId() - oracle.security.ssl.SSLSocketSession.getId(), OAS F-50

getImplementation() - oracle.xml.parser.v2.XMLDocument.getImplementation(), JPR 4-77

getIndexcols() - oracle.ODCI.ODCIIndexInfo.getIndexcols(), JPR 3-35

getIndexinfo() - oracle.ODCI.ODCIIndexCtx.getIndexinfo(), JPR 3-30

getIndexname() - oracle.ODCI.ODCIIndexInfo.getIndexname(), JPR 3-35

getIndexschema() - oracle.ODCI.ODCIIndexInfo.getIndexschema(), JPR 3-35

getInt(String) - oracle.jms.AQjmsMapMessage.getInt(java.lang.String), JPR 2-90

getIntProperty(String) - oracle.jms.AQjmsAdtMessage.getIntProperty(java.lang.String), JPR 2-12

getIntProperty(String) - oracle.jms.AQjmsMessage.getIntProperty(java.lang.String), JPR 2-105

getIocost() - oracle.ODCI.ODCICost.getIocost(), JPR 3-20

getJmsConnection() - oracle.jms.AQjmsSession.getJmsConnection(), JPR 2-178

getJMSCorrelationID() - oracle.jms.AQjmsMessage.getJMSCorrelationID(), JPR 2-105

getJMSCorrelationIDAsBytes() - oracle.jms.AQjmsMessage.getJMSCorrelationIDAsBytes(), JPR 2-106

getJMSDeliveryMode() - oracle.jms.AQjmsMessage.getJMSDeliveryMode(), JPR 2-106

getJMSDestination() - oracle.jms.AQjmsMessage.getJMSDestination(), JPR 2-106

getJMSExpiration() - oracle.jms.AQjmsMessage.getJMSExpiration(), JPR 2-107

getJMSMajorVersion() - oracle.jms.AQjmsConnectionMetaData.getJMSMajorVersion(), JPR 2-50

getJMSMessageID() - oracle.jms.AQjmsMessage.getJMSMessageID(), JPR 2-108

getJMSMessageIDAsBytes() - oracle.jms.AQjmsMessage.getJMSMessageIDAsBytes(), JPR 2-108

getJMSMinorVersion() - oracle.jms.AQjmsConnectionMetaData.getJMSMinorVersion(), JPR 2-50

getJMSPriority() - oracle.jms.AQjmsMessage.getJMSPriority(), JPR 2-108

getJMSProviderName() - oracle.jms.AQjmsConnectionMetaData.getJMSProviderName(), JPR 2-51

getJMSRedelivered() - oracle.jms.AQjmsMessage.getJMSRedelivered(), JPR 2-109

getJMSReplyTo() - oracle.jms.AQjmsAdtMessage.getJMSReplyTo(), JPR 2-12

getJMSReplyTo() - oracle.jms.AQjmsMessage.getJMSReplyTo(), JPR 2-109

getJMSTimestamp() - oracle.jms.AQjmsMessage.getJMSTimestamp(), JPR 2-109

getJMSType() - oracle.jms.AQjmsAdtMessage.getJMSType(), JPR 2-13

getJMSType() - oracle.jms.AQjmsMessage.getJMSType(), JPR 2-110

getJMSVersion() - oracle.jms.AQjmsConnectionMetaData.getJMSVersion(), JPR 2-51

getLastAccessedTime() - oracle.security.ssl.OracleSSLSession.getLastAccessedTime(), OAS F-37

getLastAccessedTime() - oracle.security.ssl.SSLSocketSession.getLastAccessedTime(), OAS F-50

getLastChild() - oracle.xml.parser.v2.XMLNode.getLastChild(), JPR 4-108

getLength() - oracle.xml.parser.v2.SAXAttrList.getLength(), JPR 4-45

getLineNumber(int) - oracle.xml.parser.v2.XMLParseException.getLineNumber(int), JPR 4-119

getLocalName() - oracle.xml.parser.v2.NSName.getLocalName(), JPR 4-39

getLocalName() - oracle.xml.parser.v2.XMLAttr.getLocalName(), JPR 4-57

getLocalName() - oracle.xml.parser.v2.XMLElement.getLocalName(), JPR 4-97

getLocalName(int) - oracle.xml.parser.v2.SAXAttrList.getLocalName(int), JPR 4-45

getLogStream() - oracle.jms.AQjmsOracleDebug.getLogStream(), JPR 2-130

getLong(String) - oracle.jms.AQjmsMapMessage.getLong(java.lang.String), JPR 2-90

getLongProperty(String) - oracle.jms.AQjmsAdtMessage.getLongProperty(java.lang.String), JPR 2-13

getLongProperty(String) - oracle.jms.AQjmsMessage.getLongProperty(java.lang.String), JPR 2-110

getMapNames() - oracle.jms.AQjmsMapMessage.getMapNames(), JPR 2-91

getMessage(int) - oracle.xml.parser.v2.XMLParseException.getMessage(int), JPR 4-119

getMessageListener() - oracle.jms.AQjmsConsumer.getMessageListener(), JPR 2-57

getMessageListener() - oracle.jms.AQjmsSession.getMessageListener(), JPR 2-178

getMessageSelector() - oracle.jms.AQjmsConsumer.getMessageSelector(), JPR 2-58

getMessageSelector() - oracle.jms.AQjmsQueueBrowser.getMessageSelector(), JPR 2-147

getMessageType(int) - oracle.xml.parser.v2.XMLParseException.getMessageType(int), JPR 4-120

getMetaData() - oracle.jms.AQjmsConnection.getMetaData(), JPR 2-46

getMethodname() - oracle.ODCI.ODCIFuncInfo.getMethodname(), JPR 3-25

getMethodname() - oracle.ODCI.ODCIPredInfo.getMethodname(), JPR 3-48

GETMISSES column

in V$ROWCACHE table, STU 19-22

getName() - oracle.jms.AQjmsAgent.getName(), JPR 2-26

getName() - oracle.xml.parser.v2.DTD.getName(), JPR 4-27

getName() - oracle.xml.parser.v2.XMLAttr.getName(), JPR 4-58

getName(int) - oracle.xml.parser.v2.SAXAttrList.getName(int), JPR 4-46

getNamespace() - oracle.xml.parser.v2.NSName.getNamespace(), JPR 4-39

getNamespace() - oracle.xml.parser.v2.XMLAttr.getNamespace(), JPR 4-58

getNamespace() - oracle.xml.parser.v2.XMLElement.getNamespace(), JPR 4-97

getNamespace(int) - oracle.xml.parser.v2.SAXAttrList.getNamespace(int), JPR 4-46

getNavigationMode() - oracle.jms.AQjmsConsumer.getNavigationMode(), JPR 2-58

getNavigationMode() - oracle.jms.AQjmsQueueReceiver.getNavigationMode(), JPR 2-154

getNavigationMode() - oracle.jms.AQjmsTopicReceiver.getNavigationMode(), JPR 2-208

getNavigationMode() - oracle.jms.AQjmsTopicSubscriber.getNavigationMode(), JPR 2-211

getNegotiatedProtocolVersion() - oracle.security.ssl.OracleSSLSession.getNegotiatedProtocolVersion(), OAS F-37

getNetworkcost() - oracle.ODCI.ODCICost.getNetworkcost(), JPR 3-20

getNextSibling() - oracle.xml.parser.v2.XMLNode.getNextSibling(), JPR 4-109

getNodeName() - oracle.xml.parser.v2.XMLNode.getNodeName(), JPR 4-109

getNodeType() - oracle.xml.parser.v2.XMLNode.getNodeType(), JPR 4-109

getNodeValue() - oracle.xml.parser.v2.XMLAttr.getNodeValue(), JPR 4-58

getNodeValue() - oracle.xml.parser.v2.XMLNode.getNodeValue(), JPR 4-109

getNodeValue() - oracle.xml.parser.v2.XMLText.getNodeValue(), JPR 4-132

getNoLocal() - oracle.jms.AQjmsConsumer.getNoLocal(), JPR 2-59

getNotations() - oracle.xml.parser.v2.DTD.getNotations(), JPR 4-27

getNumMessages() - oracle.xml.parser.v2.XMLParseException.getNumMessages(), JPR 4-120

getObject() - oracle.jms.AQjmsObjectMessage.getObject(), JPR 2-128

getObject(String) - oracle.jms.AQjmsMapMessage.getObject(java.lang.String), JPR 2-91

getObjectname() - oracle.ODCI.ODCIFuncInfo.getObjectname(), JPR 3-25

getObjectname() - oracle.ODCI.ODCIObject.getObjectname(), JPR 3-40

getObjectname() - oracle.ODCI.ODCIPredInfo.getObjectname(), JPR 3-48

getObjectProperty(String) - oracle.jms.AQjmsAdtMessage.getObjectProperty(java.lang.String), JPR 2-14

getObjectProperty(String) - oracle.jms.AQjmsMessage.getObjectProperty(java.lang.String), JPR 2-111

getObjectschema() - oracle.ODCI.ODCIFuncInfo.getObjectschema(), JPR 3-26

getObjectschema() - oracle.ODCI.ODCIObject.getObjectschema(), JPR 3-40

getObjectschema() - oracle.ODCI.ODCIPredInfo.getObjectschema(), JPR 3-49

getOptions() - oracle.ODCI.ODCIStatsOptions.getOptions(), JPR 3-61

getOwnerDocument() - oracle.xml.parser.v2.XMLDocument.getOwnerDocument(), JPR 4-77

getOwnerDocument() - oracle.xml.parser.v2.XMLNode.getOwnerDocument(), JPR 4-110

getParentNode() - oracle.xml.parser.v2.XMLAttr.getParentNode(), JPR 4-59

getParentNode() - oracle.xml.parser.v2.XMLDocumentFragment.getParentNode(), JPR 4-84

getParentNode() - oracle.xml.parser.v2.XMLNode.getParentNode(), JPR 4-110

getParseTree() - oracle.xml.parser.v2.ElementDecl.getParseTree(), JPR 4-34

getPeerCertificateChain() - oracle.security.ssl.OracleSSLSession.getPeerCertificateChain(), OAS F-37

getPeerCertificateChain() - oracle.security.ssl.SSLSocketSession.getPeerCertificateChain(), OAS F-50

getPeerHost() - oracle.security.ssl.OracleSSLSession.getPeerHost(), OAS F-38

getPeerHost() - oracle.security.ssl.SSLSocketSession.getPeerHost(), OAS F-50

getPeerRawCertificateChain() - oracle.security.ssl.OracleSSLSession.getPeerRawCertificateChain(), OAS F-38

getPrefix() - oracle.xml.parser.v2.NSName.getPrefix(), JPR 4-39

getPrefix() - oracle.xml.parser.v2.XMLAttr.getPrefix(), JPR 4-59

getPrefix() - oracle.xml.parser.v2.XMLElement.getPrefix(), JPR 4-97

getPrefix(int) - oracle.xml.parser.v2.SAXAttrList.getPrefix(int), JPR 4-47

getPreviousSibling() - oracle.xml.parser.v2.XMLNode.getPreviousSibling(), JPR 4-111

getPriority() - oracle.jms.AQjmsProducer.getPriority(), JPR 2-135

getPropertyNames() - oracle.jms.AQjmsAdtMessage.getPropertyNames(), JPR 2-15

getPropertyNames() - oracle.jms.AQjmsMessage.getPropertyNames(), JPR 2-111

getProtocol() - oracle.jms.AQjmsAgent.getProtocol(), JPR 2-26

getProviderMajorVersion() - oracle.jms.AQjmsConnectionMetaData.getProviderMajorVersion(), JPR 2-52

getProviderMinorVersion() - oracle.jms.AQjmsConnectionMetaData.getProviderMinorVersion(), JPR 2-52

getProviderVersion() - oracle.jms.AQjmsConnectionMetaData.getProviderVersion(), JPR 2-52

getPublicId() - oracle.xml.parser.v2.DTD.getPublicId(), JPR 4-27

getPublicId(int) - oracle.xml.parser.v2.XMLParseException.getPublicId(int), JPR 4-120

getQualifiedName() - oracle.xml.parser.v2.NSName.getQualifiedName(), JPR 4-40

getQualifiedName() - oracle.xml.parser.v2.XMLAttr.getQualifiedName(), JPR 4-59

getQualifiedName() - oracle.xml.parser.v2.XMLElement.getQualifiedName(), JPR 4-97

getQualifiedName(int) - oracle.xml.parser.v2.SAXAttrList.getQualifiedName(int), JPR 4-47

getQueue() - oracle.jms.AQjmsConsumer.getQueue(), JPR 2-59

getQueue() - oracle.jms.AQjmsProducer.getQueue(), JPR 2-135

getQueue() - oracle.jms.AQjmsQueueBrowser.getQueue(), JPR 2-148

getQueue(String, String) - oracle.jms.AQjmsSession.getQueue(java.lang.String, java.lang.String), JPR 2-179

getQueueConnectionFactory(String, Properties) - oracle.jms.AQjmsFactory.getQueueConnectionFactory(java.lang.String, java.util.Properties), JPR 2-80

getQueueConnectionFactory(String, String, int, String) - oracle.jms.AQjmsFactory.getQueueConnectionFactory(java.lang.String, java.lang.String, int, java.lang.String), JPR 2-80

getQueueName() - oracle.jms.AQjmsDestination.getQueueName(), JPR 2-67

getQueueOwner() - oracle.jms.AQjmsDestination.getQueueOwner(), JPR 2-68

getQueueTable(String, String) - oracle.jms.AQjmsSession.getQueueTable(java.lang.String, java.lang.String), JPR 2-179

getReleaseVersion() - oracle.xml.parser.v2.XMLParser.getReleaseVersion(), JPR 4-122

getRid() - oracle.ODCI.ODCIIndexCtx.getRid(), JPR 3-30

GETS column

in V$ROWCACHE table, STU 19-22

getSample() - oracle.ODCI.ODCIStatsOptions.getSample(), JPR 3-61

getSenderID() - oracle.jms.AQjmsMessage.getSenderID(), JPR 2-111

getSessionContext() - oracle.security.ssl.OracleSSLSession.getSessionContext(), OAS F-38

getSessionContext() - oracle.security.ssl.SSLSocketSession.getSessionContext(), OAS F-50

getShort(String) - oracle.jms.AQjmsMapMessage.getShort(java.lang.String), JPR 2-92

getShortProperty(String) - oracle.jms.AQjmsAdtMessage.getShortProperty(java.lang.String), JPR 2-15

getShortProperty(String) - oracle.jms.AQjmsMessage.getShortProperty(java.lang.String), JPR 2-112

getSpecified() - oracle.xml.parser.v2.XMLAttr.getSpecified(), JPR 4-60

getStandalone() - oracle.xml.parser.v2.XMLDocument.getStandalone(), JPR 4-77

getString() method, NLS 6-8

getString(String) - oracle.jms.AQjmsMapMessage.getString(java.lang.String), JPR 2-92

getStringProperty(String) - oracle.jms.AQjmsAdtMessage.getStringProperty(java.lang.String), JPR 2-16

getStringProperty(String) - oracle.jms.AQjmsMessage.getStringProperty(java.lang.String), JPR 2-112

getStringWithReplacement() method, NLS 6-8

getSupportedCipherSuites() - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.getSupportedCipherSuites(), OAS F-33

getSupportedCipherSuites() - oracle.security.ssl.OracleSSLSocketFactoryImpl.getSupportedCipherSuites(), OAS F-47

getSystemId() - oracle.xml.parser.v2.DTD.getSystemId(), JPR 4-28

getSystemId(int) - oracle.xml.parser.v2.XMLParseException.getSystemId(int), JPR 4-120

getTablename() - oracle.ODCI.ODCIArgDesc.getTablename(), JPR 3-4

getTablename() - oracle.ODCI.ODCIColInfo.getTablename(), JPR 3-13

getTableschema() - oracle.ODCI.ODCIArgDesc.getTableschema(), JPR 3-5

getTableschema() - oracle.ODCI.ODCIColInfo.getTableschema(), JPR 3-13

getTagName() - oracle.xml.parser.v2.XMLElement.getTagName(), JPR 4-98

getTarget() - oracle.xml.parser.v2.XMLPI.getTarget(), JPR 4-129

getText() - oracle.jms.AQjmsTextMessage.getText(), JPR 2-200

getTimeToLive() - oracle.jms.AQjmsProducer.getTimeToLive(), JPR 2-136

getTopic() - oracle.jms.AQjmsConsumer.getTopic(), JPR 2-60

getTopic() - oracle.jms.AQjmsProducer.getTopic(), JPR 2-136

getTopic() - oracle.jms.TopicReceiver.getTopic(), JPR 2-213

getTopic(String, String) - oracle.jms.AQjmsSession.getTopic(java.lang.String, java.lang.String), JPR 2-179

getTopicConnectionFactory(String, Properties) - oracle.jms.AQjmsFactory.getTopicConnectionFactory(java.lang.String, java.util.Properties), JPR 2-80

getTopicConnectionFactory(String, String, int, String) - oracle.jms.AQjmsFactory.getTopicConnectionFactory(java.lang.String, java.lang.String, int, java.lang.String), JPR 2-81

getTopicName() - oracle.jms.AQjmsDestination.getTopicName(), JPR 2-68

getTopicOwner() - oracle.jms.AQjmsDestination.getTopicOwner(), JPR 2-68

getTransacted() - oracle.jms.AQjmsSession.getTransacted(), JPR 2-180

getType(int) - oracle.xml.parser.v2.SAXAttrList.getType(int), JPR 4-47

getType(String) - oracle.xml.parser.v2.SAXAttrList.getType(java.lang.String), JPR 4-47

getValidationMode() - oracle.xml.parser.v2.XMLParser.getValidationMode(), JPR 4-122

getValue() - oracle.ODCI.ODCIArgDescRef.getValue(), JPR 3-10

getValue() - oracle.ODCI.ODCIColInfoRef.getValue(), JPR 3-18

getValue() - oracle.ODCI.ODCICostRef.getValue(), JPR 3-23

getValue() - oracle.ODCI.ODCIFuncInfoRef.getValue(), JPR 3-28

getValue() - oracle.ODCI.ODCIIndexCtxRef.getValue(), JPR 3-33

getValue() - oracle.ODCI.ODCIIndexInfoRef.getValue(), JPR 3-38

getValue() - oracle.ODCI.ODCIObjectRef.getValue(), JPR 3-46

getValue() - oracle.ODCI.ODCIPredInfoRef.getValue(), JPR 3-51

getValue() - oracle.ODCI.ODCIQueryInfoRef.getValue(), JPR 3-56

getValue() - oracle.ODCI.ODCIStatsOptionsRef.getValue(), JPR 3-64

getValue() - oracle.xml.parser.v2.XMLAttr.getValue(), JPR 4-60

getValue(int) - oracle.xml.parser.v2.SAXAttrList.getValue(int), JPR 4-48

getValue(String) - oracle.security.ssl.OracleSSLSession.getValue(java.lang.String), OAS F-38

getValue(String) - oracle.security.ssl.SSLSocketSession.getValue(java.lang.String), OAS F-50

getValue(String) - oracle.xml.parser.v2.SAXAttrList.getValue(java.lang.String), JPR 4-48

getValueNames() - oracle.security.ssl.OracleSSLSession.getValueNames(), OAS F-39

getValueNames() - oracle.security.ssl.SSLSocketSession.getValueNames(), OAS F-50

getVersion() - oracle.xml.parser.v2.XMLDocument.getVersion(), JPR 4-77

gigabyte, PLS 2-22

GIOP

described, NET 3-16

presentation, NET 3-16

global

indexes, DWG 6-6, DWG 18-55

striping, DWG 4-5

global authentication and authorization, SAD 22-11

global cache

coherence, measuring, PSA 11-9

lock allocation, PSA 6-16

synchronization and block classes, PSA 6-9

global cache control parameters, SRF 1-10

global cache cr block log flush time, PSA 12-15

global cache cr block log flushes, PSA 12-14

global cache cr block receive time, PSA 12-14

global cache cr block send time, PSA 12-14

global cache cr block serve time, PSA 12-14

global cache cr blocks received, PSA 12-14

global cache cr blocks served, PSA 12-14

global cache cr timeouts, PSA 12-14

global cache freelist waits, PSA 9-8

global cache parameters, PSA 1-9

global cache statistics

analyzing, PSA 12-11

GLOBAL clause

forcing a checkpoint, PSA 13-14

global constant parameter

rollback segments, SRF 1-42

same for all instances, PSA 1-8, PSA 1-10

global constant parameters

and non-PCM locks, PSC 4-9

list of, PSA 1-9

rollback segments, PSC 7-7

global coordinators, DDS 4-7

distributed transactions, DDS 4-7

global database consistency

distributed databases and, DDS 4-15

global database link qualifiers, NET 6-68

global database links, DDS 1-16, NET 4-15, NET 6-68

adding link qualifiers, NET 6-70

creating, DDS 2-11

registering with Oracle Names, NET 6-69

global database name, PSG 1-2, PSG 3-4, PSG 3-27, SAD 2-20

configuring on the listener, NET 7-13, NET C-51

defined, NET 6-3

described, NET 7-13, NET C-51

Global Database Name field in Net8 Assistant, NET 7-13, NET 8-9, NET 8-52

global database names

changing the domain, DDS 2-4

database links, DDS 1-13

distributed databases

how they are formed, DDS 2-2

enforcing for database links, DDS 1-15

enforcing global naming, DDS 2-3

impact of changing, DDS 1-42

querying, DDS 2-4

shared pool and, SCN 7-12

Global Directory Service (GDS), OAS 12-4

global dynamic performance view, PSC A-9

GLOBAL hint, PSA 12-10

global hints, STU 7-37

global indexes

partitioning, SCN 11-31

managing partitions, SCN 11-32, SCN 11-60

summary of index types, SCN 11-33

global lock statistics

analyzing, PSA 12-15

global locks, PSC 4-4

modes, PSC 4-12

global naming, SCN 385

global object names

database links, DDS 1-36

distributed databases, DDS 2-2

GLOBAL option

forcing a checkpoint, PSA 4-7

verifying access to files, PSC 7-2

GLOBAL PARTITION BY RANGE clause

of CREATE INDEX, SQL 7-302

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

global roles, OAS 17-6, GTK 2-9, SAD 22-11, SAD 23-9

global schema object names, SCN 1-28

GLOBAL TEMPORARY clause

of CREATE TABLE, SQL 7-391

global transactions, OCI 8-4

global user

current user links, SCN 64

global users, DDS 2-37, SAD 22-11, SQL 7-366, SQL 7-452

distributed systems

schema-dependent, DDS 1-27

schema-independent, DDS 1-28

downgrading, MIG 13-5, MIG 13-45

global V$ view tables, PSG 6-1, PSG 8-3

global work ratios

measuring, PSA 11-11

GLOBAL_DBNAME parameter, MIG F-15, NET 7-13, NET C-51, PSG 3-15

GLOBAL_NAME parameter, NET 8-9, NET 8-52, NET C-45

GLOBAL_NAME view, SRF 2-146

using to determine global database name, DDS 2-4

GLOBAL_NAMES initialization parameter, DDS 1-15, RAR 1-4, REP 7-3, SCN 385, SRF 1-43

GLOBAL_NAMES parameter

of ALTER SESSION, SQL 7-88

of ALTER SYSTEM, SQL 7-110

globally partitioned indexes, SQL 7-302

globals

naming conventions, DCI 2-5

glossary. See terminology

GMS

removed for 8.1, PSC A-4

goals for tuning, STU 1-9, STU 2-14

golden rule

of backup and recovery, SBR 3-2

GOTO action

in the WHENEVER statement, PC_ 9-25

of WHENEVER directive, PC_ F-119, PCO 8-16, PCO F-93

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-89

GRANT ANY PRIVILEGE system privilege, SCN 305, SQL 7-529

GRANT ANY ROLE system privilege, SQL 7-525

GRANT command

ADMIN OPTION, ADG 11-28

effective time, ADG 11-34

last DDL time, ADG 11-33

object privileges, ADG 11-21, ADG 11-30

system privileges, ADG 11-28

GRANT CONNECT THROUGH clause

for multi-tier authorization, SAD 22-14

of ALTER USER, SQL 7-194, SQL 7-195

GRANT object_privileges, SQL 7-532

GRANT OPTION, ADG 11-30

about, SAD 23-12

revoking, SAD 23-14

GRANT option for EXECUTE privilege, ADO 2-11

GRANT statement, SCN 13

ADMIN option, SAD 23-11

GRANT option, SAD 23-12

locks, SCN 240

object privileges, SAD 23-11

SYSOPER/SYSDBA privileges, SAD 1-13

system privileges and roles, SAD 23-10

when takes effect, SAD 23-17

Grant System Privilege, ADQ 9-42

GRANT system_privileges_and_roles statement, SQL 7-519

granted queue, PSC 5-28, PSC 5-30

grantee event attribute, ADG 14-3

granting

access, OID 9-24, OID 9-31

entry-level access

by using Oracle Directory Manager, OID 9-47

execute user-defined type, ADO 2-11

privileges and roles, SCN 305

roles, ADG 11-28

system privileges, ADG 11-28, ADG 11-29

granting privileges and roles

listing grants, SAD 23-22

SYSOPER/SYSDBA privileges, SAD 1-13

grantQueuePrivilege(Session, String, String, boolean) - oracle.jms.AQjmsDestination.grantQueuePrivilege(javax.jms.Session, java.lang.String, java.lang.String, boolean), JPR 2-69

GRANTS

Export parameter, SUT 1-21

Import parameter, SUT 2-22

grants

exporting, SUT 1-21

importing, SUT 2-12, SUT 2-22

grantSystemPrivilege(String, String, boolean) - oracle.jms.AQjmsSession.grantSystemPrivilege(java.lang.String, java.lang.String, boolean), JPR 2-180

grantTopicPrivilege(Session, String, String, boolean) - oracle.jms.AQjmsDestination.grantTopicPrivilege(javax.jms.Session, java.lang.String, java.lang.String, boolean), JPR 2-69

granules, DWG 5-3

block range, DWG 5-3

partition, DWG 5-4

GRAPHIC datatype, SUT 5-59

EXTERNAL format

SQL*Loader, SUT 5-66

GRAPHIC datatype (SQL/DS or DB2), SQL 2-30

GRAPHIC EXTERNAL datatype, SUT 5-59

Greater or Equal filter, in Oracle Directory Manager, OID 6-8, OID 7-7, OID 9-22, OID 9-29

greater than or equal to tests, SQL 3-5

greater than tests, SQL 3-5

GREATEST function, SQL 4-36

GREATEST_LB function

desupported, MIG 9-30

group

MAXLOGFILES, PSA 3-3

redo log files, PSA 3-3, PSA 3-8

group attributes, default, LEG 4-8, LEG 4-10

GROUP BY clause, PLS 5-3

decreasing demand for, DWG 18-39

NOSORT clause, STU 20-39

of SELECT, SQL 7-578

of SELECT and subqueries, SQL 7-571

optimizing views, STU 4-78

temporary tablespaces, SCN 3-12

GROUP clause, PSA 13-5

group commits, SCN 8-10

group comparison conditions, SQL 5-16

group entries, OID 2-4

adding, OID 7-20

creating

using ldapmodify, OID A-13

using Oracle Directory Manager, OID 7-20

group items

allowed as host variables, PCO 4-21

implicit VARCHAR, PCO 4-27

Group Items as host variables, PCO A-4

Group Membership Services, PSC A-10

removed for 8.1, PSC A-4

Group Membership Services (GMS), GTK 3-62

group owner

snapshot groups, REP 3-24

group separator, NLS 2-21

default, NLS 2-10

NLS_NUMERIC_CHARACTERS parameter, NLS 2-21

group-based locking, PSC 5-33

grouping

compatibility check, DWG 19-18

conditions, DWG 19-30

GROUPING aggregate function, PLS 5-3

GROUPING function, DWG 17-15, SQL 4-36

when to use, DWG 17-18

Grouping, Message, ADQ 12-66

groupOfNames object class, OID 7-20, OID 7-21

groupOfUniqueNames, OID 7-20

groups

archived redo log, SBR 6-6, SBR 6-7

granting access to by using Oracle Directory Manager, OID 9-24, OID 9-31

online redo log, SBR 6-6, SBR 6-7

privilege, OID 9-4

redo log files, PSC 7-4

LOG_FILES initialization parameter, SAD 6-10

unique numbers, PSC 7-5

V$LOGFILE, PSC 7-5

groups, instance, SCN 175

growth

accommodating with more instances, PSA 5-17

room for, PSA 9-6

GTRID. See transaction identifier

guess, PLS 2-18

guesses in logical rowids, SCN 12-21

staleness, SCN 12-22

statistics for, SCN 12-22

guest user, managing user name and password, OID 5-19

GUI, PSG 6-12

GUI, LSM

GUI, Oracle

Oracle Enterprise Manager, LEG 4-5

guidelines

GV$ view, PSC A-9

GV$ views

for parallel servers, SRF 3-2

GV$CACHE view, PSA 12-9

GV$CLASS_PING view, PSA 12-9

GV$DBLINK view, DDS 2-24

GV$FILE_PING view, PSA 12-9

GV$FILESTAT view, DWG 18-70, PSG 8-11, PSG 8-12, PSG 8-13

GV$LIBRARYCACHE view, PSA 12-9

GV$LICENSE view, PSG 8-16, PSG 8-17, PSG 8-18, PSG 8-19

GV$LOCK_ACTIVITY view, PSG 8-14

GV$PARAMETER view, PSA 2-5

GV$PING view, PSA 12-9, PSG 8-7, PSG 8-8, PSG 8-10

GV$PROCESS view, PSG 8-15

GV$PX_PROCESS view, PSA 2-6

GV$PX_PROCESS_SYSSTAT view, PSA 2-6

GV$PX_SESSION view, PSA 2-6

GV$PX_SESSSTAT view, PSA 2-6

GV$ROWCACHE view, PSA 12-9

GV$SESSION view, PSG 8-15