Oracle Help 执行过的 SQL 语句 SELECT * FROM V$SQLAREA T WHERE ROWNUM <= 50 and t.PARSING_SCHEMA_NAME = 'ZTENET' and t.SQL_TEXT like '%ZTE_FMT_SEAL%' ORDER BY T.LAST_ACTIVE_TIME DESC; 执行中的 SQL 语句 SELECT B.SID ORACLEID, B.USERNAME 登录ORACLE用户名, B.SERIAL#, SPID 操作系统ID, PADDR, SQL_TEXT 正在执行的SQL, B.MACHINE 计算机名 FROM V$PROCESS A, V$SESSION B, V$SQLAREA C WHERE A.ADDR = B.PADDR AND B.SQL_HASH_VALUE = C.HASH_VALUE and b.USERNAME = 'ZTENET'; 修改用户名密码 select username from dba_users where username = 'ZTEFMT'; -- 用户名密码不要加单引号 alter user ZTEFMT identified by ztefmt888888;