123
 123

2007-10-11 Thu

20:36 其实,我们都误解百度了 (536 Bytes) » Fenng's shared items in Google Reader

百度在搜索引擎方面净化网络做得很好,让那些色情狂们寻觅不到任何踪迹。
不信你试试,肯定很失望吧。
但是,如果你在搜索框里面输入“aaaa/aaa”,会是什么结果?
结果你也会很失望,不过你可以看看下面的相关搜索。
嗯哼!

13:19 Add an option to Fail on Innodb Initialize failure, Please ? (5612 Bytes) » MySQL Performance Blog

I already wrote about this issue but as I is third team I'm helping customers to resolve this "frm corruption" issue it is the time to return to it again.

During MySQL 5.0 release cycle the change was made so now MySQL does not stop if Innodb storage engine failed to initialize but starts properly... just having Innodb tables unavailable. I honestly do not know any case when this behavior change helps... of course you silently want to get good portion of your database unavailable right ? But I guess this change was made for reasons quite far from improving user experience.

It is worth to note MySQL 5.0 introduces STRICT option which will makes error control more strict, what is often expected by the Enterprise users - so instead of cutting the string lengths or converging NULLs to zeros MySQL can be tuned to abort such statements. In this, in my opinion much more serious case there is no option to only start MySQL if all enabled storage engines could be initialized. It should be pretty trivial to add one I think.

Note if we use typical comparison of Storage Engines to File Systems - you have an option to specify which of file systems are mandatory so system will not complete boot up without having these systems clearly mounted. The reason is same - you do not want to deal with all kind of gotchas which may happen when system is partially functional in such crazy way. It is much better to have it safely down so monitoring will scream and let you to get out quickly and fix things.

But it gets worse. Innodb failed initialization is not only very hidden - you will not see it unless you look in MySQL server Error Logs but the error message accessing Innodb tables is also very obfuscated:

SQL:
  1. error    : Incorrect information IN file: './prod/user.frm'

How this supposed to tell you Innodb (or for that sake any other Storage Engine) failed to initialize ?

This error suppose to mean .frm file is corrupted, and indeed you still can get this error message in such case, but now it is used for completely different reason.

Why not to have error message "Storage Engine is Not Available" or something similar ?

Users are confused by this error message and think it is indeed .frm corruption - trying to restore .frm from backup or other servers and being extremely frustrated as it does not work.

Of course if something looks wrong with your server you should first take a look at MySQL Server error logs but few people do it or spend a time examining error messages accurately enough.

Again if you made your made on this behavior, please at least add option such as --strict-start which would require server to start without serious errors in order to start listening on the sockets.


Entry posted by peter | No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

12:30 Oracle, MySQL and PostgreSQL feature comparison Part 2 (283 Bytes) » DBASupport
In the last piece of our database comparison, we hit upon various areas such as triggers, views, and stored procedures. This time around, we'll discuss some areas where the platforms differ more significantly, most importantly in their handling of complex SQL and optimizing choices.
09:45 Zero to Z-Shell: Learn what all the fuss is about with Z-Shell (11628 Bytes) » Red Hat Magazine

By and large, most Red Hat Linux systems will have Bash as the default shell. Bash is a darn great shell, but this article is about another equally great shell, called Z-Shell, that has most of the attributes of Bash, but in some cases goes the extra mile to give you the flexibility to customize your shell more than Bash allows.

This article is somewhat advanced, but if you’re very patient, with some effort, you will do just fine. Remember to make small changes, test them, and then make more small changes, test, and repeat.

First a few basics. I would encourage you to fire up a shell and test out this code while you read.

Basic configuration and setup

Switching your default shell to zsh

Before you start hacking away and changing config files, you need to do a few things first. Since Bash is the default shell, you will need to change things to Z-Shell, at least temporarily, while you follow this article. By far the easiest way to change your shell is to use the chsh command.

To quickly change to zsh, issue this command:

chsh -s /bin/zsh

If you take a peek at your /etc/passwd file:

less /etc/passwd 

You will see that the default shell for your user account has been changed. This is a permanent change, and when you log back in again you will stay with the zsh.

Z-Shell Configuration Files

The good and bad of it is that zsh can have as many as eight different configuration files. This is the order of execution that you should know about for the most common files:

