随笔分类 - Oracle

[Oracle]11g内存占用调整步骤

摘要：按如下的步骤调整内存 1. sqlplus /nolog2. conn / as sysdba 3. show parameter target 4. show parameter sgaalter system set sga_max_size=512M scope=spfile;alter sy 阅读全文

posted @ 2017-08-25 18:02 Tigmer 阅读(919) 评论(0) 推荐(0) 编辑

[Oracle]查看和修改连接数

摘要：#登陆数据库sqlplus system/*** as sysdba#显示当前最大连接数:show parameter processes; show parameter sessions;#修改最大连接数:alter system set processes = 300 scope = spfil... 阅读全文

posted @ 2015-06-17 10:42 Tigmer 阅读(126) 评论(0) 推荐(0) 编辑

统计用户表的大小

摘要：SELECT * FROM( SELECT SEGMENT_NAME, SUM(BYTES)/1024/1024/1024 G FROM DBA_SEGMENTS WHERE OWNER = userGROUP BY SEGMENT_NAME ORDER BY 2 DESC) 阅读全文

posted @ 2015-06-08 19:11 Tigmer 阅读(138) 评论(0) 推荐(0) 编辑

[Oracle]ocilib绑定数组实现批量写入

摘要：#include "ocilib.h"#define INSERT_SQL_00 MT("INSERT INTO C_PICRECORD_00 (ID, DEV_ID) VALUES (:id, :devid)")#define CHECK_SUCCESS(ret, x, err, clear... 阅读全文

posted @ 2015-01-27 14:50 Tigmer 阅读(1137) 评论(0) 推荐(0) 编辑

[Oracle]日期和毫秒转换（Date->int）

摘要：--日期转换毫秒SELECTTO_NUMBER(TO_DATE('2005-03-2912:30:45','YYYY-MM-DDHH24:MI:SS')- TO_DATE('1970-01-01 0:0:0','YYYY-MM-DDHH24:MI:SS'))*24*60*60*1000 FROMDU... 阅读全文

posted @ 2015-01-24 10:53 Tigmer 阅读(1504) 评论(0) 推荐(0) 编辑

Oracle查看被锁的表和解锁[转]

摘要：查看被锁的表 select p.spid,a.serial#, c.object_name,b.session_id,b.oracle_username,b.os_user_name from v$process p,v$session a, v$locked_object b,all_objects c where p.addr=a.paddr and a.process=b.process and c.object_id=b.object_id ; 查看那个用户那个进程照成死锁，锁的级别select b.owner,b.object_... 阅读全文

posted @ 2014-02-26 13:45 Tigmer 阅读(152) 评论(0) 推荐(0) 编辑