Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»´Îoracle supportµÄΣ»úÏÖ³¡´¦Àí£¨Ö®¶þ£©

ÌìÓв»²â·çÔÆ£¬
IBM µÄÖж˴ÅÅÌÕóÁÐÕâ´ÎÓÖÈÇ»öÁË¡£ÔÚ΢ÂëÉý¼¶µÄʱºò£¬
DS4800 ·¢Éú¹ÊÕÏ¡£µ¼Öµ±Ê±ÔÚÕą̂¿âÉϵļ¸Ì×Éú²ú¿â±¨´íÁË¡£
IBM¹¤³Ìʦ°ÑÕóÁйÊÕϻָ´ºó£¬ÅÄÅÄÆ¨¹É×ßÈË£¬ÕóÁÐÉϵÄÊý¾ÝÓÖµÃÎÒÃÇÀ´Ïë°ì·¨ÇÀ¾ÈÁË¡£¡£¡£¡£
»¹ºÃÓÐoracle supportµÄÖ§³ÖÎÒÃÇ×îÖÕ»¯½âÁËÕâ´ÎΣ»ú¡£ÏÂÎÄÏêϸ½éÉÜÁËÕû¸ö»Ö¸´µÄ¹ý³Ì¡£
oracle¹¤³Ìʦµ½´ïÏÖ³¡ºó£¬¸ù¾Ý´íÎóÐÅÏ¢£¬
|||||||||||||||||||||||||||||||||||||||||||||||||||||
´íÎóÐÅÏ¢ÈçÏÂËùʾ£º
Mon Apr 26 20:40:06 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/product/10.2.0/db/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =121
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 1000
  sessions                 = 1105
  sga_max_size             = 12884901888
  __shared_pool_size       = 5066719232
  __large_pool_size        = 16777216
  __java_pool_size         = 16777216
  __streams_pool_size      = 0
  sga_target               = 12884901888
  control_files            = /oradata/ccdev1/control01.ctl, /oradata/ccdev1/control02.ctl, /oradata/ccdev1/control03.ctl
  db_block_size            = 8192
  __db_cache_size    &nb


Ïà¹ØÎĵµ£º

OracleÓëMySQLÖС°¿É´®Ðл¯¡±µÄ¶Ô±È²âÊÔ

OracleÓëMySQLÖГ¿É´®Ðл¯”µÄ¶Ô±È²âÊÔ
      Thomas Kyte ÔÚ“Oracle 9i&10g±à³ÌÒÕÊõ”Ò»ÊéÖÐΪÁË˵Ã÷ÊÂÎñµÄ¸ôÀë¼¶±ð£¬ÌṩÁËһЩÀý×Ó¡£ÕâÀïÎÒÃÇÀ´¿´¿´“¿É´®Ðл¯”¼¶±ðϵıíÏÖ¡£
ÒÔÆÕͨÓû§µÇ¼ϵͳ£¬²¢´´½¨²âÊÔÓÃµÄ±í¡£
idle> connect scott/tiger ......

oracleÖÐjdbcÇý¶¯°üµÄ˵Ã÷

´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂÊ¹Ó ......

Sun & Oracle£¬ÑϾþµÄÌôÕ½£¨¶þ£©

      СÐÍ»ú·Ïߣ¬¼¸ºõÒѱ»·âËÀ¡£ÎÞ·¨Ê¹ÓÃSun£¬ËüÒѺÍOracle½ôÃܰ󶨣¬Èô»¹Ê¹ÓÃÉÏÊöÉè¼Æ£¬»áºÜÄÑ˵·þÊÛǰ½«Ð¡ÐÍ»ú¡¢´æ´¢¡¢Êý¾Ý¿â·Ö±ð´Ó²»Í¬³§É̲ɹº£»ÁíÍ⣬ÒàÎÞ·¨Ê¹ÓÃIBM£¬¾Ý˵FLYµÄij¸öÀϰ岻ϲ»¶¡£       ´óÁ¦ÍƽøÊý¾Ý¿âϵͳPC»¯£¬ÕâËÆºõÊÇ×î¼Ñ²ßÂÔ¡£FLYÓ¦ÓöÔÊý¾Ý ......

Oracle ×Ö¶ÎÀàÐÍ

ÔÚOracle¹ØÓÚʱ¼äÊôÐԵĽ¨±í
Example:
create table courses(
cid varchar(20) not null primary key,
cname varchar(20) not null,
ctype integer,
ctime date DEFAULT SYSDATE,
cscore float not null
)
insert into courses values('ss01','.NET',0,TO_DATE('2009-8-28','yyyy-mm-dd'),94)
insert into course ......

oracleɾ³ýËÀËøµÄsession

²é¿´Ëø±í½ø³ÌSQLÓï¾ä1£º
select sess.sid,
    sess.serial#,
    lo.oracle_username,
    lo.os_user_name,
    ao.object_name,
    lo.locked_mode
    from v$locked_object lo,
    dba_objects ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