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 锁表处理– 查询锁表SELECTsess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_modeFROMvlockedobjectlo,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 BWHERE A.owner = B.owner AND A.table_name = B.table_nam...