Oracle DB
文章平均质量分 55
orapeasant
这个作者很懒,什么都没留下…
展开
-
Windows下如何自定义服务?如何定义服务相关性?
背景:使用oracle form 6i 开发的一个系统,后台数据库使用oracle10g,form runtime和10gDB发布在同一台windows2000的机器上,为了方便客户使用,每次客户开机时,自动启动oracle10g 和这个应用程序直接进入系统。问题:首次尝试是在startup 里创建一个快捷方式。但是, 我没有料到oracle10g的启动实在是太慢了,以至于oracle原创 2004-08-14 15:45:00 · 2725 阅读 · 0 评论 -
Controlfile Structure
Controlfile StructureThe first block of the controlfile is a header block that records just the controlfile block size and the number of blocks in the controlfile. The controlfile block size is th原创 2007-12-24 15:36:00 · 922 阅读 · 0 评论 -
Oracle常用的dump命令
一.Memory Dumps1).Global AreaALTER SESSION SET EVENTS immediate trace name global_area level n;1 包含PGA2 包含SGA4 包含UGA8 包含indrect memory2).Library CacheALTER SESSION SET EVENTS immediate t转载 2007-12-24 17:23:00 · 938 阅读 · 0 评论 -
Index organized table and redo log it genereates
Today, OPS team raised an issue related to a program using IOT. The program generated too many archive logs thus it took more time to FTP archive logs to our DR server and apply them. 1~4 hours lag we原创 2008-10-14 13:30:00 · 534 阅读 · 0 评论 -
Form 6i cannot connect to 10gR2 or 10gXe due to character set issue
Form 6i or sqlplus reports ora805.dll and access violation error and crash immediately. This is because of the character set of 10g is in AL32UTF8, need to be changed to UTF8, do following in sqlplu原创 2009-01-12 16:34:00 · 1672 阅读 · 0 评论 -
Configure form 6i and form services to work under XDB http listener of 10gEX
In Oracle 10gEX, it supports HTTP and FTP internet protocal through XDB. So how about configuring XDB http listener to work with Oracle form/report 6i? I tried it successfully before solving followin原创 2009-01-12 16:41:00 · 968 阅读 · 0 评论 -
Using Oracle XML DB Repository as a Filesystem
DBA: XML Using Oracle XML DB Repository as a Filesystemby Yuli Vasiliev Learn how to manage XML content stored in Oracle XML DB, whether you use SQL or not. Downloads for this article:·原创 2009-01-12 15:54:00 · 10109 阅读 · 0 评论 -
XDB:How to change XDB in XE to enable remote listener.
To enable XDB to listen on remote listener, use following:exec DBMS_XDB.setListenerEndPoint(1,hostname,8080,1); To enable XDB to listen on local listener only, use following:exec DBMS_原创 2008-11-20 13:29:00 · 946 阅读 · 0 评论 -
XDB: XML DB Port Assignments
XML DB Port Assignments by Jeff Hunter, Sr. Database Administrator Portions of this article are written by Roby Sherman and Copyright 2002 http://www.idevelopment.info/data/Oracle/DBA_tips/xmldb转载 2008-11-20 07:29:00 · 1194 阅读 · 0 评论 -
XDB: Utility package to change the HTTP and FTP ports used by XML DB
Subject: How to Add LOCAL_LISTENER or REMOTE_LISTENER Entry to OID Doc ID: Note:602322.1Type: HOWTO Last Revision Date: 03-NOV-2008Status: PUBLISHEDIn this Documen转载 2008-11-20 07:33:00 · 892 阅读 · 0 评论 -
XDB: Utility package to change the HTTP and FTP ports used by XML DB.
XDB: Utility package to change the HTTP and FTP ports used by XML DB. Doc ID: Note:209564.1Type: BULLETIN Last Revision Date: 22-JUL-2008Status: PUBLISHEDIn this Doc原创 2008-11-20 07:34:00 · 1902 阅读 · 0 评论 -
Oracle数据库联机日志文件丢失处理方法
Oracle数据库联机日志文件丢失处理方法 试验一:用命令清空日志组方法 1、 查看原来表中数据 SQL>; conn test/test Connected. SQL>; select * from test; TEL ---------- 1 2 3 2、插入新数据 SQL>; insert into test values(转载 2008-11-24 11:03:00 · 763 阅读 · 0 评论 -
APEX: Some good web sites about APEX
1. Patrick Wolf in Germanyhttp://www.inside-oracle-apex.com 2. Don Burlsons page about making tree pagehttp://www.oracle-training.cc/t_easy_html_db_trees.htm 3. Oracles page about tree原创 2008-11-24 18:06:00 · 758 阅读 · 0 评论 -
Redo Byte Address(RBA)
Redo Byte Address (RBA)Recent entries in the redo thread of an Oracle instance are addressed using a 3-part redo byte address, or RBA. An RBA is comprised of the log file sequence number (4转载 2007-12-24 15:31:00 · 652 阅读 · 0 评论 -
创建一个standby database的全过程
创建一个standby database的全过程作者:fals 实施环境:OS:windows 2000 advanced server SP2 Oracle:8.1.7.4 假定主库与备用库不在同一个主机上,目录结构相同,并且配置一个自管理备用库(managed standby database):转载 2007-12-20 18:04:00 · 931 阅读 · 0 评论 -
Guide to Linux Archive Utility Mastery
Its really so happen to find this one. Im just trying to find cpio info to install 10g on an HPUX boxFinally, I use following command to get the installation sourcecpio -idvmc ship_rel10_hp64_db原创 2004-08-08 15:08:00 · 1281 阅读 · 0 评论 -
Windows 上使用超过4GB的内存
由于windows 2000是基于32bit的系统,因此,单个进程的地址空间被限制在4G(2 power 32)范围内,同时,由于操作系统内核有保留了2g作为系统地址空间,因此,单进程的可访问地址空间就只有2G了。在这种情况下, 可以在boot.ini中使用/3gb来使可访问内存增加到3g。但是对于内存大于4G的系统,又应该如何使用这些内存呢?windows 提供了一个PAE的特性。PAE原创 2004-08-14 15:11:00 · 1912 阅读 · 0 评论 -
Oracle RAC SIG Home
http://t4biweb01.t4bi.com/pls/htmldb/f?p=105:100:5602528815694943732原创 2004-08-14 16:57:00 · 813 阅读 · 0 评论 -
Build Your Own RAC Cluster on Linux and FireWire
http://www.oracle.com/technology/pub/articles/hunter_rac.html原创 2004-08-14 16:28:00 · 867 阅读 · 0 评论 -
Windows下定期导出oracle schema并压缩
Content of exprar.bat@echo offset datdir=d:/Backup/datset bindir=d:/Backup/binif %1aaa==aaa goto errset dmpname=%datdir%/%1exp %1/%2@%3 consistent=yes file=%dmpname%REM name the rar file with weekday原创 2005-06-30 18:21:00 · 1155 阅读 · 0 评论 -
Sending e-mail from Oracle Server in 10g
ORACLE DATABASE ADMINISTRATOR Sending e-mail from Oracle Server Gregory Williams06.22.2006Ra转载 2006-09-19 11:07:00 · 1699 阅读 · 0 评论 -
两个不错的关于oracle的站点
www.puschitz.com Puschitz关于oracle 和linux有不少cookbook, 很全. http://zhouwf0726.itpub.net/ Zhou 这里的不少文章很精辟.原创 2007-01-24 16:30:00 · 780 阅读 · 0 评论 -
Oracle安装相关Linux参数(转自m77m78 in ITPUB)
Oracle安装相关Linux参数 =========================================================== 作者: m77m78(http://m77m78.itpub.net)发表于:2007.05.14 21:49分类: oracle 管理 出处:http://m77m78.itpub.net/post/125/287708-------原创 2007-06-02 20:41:00 · 1339 阅读 · 0 评论 -
Memory usage in a 32bit Windows environment (how to avoid ORA-4030 /ORA-12500s
Subject: Memory usage in a 32bit Windows environment (how to avoid ORA-4030 /ORA-12500s) Doc ID:转载 2007-06-05 17:49:00 · 3458 阅读 · 0 评论 -
Recovery Principles--Redo record and change vector
当我们发出一个update语句的时候, Oracle会完成以下几步:1. 生成一系列change vector.2. 在redo buffer中保存这一系列change vector组成的redo record, redo record最终将被写入到redolog文件中.3. 更改数据快.那么change vector 包含哪些信息呢? 基本上, 它包含了来自于数据块的版本号, 操作的类型以及数据原创 2007-12-21 16:36:00 · 739 阅读 · 0 评论 -
hot backup 中alter tablespace XXXX begin backup做了什么?
大家在做hotbackup的时候, 一般是alter tablespace XXXX begin backup;!cp ....alter tablespace XXXX end backup;我们都知道在hotbackup 的同时是允许对正在备份的文件写入的, 那么随着cp的进行, 复制下来的文件从时间的角度看是在不同的时间段有cp 读出来的, 里面的数据一定是不一致的. 那么hot back原创 2007-12-20 18:40:00 · 3282 阅读 · 0 评论 -
Recovery Principle--SCN
SCN全称是system change number.这个是一个非常重要的数. oracle 为数据库中的每一个操作都分配一个递增的scn, 即使是分布式的系统,都不会出现scn重复的现象, oracle 不会重设scn. scn存在于transaction表, 数据块头部, 控制文件,数据文件头以及redo record里面. 以下来分别解释各种不同的scn.1. redo log 文件中的sc原创 2007-12-21 17:55:00 · 713 阅读 · 0 评论 -
DW: Some useful system views when checking Materialized View
1. dba_mview_refresh_times/user_mview_refresh_timesThis view lists the master table, mv and the last refresh time. When mv are fast refresh mv, the mv log will be purged only when all the mvs are re原创 2008-12-05 13:58:00 · 861 阅读 · 0 评论