This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / Oracle Developers, What tools do you use? PL/SQL Builder? PL/SQL Editer? or something else?
-xxu999(_);
2006-9-18
(#3213028@0)
-
i am learning also.... still think SQL Server is the best DataBase
-binghongcha76(一只大猫);
2006-9-18
(#3213200@0)
-
Well, it can't be running on UNIX :(
-xczheng(图图);
2006-9-18
(#3213653@0)
-
Well.....口的天真大啊。。。。
-hahaha_ly(咳....);
2006-9-21
(#3219303@0)
-
失礼失礼，正在苦学Oracle，不过觉得PL/SQL确实是不错，支持数组
-binghongcha76(一只大猫);
2006-9-21
(#3219857@0)
-
ORACLE的行级锁比其他DB领先，读取回滚段技术使得写操作不会阻塞读操作，也使得它的并发处理能力强出一截
-newkid(newkid);
2006-10-23
(#3279162@0)
-
并发更新，一致性会有问题吧。
-647i(流浪的步行万里);
2006-10-29
(#3292686@0)
-
不是很明白你的意思，你是说不应该有并发更新吗？
-newkid(newkid);
2006-10-30
(#3293181@0)
-
不见得，至少现在Oracle不敢再吹自己是最快的数据库。
-886xyz(cqcq);
2006-10-29
(#3292700@0)
-
硬件平台不一样。ORACLE的成绩是一年多前的。Server Information CPU Type: IBM POWER5+ 2.3GHz
Total # of Processors: 32
Total # of Cores: 64
Total # of Threads: 128
Cluster: N
VS
Server Information CPU Type: IBM POWER5 - 1.9 GHz
Total # of Processors: 16
Total # of Cores: 32
Total # of Threads: 64
Cluster: N
-newkid(newkid);
2006-10-30
{292}
(#3293167@0)
-
ORACLE 2005年的水平比DB2在2004年公布的的还差一半,做不到就是做不到,这和硬件，时间没关系。给你最新的硬件,软件上不去,也没办法.
-886xyz(cqcq);
2006-10-30
(#3293416@0)
-
来看看asktom上的说法
-newkid(newkid);
2006-10-30
{752}
(#3293629@0)
-
Tom是很牛，但他应该心里明白
-thisunreal(饭得志);
2006-10-30
{943}
(#3293668@0)
-
IBM使出它的独门暗器，ORACLE只有干瞪眼。按这位TOM的说法，目前ORACLE的优势还有：DB2自己在不同平台、版本之间不兼容；事务的读一致性实现得不好(Multi version concurrency control)
-newkid(newkid);
2006-10-30
(#3293762@0)
-
呵呵，刚才跑到asktom问了一贴，他说一个月后再来瞧瞧！看来oracle正在准备测试。他还建议看看历史数据（ORACLE都是后来居上?）
-newkid(newkid);
2006-10-30
(#3293880@0)
-
32位和64位的差别是巨大的?？？ 工业标准有偏向??? 所以ORACLE 比 DB2 跑得慢?我看了半天,没看出来ORACLE是跑在32位版, 麻烦哪位指点一下. 这也说不过去, ORACLE不知道64位快, 还是要显摆32位跑得慢? 虽败犹荣?
工业标准又不是IBM标准,怎么没听微软抱怨?
都是借口. 超过DB2才是真本事.
-886xyz(cqcq);
2006-10-30
{197}
(#3294216@0)
-
点击TPC页面上的system栏可看到硬件参数。为什么不跑64版？可能当时还没开发出来吧。为什么微软不抱怨？大概它对自己的成绩已经很满意了。ORACLE在对硬件调优这方面肯定要慢一拍。既然最近会有新结果，就让我们拭目以待。IBM的最新结果也只是实验室数据，System Availability不也要等到2006.12.20吗？
-newkid(newkid);
2006-10-30
{150}
(#3294424@0)
-
系统栏写的是处理器数, 内核数,线程数,微软的态度你也瞎猜.我对你这种忽悠的做法有点出离愤怒了!2001年的AIX 5.1就有64位kernel, Oracle2005年有没有64位版, 你可要说清楚.
-886xyz(cqcq);
2006-10-30
{70}
(#3294492@0)
-
老兄看来是个热血青年，请息怒！我充其量不过一O记粉丝，偶尔放放厥词又怎能当真？我对DB2可谓一无所知，不过在网上看到一说法还想请教：听说在一个SQL语句中，DB2不能保证扫描的第一行我最后一行都是同一时间点的数据？换句话说，若想计算账户总余额可能总是得不到正确结果，是真的吗？
-newkid(newkid);
2006-10-31
{189}
(#3294870@0)
-
是我看错了，ORCLE没说它是32位版，测试环境是32p即32 processors。报告是IBM提交的。32处理器和64处理器的差别难道不大？
-newkid(newkid);
2006-10-31
(#3294929@0)
-
we are running oracle 10g on 64bits Itanium. the performance is definitely much better, but have problems with cluster. I am going to 11g testing with Oracle team, see if 11g will make a difference.
-rawmoon(rawmoon);
2006-10-31
(#3294974@0)
-
NYSE and most of the big banks on Wall.St still use Sybase for most of their mission-critical system, why? 1. fast, 2. light-weight and easy to scale 3. low priceOracle and DB2 are powerful, but it costs much more to manage. MS SQL Server, the kernel is bought from Sybase and I will never recommend any database system only running on Windows Server.
-ubs(ubs);
2006-11-6
{189}
(#3306018@0)
-
You forgot to mention that there are a lot of projects on Wall St. that are migrating from Sybase to other bigger vendors. Sybase's market share is shredding.
-886xyz(cqcq);
2006-11-6
(#3306062@0)
-
这确实是事实。sybase的市场和发展策略部门都很糟糕，市场份额一天不如一天。但纯粹就performance/cost来说，我认为它是最好的。我现在公司应该算是sybase最大客户之一 (logic server > 15000)，3年前曾决定migrate到db2，到现在这个计划无疾而终，因为几乎大部分项目组都反对，先不算把海量的isql stored-procedure移植到pl/isql的巨大投入和风险，换平台对大部分application根本没有任何performance gain, license和管理的费用反而高不少.( oracle 更贵,不给我们site license)
-ubs(ubs);
2006-11-7
{372}
(#3308210@0)
-
这个算不算ORACLE的行级锁的劣势?
-886xyz(cqcq);
2006-11-6
(#3305985@0)
-
very interesting. I never notice that before. Anyway Oracle is aware of this behavior and it will be fixed someday.
-newkid(newkid);
2006-11-6
(#3306092@0)
-
能不能介绍一下write consistency in Oracle?How does it work if 1st transaction is deleteing parent table in a referential constraint while the 2nd transaction is inserting into a child table when the RI is defined as on delete cascade or on delete no action?
-886xyz(cqcq);
2006-11-6
{215}
(#3306244@0)
-
呵呵,MS的东西还是算了吧...我们公司现在最流行的一句话就是 Microsoft sucks....
-hard20(hard20);
2006-9-21
(#3220868@0)
-
PLSQL developer
-vetra(piyupiyu);
2006-9-21
(#3219148@0)
-
Any where can download for free? Thanks
-xxu999(_);
2006-9-21
(#3219274@0)
-
It is just a tool. Different company uses a different tool. There are too many similar tools outside. If you try to learn Oracle PL/SQL, you just need SQL*Plus.
-hahaha_ly(咳....);
2006-9-21
(#3219297@0)
-
我还只用UNIX下的sqlplus,我的同事惊呆了。我说，我不需要换手用鼠标
-vetra(piyupiyu);
2006-9-21
(#3220633@0)
-
TOAD
-ccra(ccra);
2006-9-21
(#3219305@0)
-
thanks.. i am using toad, so cool a software for Oracle
-binghongcha76(一只大猫);
2006-9-21
(#3220383@0)
-
TOAD是什么？
-wuyg719(wuyg719);
2006-10-30
(#3293624@0)
-
大家有什么好的PL/SQL编辑工具，介绍一下，Oracle自己带的太难用了
-binghongcha76(一只大猫);
2006-9-21
(#3219953@0)
-
俺以前一直用ULTRAEDIT。。。
-googleabcd(古狗);
2006-9-21
(#3220423@0)
-
ultraedit不错，支持多种语言高亮显示。也可以用Quest的产品。
-canadalabour(燒味);
2006-9-24
(#3226103@0)
-
ORACLE的免费工具SQL DEVELOPER 很好啊, WHY 太难用了?
-neemliu(四季如冬);
2006-10-29
(#3292712@0)
-
SQL*PLUS + Notepad
-mimier(mimier);
2006-10-20
(#3275433@0)
-
SQL*PLUS + vi
-polya(EasyWave);
2006-10-20
(#3275437@0)
-
on windows, toad, dbartisan. on unix, vi, sqsh.
-ubs(ubs);
2006-10-23
(#3279135@0)
-
ULTRAEDIT is cool for its column mode editing. I use TOAD to find compiler errors, and PL/SQL developer to test a returning cursor from a stored procedure
-newkid(newkid);
2006-10-23
(#3279154@0)
-
我喜欢TOAD的另一好处是可以把查询结果存成丰富的格式，包括文本，INSERT SCRIPT, EXCEL等。ORACLE自己开发的免费工具SQL DEVELOPER(RAPTOR)看起来也不错
-newkid(newkid);
2006-10-23
(#3279172@0)