show parameter db_recovery_file_dest_size;select sum(a.BLOCK_SIZE*a.BLOCKS)/1024/1024 from v$archived_log a where a.DELETED='NO';SELECT SUM(BLOCKS *BLOCK_SIZE )/1024/1024 AS "Size(M)",TRUNC(completion_time) FROM v$archived_logGROUP BY TRUNC(completion_time)删除归...【阅读全文】
1:使用vmstat和top查看系统cpu,io,内存使用情况2:查看当前状态下存在的等待事件select sid,event,p1,p2,seconds_in_wait from v$session_wait where event not like '%SQL%' and event not like 'rdbms%' and event not like '%message%' and event not like '%Streams AQ%' AND EVENT NOT LIKE '%slave%' order by e...【阅读全文】
1、查看已经存在的进程数SQL> select count(*) from v$process;2、查看数据库设置的进程数量SQL> select value from v$parameter where name = 'processes';3、根据实际情况更改进程数alter system set processes=500 scope=spfile;需重启数据库或者 ps -ef|grep $ORACLE_SID|grep -v grep| grep LOCAL=NO| awk '...【阅读全文】
最近在使用impdp导入数据的时候,因源库gbk与目标库utf8的字符集不一样,造成导入时目标库中表的字段长度不够。报错信息如下:点击(此处)折叠或打开ORA-02374: conversion error loading table "HN_CM_IRMS_35_TNMS"."PTN_NE_TO_SERVICE"ORA-12899: value too large for colu...【阅读全文】
查看所有用户分区表及分区策略(1、2级分区表均包括):SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,p.partitioning_type AS 分区类型, p.column_name AS 分区键,decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,q.subpartition...【阅读全文】