Transcription

SAP HANA System Tables and Monitoring ViewsReferenceSAP HANA Appliance Software SPS 04Target AudienceConsultantsAdministratorsSAP Hardware PartnerOthers12012-07-20

Copyright Copyright 2012 SAP AG. All rights reservedSAP Library document classification: PUBLICNo part of this publication may be reproduced or transmitted in any form or forany purpose without the express permission of SAP AG. The informationcontained herein may be changed without prior notice.Some software products marketed by SAP AG and its distributors containproprietary software components of other software vendors.Microsoft, Windows, Excel, Outlook, PowerPoint, Silverlight, and Visual Studioare registered trademarks of Microsoft Corporation.IBM, DB2, DB2 Universal Database, System i, System i5, System p, Systemp5, System x, System z, System z10, z10, z/VM, z/OS, OS/390, zEnterprise,PowerVM, Power Architecture, Power Systems, POWER7, POWER6 ,POWER6, POWER, PowerHA, pureScale, PowerPC, BladeCenter, SystemStorage, Storwize, XIV, GPFS, HACMP, RETAIN, DB2 Connect, RACF,Redbooks, OS/2, AIX, Intelligent Miner, WebSphere, Tivoli, Informix, and SmarterPlanet are trademarks or registered trademarks of IBM Corporation.Linux is the registered trademark of Linus Torvalds in the United States and othercountries.Adobe, the Adobe logo, Acrobat, PostScript, and Reader are trademarks orregistered trademarks of Adobe Systems Incorporated in the United States andother countries.Oracle and Java are registered trademarks of Oracle and its affiliates.UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, andMultiWin are trademarks or registered trademarks of Citrix Systems Inc.HTML, XML, XHTML, and W3C are trademarks or registered trademarks ofW3C , World Wide Web Consortium, Massachusetts Institute of Technology.Apple, App Store, iBooks, iPad, iPhone, iPhoto, iPod, iTunes, Multi-Touch,Objective-C, Retina, Safari, Siri, and Xcode are trademarks or registeredtrademarks of Apple Inc.IOS is a registered trademark of Cisco Systems Inc.RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, BlackBerry Pearl,BlackBerry Torch, BlackBerry Storm, BlackBerry Storm2, BlackBerry PlayBook,and BlackBerry App World are trademarks or registered trademarks of Research22012-07-20

in Motion Limited.Google App Engine, Google Apps, Google Checkout, Google Data API, GoogleMaps, Google Mobile Ads, Google Mobile Updater, Google Mobile, Google Store,Google Sync, Google Updater, Google Voice, Google Mail, Gmail, YouTube,Dalvik and Android are trademarks or registered trademarks of Google Inc.INTERMEC is a registered trademark of Intermec Technologies Corporation.Wi-Fi is a registered trademark of Wi-Fi Alliance.Bluetooth is a registered trademark of Bluetooth SIG Inc.Motorola is a registered trademark of Motorola Trademark Holdings LLC.Computop is a registered trademark of Computop Wirtschaftsinformatik GmbH.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAPBusinessObjects Explorer, StreamWork, SAP HANA, and other SAP productsand services mentioned herein as well as their respective logos are trademarks orregistered trademarks of SAP AG in Germany and other countries.Business Objects and the Business Objects logo, BusinessObjects, CrystalReports, Crystal Decisions, Web Intelligence, Xcelsius, and other BusinessObjects products and services mentioned herein as well as their respective logosare trademarks or registered trademarks of Business Objects Software Ltd.Business Objects is an SAP company.Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and otherSybase products and services mentioned herein as well as their respective logosare trademarks or registered trademarks of Sybase Inc. Sybase is an SAPcompany.Crossgate, [email protected] EDDY, B2B 360 , and B2B 360 Services are registeredtrademarks of Crossgate AG in Germany and other countries. Crossgate is anSAP company.All other product and service names mentioned are the trademarks of theirrespective companies. Data contained in this document serves informationalpurposes only. National product specifications may vary.These materials are subject to change without notice. These materials areprovided by SAP AG and its affiliated companies ("SAP Group") for informationalpurposes only, without representation or warranty of any kind, and SAP Groupshall not be liable for errors or omissions with respect to the materials. The onlywarranties for SAP Group products and services are those that are set forth inthe express warranty statements accompanying such products and services, ifany. Nothing herein should be construed as constituting an additional warranty.32012-07-20

