---查询数据库定义的job(视图)
select * from user_jobs;
---查看分区表
select * from ALL_PART_TABLES;
---可查看分区表的名字、归属表空间以及表的详细分区情况
select * from USER_TAB_PARTITIONS;
--可查看用户所有的分区表,以及分区方式。
select * from USER_PART_TABLES;
---查看对应分区的数据
select * from test_range_part partition(hash_dt01);
---查看索引的状态
select * from user_indexes where index_name='PK_LOGINLOG';
---查询数据库定义的job(视图)
select * from user_jobs;
---查询数据库定义的job(视图)
select * from user_jobs;
---删除job
begin
sys.dbms_job.remove(123);
commit;
end;
---跨分区查询
select * from ydyt_login_log partition (part201803)
union
select * from ydyt_login_log partition (part201804)
---查询表上有多少分区
select * from user_tab_partitions where table_name='YDYT_LOGIN_LOG';
---查询索引信息
select object_name,object_type,tablespace_name,sum(value)
from v$segment_statistics
where statistic_name IN ('physical reads','physical write','logical reads')and object_type='INDEX'
group by object_name,object_type,tablespace_name
order by 4 desc
select * from user_jobs;
---查看分区表
select * from ALL_PART_TABLES;
---可查看分区表的名字、归属表空间以及表的详细分区情况
select * from USER_TAB_PARTITIONS;
--可查看用户所有的分区表,以及分区方式。
select * from USER_PART_TABLES;
---查看对应分区的数据
select * from test_range_part partition(hash_dt01);
---查看索引的状态
select * from user_indexes where index_name='PK_LOGINLOG';
---查询数据库定义的job(视图)
select * from user_jobs;
---查询数据库定义的job(视图)
select * from user_jobs;
---删除job
begin
sys.dbms_job.remove(123);
commit;
end;
---跨分区查询
select * from ydyt_login_log partition (part201803)
union
select * from ydyt_login_log partition (part201804)
---查询表上有多少分区
select * from user_tab_partitions where table_name='YDYT_LOGIN_LOG';
---查询索引信息
select object_name,object_type,tablespace_name,sum(value)
from v$segment_statistics
where statistic_name IN ('physical reads','physical write','logical reads')and object_type='INDEX'
group by object_name,object_type,tablespace_name
order by 4 desc