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

oracle ÈÕÆÚÏÔʾӢÎĸñʽ

     ÎÒÃdzõѧÕß°²×°oracleµÄʱºò£¬×Ö·û¼¯Ñ¡ÔñµÄÒ»°ãÊǼòÌåÖÐÎĵĸñʽ£¬Õâ·½±ãÎÒÃÇÓ¢ÎIJ»ºÃµÄ²ËÄñ£¬³ö´íµÄʱºò¶¨Î»´íÎ󣬵«ÊÇÓÐÒ»¸öÎÊÌâ°éËæ³öÏÖ£¬ÎÒÃÇд¹ØÓÚÈÕÆÚµÄsqlµÄÓï¾ä£¬ÎÒÃÇÏëÒªÓ¢ÎĵĸñʽÔõô°ì£¿ÏÂÃæÓÐÁ½¸ö°ì·¨£º
1. Á¬½Óµ½Êý¾Ý¿âºó£¬ÎÒÃÇʹÓÃÈçÏÂÓï¾ä
  ALTER SESSION SET NLS_DATE_LANGUAGE='AMERICAN'   ÐèҪעÒâµÄÊÇ£¬¶Ï¿ªÊý¾Ý¿âÁ¬½Óºó£¬×Ö·û¼¯»á»¹Ô­µ½Ä¬ÈÏÖÐÎÄ×Ö·û¼¯
2.ÎÒÃǶ¨ÒåÈÕÆÚ¸ñʽµÄʱºò£¬Ò²¿ÉÒÔÀûÓÃÓï¾äʹÓÃÓ¢Îĸñʽ£¬µ«ÊÇ×÷Ó÷¶Î§½öÏÞÓÚ±¾Ìõ¶¨Òå¡£
È磺  to_char('18-dec-2009','dd-mon-yyyy','nls_date_language=american')


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracle ÈÕÖ¾Îļþ´íÎóµÄ´¦Àí¡£

ת×Ô£ºhttp://hi.baidu.com/dashuaiwang/blog/item/47cc680ec35055c37acbe1f8.html
´ò¿ªoracle Êý¾Ý¿âʱ³öÏÖÁË´íÎó:
ORA-00313: ÎÞ·¨´ò¿ªÈÕÖ¾×é 1 (Ïß³Ì 1) µÄ³ÉÔ±
ORA-00312: Áª»úÈÕÖ¾ 1 Ïß³Ì 1: 'D:\ORACLE\ORADATA\GOCOM\REDO01.LOG'
SQL> connect / as sysdba;
ÒÑÁ¬½Ó¡£
SQL> shutdown immediate;
ORA- ......

ORACLE JOBS

Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......

Oracle ERPϵ統½è´û¹Øϵ±í

ϵͳ·Ö²½Öè²úÉúµÄ·Ö¼£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº £¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
2£©¿â´æÄ£¿é×÷¼ìÑéÈë¿âʱ²úÉúµÄ·Ö¼Ϊ£º
ϵͳ²úÉúµÄ·Ö¼·Ö±ðΪ£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥Ê ......

Oracle 10.1 Statistics

Oracle 10.1 Statistics£º
In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics
The following table shows the 106 statistics that were added in Oracle 10.1:
 
Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