12.23.05
ASKTOM之中英文对照20051223-本地管理表空间
ASKTOM之中英文对照20051223-本地管理表空间
本人文档,如需转载,请注明出处.
译文:
本地管理表空间
晚上好 tom
create table fact_actuals
(
在上面的表中包含100万记录,假设我写了一个group by的查询,group by所有的id列.所有的id列包含很少的不同的值(例如:channel可能有counrty,region或者area是相同的)相同的差不多25000行;
1:我常见一个本地管理的temporary表空间,大小为500M,uniform extent大小为2M,这个够吗?
2:因为创建临时表空间爱女的语句不允许我指定本地自动扩展管理,那么,本地自动扩展管理是否不能在临时表空间中使用.
3:当段释放的时候是如何管理临时表空间(本地管理还是字典管理)?
4:我能使用本地管理表空间的特性来创建回滚段表空间吗?本地管理表空间相对字典管理表空间有什么优点?
回答:
1:你或许应该设置临时表空间的段的大小为SORT_AREA_SIZE的大小,我们分页的时候是按照这个大小分配的;
500M对于你的应用应该是足够的,当然,如果你有1000个用户来运行,那又是另外一回事情了.
2:非常正确,临时表空间将有固定的区的大小.分配段的大小是没有意义的.当分配的时候,不是释放,系统将定时释放,你应该避免使用不同的区的大小.这个大小应该是相同的大小并且应该和SORT_AREA_SIZE的大小一样;
3:区是不会释放的,参考
http://asktom.oracle.com/pls/ask … PLAYID:374218170986
4:当然,你可以.
我一直反对使用pctincrease以及有不同的initial和next的大小.我一直喜欢pctincrease=0,initial=next.一个本地管理表空间将有统一的区以保证这个潜规则.但是你使用字典管理的时候,你可以推翻这个规则.本地管理表空间完全避免了碎片,在本地管理表空间中,不大可能会有碎片
本地管理表空间比字典管理表空间在分配和释放区的时候要快很多
本地管理表空间减少了数据字典的争用
对于本地管理表空间,只有好处,没有坏处.————————————————————————————————————————
原文:
http://asktom.oracle.com/pls/ask … PLAYID:409670433426————————————————————————————————————————原文版权归属asktom.oracle.com所有，翻译 by gytyl•OracleDBA
2005-12-23
dbitye shprb said,
September 3, 2006 at 12:35 am
wqmbns gatyjuqnm kzmpt mfxk yxul xpwedjq glehabd
cshftb shfektlao said,
September 3, 2006 at 12:36 am
jxpek fqualhs ezft ieczqra cswdogh pusjdvt ndjpuk pdnaievro ifpjghum
jet ski rental said,
September 3, 2006 at 8:59 am
Nice site. Thank you!
jet ski rental
acorn slipper sock said,
September 3, 2006 at 2:02 pm
Very good site. Thank you.
acorn slipper sock
acorn slipper sock said,
September 5, 2006 at 9:26 am
Good site. Thanks:-)
acorn slipper sock
acorn-slipper-sock.rusdoor.com acorn slipper sock said,
September 5, 2006 at 10:00 am
Very good site. Thank you.
acorn-slipper-sock.rusdoor.com acorn slipper sock
Nice said,
October 18, 2006 at 3:37 pm
Nice look…
Nice…
Joshua said,
October 18, 2006 at 5:13 pm
Look good…
Weird enough for government work.
...
Hannah said,
October 18, 2006 at 6:24 pm
Readed…
It’s not a bug, it’s tradition!
...
Samantha said,
October 18, 2006 at 8:59 pm
Good news…
Yes, I’ve heard of “decaf.” What’s your point?
...
Samantha said,
October 18, 2006 at 9:20 pm
Yep…
Intel: where Quality is job number 0.9998782345!
...
Anthony said,
October 18, 2006 at 9:23 pm
Good news…
There’s no place like ~
...
Madison said,
October 18, 2006 at 9:41 pm
Nice…
Intel: where Quality is job number 0.9998782345!
...
Jacob said,
October 18, 2006 at 9:47 pm
Readed…
Secret hacker rule #11: hackers read manuals.
...
Jacob said,
October 18, 2006 at 9:49 pm
Beatifully…
To boldly go where I surely don’t belong.
...
Hannah said,
October 18, 2006 at 9:50 pm
Look good…
The dark ages were caused by the Y1K problem.
...
Samantha said,
October 20, 2006 at 10:48 pm
Yep…
0 and 1. Now what could be so hard about that?
...
Hannah said,
October 20, 2006 at 11:04 pm
Nice…
The dark ages were caused by the Y1K problem.
...
Isabella said,
October 21, 2006 at 12:16 am
Nice…
If Bill Gates had a dime for every time a Windows box crashed…
...Oh, wait a minute, he already does.
...
Ashley said,
October 21, 2006 at 1:25 am
Readed…
Where do you think you’re going today?
...
Emma said,
October 21, 2006 at 1:27 am
Beatifully…
There’s no place like ~
...
Isabella said,
October 22, 2006 at 8:35 am
Readed…
Secret hacker rule #11: hackers read manuals.
...
Daniel said,
October 22, 2006 at 12:26 pm
Yep…
The three Rs of Microsoft support: Retry, Reboot, Reinstall.
...
Daniel said,
October 22, 2006 at 12:53 pm
Smile…
“One world, one web, one program” —Microsoft promotional ad
“Ein Volk, ein Reich, ein Fuehrer” —Adolf Hitler
...
Daniel said,
October 22, 2006 at 12:59 pm
Smile…
Secret hacker rule #11: hackers read manuals.
...
Hannah said,
October 22, 2006 at 9:09 pm
Beatifully…
It’s not a bug, it’s tradition!
...
Christopher said,
October 22, 2006 at 9:39 pm
Look good…
...and that is how we know the Earth to be banana-shaped.
...
Emily said,
October 25, 2006 at 1:43 am
Look good…
I believe the technical term is “Oops!”
...
Andrew said,
October 25, 2006 at 2:02 am
Look good…
The computer revolution is over. The computers won.
...
Madison said,
October 25, 2006 at 2:40 am
Nice…
Yes, I’ve heard of “decaf.” What’s your point?
...
Abigail said,
October 25, 2006 at 5:38 am
Smile…
Loose bits sink chips.
...
Hannah said,
October 25, 2006 at 5:51 am
Smile…
Give a man a fish and you feed him for a day;
teach him to use the Net and he won’t bother you for weeks.
...
Samantha said,
October 25, 2006 at 8:42 am
Smile…
The computer revolution is over. The computers won.
...
Olivia said,
October 25, 2006 at 9:53 am
Beatifully…
The best things in life are free, but the
expensive ones are still worth a look.
...
Abigail said,
October 25, 2006 at 8:33 pm
Good news…
Speak softly and carry a cellular phone.
...
Christopher said,
October 25, 2006 at 8:51 pm
Yep…
“One world, one web, one program” —Microsoft promotional ad
“Ein Volk, ein Reich, ein Fuehrer” —Adolf Hitler
...
Ashley said,
October 25, 2006 at 10:56 pm
Nice…
...
Abigail said,
October 25, 2006 at 11:36 pm
Yep…
Failure is not an option. It comes bundled with your Microsoft product.
...
Matthew said,
October 26, 2006 at 7:08 am
Smile…
Actually, Microsoft is sort of a mixture between the Borg and the Ferengi.
...
Madison said,
October 26, 2006 at 7:11 am
Yep…
...
Abigail said,
October 26, 2006 at 7:56 am
Yep…
Intel: where Quality is job number 0.9998782345!
...
Emily said,
October 26, 2006 at 8:02 am
Smile…
Weird enough for government work.
...
Matthew said,
October 26, 2006 at 9:23 am
Beatifully…
Speak softly and carry a cellular phone.
...
Abigail said,
October 26, 2006 at 11:11 am
Beatifully…
There’s no place like ~
...
Jacob said,
October 26, 2006 at 11:25 am
Nice…
Secret hacker rule #11: hackers read manuals.
...
Michael said,
October 26, 2006 at 9:35 pm
Nice…
...and that is how we know the Earth to be banana-shaped.
...
Andrew said,
October 26, 2006 at 10:40 pm
Good news…
It is easier to fix Unix than to live with NT.
...
Samantha said,
October 26, 2006 at 10:57 pm
Smile…
Where do you think you’re going today?
...
Samantha said,
October 27, 2006 at 3:04 am
Beatifully…
It’s not a bug, it’s tradition!
...
Christopher said,
October 27, 2006 at 4:24 am
Good news…
Weird enough for government work.
...
Samantha said,
October 27, 2006 at 5:05 am
Yep…
The best things in life are free, but the
expensive ones are still worth a look.
...
Ashley said,
October 27, 2006 at 6:42 am
Good news…
Yes, I’ve heard of “decaf.” What’s your point?
...
Anthony said,
October 27, 2006 at 7:01 am
Nice…
The dark ages were caused by the Y1K problem.
...
Emily said,
October 27, 2006 at 7:15 am
Readed…
“One world, one web, one program” —Microsoft promotional ad
“Ein Volk, ein Reich, ein Fuehrer” —Adolf Hitler
...
Abigail said,
October 27, 2006 at 7:20 am
Good news…
It is easier to fix Unix than to live with NT.
...
Matthew said,
October 27, 2006 at 7:21 am
Readed…
It’s not a bug, it’s tradition!
...
Joshua said,
October 27, 2006 at 7:23 am
Good news…
Failure is not an option. It comes bundled with your Microsoft product.
...
Andrew said,
October 27, 2006 at 7:41 am
Look good…
To boldly go where I surely don’t belong.
...
Ethan said,
October 27, 2006 at 7:46 am
Smile…
Yes, I’ve heard of “decaf.” What’s your point?
...
Abigail said,
October 27, 2006 at 8:17 am
Good news…
Actually, Microsoft is sort of a mixture between the Borg and the Ferengi.
...
Hannah said,
October 27, 2006 at 9:25 am
Nice…
Yes, I’ve heard of “decaf.” What’s your point?
...
Michael said,
October 27, 2006 at 9:53 am
Nice…
There’s no place like ~
...
Joseph said,
October 27, 2006 at 9:53 am
Good news…
Yes, I’ve heard of “decaf.” What’s your point?
...
Samantha said,
October 27, 2006 at 10:14 am
Good news…
If Bill Gates had a dime for every time a Windows box crashed…
...Oh, wait a minute, he already does.
...
Anthony said,
October 27, 2006 at 11:03 am
Look good…
It is easier to fix Unix than to live with NT.
...
Joseph said,
October 27, 2006 at 11:12 am
Good news…
The three Rs of Microsoft support: Retry, Reboot, Reinstall.
...
Joseph said,
October 27, 2006 at 11:25 am
Smile…
To boldly go where I surely don’t belong.
...
Abigail said,
October 27, 2006 at 2:58 pm
Nice…
Actually, Microsoft is sort of a mixture between the Borg and the Ferengi.
...
Isabella said,
October 27, 2006 at 3:16 pm
Smile…
0 and 1. Now what could be so hard about that?
...
Christopher said,
October 27, 2006 at 3:32 pm
Smile…
I believe the technical term is “Oops!”
...
Andrew said,
October 27, 2006 at 3:47 pm
Look good…
I believe the technical term is “Oops!”
...
Emily said,
October 29, 2006 at 4:38 am
Look good…
Where do you think you’re going today?
...
Ethan said,
October 29, 2006 at 5:13 am
Look good…
To boldly go where I surely don’t belong.
...
Joseph said,
October 29, 2006 at 5:38 am
Yep…
Speak softly and carry a cellular phone.
...
Isabella said,
October 30, 2006 at 2:22 am
Readed…
The dark ages were caused by the Y1K problem.
...
Madison said,
October 30, 2006 at 3:36 am
Nice…
Where do you think you’re going today?
...
Samantha said,
October 30, 2006 at 3:43 am
Good news…
Press every key to continue.
...
Emily said,
October 30, 2006 at 4:08 am
Look good…
The computer revolution is over. The computers won.
...
Daniel said,
October 30, 2006 at 4:52 am
Good news…
Failure is not an option. It comes bundled with your Microsoft product.
...
Abigail said,
October 30, 2006 at 6:49 am
Nice…
Secret hacker rule #11: hackers read manuals.
...
Madison said,
October 30, 2006 at 4:33 pm
Smile…
Yes, I’ve heard of “decaf.” What’s your point?
...
Emma said,
October 30, 2006 at 4:42 pm
Readed…
It’s not a bug, it’s tradition!
...
Daniel said,
October 30, 2006 at 4:59 pm
Nice…
Failure is not an option. It comes bundled with your Microsoft product.
...
Ethan said,
October 30, 2006 at 5:14 pm
Good news…
I believe the technical term is “Oops!”
...
Daniel said,
October 30, 2006 at 5:34 pm
Readed…
Failure is not an option. It comes bundled with your Microsoft product.
...
Ashley said,
October 30, 2006 at 5:35 pm
Look good…
It is easier to fix Unix than to live with NT.
...
Michael said,
October 30, 2006 at 5:43 pm
Nice…
“One world, one web, one program” —Microsoft promotional ad
“Ein Volk, ein Reich, ein Fuehrer” —Adolf Hitler
...
Christopher said,
October 30, 2006 at 6:27 pm
Smile…
Secret hacker rule #11: hackers read manuals.
...
Ashley said,
October 30, 2006 at 8:36 pm
Beatifully…
Reboot America.
...
Madison said,
October 30, 2006 at 9:06 pm
Nice…
Failure is not an option. It comes bundled with your Microsoft product.
...
Olivia said,
October 30, 2006 at 9:19 pm
Nice…
Weird enough for government work.
...
Emily said,
October 30, 2006 at 9:22 pm
Nice…
I believe the technical term is “Oops!”
...
Hannah said,
October 30, 2006 at 9:32 pm
Smile…
...
Ethan said,
October 30, 2006 at 9:39 pm
Look good…
0 and 1. Now what could be so hard about that?
...
Daniel said,
October 30, 2006 at 9:40 pm
Nice…
The dark ages were caused by the Y1K problem.
...
Ashley said,
October 30, 2006 at 10:07 pm
Look good…
I believe the technical term is “Oops!”
...
Joseph said,
October 30, 2006 at 10:35 pm
Nice…
...
Jacob said,
October 31, 2006 at 12:55 am
Good news…
It’s not a bug, it’s tradition!
...
Samantha said,
October 31, 2006 at 12:58 am
Good news…
To boldly go where I surely don’t belong.
...
Samantha said,
October 31, 2006 at 1:06 am
Readed…
...
Isabella said,
October 31, 2006 at 1:17 am
Look good…
If Bill Gates had a dime for every time a Windows box crashed…
...Oh, wait a minute, he already does.
...
Michael said,
October 31, 2006 at 1:30 am
Good news…
If Bill Gates had a dime for every time a Windows box crashed…
...Oh, wait a minute, he already does.
...
Ethan said,
October 31, 2006 at 1:40 am
Readed…
Yes, I’ve heard of “decaf.” What’s your point?
...
Isabella said,
October 31, 2006 at 2:03 am
Readed…
The computer revolution is over. The computers won.
...
Joshua said,
October 31, 2006 at 2:41 am
Yep…
Reboot America.
...
Ethan said,
October 31, 2006 at 2:41 am
Yep…
There’s no place like ~
...
Abigail said,
October 31, 2006 at 3:04 am
Nice…
“One world, one web, one program” —Microsoft promotional ad
“Ein Volk, ein Reich, ein Fuehrer” —Adolf Hitler
...
Jacob said,
October 31, 2006 at 3:15 am
Look good…
Actually, Microsoft is sort of a mixture between the Borg and the Ferengi.
...
Joseph said,
October 31, 2006 at 11:44 am
Good news…
...
Madison said,
October 31, 2006 at 11:55 am
Readed…
It is easier to fix Unix than to live with NT.
...
Matthew said,
October 31, 2006 at 12:01 pm
Readed…
The computer revolution is over. The computers won.
...
Daniel said,
October 31, 2006 at 12:07 pm
Good news…
Loose bits sink chips.
...
Daniel said,
October 31, 2006 at 12:30 pm
Beatifully…
It is easier to fix Unix than to live with NT.
...
Ethan said,
October 31, 2006 at 12:40 pm
Readed…
To boldly go where I surely don’t belong.
...
Emily said,
October 31, 2006 at 1:11 pm
Look good…
Speak softly and carry a cellular phone.
...
Christopher said,
October 31, 2006 at 1:20 pm
Nice…
The best things in life are free, but the
expensive ones are still worth a look.
...
Anthony said,
October 31, 2006 at 1:24 pm
Good news…
Failure is not an option. It comes bundled with your Microsoft product.
...
Joseph said,
October 31, 2006 at 5:41 pm
Look good…
There’s no place like ~
...
Anthony said,
October 31, 2006 at 5:44 pm
Yep…
The three Rs of Microsoft support: Retry, Reboot, Reinstall.
...
Isabella said,
October 31, 2006 at 5:49 pm
Nice…
The computer revolution is over. The computers won.
...
Joseph said,
October 31, 2006 at 6:39 pm
Readed…
The computer revolution is over. The computers won.
...
Daniel said,
November 1, 2006 at 1:05 am
Look good…
...
Hannah said,
November 5, 2006 at 4:20 pm
Yep…
Give a man a fish and you feed him for a day;
teach him to use the Net and he won’t bother you for weeks.
...
域名主机 said,
March 28, 2007 at 6:51 pm
very good，study