Table of ContentTable of ContentTable of ContentSAP HANA System Tables and Monitoring Views ReferenceAbout thi s DocumentSAP HANA Gui desAUDIT POLICIESAUTHORIZATION GRAPHCONSTRAINTSCS BO VIEWSCS FREESTYLE COLUMNSCS JOIN CONDITIONSCS JOIN CONSTRAINTSCS JOIN PATHSCS JOIN TABLESCS KEY FIGURESCS VIEW COLUMNSDATA TYPESEFFECTIVE PRIVILEGESEXPLAIN PLAN TABLEFULLTEXT INDEXESFUNCTIONSFUNCTION PARAMETERSGRANTED PRIVILEGESGRANTED ROLESINDEXESINDEX COLUMNSINVALID CONNECT ATTEMPTSLAST USED PASSWORDSM ATTACHED STORAGESM BACKUP CATALOGM BACKUP CATALOG FILESM BLOCKED TRANSACTIONSM CACHESM CACHES RESETM CATALOG MEMORYM CE CALCSCENARIOSM CE CALCVIEW DEPENDENCIESM CE DEBUG INFOSM CE DEBUG JSONSM CE DEBUG NODE MAPPINGM CE PLE CALCSCENARIOSM CLIENT VERSIONSM COMPACTION THREADM CONDITIONAL VARIABLESM CONDITIONAL VARIABLES RESETM CONNECTIONSM CONNECTION STATISTICSM CONTAINER DIRECTORYM CONTAINER NAME DIRECTORYM CONTEXT 12012-07-20

Table of ContentM CONTEXT MEMORYM CONTEXT MEMORY RESETM CONVERTER STATISTICSM CONVERTER STATISTICS RESETM CS COLUMNSM CS PARTITIONSM CS TABLESM DATABASEM DATABASE HISTORYM DATA VOLUMESM DATA VOLUME PAGE STATISTICSM DATA VOLUME PAGE STATISTICS RESETM DATA VOLUME SUPERBLOCK STATISTICSM DELTA MERGE STATISTICSM DISKSM ERROR CODESM EVENTSM EXPENSIVE STATEMENTSM EXPORT BINARY STATUSM EXTRACTORSM FEATURESM FULLTEXT QUEUESM GARBAGE COLLECTION STATISTICSM GARBAGE COLLECTION STATISTICS RESETM HEAP MEMORYM HEAP MEMORY RESETM HISTORY INDEX LAST COMMIT IDM HOST INFORMATIONM HOST RESOURCE UTILIZATIONM IMPORT BINARY STATUSM INIFILESM INIFILE CONTENTSM JOB PROGRESSM LANDSCAPE HOST CONFIGURATIONM LICENSEM LIVECACHE CONTAINER STATISTICSM LIVECACHE CONTAINER STATISTICS RESETM LIVECACHE LOCKSM LIVECACHE LOCK STATISTICSM LIVECACHE LOCK STATISTICS RESETM LIVECACHE OMS VERSIONSM LIVECACHE PROCEDURE STATISTICSM LIVECACHE PROCEDURE STATISTICS RESETM LIVECACHE SCHEMA STATISTICSM LIVECACHE SCHEMA STATISTICS RESETM LOCK WAITS STATISTICSM LOG BUFFERSM LOG BUFFERS RESETM LOG PARTITIONSM LOG PARTITIONS RESETM LOG SEGMENTSM LOG SEGMENTS RESETM 1161171181191201221231261271291302012-07-20

Table of ContentM MEMORY OBJECTSM MEMORY OBJECTS RESETM MEMORY OBJECT DISPOSITIONSM MERGED TRACESM MONITORSM MONITOR COLUMNSM MUTEXESM MUTEXES RESETM MVCC TABLESM PAGEACCESS STATISTICSM PAGEACCESS STATISTICS RESETM PASSWORD POLICYM PERFTRACEM PERSISTENCE MANAGERSM PERSISTENCE MANAGERS RESETM PREPARED STATEMENTSM READWRITELOCKSM READWRITELOCKS RESETM RECORD LOCKSM RS INDEXESM RS TABLESM SAVEPOINT STATISTICSM SAVEPOINT STATISTICS RESETM SEMAPHORESM SEMAPHORES RESETM SERVICESM SERVICE MEMORYM SERVICE NETWORK IOM SERVICE STATISTICSM SERVICE THREADSM SERVICE THREAD CALLSTACKSM SERVICE TRACESM SERVICE TYPESM SESSION CONTEXTM SHARED MEMORYM SNAPSHOTSM SQL PLAN CACHEM SQL PLAN CACHE OVERVIEWM SQL PLAN CACHE RESETM SYSTEM LIMITSM SYSTEM OVERVIEWM TABLESM TABLE LOB FILESM TABLE LOCATIONSM TABLE LOCKSM TABLE PERSISTENCE LOCATIONSM TABLE PERSISTENCE STATISTICSM TABLE VIRTUAL FILESM TEMPORARY TABLESM TEMPORARY TABLE COLUMNSM TEMPORARY VIEWSM TEMPORARY VIEW 911921931941952012-07-20

