![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 61
duanduan112233
这个作者很懒,什么都没留下…
展开
-
Oracle / Buffer cache
[quote]8.7 Tuning the Operating System Buffer CacheTo take full advantage of raw devices, adjust the size of Oracle Database buffer cache. If memory is limited, then adjust the operating system buff...原创 2011-04-19 17:18:31 · 96 阅读 · 0 评论 -
Will the valid status of index impact dml operation?
[code="java"]DROP TABLE tab01;SELECT * FROM tab01;CREATE TABLE tab01(ID NUMBER NOT NULL PRIMARY KEY,NAME VARCHAR2(50));SELECT index_name,a.status FROM User_Indexes aWHERE index_name ...原创 2011-08-05 10:34:02 · 105 阅读 · 0 评论 -
where can i find the job number of those jobs defined in dba_scheduler_jobs?
[size=medium][b]Question:[/b][/size]Hello, could anybody tell me where can i find the job number of those jobs defined in dba_scheduler_jobs? either whose owner is EXFSYS or a created owner.I se...原创 2011-08-01 10:41:20 · 101 阅读 · 0 评论 -
dbms_output can not put the zero
DECLARE V_INTA NUMBER :=0.67; BEGIN DBMS_OUTPUT.put_line(TO_CHAR(V_INTA,'FM9999990.0099')); END;原创 2011-08-25 09:29:26 · 114 阅读 · 0 评论 -
what is the difference between object_id and data_object_id?
[b]The object_id is the primary key, the data_object_id is the foreign key to the data segment.You can find the DDL operation against the object (for instance,Truncate,Move etc.)by querying th...原创 2011-08-24 09:17:21 · 128 阅读 · 0 评论 -
Listener HPUX Error: 242: No route to host
现象:[quote]LSNRCTL> statusConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error HPUX Error: 242: No route to host[...2011-05-17 14:55:46 · 116 阅读 · 0 评论 -
一进程阻塞问题解决
同事反映,删除一条数据总是没有反应,请求协助解决.问题非常明显,肯定是有某个session在block他的session,导致一直在等待资源的释放.于是很快将问题定位,得到如下数据:[code="java"]SESS ID1 ID2 LMODE REQUEST TYPE CTIME BLOCKHolder: 389 17267 0 3 0 TM 8758 1Waiter...原创 2011-05-12 16:38:43 · 714 阅读 · 0 评论 -
open database with ORA-00704 and ORA-39700
1,Error1)alter.log[code="java"]Fri May 6 14:50:01 2011Errors in file /opt/oracle/app/oracle/admin/bks/udump/bks_ora_5111.trc:ORA-00704: bootstrap process failureORA-39700: database must...2011-05-06 16:13:59 · 129 阅读 · 0 评论 -
oracle text index create and use
[b][size=medium]一、Install Text Index[/size][/b]1,The steps of context install on Oracle 10g. [code="java"]1, create tablespace drsys2, run @?/ctx/admin/catctx.sql ctxsys drsys temp01 noloc...2011-05-06 13:41:19 · 126 阅读 · 0 评论 -
offline datafile and offline tablespace
1)offline datafileOFFLINE Specify OFFLINE to take the datafile offline. If the database is open, you must perform media recovery on the datafile before bringing it back online, because a checkpoin...2011-05-04 11:43:10 · 141 阅读 · 0 评论 -
oracle three type of block size
Tools:[quote][oracle@node oracle]$ $ORACLE_HOME/bin/dbfsizeUsage: /u01/oracle/product/10.2.0/db_1/bin/dbfsize: database-file[/quote]1)redo[quote][oracle@node oracle]$ $ORACLE_HOME/bin/dbfs...2011-04-28 17:35:15 · 89 阅读 · 0 评论 -
bbed一(安装)
bbed-----------------------block brows editer是oracle提供的块编辑工具但这个工具是内部使用的一旦使用oracle将不再支持这个工具没有windows版本linux/unix版本需要编译后才可以使用编译后的工具也可以对windows下数据库文件进行编辑-----------------------bbed编辑...原创 2011-04-26 14:54:01 · 90 阅读 · 0 评论 -
Strategies for RAC inter-instance parallelized queries
I recently had to sit down and think about how I would spread workloads across nodes in a RAC data warehouse configuration. The challenge was quite interesting, here were the specifications: •...原创 2011-04-25 14:14:11 · 190 阅读 · 0 评论 -
Enable Row Movement in Partitioning and Overhead
[b]Question 1:[/b]Hi,I am partitioning few huge tables, regarding The feature of Enable Row movement i need some clarifications :First QuestionDoes partitioning column should not be ...原创 2011-04-24 14:03:03 · 127 阅读 · 0 评论 -
Row Movement in Oracle
One of the relatively newer features in Oracle concerns the moving of rows. Why would a row move and who or what controls that movement? Furthermore, by “move,” what exactly does move mean? Does a row...原创 2011-04-23 22:23:49 · 135 阅读 · 0 评论 -
ORA-14402 updating partition key column
做DBA几年来,经常遇到项目到了维护期总是修改表的结构,原因很简单,就是随着数据量越来越大,对表的访问越来越慢。故这次趁着割接,把这些表重新规划下。不过有个同事在进行划分分区表时,偏偏喜欢用状态字段做分区key,原因是每个月需要出报表,统计数据方便。据我了解:1)这个状态字段,根据业务变化,要经过从0到1,最终状态是32)而且从表的数据在这个状态字段上的分布了解到,最终状态...原创 2011-04-23 19:48:28 · 597 阅读 · 0 评论 -
ORACLE DSI 介绍
DSI是Data Server Internals的缩写,是Oracle公司内部用来培训Oracle售后工程师使用的教材.由于某种原因流落江湖, 受到众多Oracle爱好者的追捧, 不过要是功力不到, 阅读反而无益. DSI3是Oracle 8系列的, DSI4是Oracle 9系列的. 这样的文档上通常都印着:Oracle Confidential:For internal Use Only....原创 2011-04-19 18:33:57 · 245 阅读 · 0 评论 -
oracle EXECUTE IMMEDIATE ora-00911
I get an error when I try to execute this procedure, which is part of a package :ERROR at line 1:ORA-00911: invalid characterORA-06512: at "SA.GET_PBS", line 41ORA-06512: at line 1line 41 is...原创 2011-08-14 10:15:59 · 669 阅读 · 0 评论