Life is hard
ҽ
л
ҵBlog
¹鵵...
·...
...
Ķ...
...
ͳ...
վ...
Դ
===========================================================
deŮ
===========================================================

Ů˵ŮرġûѣһҪŮѡ

Ů˵ŮѿԹͬĶкࣺܶ·ΡױƷٴӹĸܣȫʵ

һֱлôŮѡǵĴڣҼʹӣҲܵů

 鿴ȫ
echooooo :2006.11.30 11:03 ::: ( ) ::Ķ:(597) :: (5) :: (0)
===========================================================
ּͥԺ
===========================================================

ϰ·߹̶䣬1Сʱij̣ʵģ϶³͸ġ

糿ϰǶ³ӰóBECĵֲᣬɢעӳȥȻ·ԵҶӾȫˣͨ͸Ļɫdzɫգķ羰

ֶӵijҲǿԷһЩ羰ģԼǡԶƫɡ

 鿴ȫ

echooooo :2006.11.28 11:44 ::: ( ) ::Ķ:(197) :: (1) :: (0)
===========================================================
̸
===========================================================

һȱ׸ꡣ

ǶٵĸõĻرǶ߽ݾ˻Ůˡ

Һһ죬һֱǿߣԭǵģܶ飬ûа취̣ҵĵߡЦ˵Ϊһûȫ

ڵ˵һŮһֱһ棬˵ĺҸ

ˣߣˣԺԽԽʵ룬ԼǺģ߲Ҹ

ô˿һŮ˱棿Ҿ±ƪдĻͲˡ

İҪ࣬Լ򲻻̫ĸѡ񣬹㷢չԼרִ˵һҪ׼ǣеŮԣһ֮Եˡ

 鿴ȫ
echooooo :2006.11.26 10:04 ::: ( ) ::Ķ:(367) :: (6) :: (0)
===========================================================
CoolOracle DBA Toolbar
===========================================================

download

http://www.oracle.com/technology/toolbar/OracleDBAToolbarSetup.exe

 鿴ȫ
echooooo :2006.11.24 11:57 ::: ( Oracle Tips ) ::Ķ:(238) :: (2) :: (0)
===========================================================
ü㼰Ͷʼ
===========================================================
μ

򿪷ʽ֤ȯͶʻһַãһڹ³ĻʱҪɡϹѡڹϻʱҪɡ깺ѡڻʱҪɡѡһϹΪ1.2%깺Ϊ1.5%Ϊ0.5%(гշ)

Ϲ㹫ʽΪϹãϹϹʡϹϹ-ϹãϹյյϢϹݶ

깺㹫ʽΪ깺ã깺깺ʡ깺ݶ(깺-깺)ջλֵ

ؼ㹫ʽΪطѣطݶصջλֵطʡ 鿴ȫ
echooooo :2006.11.22 15:15 ::: ( ) ::Ķ:(1774) :: (0) :: (0)
===========================================================
A Bug of NULLS FIRST ORDER BY on a column which has the NOT NULL constraint
===========================================================
Bug 2126283

Range of versions believed to be affected
versions<9.2

Platforms affected Generic

Fixed in 9.2.0.1(Base Release)

Description

Rows may be returned in the wrong order if the rule-based optimizer
is used for a query with special sort options (eg ASC NULLS FIRST)
if the sort gets replaced with an index scan.

 鿴ȫ
echooooo :2006.11.22 14:07 ::: ( Oracle Tips ) ::Ķ:(267) :: (0) :: (0)
===========================================================
ȽϷ
===========================================================

1ˣʳԽԽãزӡ

2ȥĵطٳٲϧû㡰ʱֻܼѧϰǰЩӵѧϰЧֵÿ϶

3Ʊڱסӿʼھû׬ʺƣǹעɡרҵ齻רҵ˾ȥ

 鿴ȫ
echooooo :2006.11.21 19:19 ::: ( ) ::Ķ:(489) :: (5) :: (0)
===========================================================
portָ˿ô
===========================================================

1

There is also a port specific bug filed on HP and 10g where running queries on x$ksmsp will hang the database.

2

The types of latches used by Oracle, and whether they are solitary latches or parent and child sets, varies with different releases of Oracle and operating system ports.

 鿴ȫ
echooooo :2006.11.20 16:36 ::: ( Oracle Tips ) ::Ķ:(225) :: (3) :: (0)
===========================================================
Helisoft
===========================================================

΢ֱ......

^_^

 鿴ȫ
echooooo :2006.11.20 12:51 ::: ( һЦ ) ::Ķ:(190) :: (1) :: (0)
===========================================================
===========================================================

С˵ϲϷ꣬ͬϲѩһΪϡ

꣬ϷǺܳġ࣬˸еЩꡣ˵ʱϲڴߣббƮżƮ䣬Ʈڴߵϡɵģ֮䣬ɸɾϺѾûľ

 鿴ȫ
echooooo :2006.11.18 21:28 ::: ( ) ::Ķ:(189) :: (2) :: (0)
===========================================================
ϲORA-04031
===========================================================

metalink < Doc ID: Note:146599.1 >

ǰ2һ̨8iֳ04031Ĵϰ걨һ04031Ĵÿζ

Ȼʼα겻αķ

shared poolshared pool reservedõĶ㹻ҪdzӦóSQLд淶ʹõIJѯδʹð󶨱

һmetalinkϹ04031ĵϸѧϰһ飬Ĺ鵵

 鿴ȫ
echooooo :2006.11.16 18:46 ::: ( Oracle Tips ) ::Ķ:(989) :: (0) :: (0)
===========================================================
Oracle X$tablesһ
===========================================================

Oracle x$"tables"ʵ߻ỰڴṹıչʾΪv$ͼ

беĿѧϰOracle internalsĿγͨ鼮ϣixora http://www.ixora.com.au/ վͨԼIJԣ
v$fixed_view_definition.view_definition
еıͨʼҵݽнͣÿһӽȥġԣx$kqfdtx$kqftaлlistûгıͨһԵһЩûv$fixed_view_definitionкdzʾı

x$ıx$kͷkĸʾݽṹĸIJ㡣οSteve AdamOracle 8i Internal ServicesÿһĹܡ֪ͨⷽʶԸһOracleڲʾĸkǰǡsskgxpôһOSDϵͳصģʵ塣

http://www.stormloader.com/yonghuang/computer/x$table.html

 鿴ȫ
echooooo :2006.11.16 18:02 ::: ( Oracle Tips ) ::Ķ:(183) :: (0) :: (0)
===========================================================
ѧϰshared pool֮<ת>
===========================================================
οeygle"shared pool̽(һ)" 鿴ȫ
echooooo :2006.11.15 18:54 ::: ( Oracle Tips ) ::Ķ:(244) :: (3) :: (0)
===========================================================
ɱ ̫䣨һ
===========================================================

Written and directed by Luc Besson

Actor:Jean Reno

Actress:Natalie Portman

 鿴ȫ
echooooo :2006.11.13 17:57 ::: ( Ӱ ) ::Ķ:(269) :: (3) :: (0)