Tablesapce
check after login into database: +++++++++++++++++++++++ select instance_name,name,host_name,open_mode,database_role,startup_time from gv$database a, gv$instance b where a.inst_id=b.instance_number; select name,open_mode,database_role,startup_time from v$database; show parameter db_name; Tablespace: SQL>C/OLDNAME/NEWNAME--> alter tablespace openlink_data add datafile size 30G; select tablespace_name,used_space,tablespace_size tbsp_size, used_percent from sys.dba_tablespace_usage_metrics; select tablespace_name,used_space,tablespace_size tbsp_size, used_percent from sys.dba_tablespace_usage_metrics where tablespace_name='OPENLINL_DATA'; dba_objects: select owner,object_type,status,count(1) from dba_objects where owner in ('MTP','MTPTEST',MTP_MASK','TEIPZDO4','ZHAOJ38')group by owner,object_type,status order by 1,2,3,4;