http://en.wikipedia.org/wiki/Fabio_Grosso

Before the WorldCup 2006, I even didn't know this guy. He impressed me in the match between Italy and Australia. I think maybe Italians have already known the Chinese CCTV commentator Huang Jian Xiang of this match.:P I was totally stuck on him by his goal in the match between Germany and Italy.

Be unknown to public for a long time in low level Italian leagues and tiny clubs, it's amazing he has made such an achievement. I mean the champion of WorldCup.

I have a permanent table named titlesanindex with 1547929 rows. Each row is about 2KB in size.

First I create a temporary table as

CREATE GLOBAL TEMPORARY TABLE titlescanindex_temp ON COMMIT PRESERVE ROWS AS SELECT * FROM titlescanindex;

Then I create a null permanent table as
CREATE TABLE titlescanindex_temp_2 AS SELECT * FROM titlescanindex where 1=0;

At last, If I execute

Inside the Linux boot process

Take a guided tour from the Master Boot Record to the first user-space application

Level: Introductory

M. Tim Jones (mtj@mtjones.com), Consultant Engineer, Emulex

31 May 2006

The process of booting a Linux® system consists of a number of stages. But whether you're booting a standard x86 desktop or a deeply embedded PowerPC® target, much of the flow is surprisingly similar. This article explores the Linux boot process from the initial bootstrap to the start of the first user-space application. Along the way, you'll learn about various other boot-related topics such as the boot loaders, kernel decompression, the initial RAM disk, and other elements of Linux boot.

Today I executed the following SQL code to check the status of the data files.

SELECT d.file_name "Data File Name", d.tablespace_name "Tablespace Name",
ROUND (MAX (d.BYTES) / 1024, 2) "total KB",
DECODE (SUM (f.BYTES),
NULL, 0,
ROUND (SUM (f.BYTES) / 1024, 2)
) "Free KB",
DECODE (SUM (f.BYTES),
NULL, 0,

I have table named 'liuxg_tab_01' in 10g.

This morning I exported this table using 'exp' and then tried to imp it into 8i, I failed.

After a while, I created a database link named 'ctf' in 8i which connected to 10g. I issued 'create table test as selct * from liuxg_tab_01@ctf',it returns 'ORA-01723'.

Then I extraced the DDL of 'liuxg_tab_01' from 10g with QUEST TAOD, it's:
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

This morning I read the article titled IN (vs) EXISTS and NOT IN (vs) NOT EXISTS from AskTom.

Curious about the examples presented, I had a try in my own ORACLE 10g.

SQL>create table liuxg_tab_01 as select * from all_objects;
SQL>describe liuxg_tab_01
Name Null? Type

The residue of former Yugoslavia is breaking up again

“中国国际广播电台报道(记者 王萍)：塞尔维亚和黑山的黑山共和国与当地时间21日上午8点开始就独立问题进行全民公决。

　　根据黑山全民公决委员会的统计结果，共有484718名黑山选民有权参加投票。选民将从上午8点到晚上9点在黑山全境21个地区设立的1117个投票站投票，投票结果将于22日公布。” 信息来源：SINA。

Using Oracle's Parallel Execution Features

Parallel Features

The full list of Oracle parallel execution features currently includes the following

*Parallel Query
*Parallel DML
*Parallel DDL
*Parallel Data Loading
*Parallel Recovery
*Parallel Replication
*How Parallel Execution Works

Operations That Can Be Parallelized

Oracle can parallelize operations that involve processing an entire table or an entire partition. These operations include:

Recursive Calls

Sometimes, in order to execute a SQL statement issued by a user, Oracle must issue additional statements. Such statements are called recursive calls or recursive SQL statements. For example, if you insert a row into a table that does not have enough space to hold that row, then Oracle makes recursive calls to allocate the space dynamically. Recursive calls are also generated when data dictionary information is not available in the data dictionary cache and must be retrieved from disk.

The following query will show you the overall buffer cache hit ratio for the entire instance since it was started:

SELECT (P1.value + P2.value - P3.value) / (P1.value + P2.value)
FROM v$sysstat P1, v$sysstat P2, v$sysstat P3
WHERE P1.name = 'db block gets'
AND P2.name = 'consistent gets'
AND P3.name = 'physical reads'

You can also see the buffer cache hit ratio for one specific session since that session started:

刚刚出去上了次厕所，顺手把门关上了，钥匙没带！

干，着急啊。

楼长说他那没有备用的。

去找南门保安借梯子，预备从窗户爬进去，二楼也不高，可没梯子。

回来想踹门，觉得不合适，别人睡得香呢。

最后看到门顶上窗户裂成两半了，觉得可以下点功夫。

去楼下一个废弃书架上找到了一串废弃的钥匙。把废弃书架也搬上来，站上面。

How to Recreate the Database Control Repository - (Oracle10g)

by Jeff Hunter, Sr. Database Administrator

Contents

1. Overview
2. On UNIX Systems
3. On Windows Systems
4. Further Reading

Overview

This article provides steps-by-step details on how to remove and recreate the Database Control Repository in a 10g database.

On UNIX Systems

A number is a prime number if it's an integer greater than zero and it can not be divided exactly by other integers except 1 and itself.

So number 1, 2 and 3 are prime numbers.

Beyond number 3, If a number is not a prime number, it can be divided exactly by one of the integers between 2 and the square root of this number.This is the most efficient way to identify a prime number.

There's a

During the path a packet leaves the source computer and reaches the destination computer, When it is forwareded by an intermediate router, the Time to Live (TTL) is subtracted by 1.

This is utilized by traceroute to determine the path a packet takes to the destionation.

The Windows implementation of traceroute (tracert.exe) determines the path taken to a destination by sending ICMP Echo Request messages with varying Time to Live (TTL) values to the destination and receiving ICMP Time Exceeded messages.

If you want to watch the indexes one account can access, types of the indexes, and columns of which table the indexes are based on, the following SQL could help:

SELECT a.index_name,a.index_type,a.table_name,b.column_name from USER_INDEXES a,USER_IND_COLUMNS b WHERE a.index_name = b.index_name;