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

Oracle ·þÎñ½ø³Ì ¼òµ¥½éÉÜ

Oracle ·þÎñ½ø³Ì-¼òµ¥½éÉÜ
ÒÔOrcale10gµÄ°æ±¾ÎªÀý£¬¼òµ¥½éÉÜÏÂOracleµÄ·þÎñ½ø³Ì£¨Windows°æ±¾£© -ganlan¡£
 
1¡¢OracleCSService
  ½ø³Ì£ºocssd.exe
½éÉÜ£ºCluster Synchronization Services (CSS)—Manages the cluster configuration by controlling which nodes are members of the cluster and by notifying members when a node joins or leaves the cluster. If you are using third-party clusterware, then the css process interfaces with your clusterware to manage node membership information.
 Google·­Ò룺¼¯ÈºÍ¬²½·þÎñ£¨css£©-¹ÜÀí¼¯ÈºÅäÖã¬Í¨¹ý¿ØÖƽڵ㣬ÆäÖеijÉÔ±¼¯ÈººÍ֪ͨ³ÉÔ±µ±Ò»¸ö½Úµã¼ÓÈë»òÀ뿪¼¯Èº¡£Èç¹ûÄúÕýÔÚʹÓõÚÈý·½µ³clusterware£¬ÄÇôcssµÄ¹ý³ÌÖеĽçÃæÓëÄúclusterware¹ÜÀí½Úµã³ÉÔ±µÄÐÅÏ¢¡£
 
2¡¢OracleDBConsoleorcl
½ø³Ì£ºnmesrvc.exe
½éÉÜ£ºoem¿ØÖÆÌ¨·þÎñ½ø³Ì£¬dbaÓá£Oracle Enterprise Manager(OracleÆóÒµ¹ÜÀíÆ÷,¼ò³ÆOEM)ÊÇͨ¹ýÒ»×éOracle³ÌÐò£¬Îª¹ÜÀí·Ö²¼Ê½»·¾³ÌṩÁ˹ÜÀí·þÎñ¡£OEM°üÀ¨ÁËÒ»×éDBA¹¤¾ß£¬Ò»¸örepository£¬ÒÔ¼°Ò»¸öͼÐλ¯ÏÔʾµÄ¿ØÖÆÌ¨¡£OEM¿ØÖÆÌ¨Óëÿһ¸ö·þÎñÆ÷ÉϵÄÖÇÄÜ»¯´úÀí(IntelligentAgent)Ïà¶ÔÓ¦¡£
 
3¡¢OracleJobSchedulerORCL
½ø³Ì£ºextjob.exe
½éÉÜ£º¶¨Ê±Æ÷
 
4¡¢OracleOraDb10g_home1iSQL*Plus
½ø³Ì£ºisqlplussvc.exe
½éÉÜ£ºisql*plusµÄ·þÎñ½ø³Ì£¬SQL*PlusÊÇOracleÌṩµÄÒ»¸ö¹¤¾ß³ÌÐò£¬Ëü²»½ö¿ÉÒÔÓÃÓÚÔËÐУ¬µ÷ÊÔSQLÓï¾äºÍPL/SQL¿é£¬¶øÇÒÓÃÓÚ¹ÜÀíOracleÊý¾Ý¿â¡£
 
5¡¢OracleOraDb10g_home1SNMPPeerEncapsulator
½ø³Ì£ºENCSVC.EXE
½éÉÜ£ºagentͨѶÓÃ
 
6¡¢OracleOraDb10g_home1SNMPPeerMasterAgent
½ø³Ì£ºAGNTSVC.EXE
½éÉÜ£ºagentͨѶÓÃ
 
7¡¢OracleOraDb10g_home1TNSListener
½ø³Ì£ºTNSLSNR
½éÉÜ£º¼àÌýÆ÷µÄ·þÎñ½ø³Ì
 
8¡¢OracleServiceORCL
½ø³Ì£ºORACLE.EXE
½éÉÜ£ºÊý¾Ý¿â·þÎñ½ø³Ì
 
°²×°ÍêOracle10gÒÔºó£¬Ò»Ï·þÎñÊÇϵͳĬÈÏ×Ô¶¯Æô¶¯µÄ£º
OracleCSService
OracleDBConsoleorcl
OracleOraDb10g_home1iSQL*Plus
OracleServiceORCL
OracleOraDb10g_home1TNSListener


Ïà¹ØÎĵµ£º

Oracle´´½¨±í¿Õ¼ä¡¢´´½¨Óû§ÒÔ¼°ÊÚȨ¡¢²é¿´È¨ÏÞ

´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING
DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TE ......

oracle10g SQL ¸ú×Ù

1.¼¤»îSQL¸ú×Ù
   ´Óoracle10gÒÔºóÌṩÁËÐµķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
   ֮ǰ¾É·½·¨ÊÇʹÓà alter session set events ..  »òÕßʹÓÃdbms_system.set_ev·½Ê½
   ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......

C#½«¿ÕÖµ´«Èëµ½Oracle×Ö¶ÎÀàÐÍΪDatatimeµÄ×Ö¶Î

½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾­¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í) ......

oracle´æ´¢¹ý³ÌÓï·¨

´æ´¢¹ý³Ì °üº¬Èý²¿·Ö£º ÉùÃ÷£¬Ö´Ðв¿·Ö£¬Òì³£¡£    
¿ÉÒÔÓÐÎÞ²ÎÊý³ÌÐòºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£    
Î޲γÌÐòÓï·¨    
1 create or replace procedure NoParPro   
2 as   ;   
3 begin   
4&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