Table of ContentM TENANTSM TEXT ANALYSIS LANGUAGESM TEXT ANALYSIS MIME TYPESM TOPOLOGY TREEM TRACEFILESM TRACEFILE CONTENTSM TRANSACTIONSM UNDO CLEANUP FILESM VERSION MEMORYM VOLUMESM VOLUME FILESM VOLUME IO PERFORMANCE STATISTICSM VOLUME IO PERFORMANCE STATISTICS RESETM VOLUME IO STATISTICSM VOLUME IO STATISTICS RESETM VOLUME SIZESM WORKLOADM XS APPLICATIONSM XS APP ISSUESOBJECTSOBJECT DEPENDENCIESOWNERSHIPPROCEDURESPROCEDURE OBJECTSPROCEDURE PARAMETERSQUERY PLANSROLESSCHEMASSEQUENCESSQLSCRIPT TRACESTATISTICSSTRUCTURED PRIVILEGESSYNONYMSTABLESTABLE COLUMNSTABLE COLUMNS ODBCTRANSACTION HISTORYTRIGGERSUSERSUSER PARAMETERSVIEWSVIEW COLUMNSSta ti s ti cs Server Ta bl esGLOBAL COLUMN TABLES SIZEGLOBAL INTERNAL DISKFULL EVENTSGLOBAL INTERNAL EVENTSGLOBAL PERSISTENCE STATISTICSHOST BLOCKED TRANSACTIONSHOST DATA VOLUME PAGE STATISTICSHOST DATA VOLUME SUPERBLOCK STATISTICSHOST DELTA MERGE STATISTICSHOST HEAP 482492502512522532012-07-20

Table of ContentHOST LONG RUNNING STATEMENTSHOST ONE DAY FILE COUNTHOST RESOURCE UTILIZATION STATISTICSHOST SERVICE MEMORYHOST SERVICE STATISTICSHOST VOLUME FILESHOST VOLUME IO STATISTICSSTATISTICS ALERTSSTATISTICS ALERT INFORMATIONSTATISTICS ALERT LAST CHECK INFORMATIONSTATISTICS INTERVAL INFORMATIONSTATISTICS LASTVALUESSTATISTICS STATESTATISTICS 2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceSAP HANA System Tables and Monitoring Views ReferenceAbout this DocumentThis guide describes the system tables and monitoring views available in the SAP HANA database.System tables and monitoring views allow you to query for various information about the system state usingSQL commands. The results appear as tables.Each table contains the following columns:Column name: Contains the name of the table column nameData type: Describes what the data type is (integer, character, boolean and so on). For a fullexplanation of data types see the SAP HANA SQL Reference.Unit: If there is a relevant measurement unit for the column (millisecond, byte and so on) it isdisplayed hereDescription: Describes the columnThe tables are listed in alphabetical order. System tables can be identified as they have no prefix whereas themonitoring views are prefixed with M . Some other abbreviations are used in the table names and they areexplained here:CS Column StoreRS Row storeCE Calculation EngineXS XSEngineSAP HANA GuidesLatest documentation for SAP com/hana appliance92012-07-20

