oracle11g使用DBA_DATAPUBMP_JOBS和DBA_DATAPUMP_SESSIONS视图来显示数据泵取作业的信息，查看expdp进度：select * from DBA_DATAPUBMP_JOBS; select * from DBA_DATAPUMP_SESSIONS; select sid,serial# from v$session s,dba_datapump_s...
时光匆匆，记录是对思维的沉淀；
oracle11g使用DBA_DATAPUBMP_JOBS和DBA_DATAPUMP_SESSIONS视图来显示数据泵取作业的信息，查看expdp进度：select * from DBA_DATAPUBMP_JOBS; select * from DBA_DATAPUMP_SESSIONS; select sid,serial# from v$session s,dba_datapump_s...
出现场景：Oracle删除用户时报错SQL〉DROP USER USERXXXX CASCADE ERROR：ORA-01940: cannot drop a user that is currently connected由于当前用户正连接到数据库，所以无法删除解决办法：1、查询此用户的会话进程，SQL〉SELECT SID,SERIAL# FROM V$SESSION WHERE US...
1、查询数据库当前进程的连接数：select count(*) from v$process; 2、查看数据库当前会话的连接数：select count(*) from v$session; 3、查看数据库的并发连接数：select count(*) from v$session where status='ACTIVE'; 4、查看当前数据库建立的会话情况：select...