1. /etc/zshenv - Always executed global configuration file.
2. ~/.zshenv - Local configuration file.
3. /etc/zprofile - Global Login shell configuration.
4. /etc/zshrc - Global interactive shell configuration.
5. ~/.zshrc - User interactive shell configuration.

The most efficient file to edit is probably ~/.zshenv as it will configure both interactive and non-interactive shells. For all of the examples I show below, please edit the ~/.zshenv file.

Backing up your configuration files or using version control

One thing I always caution is to backup your original file or use version control. One of the absolute worst situations to be in is with a damaged configuration file and no way to return to the original state. Make a backup of any file you edit, or better yet, use version control!

Z-Shell Cookbook

Since there are so many things you can do with Z-Shell and no way to talk about them all, I’m going to give you as much as possible through a cookbook format. I will go through the “recipes,” and you can “cook” along with your shell at home. Did you you remember to make a backup of your original files? Great, lets get started!

Autocompletion

Z-Shell has incredible autocompletion tools. Here are few barebones examples:

In order to use autocompletion, you will need to put the following in your ~/.zshenv file:

#Allows prompt profiles
autoload -U promptinit
promptinit

With zsh you can autocomplete things other than just file. If you type in:

$PA 

you get variable completion.

If you use something like gunzip in a directory with .gz files it will just figure out what files it should work with if you keep selecting tab. Try it out.

If you’re in the mood to get really geeky, check out completion functions in zsh. I don’t cover them in this article, but they are worth investigating.

Command history and history substitution

Mastering the use of command history will save you many keystrokes!

Remove mistakes:

root@cent]~# lesss /var/log/messages
zsh: command not found: lesss
[root@cent]~# ^s
less /var/log/messages

Remember commands:

[root@cent]~# ls /var/log/messages
/var/log/messages
[root@cent]~# !!
ls /var/log/messages
/var/log/messages
!$ Last Argument on the previous command line
cp !$ .
(copies /var/log/messages to current directory)

Rerun previous commands:

!l
root@cent]~# !l
ls /var/log/messages
/var/log/messages

This works because ls is in the history.

Finally, you can substitute by a command line number.

[root@cent]~# !32
ls /var/log/messages
/var/log/messages

Key bindings

Key bindings literally bind things to certain keys. Instead of using readline like Bash, zsh uses Zsh Line Editor or zle. In Bash you use bind and in zsh you use bindkey.

In zsh to find out what keys are bound:

bindkey -L

To see the whole list of editor commands that can be bound, and it is huge:

zle -la

I would recommend exploring keybindings by piping the list of your currently bound keys to less:

bindkey -L | less

Job Control

An example of using job control in Z-Shell:

tail -f /var/log/messages &
jobs
kill %1
run:

If you have a long-running process, you might want to let it work in the background while you continue other things. For example, if you download a tool I wrote called Liten, you may want to run it as a background job, as it will search a directory tree and do md5 checksums on files to find duplicates. This may take quite a while to completely get through a large file system, so it’s a perfect choice to run in the background.
Go ahead and run liten on your home directory as a background process:

./liten.py $HOME

Then click Ctrl+Z to send the job to the background.
The output will be:

zsh: suspended  ./liten.py $HOME

Then run:

jobs

And the output will be:

[1]  + suspended  ./liten.py $HOME
root@cent]~# bg %1
[1]  + continued  ./liten.py $HOME

If you have only one suspended job, you can use the shortcut:

%top
%vi 

You can also set an option in zsh to resume jobs by name:

setopt auto_resume

This lets you resume a job just by typing in the name of the job. It’s quite handy!

Remember that if you put a job in the background, you might want to pipe stdout somewhere while it runs.

When you exit the shell and you have a running job, zsh will kill the jobs by giving them a SIGHUP signal. Here are ways to tell zsh to prevent killing the jobs on exit:

  • Use nohup in front of jobs you want to run on exit. Make sure it used in this manner:
    nohup top &
  • You can also let your job run wild and give it the disown command or followup the the job with
    &!.

Priority of background jobs

In zsh, background jobs are automatically given a lower priority unless you set an option.

Process substitution

One neat feature zsh has is the special =(…) substitution.For example, if you want to find out the full path to a program you can do run:

