Oracle 10g: Top Goodies and Gotchas by Mike Ault

原创 2004年07月12日 08:23:00
AMM (Automatic Memory management). "Because DBAs spend a large amount of time monitoring and tuning the SGA areas in Oracle, AMM relieves them of a majority of this chore," Ault said.

Automated diagnostics through ADDM ("Adam"). "This process collects the needed statistics, SQL statements and other required data to analyze performance bottlenecks and provide detailed recommendations to the DBA," he said. "In addition, ADDM can be used to do detailed analysis of SQL statements to develop a SQL profile that can be used to tune previously 'un-tunable' SQL such as third-party application SQL."

ASM (Automated Storage management). "This allows the DBA to set and forget datafile, redo log and other file areas," Ault said. "ASM provides for automated striping and mirroring as well as backup of Oracle-related files. ASM replaces more expensive disk management software (as related to Oracle data files)."

Enterprise manager and Grid Control. "There are so many enhancements in EM that it is difficult to pinpoint one that really shines," Ault said. "However, the automation of backups via a simple point-and-click interface has to be right up there. In addition, the fully Web-compliant interface that allows a DBA to manage [his or her] environment from anywhere they have access to the Internet is also a great convenience.

Improvements to the wait interface. This eliminates the need to dig for child wait information and the grouping of related waits by category, Ault said.

Fair enough—those are the time-savers to which we can look forward. But what about the top gotchas? What should DBAs look out for when working in 10g? Here's that list:

  • ew_spacer.gif

Automated features don't quite replace an experienced DBA. Rather than blindly following all ADDM suggestions, for example, DBAs must monitor the AMM to make sure it's not overallocating memory areas, Ault suggests. Use ADDM suggestions as guidelines for tuning, based on your own knowledge of the database being tuned.

Verify all backups by performing recoveries.

The EM interfaces are nice, but knowing the underlying data dictionary is still critical.

Start the ASM instance first and shut it down last. "ASM controls access to the disks," Ault says, "and if the ASM instance is not started, none of the other databases can mount their data files. If the ASM instance shuts down, all of the other dependent databases will crash. Another thing to watch out for in ASM is that, at least for now, you must use the EM interface and RMAN to back up a database that uses ASM."

Watch out for everything you always watched out for. That includes ensuring that you have enough disk space, watching the placement of ASM RAW devices for file I/O balancing (replacing watching the placement of data files), and making sure that all appropriate OS and Oracle patches are applied.

Finally, I wanted to know what the top things are that Oracle still needs to iron out. In Ault's view, one shortcoming has to do with the fact that the current streams interface is still in the Java version of the enterprise manager. That means you need to have two sets of EM software if you want to use streams features. That also applies to other features, Ault told me.

In addition, some of the EM screens could be more intuitive to navigate. Ault would also be pleased by seeing more tabular results, with reports backing up what's now just nice graphics. As far as RAC (Real Application Clusters) goes, "some of the install is still rather rough," Ault opined, so more work on that would be welcome.

Oracle Bigfile tablespace tips---By Mike Ault

Bigfile Tablespace A bigfile tablespace (BFT) is a tablespace containing a single file that can hav...
  • kobe24shou
  • kobe24shou
  • 2014年08月13日 15:20
  • 573

连接Oracle 10g时ORA-12514: TNS: 监听进程不能解析问题的解决

最近安装完Oracle之后,手贱了一下下,将计算机的本地名给改了,使用 sqlplus system/manager@orcl的时候却会报ora-12514的错误。 经过多方查找找到解决方法...
  • livia1234
  • livia1234
  • 2013年09月02日 22:34
  • 1018

Oracle 10g RAC 维护常用命令

一、禁止开机启动CRS&Database 默认在linux上面安装完oracle 10g RAC 后在开机时总是会自动把 cluster 、Database一起和系统起来,一般来说随系统启动与关...
  • tswisdom
  • tswisdom
  • 2012年06月03日 12:22
  • 2693

Oracle10g 分区表总结

原文出自: 作者总结的很好,在此转载! 一. 分区表理论知识        ...
  • yyj8255
  • yyj8255
  • 2012年04月05日 14:23
  • 2895


如有转载,请声明出处: 极致博客: 这段时间经历太多太多,工作忙的不要不要的! 感觉自己哪里都不在状态了,今天总算抽出了点时间总结下...
  • u011218159
  • u011218159
  • 2016年03月23日 20:58
  • 818

Oracle 10g For Windows 10.1.0和 Oracle 10g For Linux下载地址

Oracle 10g For Windows 10.1.0[ISO][已通过安全检测] 瑞星17.57.42[安装测试]WinXP SP2 上安装 Oracle 数据库 10g如果打开不了请 打开迅雷...
  • qfs_v
  • qfs_v
  • 2008年05月07日 20:47
  • 7810

oracle 10g rac 安装图解

oracle 10g rac 安装图解 规划:所用linux系统以虚拟化方式安装在esx上,配置有内网的yum源,各分配有16G存储,下面为简单拓扑图 一,下载软件 1,地址...
  • u010098331
  • u010098331
  • 2016年06月09日 23:44
  • 1232

oracle 10g 各版本下载地址

将以下地址复制到迅雷新任务即可下载 Oracle Database 10g Release 2 ( Enterprise/Standard Edition for Micros...
  • llq108
  • llq108
  • 2015年07月19日 14:05
  • 2720

Oracle 10G 64位下载 http://download.orac...
  • dingsai88
  • dingsai88
  • 2014年09月12日 16:43
  • 4563

Oracle 10g 如何删除干干净净!

oracle数据库卸载非常麻烦,经常卸载不彻底,导致重新装oracle非常麻烦,针对不同的平台需要不同的方法。 一、Linux 平台 Linux 平台下卸载Oracle 非常简单,...
  • u010801439
  • u010801439
  • 2017年04月12日 22:02
  • 577
您举报文章:Oracle 10g: Top Goodies and Gotchas by Mike Ault