oracle everyday
文章平均质量分 78
empoli
这个作者很懒,什么都没留下…
展开
-
No Response from the Server, Does it Hang or Spin?
Diagnostics -----------If an operation is taking significantly more time than expected or is compromising the performance of other operations, then the best place to check is v$session_wait. This vi转载 2013-03-06 11:02:31 · 1414 阅读 · 0 评论 -
2012-12-4 11gR2 "Database Installation Guide for Linux" page 48 - 97
Package Requirements -- 需要打上的包Linux x86-64IMPORTANT: -- Starting with Oracle Database 11g Release 2 (11.2.0.2), all the 32-bitpackages, except for gcc-32bit-4.3, listed in the followingtable原创 2012-12-04 21:33:14 · 326 阅读 · 0 评论 -
2012-11-20 11gR2 "Backup and Recovery User's Guide" page 257 - 300
RMAN Data Repair Techniques -- 数据恢复技术 -- Data Recovery Advisor -- 数据恢复的建议器 -- logical flashback features 闪回查询等 -- Oracle Flashback Database 闪回数据库 -- datafile media recovery -- 数据文件介质恢复 -- bl原创 2012-11-20 20:43:28 · 393 阅读 · 0 评论 -
2012-11-19 11gR2 "Backup and Recovery User's Guide" page 203 - 256
To query details about past and current RMAN jobs: -- 查询RMAN备份的作业的具体细节COL STATUS FORMAT a9COL hrs FORMAT 999.99SELECT SESSION_KEY, INPUT_TYPE, STATUS,TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') sta原创 2012-11-19 22:38:56 · 354 阅读 · 0 评论 -
2012-12-2 - 12-3 11gR2 "Database Installation Guide for Linux" page 1 - 47
New Tool to Configure Custom Installation Options -- CUSTOM建库的选项Oracle Universal Installer no longer provides the custom installation option ofindividual components. Use the chopt tool, a command-原创 2012-12-03 20:57:16 · 284 阅读 · 0 评论 -
2012-11-18 11gR2 "Backup and Recovery User's Guide" page 151 - 202
User-Managed Image Copies -- CATALOG注册进RMAN并不保证以下两点You can use the CATALOG command to inspect an existing image copy and enter itsmetadata into the RMAN repository. However, the CATALOG command do原创 2012-11-18 20:27:12 · 495 阅读 · 0 评论 -
2012-11-16 - 11-17 11gR2 "Backup and Recovery User's Guide" page 121 - 150
Enabling Lost Write Detection -- 写丢失探测You can set the DB_LOST_WRITE_PROTECT initialization parameter to TYPICAL orFULL so that a database records buffer cache block reads in the redo log. The defa原创 2012-11-17 23:00:13 · 376 阅读 · 0 评论 -
2012-11-30 - 12-1 11gR2 "Backup and Recovery User's Guide" page 530 - 608
Trying to Fix the Recovery Problem Without Corrupting Blocks -- 解决非块损坏的恢复问题原创 2012-12-01 18:51:35 · 383 阅读 · 0 评论 -
2012-11-28 - 11-29 11gR2 "Backup and Recovery User's Guide" page 485 - 529
Checking the Database Before Cross-Platform Database Conversion -- CONVERT DATABASE之前先检查可行性DECLAREdb_ready BOOLEAN;BEGINdb_ready :=DBMS_TDB.CHECK_DB('Microsoft Windows IA (32-bit)',DBMS_TDB.原创 2012-11-29 22:06:53 · 316 阅读 · 0 评论 -
2012-11-15 11gR2 "Backup and Recovery User's Guide" page 109 - 120
Relationship Between CONFIGURE CHANNEL and Parallelism Setting -- 并行度与通道的关系The PARALLELISM setting is not constrained by the number of specifically configuredchannels. For example, if you back up原创 2012-11-15 21:44:05 · 432 阅读 · 0 评论 -
2012-11-14 11gR2 "Backup and Recovery User's Guide" page 65 - 108
Specifying the Location of RMAN Output -- RMAN的日志输出By default, RMAN writes command output to standard output. To redirect output to alog file, enter the LOG parameter on the command line when star原创 2012-11-14 20:43:24 · 427 阅读 · 0 评论 -
2012-11-13 11gR2 "Backup and Recovery User's Guide" page 30 - 64
Backup and Recovery Documentation Roadmap -- 关于备份恢复的学习 Typical Backup Options -- 数据库备份标识 Making Incremental Backups -- 增量备份The starting point for an incremental backup strategy is a原创 2012-11-13 22:00:46 · 478 阅读 · 0 评论 -
2012-11-26 - 11-27 11gR2 "Backup and Recovery User's Guide" page 443 - 484
Basic Concepts of Database Duplication Active Database Duplication In active database duplication, RMAN connects as TARGETto the source database instance and as AUXILIARY to the auxiliary inst原创 2012-11-27 22:19:26 · 382 阅读 · 0 评论 -
2012-11-12 11gR2 "Backup and Recovery User's Guide" page 1 - 29
New Backup and Recovery Features for Oracle 11g Release 2 -- 备份恢复在此版本的新特性(着重摘取几个)DUPLICATE Database Command Enhancements -- 可以不用连到TRAGET DATABASE 也可以做DUPLICATE操作Users can duplicate a database with原创 2012-11-12 21:38:42 · 463 阅读 · 0 评论 -
2012-11-21 11gR2 "Backup and Recovery User's Guide" page 301 - 394
Physical and Logical Block Corruption -- 物理坏块和逻辑坏块In a physical corruption, which is also called a media corruption, the database doesnot recognize the block at all: the checksum is invalid, the b原创 2012-11-21 22:05:32 · 430 阅读 · 0 评论 -
2012-12-5 11gR2 "Database Installation Guide for Linux" page 98 - 142
安装过程的一个CAUTIONCaution: After installation is complete, do not manually remove, orrun cron jobs that remove /tmp/.oracle or /var/tmp/.oracledirectories or their files while Oracle software is run原创 2012-12-05 21:05:22 · 351 阅读 · 0 评论 -
2012-11-22 - 11-23 11gR2 "Backup and Recovery User's Guide" page 395 - 424
Allocation of Input Disk Buffers -- INPUT BUFFER的分配 Monitoring RMAN Job Progress with V$SESSION_LONGOPS -- 通过此视图监控RMAN的JOB To monitor RMAN job progress:1. Before starting the RMAN原创 2012-11-23 22:08:57 · 312 阅读 · 0 评论 -
How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues
SQL> show parameter diaNAME TYPE VALUE------------------------------------ ----------- ------------------------------diagnostic_dest string /u01/app/oracle To gather 10046 t转载 2013-03-05 21:04:49 · 607 阅读 · 0 评论 -
Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes
PurposeProcwatcher is a tool to examine and monitor Oracle database and/or clusterware processes at an interval. The tool will collect stack traces of these processes using Oracle tools like orade转载 2013-03-08 21:09:31 · 736 阅读 · 0 评论 -
2013-1-30 - 1-31 11gR2 "Performance Tuning Guide" page 152 - 162
Interpreting Shared Pool StatisticsAllocating Additional Memory to the Data Dictionary Cache Examine cache activity bymonitoring the GETS and GETMISSES columns. For frequently accessed dictionary原创 2013-01-31 15:39:21 · 297 阅读 · 0 评论 -
2013-1-23 - 1-24 11gR2 "Performance Tuning Guide" page 142 - 151
Shared Pool ConceptsA cache miss on the data dictionary cache or library cache is more expensive than amiss on the buffer cache. For this reason, the shared pool should be sized to ensurethat fr原创 2013-01-24 22:44:05 · 309 阅读 · 0 评论 -
2013-1-6 - 1-7 11gR2 "Performance Tuning Guide" page 114 - 141
Buffer Pool Data in V$DB_CACHE_ADVICE -- 在v$视图中查询BUFFER POOL的相关数据You can use V$DB_CACHE_ADVICE to size all pools configured on a database instance.Make the initial cache size estimate, run the rep原创 2013-01-07 21:53:28 · 404 阅读 · 0 评论 -
2012-12-19 - 12-20 11gR2 "Performance Tuning Guide" page 50 - 69
Steps in The Oracle Performance Improvement Method -- 性能调优的步骤1. Perform the following initial standard checks: -- 初始标准的检查a. Get candid feedback from users. Determine the performance project's scop原创 2012-12-20 21:53:12 · 246 阅读 · 0 评论 -
2012-12-17 11gR2 "Performance Tuning Guide" page 1 - 49
Oracle Database 11g Release 2 (11.2.0.2) New Features in OracleDatabase Performance -- 11202新特性Oracle Orion I/O Calibration Tool Documentation -- Oracle Orion I/O测试工具Oracle Orion is a tool for p原创 2012-12-17 16:17:19 · 359 阅读 · 0 评论 -
2012-12-12 - 12-14 11gR2 "2 Day + Performance Tuning Guide" page 52 - 168
Creating a SQL Tuning Set: Load Method -- SQL TUNING SET的加载方法Loading Active SQL Statements Incrementally from the Cursor Cache You can load active SQLstatements from the cursor cache into the SQL原创 2012-12-14 22:48:25 · 257 阅读 · 0 评论 -
2012-12-27 11gR2 "Performance Tuning Guide" page 83 - 113
Transporting Automatic Workload Repository Data -- 转移AWR数据Extracting AWR DataAt the SQL prompt, enter:@$ORACLE_HOME/rdbms/admin/awrextr.sqlA list of the databases in the AWR schema is displaye原创 2012-12-27 21:31:58 · 311 阅读 · 0 评论 -
2012-12-25 11gR2 "Performance Tuning Guide" page 70 - 82
Operating System Statistics -- 操作系统的统计信息CPU Statistics -- CPU信息The V$OSSTAT view captures machine-level information in the database, making iteasier for you to determine if hardware-level resour原创 2012-12-25 20:05:16 · 343 阅读 · 0 评论 -
2012-12-11 11gR2 "2 Day + Performance Tuning Guide" page 1 - 51
Gathering Database Statistics Using the Automatic Workload Repository -- 使用AWR收集系统信息The following initialization parameters are relevant for AWR: -- STATISTICS_LEVELSet this parameter to TYPICAL原创 2012-12-11 15:58:08 · 372 阅读 · 0 评论 -
2012-11-24 - 11-25 11gR2 "Backup and Recovery User's Guide" page 425 - 442
Tuning RMAN Backup Performance -- RMAN的性能调优Step 1: Remove the RATE Parameter from Channel SettingsAs explained in "RATE Channel Parameter" on page 22-5, the RATE parameter on achannel is intende原创 2012-11-25 23:02:44 · 352 阅读 · 0 评论 -
2012-12-6 - 12-7 11gR2 "Database Installation Guide for Linux" page 143 - 246
Port Numbers and Protocols of Oracle Components -- 端口号与组件的对应关系 What to Do If an Installation Error Occurs? -- 在安装失败时的操作If you encounter an error during installation: -- Do not ex原创 2012-12-07 21:55:35 · 223 阅读 · 0 评论 -
2012-11-10 - 11-11 11gR2 "ADMINISTRATOR'S GUIDE" page 905 - 1066
这一章节大部分讲的是分布式数据库的管理以及重点(DATABASE LINK的设置) Analyzing the Execution Plan -- 分析执行计划Preparing the Database to Store the Plan -- 创建存放执行计划的表SQL> @UTLXPLAN.SQLGenerating the Execution Plan -- 生成执行计原创 2012-11-11 17:23:14 · 493 阅读 · 0 评论 -
2012-11-9 11gR2 "ADMINISTRATOR'S GUIDE" page 848 - 904
Setting Up the Database for Remote Jobs -- 设置非本地的JOB(需要REMOTE端安装AGENT)To set up a database to create and run remote jobs:1. Ensure that shared server is enabled.2. Using SQL*Plus, connect to t原创 2012-11-09 21:04:54 · 594 阅读 · 0 评论 -
2012-10-21 11gR2 "2DAY DBA" page 73 - 125
About Server and Client Processes -- 专有模式与共享模式连接各自使用的地方Using shared server mode eliminates the need for a dedicated server process for eachuser connection, requires less memory for each user conne原创 2012-10-21 22:20:13 · 477 阅读 · 0 评论 -
2012-10-29 11gR2 "ADMINISTRATOR'S GUIDE" page 353 - 396
Control Files Data Dictionary Views -- 与控制文件相关的数据字典视图Creating Redo Log Groups -- 日志文件的创建Using group numbers can make administering redo log groups easier. However, thegroup number must be be原创 2012-10-29 21:24:27 · 635 阅读 · 0 评论 -
2012-10-19 11gR2 concepts page 327 - 454
数据仓库和在线联机系统的比较 Overview of Extraction, Transformation, and Loading (ETL)The process of extracting data from source systems and bringing it into the warehouseis commonly called ETL: extract原创 2012-10-19 22:24:14 · 723 阅读 · 0 评论 -
2012-10-18 11gR2 concepts page 326 - 367
Shared Server ProcessesThe dispatcher process receives requests from connected clients and puts them into arequest queue in the large pool (see "Large Pool" on page 14-21). The first availablesh原创 2012-10-18 21:07:41 · 474 阅读 · 0 评论 -
2012-10-17 11gR2 concepts page 293 - 326
今天,一开头,我想分享点想法。如果我们能够把技术当作茶余饭后的乐趣,那我们在这条路就可以做得久。如果我们看书,看文档,不是为了学习而学习,而是觉得,它就是一种乐趣,那我们就会快乐。 -- 这又是一句会被现实主义者批判的话,因为他们永远不懂作为DBA,能够感受到的巨大的成就感与自豪感。 继续今天的CONCEPTS,今天很精彩,都想摘下来。 ADR Structur原创 2012-10-17 21:03:14 · 358 阅读 · 0 评论 -
2012-10-16 11gR2 concepts page 245 - 292
Row FormatRow HeaderThe row header contains information such as the following: -- Columns in the row piece -- Pieces of the row located in other data blocksIf an entire row can be insert原创 2012-10-16 22:07:22 · 342 阅读 · 0 评论 -
2012-10-15 11gR2 concepts page 216 - 244
In-Doubt Transactions The recoverer (RECO) background process automatically resolves the outcome ofin-doubt distributed transactions. After the failure is repaired and communication isreestablis原创 2012-10-15 22:27:39 · 569 阅读 · 0 评论 -
2012-10-14 11gR2 concepts page 193 - 215
Table Locks (TM) -- TM锁A table lock, also called a TM lock, is acquired by a transaction when a table ismodified by an INSERT, UPDATE, DELETE, MERGE, SELECT with the FOR UPDATEclause, or LOCK TA原创 2012-10-14 23:50:33 · 316 阅读 · 0 评论