数据库管理在NT下与UNIX下异同有多大？

ntxy

如果不太熟悉UNIX，先学习LINUX是各不错的选择。

在电信、金融等大型企业级应用中，还是用的HPUX、IBMAIX
SUN这些服务器，LINUX用的很少

zlmei

Hi:

From my limited experience, I have used Sun Solaris, HP, Digital Unix, RH Linux, W2k, NT with Oracle 7.3, 8.0, 8i and 9i, I found that I much prefer Unix (or Linux) than NT. Not only the performance but also it's actually easier to manage the database. You can run cron job and shell scripts very easily. All the production DB I have worked on are on Unix. Linux and NT are only for development purpose, basically like a toy to play with.  It seems (by reading posts here) that most people use OEM and some other GUI tools to do DBA work, I would suggest people to use sqlplus to learn all the commands. If you really want to learn Unix, Linux is a good place to start. Using vi and sqlplus, you should be able to take care of any Oracle database problems.

Guang

gangang

我的亲身经历：
在SUN E4500（4*550MHz，8G mem) 装ORACLE817用30分钟
在LINUX RH7.1(Celeon 1.2G,256M mem)装ORACLE817用15分钟。

当然二者不见得有可比性。但应当承认INTEL平台的进步。SUN SPARC已经落后了。当然，机器的性能不仅仅是CPU决定的。SUN，IBM，HP的专有系统目前还会有一定的优势，但无疑在缩小。我相信IA64(或者其他什么CPU)一统天下是趋势。

chwchw

最初由 zlmei 发布
[B]Hi:

From my limited experience, I have used Sun Solaris, HP, Digital Unix, RH Linux, W2k, NT with Oracle 7.3, 8.0, 8i and 9i, I found that I much prefer Unix (or Linux) than NT. Not only the performance but also it's actually easier to manage the database. You can run cron job and shell scripts very easily. All the production DB I have worked on are on Unix. Linux and NT are only for development purpose, basically like a toy to play with.  It seems (by reading posts here) that most people use OEM and some other GUI tools to do DBA work, I would suggest people to use sqlplus to learn all the commands. If you really want to learn Unix, Linux is a good place to start. Using vi and sqlplus, you should be able to take care of any Oracle database problems.

Guang [/B]

您说得很不错，不过一般常用命令使用名令行是没问题，但有些复杂的dba工作是需要使用图形界面来辅助的，比如性能调试，压力测试时监控系统随时间变化的情况，表空间的各种状况，这些显然图形界面更能做到一目了然。不知你有没有同感？

Fenng

最初由 gangang 发布
[B]我的亲身经历：
在SUN E4500（4*550MHz，8G mem) 装ORACLE817用30分钟
在LINUX RH7.1(Celeon 1.2G,256M mem)装ORACLE817用15分钟。
[/B]

安装的速度能看出来什么呢？如果你的光驱不是同速度的，差别当然很大了，现在Sun的服务器一般都是DVD光驱，而Intel平台的光驱速度可以有52速的

chao_ping

最初由 Fenng 发布
[B]

安装的速度能看出来什么呢？如果你的光驱不是同速度的，差别当然很大了，现在Sun的服务器一般都是DVD光驱，而Intel平台的光驱速度可以有52速的 [/B]

不争的事实是，在中低端市场，Intel构架的确实超过了Unix平台。类似的配置，性能上Intel的确超过Risc。性能价格比更是远远超过。

zlmei

Sorry, my computer can only use English.

About "chwchw" comments:

Yes, GUI sometimes helps DBA. But what you see from GUI are actually the results from some sql running, the application just display them as "Graphics". To tune the database or application, you can use "Explain Plan", query some "wait" tables, use "statpack" (?),  look at sqls with most buffer_gets and disk_reads, make sure index are created properly, etc. So far I have not seen anything that GUI can do but sqlplus can not (except Universal Installer).

About "chao_ping" comments about Linux and Sun:

You can not compare recent Linux with old Sun box. Also software installation is only done once. To compare, one should run some kind of identical application and do timing measurements. Yes, middle-to-low-end application can use Linux, but any middle or high end application are on unix's.

As far as Microsoft PC: show me some Microsoft machines that running in the past 12 monthes without a reboot, I will be impressed. Our unix boxes routinelly run more than one year without reboot. We only bring it down if we need to install new OS or install new version of Oracle Software.

Guang

quicksand

fjdskfjdslfjsalkjfqoidoafjslkdfjoiwqejfdsjfksdfjwiefjkdslfjwoiefjsdkjflskjfdoewioewfjldskfjls

hotian

旁听高手讲话，长知识

lxhit

最初由 hotian 发布
[B]旁听高手讲话，长知识 [/B]

同感啊