SAP HANA System Tables and Monitoring Views ReferenceAUDIT POLICIESShort descriptionDefined audit policiesStructure10Column nameData typeUnitDescriptionAUDIT POLICY NAMENVARCHAR(256)Audi t pol i cy na meAUDIT POLICY OIDBIGINTObject ID of the a udi t pol i cyEVENT STATUSVARCHAR(5000)Sta tus of events to be a udi ted: 'SUCCESSFUL EVENTS','UNSUCCESSFUL EVENTS', 'ALL EVENTS'EVENT LEVELVARCHAR(5000)Level of events to be a udi ted: 'EMERGENCY', 'CRITICAL','ALERT', 'WARNING', 'INFO'IS AUDIT POLICY ACTIVEVARCHAR(5000)Audi t pol i cy i s a cti ve: 'TRUE', 'FALSE'EVENT ACTIONVARCHAR(5000)Acti on to be a udi ted, for exa mpl e: 'SELECT', 'GRANTPRIVILEGE', .USER NAMENVARCHAR(5000)Us er whos e a cti ons a re to be a udi tedOBJECT TYPEVARCHAR(5000)Type of object to be a udi tedOBJECT SCHEMAVARCHAR(5000)Schema of object to be a udi tedOBJECT NAMEVARCHAR(5000)Na me of object to be a udi ted2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceAUTHORIZATION GRAPHShort descriptionRepresents authorization dependencies of complex database objectsFull descriptionThe WHERE clause is mandatory when you SELECT from AUTHORIZATION GRAPH. This view only returnsdata if you specify 'ROOT DEPENDENT TYPE ID .AND ROOT DEPENDENT OBJECT ID .' as part of thewhere clause.StructureColumn nameData typeUnitDescriptionDEPENDENT TYPE IDINTEGERObject type ID of the dependent objectDEPENDENT TYPE ID NAMENVARCHAR(5000)Object type na me of the dependent objectDEPENDENT SUBTYPE IDSMALLINTObject s ubtype ID of the dependent objectDEPENDENT SUBTYPE ID NAMENVARCHAR(256)Object s ubtype na me of the dependent objectDEPENDENT OBJECT IDBIGINTObject ID of the dependent objectDEPENDENT SCHEMA NAMENVARCHAR(256)Schema na me the dependent object bel ongs toDEPENDENT OBJECT NAMENVARCHAR(256)Object na me of the dependent objectDEPENDENT OWNER OIDBIGINTID of the us er owni ng the dependent objectDEPENDENT OWNER NAMENVARCHAR(5000)Na me of the us er owni ng the dependent objectDEPENDENT READONLYINTEGERRea donl y property of the dependent objectUNDERLYING TYPE IDINTEGERObject type ID of the underl yi ng objectUNDERLYING TYPE ID NAMENVARCHAR(5000)Object type na me of the underl yi ng objectUNDERLYING SUBTYPE IDSMALLINTObject s ubtype ID of the underl yi ng objectNVARCHAR(256)Object s ubtype na me of the underl yi ng objectUNDERLYING OBJECT IDBIGINTObject ID of the underl yi ng objectUNDERLYING SCHEMA NAMENVARCHAR(256)Schema na me the underl yi ng object bel ongs toUNDERLYING OBJECT NAMENVARCHAR(256)Object na me of the underl yi ng objectUNDERLYING OWNER OIDBIGINTID of the us er owni ng the underl yi ng objectUNDERLYING OWNER NAMENVARCHAR(5000)Na me of the us er owni ng the underl yi ng objectUNDERLYING READONLYINTEGERRea donl y property of the underl yi ng objectDEPENDENCY USER OIDBIGINTID of the us er requi red to ha ve a certa i n pri vi l egeon the underl yi ng object i n order to va l i da te thedependent objectDEPENDENCY USER NAMENVARCHAR(256)Na me of the us er requi red to ha ve a certa i npri vi l ege on the underl yi ng object i n order tova l i da te the dependent objectUNDERLYING SUBTYPE ID NAME112012-07-20

