qq_30458209的博客

前几天系统突然出现严重卡顿，部分模块卡死现象，最后排查下 发现是有些sql查询卡死 数据库连接数过大导致 ，最后按一下流程 查询出对应sql 做了下优化解决 ----查看oracle DB的负载情况 SELECT * FROM (SELECT A.INSTANCE_NUMBER, A.SNAP_ID, B.BEGIN_INTERVAL_TIME + 0 BEGIN_TIME, to_char(END_INTERVAL_TIME, 'yyyy-MM-dd hh24:mm:ss') END_TIME,...

--查询表空间使用情况 SELECT a.tablespace_name "表空间名", total / (1024 * 1024 * 1024) "表空间大小(G)", free / (1024 * 1024 * 1024) "表空间剩余大小(G)", (total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)", round((total - free) / total, 4) * 100 "使用率 %" ...

exp 用户/密码@0.0.0.0:1521/orcl file=F:\dmps\sgt\wgh.dmp tables=(表名,表名)

这里写自定义目录标题oracle 锁表处理 oracle 锁表处理 – 查询锁表 SELECT sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode FROM vlockedobjectlo,dbaobjectsao,vlocked_object lo, dba_objects ao, vlockedo​bjectlo,dbao​bjectsao,vsession ses

--批量更新 快速游标法 BEGIN FOR cr IN ( SELECT D .name FROM XXXX WHERE D .numIN (select tz.num from XXXX tz WHERE tz.xzz_dzbm not in (select a.xzz_dzbm ...

SELECT A.COLUMN_NAME AS "字段名", A.DATA_TYPE AS "字段类型", A.CHAR_LENGTH AS "字段长度", A.NULLABLE AS "能否为空", B.comments AS "备注" FROM all_tab_columns A, DBA_COL_COMMENTS B WHERE A.owner = B.owner AND A.table_name = B.table_nam...