- 博客(12)
- 收藏
- 关注
RSS订阅原创 Oracle tuning the buffer cache
<br />LRU list, checkpoint queue<br /> buffer states:pinned,clean,free/unused,dirty<br /> block check para: db_block_checksum db_block_checking<br /> cache para:db_block_size,db_cache_size,db_keep_cache_size,db_recycle_cache_size,db_cache_advice<br />
2010-12-31 09:46:00
525
原创 Oracle tuning the shared pool
<br />shared pool:library cache, data dictionary cache, (user global area for shared server)<br /> para:shared_pool_size,shared_pool_resved_size,open_cursors,cursor_space_for_time,session_cached_cursors,cursor_sharing<br /> lib cache: sql statements and
2010-12-28 21:04:00
455
原创 Oracle database configuration and i/o issues
<br />storage:file system,raw partitions,automatic storage management<br /> distributing files: separate datafiles and redo log files,stripe table data,reduce disk i/o unrelated to db<br /> i/o statistics: v$filestat v$tempstat v$datafile v$tempfile<br /
2010-12-27 11:23:00
436
原创 Oracle diagnostic and tuning tools
<br />alert log file: show parameter dump<br /> ORA-600 internal error,block corruption error<br /> clear alterlog: cat /dev/null >alert*.log<br /> log_checkpoints_to_alert set true<br /> alter session set sql_trace =true;<br /> execute dbms_system.se
2010-12-21 11:11:00
728
原创 Oracle overview of oracle database performance tuning
<br />sla :service level agreements<br /> problems:session,cursor,relational design<br /> tuning steps in devlepment: tune design,application,memory,i/o,contention,os<br /> baseline <br /> steps for a production db: define the problem,examine os/oracle
2010-12-20 17:22:00
486
原创 Oracle sql
<br />写程序时 select * 速度比直接写列名要慢，需要转换 <br /> null算数运算后还是null ||操作还是原来的值<br /> distinct a,b,c 选择的所有列都不同时才去除<br /><br /> where 子句不能用别名<br /> between and 相当于大于等于>= 小于等于<=<br /> in 相当于 or<br /><br /> like % _ <br /> where job_id like '%sa/_%' escape '
2010-12-14 15:41:00
549
原创 Oracle export and import utilities
<br /><br /> tables % owner <br /><br /> globalization support: source database<target database<br /><br /> imp / show=y file=1.dmp display nls info<br /><br /> direct-path<br />
2010-12-07 17:05:00
466
原创 Oracle rman maintenance
<br />retention plicy:recovery window,redundancy,none<br /> crosscheck<br /> backup archivelog delete input
2010-12-07 17:04:00
500
原创 Oracle rman incomplete recovery
<br /><br /> RMAN> run{<br /> allocate channel c1 type disk;<br /> allocate channel c2 type disk;<br /> allocate channel c3 type disk;<br /> set until time "to_date('2010-12-02:02:48:49','yyyy-mm-dd:hh24:mi:ss')" ;(否则需要设置env )<br /> restore data
2010-12-07 17:03:00
432
原创 Oracle recovery catalog creation and maintenance
<br /><br /> grant recovery_catalog_owner to ..
2010-12-07 17:03:00
421
原创 Oracle user -Managed incomplete recovery
<br /><br /> types:time-based,Cancel-based,Change-based<br /><br /> recover database until time '2010-11-30:02:52:16';<br /> (until not include-> 02:52:15)<br /><br /> select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS
2010-12-07 17:02:00
420
原创 Oracle rman complete recovery
<br />database tablespace datafile<br /> backup-> restore -> recover->open<br />
2010-12-07 17:01:00
457
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人