SAP HANA System Tables and Monitoring Views Reference12DEPENDENCY TYPEINTEGERType of dependency determi nes the va l i da ti ons ema nti cs for dependenci es s ha ri ng the s a medependent objectsPRIVILEGE IDBIGINTID of the pri vi l ege the dependency us er i srequi red to ha ve on the underl yi ng objectPRIVILEGE NAMENVARCHAR(256)Na me of the pri vi l ege the dependency us er i srequi red to ha ve on the underl yi ng objectIS VALIDTINYINTCurrent s ta te of the dependency. It i s s et by theobject va l i da ti on l ogi c a nd refl ects mi s s i ngpri vi l eges or i nva l i da ted objects2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCONSTRAINTSShort descriptionConstraints defined for tablesStructure13Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meTABLE NAMENVARCHAR(256)Ta bl e na meCOLUMN NAMENVARCHAR(256)Col umn na mePOSITIONSMALLINTCol umn number i n ta bl e defi ni ti onCONSTRAINT NAMENVARCHAR(256)Cons tra i nt na meIS PRIMARY KEYVARCHAR(5000)Cons tra i nt i s pri ma ry key cons tra i nt: 'TRUE', 'FALSE'IS UNIQUE KEYVARCHAR(5000)Cons tra i nt i s uni que cons tra i nt: 'TRUE', 'FALSE'2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS BO VIEWSShort descriptionBusiness object views for column store join viewsStructure14Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meBO VIEW NAMENVARCHAR(256)Bus i nes s object vi ew na meANCHOR SCHEMA NAMENVARCHAR(256)Anchor s chema na meANCHOR TABLE NAMENVARCHAR(256)Anchor ta bl e na me2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS FREESTYLE COLUMNSShort descriptionFreestyle search columns for column store join viewsStructure15Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meCOLUMN NAMENVARCHAR(256)Frees tyl e col umn na me2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS JOIN CONDITIONSShort descriptionJoin conditions defined for column store join viewsStructure16Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meJOIN CONDITION NAMENVARCHAR(256)Joi n condi ti on na meJOIN ORDERBIGINTJoi n order numberTABLE SCHEMA NAME1NVARCHAR(256)Schema na me of col umn 1TABLE NAME1NVARCHAR(256)Ta bl e na me of col umn 1COLUMN NAME1NVARCHAR(256)Na me of col umn 1TABLE SCHEMA NAME2NVARCHAR(256)Schema na me of col umn 2TABLE NAME2NVARCHAR(256)Ta bl e na me of col umn 2COLUMN NAME2NVARCHAR(256)Na me of col umn 2CONSTRAINTSNVARCHAR(256)Joi n cons tra i nt na meJOIN TYPEVARCHAR(5000)Joi n type: 'i nner', 'l eft', 'ri ght', 'ful l 'CARDINALITYVARCHAR(5000)Joi n ca rdi na l i ty: '1:1', '1:n', 'n:1', 'n:n'2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS JOIN CONSTRAINTSShort descriptionJoin constraints defined for column store join viewsStructure17Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meJOIN CONSTRAINT NAMENVARCHAR(256)Joi n cons tra i nt na meCONSTRAINT TYPEVARCHAR(5000)Type of cons tra i nt ownerLOCATIONNVARCHAR(256)Na me of cons tra i nt ownerTABLE SCHEMA NAMENVARCHAR(256)Schema na me of ta bl eTABLE NAMENVARCHAR(256)Ta bl e na me of col umnCOLUMN NAMENVARCHAR(256)Col umn na meOPERATORNVARCHAR(256)Opera torVALUENVARCHAR(5000)Va l ue2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS JOIN PATHSShort descriptionJoin paths defined for column store join viewsStructure18Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meJOIN PATH NAMENVARCHAR(256)Joi n pa th na meJOIN CONDITIONSNVARCHAR(5000)Comma s epa ra ted l i s t of joi n condi ti onsJOIN CONSTRAINTSNVARCHAR(5000)Comma s epa ra ted l i s t of joi n cons tra i nts2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS JOIN TABLESShort descriptionPhysical tables referred by column store join viewsStructure19Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meTABLE SCHEMA NAMENVARCHAR(256)Schema na me of phys i ca l ta bl e na meTABLE NAMENVARCHAR(256)Phys i ca l ta bl e na meTABLE TYPEVARCHAR(5000)Type of ta bl e2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS KEY FIGURESShort descriptionKey figures defined for column store join viewsStructure20Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meKEY FIGURE NAMENVARCHAR(256)Key fi gure na meDEFAULT AGGREGATION TYPENVARCHAR(5000)Aggrega ti on type l i ke: 's um', 'count', 'mi n', .DESCRIPTIONNVARCHAR(5000)Des cri pti onUNIT CONVERSION NAMENVARCHAR(256)Na me of uni t convers i onTABLE SCHEMA NAMENVARCHAR(256)Schema na me of ta bl eTABLE NAMENVARCHAR(256)Ta bl e na me of col umnCOLUMN NAMENVARCHAR(256)Col umn na meEXPRESSION FLAGSVARCHAR(5000)Expres s i on fl a gsEXPRESSIONNVARCHAR(256)Expres s i on2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceCS VIEW COLUMNSShort descriptionColumns defined for column store join viewsStructure21Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meVIEW NAMENVARCHAR(256)Joi n vi ew na meVIEW COLUMN NAMENVARCHAR(256)Vi ew col umn na meTABLE SCHEMA NAMENVARCHAR(256)Schema na me of ta bl eTABLE NAMENVARCHAR(256)Ta bl e na me of col umnCOLUMN NAMENVARCHAR(256)Col umn na meJOIN PATHNVARCHAR(256)Joi n pa th na meCS TYPEVARCHAR(5000)Col umn s tore da ta typeEXPRESSION FLAGSVARCHAR(5000)Expres s i on fl a gsEXPRESSIONNVARCHAR(256)Expres s i on2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceDATA TYPESShort descriptionAvailable SQL data typesStructure22Column nameData typeUnitDescriptionTYPE IDSMALLINTDa ta type IDTYPE NAMEVARCHAR(16)Da ta type na meCOLUMN SIZEINTEGERMa xi mum s i ze of the da ta type tha t thi s s ys tem ca n s upportLITERAL PREFIXCHAR(1)ODBC 2.0 SQLGetTypeInfo Va rcha r. Cha ra cter or cha ra cters us edto prefi x a l i tera l , for exa mpl e, a s i ngl e quota ti on ma rk (') forcha ra cter da ta types or 0x for bi na ry da ta types ; NULL i sreturned for da ta types where a l i tera l prefi x i s not a ppl i ca bl eLITERAL SUFFIXCHAR(1)ODBC 2.0 SQLGetTypeInfo Va rcha r. Cha ra cter or cha ra cters us edto termi na te a l i tera l , for exa mpl e, a s i ngl e quota ti on ma rk (')for cha ra cter da ta types ; NULL i s returned for da ta types wherea l i tera l s uffi x i s not a ppl i ca bl eCREATE PARAMSVARCHAR(16)ODBC 2.0 SQLGetTypeInfo Va rcha r. A l i s t of keywords ,s epa ra ted by comma s , corres pondi ng to ea ch pa ra meter tha tthe a ppl i ca ti on ma y s peci fy i n pa renthes es when us i ng thena me tha t i s returned i n the TYPE NAME fi el dNULLABLETINYINTSpeci fi es whether the da ta type ca n a ccept nul l or notCASE SENSITIVETINYINTODBC 2.0 SQLGetTypeInfo s ma l l i nt. Whether a cha ra cter da tatype i s ca s e-s ens i ti ve i n col l a ti ons a nd compa ri s onsSEARCHABLETINYINTHow the da ta type ca n be us ed i n the WHERE cl a us eUNSIGNED ATTRIBUTETINYINTSi gned or uns i gnedFIXED PREC SCALETINYINTWhether the da ta type ha s predefi ned fi xed preci s i on a nds ca l e (ODBC)AUTO UNIQUE VALUETINYINTWhether the da ta type i s a utoi ncrementi ng (ODBC)LOCAL TYPE NAMEVARCHAR(16)ODBC 2.0 SQLGetTypeInfo va rcha r. Loca l i zed vers i on of the da tas ource-dependent na me of the da ta typeMINIMUM SCALESMALLINTODBC 2.0 SQLGetTypeInfo s ma l l i nt. The mi ni mum s ca l e of theda ta type on the da ta s ourceMAXIMUM SCALESMALLINTODBC 2.0 SQLGetTypeInfo s ma l l i nt. The ma xi mum s ca l e of theda ta type on the da ta s ourceSQL DATA TYPESMALLINTODBC 3.0 SQLGetTypeInfo s ma l l i nt. The va l ue of the SQL da tatype a s i t a ppea rs i n the SQL DESC TYPE fi el d of thedes cri ptor. Thi s col umn i s the s a me a s the DATATYPE col umn,except for i nterva l a nd da teti me da ta typesSQL DATETIME SUBSMALLINTODBC 3.0 SQLGetTypeInfo s ma l l i nt. When the va l ue ofSQL DATATYPE i s SQL DATETIME or SQL INTERVAL, thi s col umnconta i ns the da teti me/i nterva l s ubcodeNUM PREC RADIXINTEGERODBC 3.0 SQLGetTypeInfo i nteger. In ca s e of a n a pproxi ma te2012-07-20

