统计x$bh 表的state列 这列值等于0的有多少，不等于0的有多少。
select  * from tb where isnull(SCORE,1)<>0
select count(*) as count from x$bh where state<>0;
 扩文件系统命令 smitty chjfs2


创建用户portal01 密码portal01 
create user portal01 identified by portal01;
查询表的所有者
select owner from all_tables where table_name =upper('wj_patternplan');
授予表读写权限
grant select,insert,delete,update on PDMM501B.hrNotif to portal01; 
grant connect to portal01; 
拼创建同名词串，要赋予新用户create synonym的权限
grant create synonym to portal01;
执行上面创建的同名词串
create synonym hrNotif for PDMM501B.hrNotif;
create synonym wj_patternplan for PDMM501B.wj_patternplan;