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

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cmd
sqlplus /nolog
connection /as sysdba
select instance_name,host_name,thread#,status from v$instance
Àý³Ì±êʾ£¬Ö÷»úÃû£¬±êʾÖØ×éÏ̺߳Š£¬±êʾÀý³Ì״̬
ÖØÐÂ×°ÔØ
startup force


Êý¾Ý¿âºÍ¼àÌý¶¼ÖØÆôÒ»ÏÂ


Ïà¹ØÎÊ´ð£º

.netµ÷ÓÃOracle´æ´¢¹ý³ÌµÄÖØÔØÎÊÌâ

Oracle´æ´¢¹ý³ÌÈçÏÂ,ÓÃÓαêÊä³ö½á¹û:
procedure proc_xcxf_detail(v_sbh varchar2,
                          v_szpq varchar2,
&nbs ......

Çë½Ì¹ØÓÚoracleµÄ×Ô¶¨Ò庯ÊýµÄÎÊÌâ

create or replace function GetWorkBeginTime()
  return date is
  myDate    date;
begin
  myDate := trunc(sysdate-1)+8/24;
  return myDate;
end;

......

OracleÎÊ´ðÌâ,´ð¶ÔÓзÖ,²»¶ÔÓйÄÀø·Ö

ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØϵʱµÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩

    1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÓÐʲôÊéÊǽ²¹ØÓÚOracleµÄЧÂʵÄ

´ó¼ÒÍƼöÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´

Database Performance Tuning Guide and Reference

oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