-
编辑 删除
Bug of Prod of Oracle
A bug of Oracle 8.0.5.2When I query GL_JE_LINES, it prompt like following:20:42:55 ORA-01115: 从文件8读取块时出现 IO 错误（块#1048578）20:42:55 ORA-01110: 数据文件8：'/u02/appldata/PROD/find01.dbf'20:...
-
编辑 删除
Write a simple security audit script for Oracle
For Oracle SecurityThose who are familiar with the Oracle data dictionary can use the dictionary to find out if their database has any security exposures. Here are some common queries that are used to...
-
编辑 删除
Oracle Internal Parameter set for Unix
in Linux /etc/system Asked Tom,a. db1 – concurrent users + processes = 410b. db2 – concurrents users + processes = 50c. db3 – concurrents users + processes = 50The above three databases ar...
-
编辑 删除
Oracle性能调优实践中的几点心得
很多的时侯，做Oracle DBA的我们，当应用管理员向我们通告现在应用很慢、数据库很慢的时侯，我们到数据库时做几个示例的Select也发现同样的问题时，有些时侯我们会无从下手，因为我们认为数据库的各种命种率都是满足...
-
编辑 删除
说一说Oracle的优化器(Optimizer)
本文的目的：1、说一说Oracle的Optimizer及其相关的一些知识。2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有...
-
编辑 删除
Online Index Rebuild and Table Redefinition
From Other SiteA number of new features in Oracle9i have increased database availablity including:Online Index Rebuilds Online Table Redefinition Online Analyze Validate Quiesce Database Dynamic Initi...
-
编辑 删除
Oracle Block Error
If you find block Error in alert or when you run sql Statement......If we run Oracle in Archive log mode. And the Error was not in system/Redo and Rollback segment.A. Recovery with Backup files. 1.cp...
-
编辑 删除
Analyze Library Cache Pin and 4021 Error
From MetalinkPURPOSE------- This article discuss the library cache locks and pins and how to analyzelocking problems in this area. SCOPE & APPLICATION------------------- Support analysts, dba's, .. T...
-
编辑 删除
When to Implement Parallel Execution
When to Implement Parallel Execution , We know parallel Execution will greatly improve performance, but,The most common use of parallel execution is in DSS and data warehousingenvironments. Complex qu...
-
编辑 删除
v$sesstat and v$statname usage
From the performance of OracleTo determine the STATISTIC#’s for the session logical reads and physicalreads statistics:SELECT name, statistic#FROM V$STATNAMEWHERE name IN ('session logical reads','ph...
-
编辑 删除
How to Create a Large SGA Without Relocating sgabeg on 32-bit Oracle?
About SGA set of Limited of 32 bit or 64 bit in UnixHow to Create a Large SGA Without Relocating sgabeg on 32-bit Oracle?One of our production data warehouse servers (Oracle 8.1.7.4 Solaris 2.6 sun4u ...
-
编辑 删除
Oracle Critical Patch Upgrade April 2006
The Critical Patch Update Advisory is the starting point for relevant information, and it provides instructions on how to obtain the patches. It contains a summary of the security vulnerabilities and ...
-
编辑 删除
Oracle Enqueue Name list(9.2.0.6)
ALL Oracle Enqueue ListEnqueue TypeNotesBL Buffer Cache Management CF Controlfile Transaction CI Cross-instance Call Invocation CU Bind Enqueue DF Datafile DL Direct Loader Index Creation DM Database ...
-
编辑 删除
Install Oracle In Linux 9.0
configure and Install Oracle in Linux?软件环境：RedHat9.0,内核2.4.20?????Oracle:? oracle9i,光盘：?????ship_9204_linux_disk1.cpio.gz，?????ship_9204_linux_disk2.cpio.gz，?????ship_9204_linux_disk3.cpio...
-
编辑 删除
使用ORACLE诊断事件:打开事件跟踪的方法
Oracle为RDBMS提供了多种的诊断工具，诊断事件(Event)是其中一种常用、好用的方法，它使DBA可以方便的转储数据库各种结构及跟踪特定事件的发生。使用这些事件也不是件很高深的学问，举例来说10046这个Event你也一定...
-
编辑 删除
Standby DB 增加数据文件
1.22 Standby DB关闭，1.23给PRIMARY DB增加了一个数据文件，结果在standby DB中发现错误。alter database register physical logfile 'D:FTPlogARC01493_001.Arc'There are 1 logfiles specified.ALTER DATABASE RE...
-
编辑 删除
Veritas Backup Script of Shell for RMAN
veritas Backup Script modify#bcpyrght#***************************************************************************#* $VRTScprght: Copyright 1993 - 2002 VERITAS Software Corporation, All Rights Reserved...
-
编辑 删除
How To Reduce the DB File Sequential Read Wait Event
How to reduce the DB File Sequential Read :)stripe the data across multiple disks?db file sequential read is due to INDEXED reads by the way -- it is single block IO, it is not the result of a full sc...
-
编辑 删除
exp big file over os
mknod exp_pipe pdd if=/u05/dbbackup/exp_pipe of=tvsn.dmp & exp oscar/dba@tns owner=tvsn file=/u05/dbbackup/exp_pipe direct=y
-
编辑 删除
Finding the source of enqueue waits
From OTNSystem wide, event based tuning using statspack or utlbstat/estat reports can give a useful overview of any potential bottlenecks in the database. The wait events are good place to start looki...
