Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Oracle Internal
Home
+ new post
Pages
Files
About this group
Join this group
11G service_name说明
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   2 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
mophe  
View profile   Translate to Translated (View Original)
 More options Aug 14, 2:03 am
From: "mophe" <m...@tydic.com>
Date: Fri, 14 Aug 2009 14:03:16 +0800
Local: Fri, Aug 14 2009 2:03 am
Subject: 11G service_name说明
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

各位大虾：
现在BI这块趋势一般就是多台PC SERVER+ ASM +廉价RAID存储
比如TAOBAO用了12个节点的RAC加ASM加存储  几十TB
亚玛迅用到16个节点的RAC后面加ASM加存储  200多TB

BI或者数据仓库这块，ORACLE也提供了exadata来解决，据说是比传统的提高20倍速度。但成本太高。104TB的加ORACLE软件+HP硬件+L ICENSE等要2300万。exdata需要在11.0.1.7以后的版本支持。

同时还有green plum来比较。green plum类似于DB2。

我说的和这些没关系，呵呵。只是我想问下，
比如8个NODE的ORACLE RAC，我一条SQL语句过来，最终是不是还是落实到1个NODE上来执行了？
听说是 新增service_name，每个service_name对应4个instance(4 node)，那么客户端执行这条SQL语句，如果指定了这个service_name以后，是不是ORACLE就自动的将这条SQL分配到4个instance 上去执行？利用4个node的带宽和处理能力？
最终反馈一个结果通过service_name给客户端？

如果是的，那10G和11G的service_name是否都是可以做到？
还是说11G配置的service_name才能做到，10G不行？

莫波  Mophe
技术支持部/部门经理
深圳天源迪科信息技术股份有限公司
Tel：+86-755-26745728
Mobile：+86-139-2459-1993
邮箱： m...@tydic.com
网址： www.tydic.com
深圳市高新技术产业园区南区南七道T3大厦B三层
邮编：518057


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
zong yongchun  
View profile   Translate to Translated (View Original)
 More options Aug 14, 2:53 am
From: zong yongchun <zongyongc...@gmail.com>
Date: Fri, 14 Aug 2009 14:53:51 +0800
Local: Fri, Aug 14 2009 2:53 am
Subject: Re: 11G service_name说明
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

Mophe大虾：
不知道我是否正确理解了你的问题，普通的SQL即使使用了 Service_name 最终也只是由一个 Instance
应答，利用 Service_name 主要是利用了 RAC 的 HA 的特性。如果你需要用到多个 Instance 的资源，那么使用
并行+ Service_name 好了。
这是我的理解，仅供参考。

“exdata需要在11.0.1.7以后的版本支持”？
我不知道这个信息，但 Exdata 本身据说的确是 11.0.1.7 的版本。

2009/8/14 mophe <m...@tydic.com>


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google