SAP HANA System Tables and Monitoring Views Referencenumeri c da ta type, va l ue i s 2 to i ndi ca te tha t COLUMN SIZEs peci fi es the number of bi ts . For exa ct numeri c da ta typesva l ue 10 i ndi ca tes tha t COLUMN SIZE s peci fi es the number ofdeci ma l di gi tsINTERVAL PRECISION23SMALLINTODBC 3.0 SQLGetTypeInfo s ma l l i nt. If the da ta type i s a ni nterva l da ta type, then thi s col umn conta i ns the va l ue of thei nterva l l ea di ng preci s i on. Otherwi s e, thi s col umn i s NULL2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceEFFECTIVE PRIVILEGESShort descriptionPrivileges of the current userFull descriptionThe WHERE clause is mandatory when you SELECT from EFFECTIVE PRIVILEGES. This view only returns dataif you specify 'USER NAME .' as part of the where clause.Structure24Column nameData typeUnitDescriptionUSER NAMENVARCHAR(256)Na me of the us er for whom effecti ve pri vi l eges a re s hownGRANTEENVARCHAR(256)Us er or rol e tha t ha s the pri vi l egeGRANTEE TYPEVARCHAR(5000)'USER' or 'ROLE'GRANTORNVARCHAR(256)Us er or rol e tha t provi ded the pri vi l egeGRANTOR TYPEVARCHAR(5000)'USER' or 'ROLE'OBJECT TYPENVARCHAR(256)Type of the gra nted object l i ke: 'TABLE', 'SCHEMA', .SCHEMA NAMENVARCHAR(256)Schema na me the object bel ongs toOBJECT NAMENVARCHAR(5000)Object na me of gra nted objectCOLUMN NAMENVARCHAR(5000)Col umn na mePRIVILEGENVARCHAR(256)Pri vi l ege gra ntedIS GRANTABLEVARCHAR(5000)Pri vi l ege wa s gra nted 'WITH GRANT OPTION', 'WITH ADMINOPTION': 'TRUE', 'FALSE'IS VALIDVARCHAR(5000)Pri vi l ege i s va l i d or i t beca me i nva l i d beca us e of i mpl i ci trevoki ng: 'TRUE', 'FALSE'2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceEXPLAIN PLAN TABLEShort descriptionSQL query plan explanation resultStructure25Column nameData typeUnitDescriptionSTATEMENT NAMEVARCHAR(256)The s tri ng s peci fi ed a s STATEMENT NAME on executi ngEXPLAIN PLAN comma nd. Thi s i s us ed to di s ti ngui s h pl a nsfrom ea ch other when there a re mul ti pl e pl a ns i nEXPLAIN PLAN TABLE vi ewOPERATOR NAMEVARCHAR(5000)Na me of a n opera tor. Deta i l s a re des cri bed i n thefol l owi ng s ecti onOPERATOR DETAILSNCLOBDeta i l s of a n opera tor. Predi ca tes a nd expres s i ons us ed bythe opera tor a re s hown hereEXECUTION ENGINEVARCHAR(256)Executi on engi ne where the pl a n opera tor i s executed:COLUMN or ROWSCHEMA NAMENVARCHAR(256)Schema na me the dependent object bel ongs toTABLE NAMENVARCHAR(256)Na me of da ta ba s e ta bl es a nd vi ews a cces s ed by a nopera torTABLE TYPEVARCHAR(5000)Ta bl e s tored type: COLUMN or ROWTABLE SIZEDOUBLEEs ti ma ted i nput row count of a n opera tor. Thi s i s a va i l a bl eonl y for opera tors a cces s i ng ta bl es a nd vi ews di rectl yOUTPUT SIZEDOUBLEEs ti ma ted output row count of a n opera torSUBTREE COSTDOUBLEEs ti ma ted cos t of executi ng the s ubtree s ta rti ng from a nopera torOPERATOR IDINTEGERUni que ID of a n opera tor. IDs a re i ntegers s ta rti ng from 1PARENT OPERATOR IDINTEGEROPERATOR ID of the pa rent of a n opera tor. The s ha pe of aquery pl a n i s a tree a nd the topol ogy of the tree ca n berecons tructed us i ng OPERATOR ID a ndPARENT OPERATOR ID. PARENT OPERATOR ID of the rootopera tor i s s hown a s NULLLEVELINTEGERLevel from the root opera tor. Level of the root opera tor i s 1,l evel of a chi l d of the root opera tor i s 2 a nd s o on. Thi s ca nbe uti l i zed for output i ndenta ti onPOSITIONINTEGERPos i ti on i n the pa rent opera tor. Pos i ti on of the fi rs t chi l d i s1, pos i ti on of the s econd chi l d i s 2 a nd s o onHOSTVARCHAR(256)Hos t where the pl a n opera tor i s genera tedPORTINTEGERPort where the pl a n opera tor i s genera tedTIMESTAMPTIMESTAMPDa te a nd ti me when the EXPLAIN PLAN comma nd wa sexecutedCONNECTION IDINTEGERConnecti on ID2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceFULLTEXT INDEXESShort descriptionFulltext indexes on table columnsStructure26Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na meTABLE NAMENVARCHAR(256)Ta bl e na meTABLE OIDBIGINTObject ID of the ta bl eINDEX NAMENVARCHAR(256)Na me of the ful l text i ndexINDEX OIDBIGINTObject ID of the ful l text i ndexLANGUAGE COLUMNNVARCHAR(256)Col umn na me of the i ndexed ta bl e conta i ni ngl a ngua ge i ndi ca tors for the i ndexed documentsMIME TYPE COLUMNNVARCHAR(256)Col umn na me of the i ndexed ta bl e conta i ni ngmi metype i ndi ca tors for the i ndexed documentsLANGUAGE DETECTIONNVARCHAR(256)Set of l a ngua ges to be cons i dered for a utoma ti cl a ngua ge detecti onFAST PREPROCESSVARCHAR(5000)If s et to true, preproces s i ng wi l l be done wi th reducedfuncti ona l i ty (e.g. l i ngui s ti c s ea rch i s not a va i l a bl e),whi ch wi l l s peed up the i ndexi ngFUZZY SEARCH INDEXVARCHAR(5000)If s et to true, fuzzy s ea rch i s performed wi th a na ddi ti ona l i ndex (fa s ter s ea rch, but hi gher memorycons umpti on)SEARCH ONLYVARCHAR(5000)If s et to true, the text-a ttri butes wi l l not s tore a nyDAFs , i .e. i t i s not pos s i bl e to retri eve the HTMLconverted or ori gi na l da ta from the text-a ttri bute. If thetext-a ttri bute i s a s ha dow a ttri bute (i .e. crea ted vi aCREATE FULLTEXT INDEX), the s ource-a ttri bute(conta i ni ng the ori gi na l da ta ) i s not a ffected by thi sfl a gIS EXPLICITVARCHAR(5000)If s et to true, the i ndex i s a n expl i ci t ful l text i ndex, i .e.crea ted by CREATE FULLTEXT INDEXFLUSH AFTER DOCUMENTSINTEGERUs ed to s tore cha nge-tra cki ng beha vi our of the ful l texti ndexFLUSH EVERY MINUTESINTEGERUs ed to s tore cha nge-tra cki ng beha vi our of the ful l texti ndexCONFIGURATIONNVARCHAR(256)An expl i ci t confi g-fi l e ca n be s peci fi ed, for exa mpl e, toena bl e na med enti ty extra cti onINTERNAL COLUMN NAMENVARCHAR(512)Na me of the i nterna l text-a ttri bute, onl y s et i f ful l texti ndex wa s not crea ted us i ng TEXT-da ta typePHRASE INDEX RATIOREALFl oa t between 0.0 a nd 1.0 whi ch s peci fi es how muchmemory the phra s e i ndex ma y us e (a s percenta ge ofthe memory s i ze of the ful l text i ndex)2012-07-20