ls =top

The output will be:

/usr/bin/top

I personally think this shorthand is quite nice, and I commonly find myself needing to find the full path to some command.

Another example would be when you want to use a shell command to format stdout and then
edit it in a text editor like vi:

vim =(tail < /var/log/messages)

Customizing Prompt

Like just about everything else in Z-Shell, the prompt is extremely customizable. If you would like to check out a few of the themes, you can set your .zshenv to allow prompt switching:

#Allows prompt profiles
autoload -U promptinit
promptinit

You can now view available prompt themes by typing:

prompt -l

You can also select and then set with the following:

prompt oliver
prompt -s

You will get back something like this:

prompt -s oliver
Set and save not yet implemented.

Please ensure your ~/.zshrc contains something similar to the following:

  autoload -U promptinit
  promptinit
  prompt oliver

If you want to get really fancy, you can also edit the following in your .zshenv file:

#Customize Prompt
PROMPT=$'[%n@%m][H:%B%!%b][J:%B%j%b]> '
RPS1='[D:%B%~%b]'

This is actually my current prompt, but feel free to tweak it around a bit; that’s how you learn. I won’t go any more into the details of customizing prompts here, but you should read through the Z-Shell manual.

File and directories

If you set:

setopt autocd

It will allow you to cd into a directory without typing cd first.

If you set:

cdable_vars

It will allow you to cd to a variable, such as:

cd HOME

Shortcuts for referring to directories

Get back to the directory you were just in:
~- same as $OLDPWD

Some fancy stuff:
~2 Second directory on the directory stack.
~-0 Final directory on the directory stack.

This works in conjunction with the pushd and the popd commands, which I won’t get into in this article, but you can read more here.

Using braces

Create ten test files in a few keystrokes:

touch {1..10}.txt

Summary

Z-Shell is a mind-blowing shell with the ability to tweak and change just about anything. What I covered in this brief survey article barely does Z-Shell justice. If you are interested in knowing more about Z-Shell or Bash, I would highly recommend reading, From Bash To Z-Shell by Oliver Kiddle, Jerry Peek, and Peter Stephenson. It is truly a masterful book! Of course, you can’t go wrong by reading the official documentation either.

Finally, I would love to hear back on some extra tricky things you have done with your Z-Shell.

09:45 三言二拍:上市,上市 (2664 Bytes) » Fenng's shared items in Google Reader

长跑19年,8年上市准备,金山终于如愿以偿。很多人认为,金山能够成功上市,是坚持的胜利。但,如果金山仍然在通用软件领域坚持,恐怕就不会有雷军今天的喜悦。多次转型,无数次地错失良机,才最终让金山抓住了网络游戏这个机会。金山上市,实在不是一曲坚持的凯歌。今天的金山,除了个别人物还在,我不知道它跟8年前的金山、19年前的金山,到底有什么关系。

不过,上市并不是金山的终点,喜悦不会一直在那儿。雷军说,金山要“创建快乐的企业文化,要让苦难的东西越来越少。”恐怕很难,雷军是金山最苦命的人,我一点都不怀疑,雷军会继续苦命下去。只不过,以后他需要苦苦周旋的,主要可能不再是产品、市场,而是很难伺候的投资者。

当然,苦大仇深的雷军是需要上市来激励的,但马云可能就未必。阿里巴巴也将在下个月登陆香港股市,但最希望阿里巴巴上市的,恐怕不是马云,而是别人。据报道,在阿里巴巴将向市场公开出售的8.59亿股中,用于为企业募集资金的新股只占1/4多一点,而接近3/4的发行股票来自股东套现。

无论如何,阿里巴巴的上市,将是中国电子商务市场的利好消息。在互联网广告越来越集中到几个大网站的不利形势下,电子商务很可能成为中国互联网,尤其是大量中小网站的另一个支柱

08:25 《越狱》第三季之Sara之死 (3535 Bytes) » Oracle Life

©作者:eygle 发布在 eygle.com

假期里,唯一没有停下来的工作是继续观看越狱第三季。

在第二集中发现了一个小Bug,Michael Scofield在排队领水的时候,本来分到的水只有一点点,可是一转身,他水杯里的水变成了大半杯,因为之后他还要把水分给别人。

