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

oracle ´´½¨Óû§


oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢   linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼  
Æô¶¯    lsnrctl start
µÇ¼    sqplus /nolog
Á¬½ÓÊý¾Ý¿â    connect  /as   sysdba
Æô¶¯Êý¾Ý¿â    startup
¹Ø±ÕÊý¾Ý¿â    shutdown immediate
2¡¢   ÔÚÊý¾ÝÖд´½¨Óû§Ãû
Æô¶¯Êý¾Ý¿âºó´´½¨Óû§Ãû
Á¬½Ó³¬¼¶Óû§    connect system/admin    system ϵͳÓû§Ãû×Ö   admin ÃÜÂë
´´½¨Óû§Ãû×Ö    create user sha identified by admin   Óû§Ãû£º sha ÃÜÂë :admin
           ¿ÉÒÔд    Default tablespace user   // Ö¸¶¨´æ´¢¶ÔÏóʹÓõÄĬÈϿռä±í ĬÈÏÊÇ system
               Temporary tablespace temp; // ±£´æÁÙʱ¶ÔÏóËùʹÓõĿռä±í ĬÈÏÊÇ system
        ÉÏÃæµÄÁ©ÐУ¬¿ÉÒÔд ¿Õ¼ä±íΪ user ÁÙʱΪ temp £»²»Ð´¾ÍĬÈÏ
3¡¢   Ìí¼ÓÓû§µÄȨÏÞ
Grant ÊÇÊÚÓèȨÏÞµÄ È磺
     Grant create session to sha £» // ÊÚÓè sha Á¬½ÓÊý¾ÝµÄȨÏÞ
  ϵͳȨÏÞÈçÏ£º
ÏµÍ³ÌØÈ¨
ÔÊÐíÖ´ÐеIJÙ×÷
Create session
Á¬½ÓÊý¾Ý¿â
Create sequence
´´½¨ÐòÁÐ
Create synonym
´´½¨Í¬Ãû¶ÔÏó
Create table
´´½¨±í
Create any table
´´½¨ÈκÎģʽµÄ±í
Drop table
ɾ³ý±í
Create procedure
´´½¨´æ´¢¹ý³Ì
Execute any procedure
Ö´ÐÐÈκÎģʽµÄ´æ´¢¹ý³Ì
Create user
´´½¨Óû§
Create view
´´½¨ÊÓͼ
Drop user
ɾ³ýÓû§
Drop any table
ɾ³ýÈκÎģʽµÄ±í
4¡¢   ÏòÓû§ÊÚÓèÏµÍ³ÌØÈ¨
Grant execute any procedure to sha with admin option 
´Ë¾äÒâ˼ΪΪ sha Óû§´´½¨ÏµÍ³ÌØÈ¨²¢ÇÒ¿ÉÒÔÓà sha Ϊ±ðµÄÓû§ÊÚÓèȨÏÞ
Á¬½Ó sha Óû§   connect sha/admin
¿ÉÒÔ´´½¨±ðµÄÓû§
5 ¡¢²é¿´Óû§È¨ÏÞ
½øÈë sha Óû§ connect sha/admin
Select * from user_sys_privs; ¿ÉÒԲ鿴µ½Ò»¸öÁÐ±í£¬
Áдú±í Óû§Ãû ȨÏÞ ÊÇ·ñ¿ÉÒÔ¸ø±ðµÄÓû§¸½¼ÓȨÏÞ£¨ N ¡¢ Y £©  
Ðдú±í ȨÏÞ¶¼ÓÐÄÇЩ
6 ¡¢³·ÏúÓû§ÊÚÓèµÄȨÏÞ
±


Ïà¹ØÎĵµ£º

sqlserverÒÆÖ²ÎªOracle±Ê¼Ç

Oracle±Ê¼Ç
l         ¹ØÓÚTRUNCº¯Êý
   SELECT
   RELATED_ID ,
      DOC_ID ,
      CAT_ID ,
      CAT_CODE ,
      RELEASE_DATE ,
&n ......

oracleϵͳ±í²éѯ¡¾GBUnix¡¿

¡¾×ª¡¿http://www.gbunix.com/htmldata/2004_06/2/5/article_53_1.html
oracleϵͳ±í²éѯ¡¾GBUnix¡¿
 
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * fro ......

Oracle 10g StatisticÊý¾Ýͳ¼Æ


Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ´Ðз¾¶,Èç¹ûûÓÐ×ö¹ýͳ¼Æ£¬CBOÒ²¾ÍûÓÐ×öcostÆÀ¹ÀµÄÒÀ¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