SAP HANA System Tables and Monitoring Views Reference272012-07-20

SAP HANA System Tables and Monitoring Views ReferenceFUNCTIONSShort descriptionAvailable functionsStructure28Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na me of the functi onFUNCTION NAMENVARCHAR(256)Na me of the functi onFUNCTION OIDBIGINTObject ID of the functi onINPUT PARAMETER COUNTINTEGERInput type pa ra meter countRETURN VALUE COUNTINTEGERReturn va l ue type pa ra meter countIS UNICODEVARCHAR(5000)Speci fi es whether the functi on conta i ns Uni code or not:'TRUE', 'FALSE'DEFINITIONNCLOBQuery s tri ng of the functi onFUNCTION TYPEVARCHAR(5000)Type of the functi on2012-07-20

SAP HANA System Tables and Monitoring Views ReferenceFUNCTION PARAMETERSShort descriptionParameters of functionsStructure29Column nameData typeUnitDescriptionSCHEMA NAMENVARCHAR(256)Schema na me of the functi onFUNCTION NAMENVARCHAR(256)Na me of the functi onFUNCTION OIDBIGINTObject ID of the functi onPARAMETER NAMENVARCHAR(256)Pa ra meter na meDATA TYPE IDINTEGERDa ta type IDDATA TYPE NAMEVARCHAR(5000)Da ta type na meLENGTHINTEGERPa ra meter l engthSCALEINTEGERSca l e of the pa ra meterPOSITIONINTEGEROrdi na l pos i ti on of the pa ra meterTABLE TYPE SCHEMAVARCHAR(5000)Schema na me of ta bl e type i f DATA TYPE NAME i sTABLE TYPETABLE TYPE NAMEVARCHAR(5000)Na me of ta bl e type i f DATA TYPE NAME i s TABLE TYPEPARAMETER TYPEVARCHAR(5000)Pa ra meter mode: IN, OUT, INOUTHAS DEFAULT VALUEVARCHAR(5000)Speci fi es whether the pa ra meter ha s defa ul t va l u

SAP HANA System Tables and Monitoring Views Reference About this Document This guide describes the system tables and monitoring views available in the SAP HANA database. System tables and monitoring views allow you to query for various information about the syste