d******e 发帖数: 2265 | 1 thank you, I will install it soon |
|
q*z 发帖数: 14 | 2 每秒大约200 个 'Insert ',每个也就几十个byte的数据, CPU
usage 就超过90%了!再多反映就有明显延迟了。这是到了极限了吗
?
偶用的是 DELL Server, PIII 600, Win2k Server, Oracle 8i
自己写的 ADO program. |
|
w*******g 发帖数: 51 | 3 It is not free downloadable from oracle or sun's site. |
|
h****r 发帖数: 2056 | 4 Use JDBC to insert record to Oracle 8i, only 40 inserts per
second, it
is too slow, does some one know how to improve the
performance of insert
and query?
I already use the connection pool and "not auto commit"
features.
Thanks a lot! |
|
h****r 发帖数: 2056 | 5 want porting my application from NT to Solaris,
on NT, I link Microsoft Visual Studio/VC98/Lib/ODBC32.LIB to
provide the
odbc 3.0 API, what is the corresponding lib I should use on
Solaris(Both NT
and solaris I installed oracle 8i)?
Thanks a lot! |
|
c*****t 发帖数: 5 | 6 any place can I find e-books on oracle 8i database
administration, application development, system architecture
etc., some handbook, guidebook? |
|
a**w 发帖数: 11 | 7 Better try 9i about this.
作中提到: 】 |
|
w*r 发帖数: 2421 | 8 oracle 8i personal is not compatible with WinME.
It is reported to the oracle. I think you might need to try
win98 or win2k |
|
h****r 发帖数: 2056 | 9 Hi,
How can i connect to a Oracle 8i database using ASP(DSN less connection).
Kindly help me.
Thank you in advance. |
|
r*********t 发帖数: 4 | 10
so your Oracle would be for study purpose? I think it'll live
fine with 256M under Linux, you can download 8i from their website.
The installation is a bit tricky on Redhat7.1/7.2 but I finally
get it up and run. as to Lite, it's more of another DB than
a simplified Oracle and it's not true RDBMS if I recall correctly. |
|
l*****k 发帖数: 587 | 11 installed Oracle 8i on my win2k, but can't start the
oracle management server service... it tells me this didn't return
an error... blabla, i don't even know what the problem is...
please help, anyone encountered this problem? (I created a repository
already...).
Thanks |
|
s******n 发帖数: 2 | 12 That's right, experience is more important than certifications.
The reason I took certifications is just because I am too lazy to study
anything new so I have to register the test and then I can finish a book in
one week which I can't finish in one year normally.
When I go to interview, nobody look at my certifications (even I have ocp dba
7.3, 8, 8i, now I have 9i, developer 2000, 6i, solaris scsa 7, 8, scna 8),
they only care what kind of projects I have done.
YI JIA ZHI YAN.
fools) |
|
f**y 发帖数: 138 | 13 I tried 8i in RedHat before. It was a bit clumsy because the instruction
requested me to recompile the linux kernel.
How about 9i? Does it still need to recompile the kernel? |
|
|
m**h 发帖数: 22 | 15 it is driving me nuts...
Oracle Enterprise Edition 8i
以前在win2k下可以用(btw,机器是用modem的, 不知道对host有没有影响)
现在在winXP下用, 新建一个database, system/scott都可以用
可是重新启动机器, TNSListener started 正常, OracleServiceDatabasename
始终就在那儿"starting". SQL plus 进不去.
check了listener.ora, TNSNames.ora, services.ora似乎都没什么问题
也用database configuration assistant, Net8 configrate assistant试了
把机器格式化重装还是这样
把那个database删了, 重新建一个, start, stop, restart都好好的, sql plus
也好好的, 可是一重启机器, 它又在那儿"starting"...
有谁遇见过这样的情况吗? 帮帮我呀, 多谢! |
|
t********k 发帖数: 808 | 16 我的系统是2000 advance server
我的机器名是daniel
用Net 8 Assistant配置的服务名是orahome
那在database profile内是不是这样配置?
SQLCA.DBMS = "O84 Oracle8/8i (8.x.4+)"
SQLCA.LogPass = <*****>
SQLCA.ServerName = "orahome"
SQLCA.LogId = "scott"
SQLCA.AutoCommit = False
SQLCA.DBParm = "" |
|
s****d 发帖数: 13 | 17 OCPs that are already certified in version 7.3, 8.0 or 8i of the Oracle
database do not have to meet this requirement in order to upgrade their
credential to Oracle 9i.
class
the
2002**). |
|
a****c 发帖数: 25 | 18 Is it for OCP 9i? From my understanding, you can either take it at home or
wherever you can access the internet. I took it at test center two years ago
for 8i. Anyway, good luck!
go |
|
l*****k 发帖数: 587 | 19 I installed oracle 8i but in the oem, I can't see instance manager?
should I install more package? it is weird. I logged in as sysman
//bow |
|
w*********o 发帖数: 15 | 20 I tried to install oracle 9i or oracle 8i ,but whenever i clicked setup.exe
there is no response.
i use windows XP for my system
how can i solve it?
thanks |
|
l*****k 发帖数: 587 | 21 PIV has a problem with 8i, in that you can't install it, I finally have
to do with 9i. It is because the CPU doesn't support the java engine or
something like that...
you probably are facing the same problem. I searched google and found
a solution, however, it didn't work well for me. |
|
m******g 发帖数: 91 | 22 calm down.. I think 9i is much much better than 8i for installation
on Linux.
You'd better check it out what real problem is.
ps: don't know if it is true the GUI needs some GNOME libraries. ie,
you 'd better install it under GNOME or any Xwindow if you've GNOME installed |
|
s***m 发帖数: 28 | 23 Try to check your ../../ctx/lib/ins_ctx.mk file. In 8i version, this makefile
is defective. The line "CTXHX_LINKLINE=$(LINK) $(CTXLIB)ctxhx.$(OBJ_EXT)
$(INSO_LINK) $(USRLIBS)" is missing a "-ldl" option.
Good Luck
install.
wrong
了。
在那个
选择 |
|
k**e 发帖数: 86 | 24 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: kyte (芦荻), 信区: Java
标 题: 巨量数据读取问题求助
发信站: Unknown Space - 未名空间 (Fri Sep 12 06:05:29 2003) WWW-POST
数据库: ORACLE 8i
开发语言: JAVA 1.3
当一个TABLE中的行数非常大时, 由于内存问题所有内容不能一次读出来, 要用JAVA开发
的UI去编辑(ADD, UPDATE, DELETE)这个表中的内容, 应该如何实现呢? |
|
a********r 发帖数: 28 | 25 谁能介绍一本学Oracle 8i/9i的书?
我原来懂一点,但只能说是皮毛
现在想学得精通一点
先谢谢了!
br />
br /> |
|
B*******e 发帖数: 3882 | 26 学习的话, 装个 8i 就够了
数据库换代的慢, 不像个人操作系统 |
|
j**i 发帖数: 419 | 27
9i is better than 8i, why do you need 1G memory?
I installed it on machines with 500M ,runs OK. |
|
s****e 发帖数: 68 | 28 Oracle 8i environment. I am not familiar with Oracle.
I guess it is not a difficult problem. Any help will
be really appreciated, thx in advance.
just know a field name, want to know which taable it locates
in a big Oracle database. |
|
s*******e 发帖数: 151 | 29 My friend had a DBA interivew question to ask me, but I do not know how to
help her.
An 8.0.6 database is being hit very hard with transactions that do not utilize
bind variables. The shared pool is set to 300MB. Intermittently, users are
unable to connect to the database. What specific actions would you take in
this situation?
Does sb know the answer? thanks a lot! |
|
c*****d 发帖数: 6045 | 30 不知道这道题目想考那方面的知识?
1. increase the shared_pool_size
2. modify cursor_sharing
3. query v$session and v$process
4. restart db
utilize |
|
s*******e 发帖数: 151 | 31 我也不知道。 应该是和bind variables有关吧。 我就没有用过oracle8, 所以 想问这里
高人的意见。
are
in |
|
s*****c 发帖数: 24 | 32 Cursor sharing should be the key.
1st: verify the shared pool memory usage: most used by cursors
2nd: set cursor_sharing to force
3rd: restart the database or (alter system set and flush shared pool)
The purpose to use force is that the optimzer will the following cursors
SELECT * FROM user_names WHERE name='Jeff' AND county = 'Butler';
SELECT * FROM user_names WHERE name='Melody' AND county = 'Butler';
as one cursor with system generated bind variables:
SELECT * FROM user_names WHERE name=:SY |
|
s*******e 发帖数: 151 | 33 yes, I am quite sure the database is 8.0.6. anyway, thanks a lot for your
answer.
这
how
users
take |
|
p*******i 发帖数: 2 | 34 I 'm going to upgrade my DBA certificate from 8i to 10g. I'm interested in
buying or renting the book '#1z1-045 Oracle Database 10g:New features for
Oracle8i OCP '. If you are interested, please re to my mail. Appreciate. |
|
k**e 发帖数: 86 | 35 I try to do some manipulation with the input INFILE file name for some of the
columns in Oracle SQL Loader. Is there any keyword or internal variable in 8i
to get this filename? |
|
c*****d 发帖数: 6045 | 36 11g没搞过,8i/9g/10g 512M我都玩过,没问题 |
|
c*****d 发帖数: 6045 | 37 在Oracle 8i,9i里面,肯定有影响
没有statistic,engine无法决定cost,只能用rbo |
|
c*****d 发帖数: 6045 | 38 oracle现在想钱想疯了
我现在还是8i的ocp,没钱升级呀 |
|
h******e 发帖数: 150 | 39 这是COMMON SENSE ,还需要查吗?十年前查8I的DOCUMENT好象就有这方面的说明.
那论坛废贴一堆. |
|
g***l 发帖数: 18555 | 40 Sorry,只玩过8I,不知道有没有DECIMAL什么的,有的数据类型可能还不一样,不行就
搞个TESTDB先倒出来,然后再LOAD进TARGET DB,建个SSIS的PACKAGE, SCHEDULE个JOB
吧,REPLICATION好像理论上能做,没经验,看到一个这样做的
you can replicate datas from Oracle to MSSQL or SQL Server.
1) You can create triggers, so that the datas will be directly transferred
to MSSQL/SQL Server. Use ABDC (that is a package in Oracle). With ADBC you
are able to connect against the slaves and update/insert/delete the datas
directly.
That will be something like a just in time replication.
2) You can... 阅读全帖 |
|
|
a9 发帖数: 21638 | 42 join难道不是标准sql里的吗?8i不支持? |
|
B*****g 发帖数: 34098 | 43 Oracle Webinar hosted by CINAOUG on July 18, 2011
The Chinese in North America Oracle User Group (CINAOUG) will host a webinar
on Monday, July 18, 2011 featuring Tingda Lu, who will talk about Oracle da
tabase architecture and its main components. Before Mr. Lu's presentation, w
ebinar attendees are invited to participate in an interactive discussion on
how Oracle users should deal with the changing IT environment like June's we
binar.
When: 8:20pm - 9:40pm, Eastern Time, Monday, July 18, 2011
W... 阅读全帖 |
|
B*****g 发帖数: 34098 | 44 1998: Oracle 8i is released (the i stands for Internet).
2000: Oracle 9i and Application Server is released
2004: Oracle 10g is released (the g stands for Grid).
2007: Oracle 11g is released
Oracle 12g?? 2011?? |
|
|
|
c*****d 发帖数: 6045 | 47 这个问题是标准题,不偏
oracle 8i/9i升级10g考试里也有这个题目 |
|
d****n 发帖数: 12461 | 48 oracle有两条路,dba和开发。搞开发的其实所有的rdbms都是相通的。说搞数据库的如
果没见过三种不同类型以上5种产品以上的,都不好意思啊。
这是某个程序员自己写的
http://blog.csdn.net/liuyifeng_510/article/details/6412788
“下面我19年来使用过的数据库:
• dBase/FoxBase/FoxPro in the DOS/Novell/Windows 3.x world
• MS SQL Server (6.5,7.0,2000,2005 and 2008)
• Oracle (7, 8/8i,9i,10g)
• Sybase SQL/ASE Servers (4.9.2, 10, 11, 11.9.2, 12/12.5, 15.x)
• Sybase IQ 12.6/12.7
• Informix/Dynamic (6, 7)
• MySQL (4, 5/5.1)
• PostGreSQL (8.3.5)/Enterpri... 阅读全帖 |
|
d****n 发帖数: 12461 | 49 oracle有两条路,dba和开发。搞开发的其实所有的rdbms都是相通的。说搞数据库的如
果没见过三种不同类型以上5种产品以上的,都不好意思啊。
这是某个程序员自己写的
http://blog.csdn.net/liuyifeng_510/article/details/6412788
“下面我19年来使用过的数据库:
• dBase/FoxBase/FoxPro in the DOS/Novell/Windows 3.x world
• MS SQL Server (6.5,7.0,2000,2005 and 2008)
• Oracle (7, 8/8i,9i,10g)
• Sybase SQL/ASE Servers (4.9.2, 10, 11, 11.9.2, 12/12.5, 15.x)
• Sybase IQ 12.6/12.7
• Informix/Dynamic (6, 7)
• MySQL (4, 5/5.1)
• PostGreSQL (8.3.5)/Enterpri... 阅读全帖 |
|
t**t 发帖数: 27760 | 50 1 Jaguar - Cray XT5-HE Opteron Six Core 2.6 GHz
2 Roadrunner - BladeCenter QS22/LS21 Cluster, PowerXCell 8i 3.2 Ghz / Optero
n DC 1.8 GHz, Voltaire Infiniband
3 Kraken XT5 - Cray XT5-HE Opteron Six Core 2.6 GHz
4 JUGENE - Blue Gene/P Solution
5 Tianhe-1 - NUDT TH-1 Cluster, Xeon E5540/E5450, ATI Radeon HD 4870, Infini
band
6 Pleiades - SGI Altix ICE 8200EX, Xeon QC 3.0 GHz/Nehalem EP 2.93 Ghz
7 BlueGene/L - eServer Blue Gene Solution
8 Blue Gene/P Solution
9 Ranger - SunBlade x6420, Opteron QC 2 |
|