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

oracle ֮ϵͳ±í µãµÎ »ýÀÛ

²é¿´ÕýÔÚÖ´ÐеÄsqlÓï¾ä
SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;
²¶×½ÔËÐкܾõÄSQL
 select username,sid,opname, round(sofar*100 / totalwork,0) || '%' as progress, time_remaining,sql_text from v$session_longops , v$sql where time_remaining <> 0 and sql_address = address and sql_hash_value = hash_value
Èç¹û¸ú×Ù×Ô¼ºµÄ»á»°»òÕßÊDZðÈ˵ĻỰ    
  [A]¸ú×Ù×Ô¼ºµÄ»á»°ºÜ¼òµ¥    
  Alter   session   set   sql_trace   true|false    
  Èç¹û¸ú×Ù±ðÈ˵ĻỰ£¬ÐèÒªµ÷ÓÃÒ»¸ö°ü    
  exec   dbms_system.set_sql_trace_in_session(sid,serial#,true|false)    
  or    
  exec   dbms_system.set_sql_trace_in_session(sid,serial#,8,’’)£¬ÕâÀïµÄ8ÊǸú×Ù¼¶±ð    
  ¸ú×ÙµÄÐÅÏ¢ÔÚuser_dump_dest   Ŀ¼Ï¿ÉÒÔÕÒµ½    
  ¿ÉÒÔͨ¹ýTkprofÀ´½âÎö¸ú×ÙÎļþ£¬Èç    
  Tkprof   Ô­Îļþ   Ä¿±êÎļþ   sys=n    
   
   
  ÔõôÉèÖÃÕû¸öÊý¾Ý¿âϵͳ¸ú×Ù    
  [A]ÆäʵÎĵµÉϵÄalter   system   set   sql_trace=trueÊDz»³É¹¦µÄ    
  µ«ÊÇ¿ÉÒÔͨ¹ýÉèÖÃʼþÀ´Íê³ÉÕâ¸ö¹¤×÷£¬×÷ÓÃÏàµÈ    
  alter   system   set   events    
      ‘10046   trace   name   context   forever,level   1’;    
  Èç¹û¹Ø±Õ¸ú×Ù£¬¿ÉÒÔÓÃÈçÏÂÓï¾ä    
  alter   system   set   events    
      ‘10046   trace   name   context   off’;    
  ÆäÖеÄlevel   1ÓëÉÏÃæµÄ8¶¼ÊǸú×Ù¼¶±ð    
  level   1£º¸ú×ÙSQLÓï¾ä£¬µÈÓÚsql_trace=true    
  level   4£º°üÀ¨±äÁ¿µÄÏêϸÐÅÏ¢    
  level   8£º°üÀ¨µÈ´ýʼþ   &n


Ïà¹ØÎĵµ£º

Oracle ÈçºÎ¶¨Òå×Ô¶¯ÔöÁ¿autocreamentµÄÖ÷¼üID?

MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
  ID           
INTEGER      ......

ORACLE 10 ѧϰ±Ê¼ÇÃüÁî µÚÒ»¿Î¡£(¸¶Ê×ê¿)

ORACLE 10 ѧϰ±Ê¼ÇÃüÁîµÚÒ»¿Î¡£
1.
sqlplus /nolog
connect /as sysdba
alter user scott account unlock;
alter user scott identified by manager;
2.
grant  select on dept to nmerp;
revoke select on dept to nmerp;
select * from scott.dept
create table abc(a varchar2(10),b char(10));
alter& ......

killtest ·ÖÏí×îеÄoracle 1z0 047Ìâ¿â×ÊÁÏÏÂÔØ

1z0-047 ×ÊÁϵÄ×îзÖÏí£¬ÏÂÃæһЩÌâÄ¿ÊÇ´Ó×îеÄÌâ¿âÖо«ÐÄÕûÀí³öÀ´µÄ£¬ÖÊÁ¿ºÜ¸ß£¬ÐèÒªµÄÅóÓÑ¿´¹ýÀ´µÄ°¡¡£
1. Which statements are true? (Choose all that apply.)
A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views can consist of joins of dictiona ......

ÔÚOracleÖÐʹÓÃ×Ô¶¯µÝÔöÁÐ

ÔÚOracleÖÐʹÓÃ×Ô¶¯µÝÔöÁÐ
Oracle 沒ÓÐ類ËÆ MS-SQL ¿ÉÒÔÖ±½ÓÐÞ¸Ä欄λ屬ÐÔ£¬設¶¨³É×Ô動編號欄룬ËùÒÔÎÒ們±Ø須͸過 Sequence Îï¼þµÄ nextval ·½·¨£¬È¡µÃÆäÏÂÒ»個Öµ£¬È»áá將´ËÖµÐÂÔöÖÁ TABLE ÖУ¬製Ôì³öÓÐ×Ô動編 ......

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ


²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 Î´ÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
 
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ¢£¬
IOPS£º66
¶ÁÈ¡£º90MB/s
дÈ룺82MB/s
 
² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