Oracle®TimesTenIn-MemoryDatabaseSystemTablesandLimitsReferenceRelease11.2.1E17114-04January2011OracleTimesTenIn-MemoryDatabaseSystemTablesandLimitsReference,Release11.2.1E17114-04Copyright©2011,Oracleand/oritsaffiliates.Allrightsreserved.Thissoftwareandrelateddocumentationareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandareprotectedbyintellectualpropertylaws.Exceptasexpresslypermittedinyourlicenseagreementorallowedbylaw,youmaynotuse,copy,reproduce,translate,broadcast,modify,license,transmit,distribute,exhibit,perform,publish,ordisplayanypart,inanyform,orbyanymeans.Reverseengineering,disassembly,ordecompilationofthissoftware,unlessrequiredbylawforinteroperability,isprohibited.Theinformationcontainedhereinissubjecttochangewithoutnoticeandisnotwarrantedtobeerror-free.Ifyoufindanyerrors,pleasereportthemtousinwriting.IfthissoftwareorrelateddocumentationisdeliveredtotheU.S.GovernmentoranyonelicensingitonbehalfoftheU.S.Government,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,theuse,duplication,disclosure,modification,andadaptationshallbesubjecttotherestrictionsandlicensetermssetforthintheapplicableGovernmentcontract,and,totheextentapplicablebythetermsoftheGovernmentcontract,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftwareLicense(December2007).OracleUSA,Inc.,500OracleParkway,RedwoodCity,CA94065.Thissoftwareisdevelopedforgeneraluseinavarietyofinformationmanagementapplications.Itisnotdevelopedorintendedforuseinanyinherentlydangerousapplications,includingapplicationswhichmaycreateariskofpersonalinjury.Ifyouusethissoftwareindangerousapplications,thenyoushallberesponsibletotakeallappropriatefail-safe,backup,redundancy,andothermeasurestoensurethesafeuseofthissoftware.OracleCorporationanditsaffiliatesdisclaimanyliabilityforanydamagescausedbyuseofthissoftwareindangerousapplications.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Thissoftwareanddocumentationmayprovideaccesstoorinformationoncontent,products,andservicesfromthirdparties.OracleCorporationanditsaffiliatesarenotresponsibleforandexpresslydisclaimallwarrantiesofanykindwithrespecttothird-partycontent,products,andservices.OracleCorporationanditsaffiliateswillnotberesponsibleforanyloss,costs,ordamagesincurredduetoyouraccesstooruseofthird-partycontent,products,orservices.iiiContentsPreface................................................................................................................................................................viiAudience......................................................................................................................................................viiRelateddocuments.....................................................................................................................................viiConventions................................................................................................................................................viiDocumentationAccessibility...................................................................................................................viiiTechnicalsupport........................................................................................................................................ixWhat'sNew......................................................................................................................................................xiNewfeaturesinRelease11.2.1.4.0............................................................................................................xiNewfeaturesinRelease11.2.1.1.0............................................................................................................xi1SystemTablesTablesandviewsreservedforinternalorfutureuse........................................................................1-1Requiredprivilegestoaccesssystemtablesandviews....................................................................1-3SYS.ALL_ARGUMENTS........................................................................................................................1-4SYS.ALL_COL_PRIVS............................................................................................................................1-7SYS.ALL_DEPENDENCIES...................................................................................................................1-8SYS.ALL_DIRECTORIES.......................................................................................................................1-9SYS.ALL_ERRORS...............................................................................................................................1-10SYS.ALL_IDENTIFIERS........