- 博客(81)
- 收藏
- 关注
RSS订阅转载 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
729
转载 11g Active Data Guard 报表访问报 ora-01555
原帖地址：http://www.itpub.net/thread-1455201-1-1.html Oracle 11.2.0.2.0 , Linux AS 5.3 64bit 11g production 系统是三节点RAC 开启为read only 模式，供web report 查询，刚开始还比较正常，到晚上22：30多分的时候发现web report
2013-03-08 20:55:24
19514
转载 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
1388
转载 expdp整库迁移问题
原文链接： http://www.itpub.net/thread-1769463-1-1.html 我有个数据库想从同版本的32位迁移到64位。原库有多个用户对应多个表空间和数据文件。如果用expdp full方法导出，我要在新库上建立用户和相应的表空间和数据文件？还是在impdp的时候会直接自动建立相应的用户，表空间和相应的数据文件么？ 如果是用EXPDP的方式 建
2013-03-06 10:29:54
779
转载 大型网站的备份恢复同步策略
原文链接： http://www.itpub.net/thread-1769278-1-1.html 遇到需求如下：客户要做网站迁移并且，要做一台备机，当主机发生问题时候，备机立马能用。做数据备份方案。网站已经跑了8年了，数据库文件大概21G，数据文件大概有40G，没有文件服务器，所有的文件都会上传到一个文件夹下面，文件夹巨大40G，并且文件琐碎，每天还上传大量的数据，pdf，word
2013-03-05 21:18:53
848
转载 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
601
原创 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
292
原创 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
305
原创 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
399
原创 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
306
原创 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
338
原创 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
240
原创 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
354
原创 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
254
原创 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
369
原创 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
218
原创 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
346
原创 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
323
原创 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
276
原创 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
379
原创 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
310
原创 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
378
原创 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
348
原创 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
306
原创 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
424
原创 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
377
原创 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
350
原创 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
490
原创 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
371
原创 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
426
原创 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
419
原创 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
464
原创 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
457
原创 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
486
原创 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
589
原创 2012-11-8 11gR2 "ADMINISTRATOR'S GUIDE" page 809 - 847
How Programs, Jobs, and Schedules are Related -- 三者之间的关系 Using the Scheduler in Real Application Clusters Environments -- scheduler在RAC中的使用 Service Affinity when Using the Scheduler --
2012-11-08 21:04:25
620
原创 2012-11-7 11gR2 "ADMINISTRATOR'S GUIDE" page 763 - 808
Oracle Database Resource Manager -- 资源管理器 Resource Manager Data Dictionary Views -- 与资源管理器相关的数据字典视图
2012-11-07 19:58:40
507
原创 2012-11-6 11gR2 "ADMINISTRATOR'S GUIDE" page 699 - 762
DBMS_REPAIR Procedures Task 1: Detect and Report Corruptions -- 检测坏块 Task 2: Evaluate the Costs and Benefits of Using DBMS_REPAIR -- 评估消耗与使用价值1. What is the extent of the corruption? --
2012-11-06 21:18:20
599
原创 2012-11-5 11gR2 "ADMINISTRATOR'S GUIDE" page 647 - 698
Consider Costs and Benefits of Coalescing or Rebuilding Indexes -- COALESCE与REBUILD Monitoring Space Use of Indexes -- 监控索引的空间使用If key values in an index are inserted, updated, and delete
2012-11-05 22:25:16
307
原创 2012-11-3 - 11-4 11gR2 "ADMINISTRATOR'S GUIDE" page 585 - 646
Methods for Loading Tables -- 加载导入表的方法 Removing Unused Columns -- 移除表的字段In the ALTER TABLE statement that follows, the optional clause CHECKPOINT isspecified. This clause causes a checkpoint
2012-11-04 21:42:59
369
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人