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
Ïà¹ØÎĵµ£º
MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
ID
INTEGER ......
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& ......
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 沒ÓÐ類ËÆ MS-SQL ¿ÉÒÔÖ±½ÓÐÞ¸Ä欄λ屬ÐÔ£¬設¶¨³É×Ô動編號欄룬ËùÒÔÎÒ們±Ø須͸過 Sequence Îï¼þµÄ nextval ·½·¨£¬È¡µÃÆäÏÂÒ»個Öµ£¬È»áá將´ËÖµÐÂÔöÖÁ TABLE ÖУ¬製Ôì³öÓÐ×Ô動編 ......
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
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
² ......