select count(*) from v$process ;????--當(dāng)前的數(shù)據(jù)庫連接數(shù)
select value from v$parameter where name ='processes';? --數(shù)據(jù)庫允許的最大連接數(shù)
alter system set processes = 300 scope = spfile; ?--修改最大連接數(shù):
shutdown immediate; --關(guān)閉數(shù)據(jù)庫
startup; --重啟數(shù)據(jù)庫
?select count(*) from v$session??--當(dāng)前的session連接數(shù)
select count(*) from v$session where status='ACTIVE'; --并發(fā)連接數(shù)
oracle清除分區(qū)表分區(qū)數(shù)據(jù)造虏；
ALTER TABLE tb_report_fyh TRUNCATE PARTITION P201703;
select 'alter index '||index_name||' rebuild online;' from user_indexes where status <> 'VALID' and index_name not like'%$$';
alter index IDX_SHXYDM_QYBM rebuild online;
alter index IDX_SHXYDM_JFSSQ rebuild online;
alter index IDX_SHXYDM_SSQ rebuild online;
alter index PID rebuild online;