第四集的意外出现了,那就是Sara死掉了,Julia和很多人一样,并不相信就是这样了,就这样就失去了那个很多人喜爱的女主角。然而事实就是如此。网上已经有很多文章说明了真相:
以下是TV Gudie独家专访《越狱》编剧的内容
如果你还固执地否认今天《越狱》中那件惊人的事件,还对此抱有幻想,那么请不要再读下去了,因为下面是铁的事实:在那个盒子里面放着的的的确确是莎拉-唐克莱蒂的脑袋。没有任何挽回的余地,没有任何改变的可能。迈克尔长期牵挂的伴侣已经死了永远都不会回来了。

虽然莎拉拒绝了多个采访的要求,但上周五这位女演员还是通过她的发言人传达了以下声明:
  "我们都已经尽了最大努力,《越狱》对我意义重大,但我无法同时满足剧集的需要和家庭的需要。我们双方只能在互道祝福后分道扬镳。在和整个充满创造力的剧组共事期间我渡过了愉快的时光,我对他们每一个人都充满敬意。他们对莎拉医生这个角色一直处理的非常好。同时我要对剧迷们表达深深的感激。他们是如此的支持我们,我希望他们能继续喜欢这部剧集。"

这一切都说明,这是一个事实,SARA这个受人喜爱的越狱角色已经离开了PB。

继续阅读 【《越狱》第三季之Sara之死】...

相关文章|Related Articles

评论数量(1)|Add Comments

本文网址:

07:31 结束假期 回到北京 (2553 Bytes) » Oracle Life

©作者:eygle 发布在 eygle.com

在经过了漫长的游荡之后,终于又回到了北京。

这个假期是繁忙而愉快的,先是经历了一个巡回的演讲活动,然后到了昆明,再然后回到广东江门,和家人一起度过了愉快的国庆假日。
离开北京的时候,还是天气炎热,现在回来,已经颇有点寒意了;而现在的广州,刚刚还是三十多度的气温;电话给东北的爸爸妈妈,说是气温已经到了零下;真是天南地北几重天啊!

和大家分享一下昆明的花花草草。
1.昆明的花

2.昆明的草

昆明真是一个美丽的城市,虽然又一次是来去匆匆,但是心中的不舍依然。

当飞机在北京降落,看着满城市的烟雾,水泄不通的道路,我心里想:北京,我回来啦!

相关文章|Related Articles

评论数量(1)|Add Comments

本文网址:

06:31 New command line option for text export utility -- BUFFER (2564 Bytes) » DBA Tools

    When tuning the performance of Oracle SQL loader (sqlldr), the read size and bind size option are very critical. When ociuldr utility generate the SQL loader control file for you, the default read size and bind size are fixed 8MB. Sometime it's not big enough.

OPTIONS(BINDSIZE=8388608,READSIZE=8388608,ERRORS=-1,ROWS=50000)
LOAD DATA
......

    So I add a new command line option "BUFFER" to specify the read size and bind size, and the default value is changed to 16MB (minimum value 8MB, maximum value 100MB) now. We just need to specify the size in MB, for example.

ociuldr user=... query=... talbe=... BUFFER=10

    And the generated SQL loader control file will look like as following.

OPTIONS(BINDSIZE=10485760,READSIZE=10485760,ERRORS=-1,ROWS=50000)
LOAD DATA
......

    You can test the performance change with different buffer values.

Related Posts

Leave New Comment(Current: 0)

Link: http://www.dbatools.net/mytools/ociuldr_buffer_option.html

05:30 国庆出游 (4622 Bytes) » DBA notes

©作者:Fenng 发布在 dbanotes.net

这个国庆跑了一大圈。9 月 25 日就开始休假了,加起来一共十几天的假期过得其实挺累。我的路线是:杭州->上海->成都->黄龙->九寨沟->成都->沈阳->抚顺->长春->杭州。

先去的四川成都,然后走马观花了去了黄龙、九寨沟和都江堰。其实我是个比较懒的人,不过是答应了 Laura 今年要出来玩一次的,要讲究诚信嘛。

黄龙我个人觉得一般般。到了景点才知道为啥叫做黄龙。起这个名字的人一定是搞航拍的。

