Wesley13· 1474 阅读 ·2021-10-11 # oracle# oracle数据库# oracle表空间# 连接数# dbfORACLE常用系统查询SQL 1 查询系统所有对象SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUSFROM DBA_OBJECTS WHERE OWNERUPPER('SCOTT')2 查看系统所有表SELECT