These views are supported in TimesTen Scaleout and TimesTen Classic. TimesTen provides several views that are prefixed with V$ and GV$. There is neither a SYS.ALL_PROFILES nor a SYS.USER_PROFILES system view.Ĭontains data about the text source of the stored PL/SQL objectsĬontains data about persistent parameter settings for stored PL/SQL unitsĬontains data about the tables in the databaseĬontains data about the views in the database There is neither a SYS.ALL_PASSWORD_LIMITS nor a SYS.DBA_PASSWORD_LIMITS system view.Ĭontains data about the compiler settings for PL/SQL objectsĬontains data about PL/SQL procedures and functionsĬontains data about profiles and the limits for each of the profiles.
Table 1-3 Static data dictionary views NameĬontains data about the arguments of stored procedures and functionsĬontains data about the dependencies between procedures, packages, functions, and package bodiesĬontains data about errors on the stored objectsĬontains data about the identifiers in the stored objectsĬontains data about the objects that are stored in the databaseĬontains data about the size (in bytes) of PL/SQL objectsĬontains data about the password profile resources that are assigned to the user. When retrieving these columns with an ODBC program, the application must bind them using SQL_C_SBIGINT. System tables declare certain fields as data type TT_BIGINT. Names stored in columns are 30 characters in length. Locks acquired by users on system tables may prevent others from defining data or executing the SQLPrepare ODBC function or the Connection.prepareStatement JDBC method. The ADMIN or SELECT ANY TABLE privilege is required to access other system tables and views. SELECT * FROM sys.dba_tab_privs WHERE grantee='PUBLIC' You can see the list of objects by using this query: By default PUBLIC has SELECT privileges on various system tables and views. Privileges are required to access system tables and views. See "ttIsql" in the Oracle TimesTen In-Memory Database Reference for more information on the ttIsql utility. Use the ttIsql allviews command to display a list of all system and user views. Use the ttIsql alltables to display a list of all system and user tables. There are several tables and views that are included in TimesTen, but are not relevant for your use. TimesTen provides system tables and views so that you can gather information about metadata in your database.