IMG_8489

同行的还有一对印尼来的 Thomas 夫妇,导游的英语似乎不过关,我有的时候自告奋勇冒充一下翻译,可怜我的洋汀浜英语......这俩人行程安排的可倒挺满,基本把国内著名景点都逛遍了,挺佩服他们的体力。

九寨沟的水:

093009~4

九寨沟还是名不虚传的,所谓"九寨归来不看水"倒是一点也不夸张。其实游客都是挺自私的,景观虽好,但不会因为你来了而变得更美,只会更糟。昨天看到世界遗产的中国悲歌这篇文章,觉得文中的担忧是对的。游客这么多,到哪里都和蝗虫似的。

没经得起司机的撺掇,也顺便去都江堰转了一圈:

IMG_9006

大家都知道都江堰是李冰父子主导修建的。到底李冰的儿子叫啥? 这龙套跑的,好几千年了也没多少人知道。搜索了一下,似乎叫做”李二郎“,好像只是个小名啊。

这一圈很多时间坐车/飞机, 搞得我颈椎现在有反应了,今天不得不跑去做推拿。

更多图片请移步:

--EOF--

相关文章|Related Articles

评论数量(1)|Add Comments

本文网址:

05:00 Baidu plans R&D centers in Shanghai, Tokyo (355 Bytes) » Fenng's shared items in Google Reader
"China's top Web search firm Baidu.com Inc plans to launch a research and development centre in Shanghai as early as this year, an industry source said on Wednesday, as it seeks to fend off rival Google in the world's second-largest Web market."
04:43 Cost saving in wrong place (3347 Bytes) » DBA Tools

    Someone got their database lost today. A decision support system (DSS) database, 200GB size, running in noarchive log mode, and no backup available. One of the hard disk got corrupted, after got the data files back with disk utilities, they found there are a lot of corrupted or fractured blocks in system tablespace, about 100 damaged blocks found with DBVerify utility.

    I want to ask them, why no backup? Lack of storage? The disk space is cheap now, I can get 1TB storage within 500USD for PC hard disks, where they spent the storage money? Nobody know how to take effective backup? Hiring a DBA who knows how to perform backup is not expensive, where they spent the money to hire a qualified DBA? And they had no backup of the table structure, want to find these back from the corrupted system tablespace, it's not a easy job. Of cause, the cost saving is in wrong place.

    They asked me for possible recovery solutions. In this case, I told them that they can get some of the data recovered with Oracle DUL or AUL/MyDUL utility, if there are no corrupt blocks in other data files, we can get all the data recovered. But after ask me how I will charge them for the data recovery, they keep sliently, their department leaders are waiting for a free recovery. Is this correct cost saving method?

    A decision support system with 200GB data should be very important to the company, but they don't worry about it, seems the data is not important at all. Then why the company spend money in building it? Previous similar case is a OLAP database with 500GB data in it, finally they decide to spend several months of time to reload the data from business system because they do not want to pay for the recovery or they just want to pay several hundreds of dollars for it.

    We are very hard to get the reward for support service. A lot of costing saving occurred in wrong place.

Related Posts

Leave New Comment(Current: 0)

Link: http://www.dbatools.net/support/wrong_cost_saving.html

04:30 逻辑卷管理 (357 Bytes) » developerWorks : AIX 专区的文章,教程
卷管理在 -ix 环境(UNIX、AIX 等等)中并不是新特性。逻辑卷管理(logical volume management,LVM)在 Linux 内核 2.4v1 和 2.6.9v2 中就已经出现了。本文讨论 LVM2 最有用的特性(LVM2 是一个相当新的用户空间工具集,它提供逻辑卷管理功能),并提供几种简化系统管理任务的方法。
02:57 The payment of AUL Oracle data recovery service. (3178 Bytes) » DBA Tools

    I provide Oracle data recovery service for you, it's not free, so you will be charged, we need get an agreement on the charge first. How much you will be charged? I am not selling a product or a license, you may feel that I am just selling the AUL license, but I need to be online and provide support for you, so it's a support service actually. So there is no fixed price for this service. It varies on the database size and where are you from.

    But you need to tell me the company name and the phone number, please send these information via your enterprise email box. Else I may have problem to trust you.

    You do not have to process payment first before recovery. Because time saving is very important for recovery, everyone prefers get the data back first. Usually international payment may take several days to finish, can you wait several days? The most important is that I trust you, trust your promise. However, in China, I have to get the payment first.

    For international payment, I will send a bill invoice document to you to process the payment. The following information are critical for successful payment, ask your bank employee perform double check when processing.

