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





发布时间: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......【阅读全文】

阅读(12019) | 评论(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......【阅读全文】

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

发布时间:2005-04-27 08:39:12

Nag -- Thanks for the question regarding "sql to get data from flat file-- this is mind blowing", version 8.1.7originally submitted on 12-Oct-2001 19:26 Eastern US time, last updated 26-Apr-2005 20:08You Asked "In 9i, with the addition of external tables ( the ability to query a FLAT FILE with SQL) -- SQLLDR might be "moot". Using the external table and the insert /*+ append */ I can basically do a direct path load from file to database without running a command......【阅读全文】

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

发布时间:2005-04-27 00:58:48

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:25685777038588in general your query won't get the "next n rows".Why would you not just:select /*+ FIRST_ROWS */ * from ( select /*+ FIRST_ROWS */ a.*, rownum rnum from (select /*+ FIRST_ROWS */ * from t where .... order by ... ) a where rownum <= :MAX_ROW ) where rnum >= :MIN_ROW;done. that is how I write all pagination queries.(you do know that A||B has serious programming issues -- A=1, B=11......【阅读全文】

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

发布时间:2005-04-26 07:41:32

The purpose of this document is to provide an easy to use, step by step guide to resolving ORA-04031 errors. Contents: 1. Instance parameters related with the Shared Pool2. Diagnosing ORA-04031 errors3. Resolving error ORA-04031    * Known Oracle BUGs    * ORA-4031 when compiling Java code    * Small shared pool size          o Library Cache Hit Ratio        ......【阅读全文】

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

jametong2014-06-27 16:58


回复  |  举报

登录 注册