- 博客(14)
- 资源 (8)
- 收藏
- 关注
转载 计算机专业就业方向分析
sink:觉得写得还挺好的,一字不漏的看过来了,都是自己不太了解的方面,放这了。另外,最近一个星期应该都不会更新博客了。忙着毕业,忙着玩。……………………………………………………………………我是水平线…………………………………………………………………………一、 关于企业计算方向企业计算(Enterprise Computing)是稍时髦较好听的名词,主要是指企业信息系统,如ERP软件(
2012-01-25 20:26:41 2469
原创 Tuning the Buffer Cache(2)
Server process接受了客户的查询请求,先从内存找答案,如果没有,则从数据文件中调内容到内存中。Server process工作原理1.首先,用HASH函数看一下查询的块是否在buffer cache中。如果找到,这个块就会被调到LRU列表的MRU端。这个叫逻辑读,因为没有I/O。余下的步骤也不会被执行了。2.如果没有找到,
2012-01-22 13:02:24 701
原创 Tuning the Buffer Cache(1)
Tuning the Buffer CacheBuffer cache的命中率对性能的影响,不如shared pool大。因为你一般select * 就返回上千条记录回来,所以buffer cache会被交换得比较频繁,不被命中也是情有可原的。也就是调shared pool比较重要。Objectvies:1.Employ the buffer
2012-01-22 00:58:58 612
原创 Tuning the Shared pool(4)
The reserved Pool如果有一个请求,但shared pool中由于内存过于碎片化,没有连续一片的chunk,就会请求保留池中的内存。show parameter shared可以看到保留池大小参数。 Oracle是怎么分配shared pool空间呢?1.From the unreserved part of the shared pool.2.Fro
2012-01-21 19:26:02 727
原创 Tuning the Shared pool(3)
Shared Cursors1.少用动态SQL,多用普通SQL。Avoid application designs that result in large numbers of users issuing dynamic,unshared SQL statements.Typically,the majority of data required by
2012-01-20 21:45:04 563
原创 Tuning the Shared pool(2)
使用绑定变量的好处的实验:drop table m;create table m(x int);过程一:使用绑定变量CREATE OR REPLACE PROCEDURE proc1ASBEGINFOR i IN 1..10000LOOPexcute immediate'INSERT INTO m VALUES(:x)' USING 'i';END LO
2012-01-20 12:39:59 453
原创 Tuning the Shared pool(1)
Tuning the Shared pool培训目标:* Determine the size of an object and pin it in the shared pool.钉在* Tune the shared pool reserved space* Describe the user global area and session memory considerati
2012-01-20 01:50:07 612
原创 Database Configuration and I/O Issues(3)
Regulating Checkpoint Queue调整checkpoint队列有如下参数FAST_START_TO_TARGET LOG_CHECKPOINT_INTERVAL 过时LOG_CHECKPOINT_TIMEOUT 过时FAST_START_MTTR_TARGET实例恢复速度与日常运行效率的权衡。实际情况是掉电情况比较少,所以
2012-01-19 19:25:20 580
原创 Database Configuration and I/O Issues(2)
File Striping关于ASM的。大概是说,把文件放在磁盘的不同扇区,均衡读取。Tuning FTS OperationsInvestigate the need for full table scans.Configure the DB_FILE_MULTIBLOCK_READ_COUNT参数可以决定实例一次读的数据库块数,这也影响了CBO的执行
2012-01-19 15:12:56 562
原创 Database Configuration and I/O Issues(1)
Database Configuration and I/O Issues.数据库配置与I/O相关事项。Objectvies:1.List the advantages of distributing different Oracle file types.2.Diagnose tablespace usage problems.3.List reasons for p
2012-01-19 15:12:17 551
原创 Diagnostic and Tuning Tools(4)
TS and TuningInstance/database:v$databasev$instancev$optionv$parameterv$backupv$px_process_sysstatv$processv$waitstatv$system_eventDisk:v$datafilev$filestatv$logv$log_his
2012-01-15 18:07:31 469
原创 Diagnostic and Tuning Tools(3)
statspack报告,对数据库做一次全面的体检。参考书:《Oracle database 10g performance tuning tips & techniques 》《Your Performing toolkit》 TOM大师DD and Special Viewsdba_tables,dba_tab_columnsdba_clustersdba
2012-01-15 18:07:03 547
原创 Diagnostic and Tuning Tools(2)
User Trace Filesbdump保存alert文件与background_trace文件。udump保存用户trace文件。desc v$sessionselect sid,serial#,username from v$session;1-10是后台进程,11是SYS用户。show user可以看到是SYS用户。打开另一会话,conn
2012-01-15 18:06:25 544
原创 Diagnostic and Tuning Tools(1)
Chapter02 Diagnostic and Tuning Tools诊断与调优工具Objectives:1.Identify key tuning components of the alert log file.理解alert log file中关于调优的重要信息。2.Identify key tuning components of background trac
2012-01-15 18:05:40 799
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人