• 博客访问: 96762
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02





发布时间:2005-06-14 16:04:35

Hi there,I am running Oracle 8.1.7 EE on SUN Solaris. I created two databasesSUGAR and TestDb (I need one to do some testing). Both are set remote_login_passwordfile = exclusive. The following shows how I had trouble to connect as SYSDBA. The big problem is that I cannot connect to TestDb as SYSDBA.$sqlplus /nologSQL> conn sys/change_on_install@testdbconnectedSQL> select * from v$pwfile_users;username sysdb sysop------------------------------internal true truesys ......【阅读全文】

阅读(11200) | 评论(0) | 转发(0)

发布时间:2005-06-07 09:03:21

Consistenet gets is based upon re-constructing a block for consistent read. Hence it is a function of only the number of db_blocks to be read. If you say that it is altered by the arraysize, do you suggest that, due to arraysize, some blocks are read muliple times and hence some blocks have > 1 consistent read in the process Thanks Followup: No, you are wrong in your statement. A consistent get is a block gotten in read consistent mode (point in time mode). It MAY......【阅读全文】

阅读(76577) | 评论(0) | 转发(0)

发布时间:2005-05-19 18:34:05

i have 8174 db.how can i know that i have the db buffer too small?thanks Followup: trick question.you have to first make sure your SQL is as good as it gets (reduce the number of LIO's your sql does). Then, you need to understand if a sql cache of any size can cache some percentage of your data (maybe it can, maybe it can't)Then you can look at ratio to see if you have a satisfactory hit.But basically, you want to look at what you system is waiting for. Not waiting on physical IO? then y......【阅读全文】

阅读(3813) | 评论(0) | 转发(0)

发布时间:2005-04-28 10:06:57

-- Thanks for the question regarding "DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS", version submitted on 28-Sep-2002 10:19 Eastern US time, last updated 27-Apr-2005 16:37You Asked Hi TomWhat's the difference between connections, sessions and processes?I read a note from Metalink about the difference but I simply dont get it!May you give a brief explanation?Thank you and we said...A process is a physical process or thread.On unix, you can se......【阅读全文】

阅读(12018) | 评论(0) | 转发(0)

发布时间:2005-04-27 23:26:45

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1993409963502Sudee -- Thanks for the question regarding "Calling Export from Pl/sql using C external proc.", version 8.1.6originally submitted on 16-Nov-2001 20:55 Eastern US time, last updated 27-Apr-2005 9:31You AskedHi Tom,Is there anything wrong with these steps,the exp does not create a .dmp file.Thanks #include <stdio.h> #include <stdlib.h> #include <string.h> __declspec(dllexport) v......【阅读全文】

阅读(40471) | 评论(0) | 转发(0)

jametong2014-06-27 16:58


回复  |  举报

登录 注册