1, Bank Name
2, Account Name
3, Account Number
4, SWIFT code of the bank

    Usually you should ask your finance department employee to process the payment after we successfully recover some data. And you should send me a image of the receipt from the bank, I will check whether the information is correct or not. The is required, if something wrong, we can fix it earlier.

    One of my customers wrote wrong account number, and I waited one month to get the payment. Another customer write wrong account name, and I waited near one month also to get the payment. I hope this won't happen again.

Related Posts

Leave New Comment(Current: 0)

Link: http://www.dbatools.net/mydul/aul_payment.html

02:33 Y! Blog Downgraded (3670 Bytes) » Fenng's shared items in Google Reader

因為Yahoo! Blog說系統升級,所以一整晚上不到,令我閱讀不到某些喜歡的Blog。Anyway,令所有用戶一整晚用不到,一定是大升級。那麼我只好懷著一些憧憬去等一下。

誰不知,再看看光復了的Yahoo! Blog。真的不知他們搞甚麼,也不知可說甚麼來形容。只覺得他們像Downgrade了整個服務。

沒錯,你們是加入了一些Ajax的介面,例如我們可以直接在一個blog的首頁,留言回應最新一篇的文章之類。不過,這類Ajax的小玩意,真的不能補償他們Downgrade了的用戶體驗。

首先,幹嗎每篇文都加一個醜樣的icon,算是甚麼呢?其實我第一次見到這icon,感到倒胃,於是立即去了其他網站。沒有icon不好嗎?有關這問題,不多說,因為阿Hang已詳細談論了。

很多Yahoo! Blog的用戶都將最新的回應列在首頁。「升級」之後,回應的次序亂了。我還以為我的舊文章有這麼多人回應。另外,「最新回應」所列出來的,只是某某人回應了某篇文章。為何不顯示回應的內文呢?如果這樣,不如直截了當的刪除這功能吧。

另外,「我的BLOG友」一欄強行把用戶的相片放大,令每個用戶的相都像打了馬賽克一樣,又是一大敗筆。

又另外,首篇文章的網誌日期,竟是XX個小時前。XX個小時前或XX天前算是甚麼日期呢?

其實我數的這幾點,都只是其中的Downgrade部份。他們還做了好些令用戶激憤的事情。大家可以閱讀他們《功能正逐步恢復》的官方文章,看看用戶們的回應有多澎湃便明白(15小時就有1182個回應,絕大部份是破口大罵的)。

另外on.cc亦開了一個討論,讓大家評價一下Yahoo! Blog的新版面

P.S. on.cc像絕大部份的人,都不能正確的寫出Yahoo!的名稱。是「Yahoo!」,不是「Yahoo」呢。

Jan’s Tech Blog, where technologies are explored and annotated.

02:17 How AUL support the partition table's CLOB/BLOB recovery? (3234 Bytes) » DBA Tools

    When you prepare to do recovery of partitioned table with LOB columns with AUL4, you must modify the LOB index's partition name first in "AULOBJ.TXT". I have thought that the LOB index have the same partition name with table, just as normal local index, and in AUL 4 I use the table's partition name to locate the LOB index's partition to get the relative data object id. But the names are not same, let's start with two demo table :

SQL> CREATE TABLE T_HASHLOB (COL1 NUMBER, COL2 CLOB)
  2  LOB(COL2) STORE AS (DISABLE STORAGE IN ROW)
  3  PARTITION BY HASH(COL1) PARTITIONS 2;

Table created.

    Insert few rows and the perform a checkpoint, and start AUL 4 to unload the dictionary table, and describe the table structure:

AUL> desc anysql.t_hashlob

