oracle服务硬件升级 调整参数
author：skate
time：2010-05-13
1)If memory increases and you're 64-bit, e.g 8G to 16G, Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration, some parameters, based on CPU_count, need to adjust,
* cpu_count
* fast_start_parallel_rollback
* parallel_max_servers
* log_buffer
* db_block_lru_latches
Please read below:
"Why is cpu_count important?
The Oracle cpu_count is determined when you start Oracle. The cpu_count affects the Oracle cost-based optimizer through many calculated parameters that use cpu_count as their basis and are considered every time that Oracle creates an execution plan for a SQL statement. A doubled setting for cpu_count can result in changes to your explain plans when moving from a single to multiple CPUs or when you increase the number of CPUs in your system.
The cpu_count is used to determine the settings for several important init.ora parameters:
· fast_start_parallel_rollback - The default value is 2 times the number of CPU of your system, but some DBAs recommend setting this value to 4 times the cpu_count.
* db_block_lru_latches – This defaults to the following formula : (CPU_COUNT x 6) or (DB_BLOCK_BUFFERS/50), whichever is less. In earlier releases it defaulted to CPU_COUNT/2. If you set DB_BLOCK_LRU_LATCHES higher than this max value on systems where it is available (<9i) or set the undocumented parameter _DB_BLOCK_LRU_LATCHES higher, then Oracle just ignores this and sets it internally to the above calculated value. However it will be set to Num_pools x (CPU_COUNT/2) if multiple buffer pools (default, recycle, keep and any of the multi-block size pools) are setup.
*&nb
相关文档：
查看回收站中表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
恢复表
SQL
>flashback table test_drop to before drop;或
SQL
>flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to befor ......
最近做短信群发项目有一个需求,需要客户大批量(十万级)导入数据.
开始是用insert单条数据,10万条数据要20分钟
后来发现可以用insert all 一条sql一次导入500条记录,这样10万条数据只用了1.5分钟,导入速度提高了近来20倍
下面就使用insert all的心得体会记录如下.
使用方法:
insert all into table_name(col_1,col_2) v ......
oracle不用安装客户端也可以用plsql远程连接(转）
oracle不用安装客户端也可以用plsql远程连接 pl sql远程连接
2008-01-14 14:33
oracle不用安装客户端也可以用plsql远程连接
每次问人家，plsql 可不可以直接远程连接服务器，他们都说要安装客户端，记得以前� ......
oracle启动问题
一：数据库没有启动
#sqlplus /nolog
sql>connect /as sysdba
sql>startup
二：监听出问题
登录DB服务器
使用lsnrctl start/stop开启/关闭监听
使用lsnrctl status查看状态
理应为：
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPAP)(PORT=1521)))
STATUS of the ......
CREATE OR REPLACE PROCEDURE kevin_proc(x varchar) IS
a VARCHAR(20);
b VARCHAR(20);
CURSOR mycur(rn NUMBER) IS SELECT * from t_kevin_test WHERE ROWNUM<rn;
BEGIN
OPEN mycur(10);
LOOP FETCH mycur INTO a,b;
EXIT WHEN mycur%NOTFOUND;
Dbms_Output.put_line('a: '||a);
Dbms_Output.put_line('b: '| ......
