# 43835
jjxlcsw
|
|
To: to eygle
数据库中update是把数据从磁盘上读到cache中(如果cache中没有),然后再update,然后dbwr 在写到磁盘。
那么insert是如何处理的了?也是构造一个block放到cache中然后再用dbwr回写吗? 如果写入的数据大小只有7.9K,那么是不是剩下的0.1K就是碎片(假如数据块是8K)。
delete是不是也是读数据到cache然后做一个删除的标记?谢谢
From: jjxlcsw 2008.01.03 16:25
|
|
|
|
To: jjxlcsw
[COLOR=blue]insert要找到一个空闲块或者空闲空间去插入;是的,如果一行记录7.9k,理论上剩余的空间就无法使用了。[/COLOR]
From: eygle 2008.01.06 16:47
|
|
|
|
# 43834
jennifer
|
|
To:
Hehe
I forgot writing down my question.
HOW to do it?
From: jennifer 2008.01.03 06:53
|
|
|
|
To: jennifer
[COLOR=blue]你可以先回收再授权,不能单独回收管理选项。[/COLOR]
From: eygle 2008.01.06 16:45
|
|
|
|
# 43833
jennifer
|
|
To:
Hi! Eygle
Happy new year.
I have a question about managing privileges.
For example, I gave user A some system privs and with admin option.
Now I regret. But I don't want to revoke A's system privs that I gave to him. I just want to revoke his right "with admin option". This means I don't want him to give his privs to others any more.
Say hello to your baby.
From: jennifer 2008.01.03 06:49
|
|
|
|
# 43832
想念水的鱼
|
|
To: Eygle大哥
从0开始,半年时间,如果是你的话,能学到什么样的程度?
从0开始,半年时间,如果是你的话,能学到什么样的程度?我没有冒犯的意思,我只是想尽可能高一些地要求自己!我想对自己狠一些,这段时间没有聚会,没有旅游,没有玩乐,就是oracle......Eygle大哥当年经常是"每有所获,便欣然忘食",你还说"学习和研究Oracle,严谨和认真必不可少,另外还需要勤奋!"这些我都能做到.我现在也要像你们一样勤奋,希望可以为我点拨一下,大概制定一个应该达到的标准,不用手软,我就当是特训了!谢谢!
还有,学习oracle需要的实践环境就是电脑吧,我自己有一个ACER的老笔记本,还需要什么不?
From: 想念水的鱼 2008.01.03 02:32
|
|
|
|
To: 想念水的鱼
[COLOR=blue]半年应该做到基础知识上没有盲点,为以后的学习打好根基[/COLOR]
From: eygle 2008.01.06 16:29
|
|
|
|
# 43831
想念水的鱼
|
|
To: Eygle大哥
谢谢你抽时间解答我的问题,听说10g R2 只考试两门是这样吗?
From: 想念水的鱼 2008.01.01 23:48
|
|
|
|
To: 想念水的鱼
[COLOR=blue]应该是的。[/COLOR]
From: eygle 2008.01.02 21:12
|
|
|
|
# 43830
Larry
|
|
To:
你好,eygle,忙中还顾得上帮忙解答问题,呵呵,很感谢哦。。。
我想请教一下,如果我在alter tablespace users begin backup的时候,忘了作end backup,那么其中这段期间的commit 了的trasaction是怎么存放的,只是会全部写入到redo log中吗?如果这样的话,我再做end backup,那数据库是不是根据redo log来写入这段期间的trasaction呢?那可是相当一次recovery啊。
From: Larry 2008.01.01 19:33
|
|
|
|
To: Larry
[COLOR=blue]
跟正常的没区别,只不过多写了REDO
[/COLOR]
From: eygle 2008.01.02 21:11
|
|
|
|
# 43829
Julia
|
|
To: Eygle
好不舒服Er...
From: Julia 2008.01.01 18:36
|
|
|
|
To: Julia
[COLOR=blue]辛苦咪![/COLOR]
From: eygle 2008.01.02 21:10
|
|
|
|
|