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

OracleÊý¾Ý¿âΪʲô±äÂýÁË£¿

±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ü¸±¶£¬ÓеijÌÐòÉõÖÁÖ´Ðкó£¬Ò»Ö±´¦ÓڵȴýµÄ״̬£¬ÎÞ·¨ÔËÐУ¡
ƾ×Ô¼ºµÄÖ±¾õ£¬³öÏÖÕâÖÖÎÊÌ⣬һ°ãÊÇϵͳÖгöÏÖÁËʲôÒì³£µÄ³ÌÐò£¬ÓÚÊÇÂíÉÏÓÃpsÃüÁî²éÕÒ£¬µ«ÊÇûÓз¢ÏÖÈκηǷ¨µÄ³ÌÐò£¬Ò²Ã»ÓкڿÍÈëÇֵļ£Ïó¡£ÄÇÊDz»ÊDz¡¶¾µÄÔ­ÒòÄØ£¿Õâ¸öÏë·¨ÔÚÄÔ×ÓÀïÒ»ÉÁ¡£¶Ô£¬ÓпÉÄÜ,UNIXϵͳÖв»ÊÇûÓв¡¶¾µÄ£¡µ«ÕâÖÖ¼¸ÂÊ·¢ÉúµÄÇé¿öÒ»°ã±È½ÏÉÙ¡£ÓÚÊÇ×Ô¼ºÂíÉÏtopÃüÁ̬²é¿´ÏµÍ³×ÊÔ´µÄʹÓÃÇé¿ö£¨¿ÉÒÔÉèÖÃtopÃüÁîµÄË¢ÐÂÂÊΪ1Ã룬²¢Ö»¼à¿ØOracleÓû§¼´Êý¾Ý¿âµÄ½ø³Ì£©£¬ÔÚSolarisϵͳÔËÐÐÃüÁîÌáʾ·ûºó¼üÈëtop»Ø³µ,È»ºóÉèÖÃtopÃüÁîµÄË¢ÐÂÂÊΪ1Ã룬¾ßÌå²Ù×÷·½·¨£ºµ±topÃüÁîÔËÐкó£¬ÇüüÅÌs¼ü£¬ÔÚÌáʾÐÅÏ¢ºóÃæÔÙÇüüÅ̵ÄÊý×Ö¼ü1ºó»Ø³µ¼´¿É£»ÔÙÉèÖÃtopÃüÁîÖ»¼à¿ØOracleÓû§µÄ½ø³Ì£¬¾ßÌå²Ù×÷·½·¨£ºµ±topÃüÁîÔËÐкó£¬ÇüüÅÌu¼ü£¬ÔÚÌáʾÐÅÏ¢ºóÔÙÇÃÈëOracle£¬È»ºó»Ø³µ¼´¿É¡£
Õâʱϵͳ½ø³ÌµÄÔËÐÐÇé¿ö»áÈçÏÂͼËùʾ£º
ÓÚÊÇÎÒ×Ðϸ²é¿´ÉÏÃæµÄµÄÔËÐнá¹û£¬¹ûÈ»ÓÐÁËÒ»¸öÖØ´óµÄ·¢ÏÖ£¬ÔÚÉÏÃæµÄͼÏñÖпÉÒԲ쿴µ½ÏµÍ³Ò»Ö±ÕýÔÚÔËÐÐµÄ 6028 ½ø³Ì£¨Í¼ÖÐ×óÁеĵÚÒ»¸öPID£©£¬·¢Ïִ˽ø³Ìռϵͳ×ÊÔ´±È½Ï´ó£¨CPUʹÓÃÂÊΪ49.41%£©£¬ÏµÍ³CPUÏÐÖÃ×ÊԴΪ0.0%,Õâ¸ö³ÌÐò¶Ô·þÎñÆ÷¶¼×÷ÁËʲôÄØ£¬ÎªÊ²Ã´µ¼ÖÂÕû¸öϵͳµÄCPU×ÊÔ´¶¼ºÄ¾¡ÁË£¿
´ø×ÅÕâ¸öÎÊÌâÓÖµ½ÍøÉÏ×ÐϸµÄ²éÁËһЩ×ÊÁÏ£¬¹¦·ò²»¸ºÓÐÐÄÈË£¬ÖÕÓÚ´ÓһЩÎÄÕÂÖлñÖª¿ÉÄÜÊÇÓÉÓÚÊý¾Ý¿âÕýÔÚÖ´ÐеÄij¸öSQLÓï¾ä¶ÔÓдóÁ¿¼Ç¼µÄÊý¾Ý±í²Ù×÷ÒýÆðµÄ¡£ÎªÁ˽øÒ»²½Ö¤Êµ£¬ÎÒÓÃSQLÓï¾ä½øÐвéѯ£¬ÒÔsystemÓû§µÇ½SQL*Plus£¬Ö´ÐÐÃüÁîÈçÏ£º
$ su -l oracle
$ sqlplus system/manager
SQL> select sql_text from v$sql
2  where address in (
3 select sql_address from v$session where sid in (
4 select sid from v$session where paddr in (
5 select addr from v$process where spid=6028)))£»
È»ºó»áÏÔʾÐÅÏ¢£º
SQL_TEXT
select bbsid,motherid,authorid,authorip,bbsdate,bbscontent,authortype,
discussed from BK_BBS where motherid=122983 order by bbsdate
¼ÌÐøÓÃÏÂÃæµÄÓï¾ä¶ÔÉÏÃæÐÅÏ¢ÖеÄBK_BBS±í½øÐвéѯ£¨×¢Ò


Ïà¹ØÎĵµ£º

Oracle Cursor

 1£¬Ê²Ã´ÊÇÓαꣿ
 ¢Ù´Ó±íÖмìË÷³ö½á¹û¼¯£¬´ÓÖÐÿ´ÎÖ¸ÏòÒ»Ìõ¼Ç¼½øÐн»»¥µÄ»úÖÆ¡£
   
 ¢Ú¹ØϵÊý¾Ý¿âÖеIJÙ×÷ÊÇÔÚÍêÕûµÄÐм¯ºÏÉÏÖ´Ðеġ£
  ÓÉ SELECT Óï¾ä·µ»ØµÄÐм¯ºÏ°üÀ¨Âú×ã¸ÃÓï¾äµÄ WHERE ×Ó¾äËùÁÐÌõ¼þµÄËùÓÐÐС£ÓɸÃÓï¾ä·µ»ØÍêÕûµÄÐм¯ºÏ½Ð×ö½á¹û¼¯¡£
   &n ......

Oracle Rman¿çresetlogs°æ±¾»Ö¸´

RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......

oracle 10 em

Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾ­Æô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME/install/pro ......

ÈçºÎ´ÓÍêºÃµÄÊý¾ÝÎļþ»Ö¸´oracleÊý¾Ý¿â

Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷ÖØ×°Á˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹ûÖØ×°µÄoracleºÍÒÔÇ°Ë𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
    1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔ­Êý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