View Oracle database information (Windows systems)

You can view and control the size and content of the Oracle database. The following SQL commands are provided to view general database information. Prior to entering any SQL statements, you must run the Oracle SQLPlus utility as follows: Procedure Log on to the operating system as a user with administrator privilege. Manually set the Oracle environment by typing the following commands: Copy set ORACLE_HOME=Oracle-home-path set ORACLE_SID=tc set PATH=%PATH%;%ORACLE_HOME%\bin Start the Oracle SQLPlus utility: Copy %ORACLE_HOME%\bin\sqlplus Log on to SQL. At the SQLPLUS prompt, type the following command: Copy connect db-user/password Replace db-user with the Teamcenter database user name; replace password with the database user password. The following system message is displayed: Copy Connected. Issue any of the following commands to obtain desired information about your database. To list a summary of the Teamcenter database files, type the following command from the SQLPLUS prompt: Copy select * from sys.dba_data_files; To list available space in the tablespace in bytes, type the following command from the SQLPLUS prompt: Copy select sum (bytes) from sys.dba_free_space where tablespace_name=’IDATA’; To list available space in the SYSTEM tablespace in bytes, type the following command from the SQLPLUS prompt: Copy select sum (bytes) from sys.dba_free_space where tablespace_name =’SYSTEM’; To exit the SQL*Plus utility, type the following command from the SQLPLUS prompt: Copy exit