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;