Storage(OBJ#=0 OBJD=0 TS=0 FILE=0 BLOCK=0 CLUSTER=0)
No. SEQ INT Column Name         Type
--- --- --- ------------------- ----------------
  1   1   1 COL1                NUMBER
  2   2   2 COL2                CLOB  (SYS_IL0000010046C00002$$)

    We could use grep to get the partition name information:

Read Full Text of【How AUL support the partition table's CLOB/BLOB recovery?】

Related Posts

Leave New Comment(Current: 0)

Link: http://www.dbatools.net/mydul/aul_lobpartition.html

02:14 badge_image (292 Bytes) » Photos from dbanotes

dbanotes posted a photo:

badge_image

02:13 How AUL support different Oracle CLOB/BLOB chunk size? (2826 Bytes) » DBA Tools

    All the blocks of a chunk must be continual with a single extent, because you cannot specify a chunk size larger than the next extent size. Based on this rule, I add different chunk size support to AUL 4. Following are two demo tables, they both contains one column and only one row, populated with the same data.

SQL> SELECT TABLE_NAME,COLUMN_NAME,CHUNK FROM USER_LOBS;

TABLE_NAME      COLUMN_NAME       CHUNK
--------------- ------------ ----------
T_CHUNK2        COL1              32768
T_CHUNK1        COL1              16384

    Then we will use the chunk option of unload command to specify the LOB chunk size (how many blocks?) of this table, default is one. There is one limit that all the LOB columns should have the same chunk size in a single table. Then we start to unload the two LOB value to OS files :

Read Full Text of【How AUL support different Oracle CLOB/BLOB chunk size?】

Related Posts

Leave New Comment(Current: 0)

Link: http://www.dbatools.net/mydul/aul_lobchunk.html

2007-10-10 Wed

22:53 嫁给有钱人的秘方 » DBA is thinking
22:00 备份工具rsync介绍 » Welcome to brotherxiao's Home
20:30 小窍门–sqlplus中使用backspace键 » Welcome to brotherxiao's Home
20:30 从 Windows 移植到 UNIX,第 1 部分: 移植 C/C++ 源代码 » developerWorks : AIX 专区的文章,教程
19:54 Spring 2.5 Perfomance Improvements 200% 直逼 Guice » Fenng's shared items in Google Reader
17:22 一夜无眠 » OracleDBA Blog
15:57 Simplifying Database Administration – Part 1 » Fenng's shared items in Google Reader
11:21 多才多艺土摩托 » Fenng's shared items in Google Reader
11:08 无题 » eagle's home
10:37 Friendster_Arch » Photos from dbanotes
09:24 上海F1 » 给你点color see see
08:21 小店2.0:格仔铺 » Fenng's shared items in Google Reader
08:16 如何让sql plus有记忆? » DBA is thinking
07:17 eBay: Here Come the Neighborhoods » Fenng's shared items in Google Reader
06:01 Just for fun... » The Tom Kyte Blog
06:01 Amazon 的 Dynamo 架构 » DBA notes
04:31 方军:朱伟 on 采访 » Fenng's shared items in Google Reader
04:23 尘埃落定 » 人生就是如此
02:42 演讲者简介之Alan Tien » Fenng's shared items in Google Reader

2007-10-09 Tue

23:35 TNND,都想钱想疯了 » Fenng's shared items in Google Reader
22:39 让搜索充满爱 » Fenng's shared items in Google Reader
22:31 公司2008 Technical Vision 和 前eBay CTO » Orange Tiger 木匠 的 移民生活
21:53 公司2008 Technical Vision 和 前eBay CTO » Fenng's shared items in Google Reader
19:58 家长,请不要乱方寸 » Fenng's shared items in Google Reader
19:01 IBM And Linden Lab Team For Virtual World Interoperability » Fenng's shared items in Google Reader
12:33 Show us your pumpkins! » Red Hat Magazine
09:52 Uli Drepper part 4: » Red Hat Magazine
08:31 Google_reader_error » Photos from dbanotes
08:28 抓瞎_DB_error » Photos from dbanotes
08:09 Beware of Comments in SQL » Eddie Awad's Blog
07:00 高尚生活 » DBA notes
06:38 今年黄金周预示明年粮食价格走高 » 玉面飞龙的BLOG
05:57 shell 编程之2>&1 » NinGoo@Net
05:45 What about a Self-learning SQL Optimizer? » Fenng's shared items in Google Reader