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

ORACLE ×ÊÔ´°üÏÂÔصØÖ·


oracle9iºÍ10gµÄÏÂÔصØÖ·
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk2.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk3.cpio.gz
Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk3.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX - Based 4.3.3 Systems (64-bit)
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk1.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk2.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk3.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk4.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-02.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-03.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-04.zip


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Oracle DBA£º±Ø±¸16´ó¼¼Äܺ;­µäÊé¼®»ã×Ü

Ò»¸ö³ÆÖ°µÄÊý¾Ý¿âDBA½ö½öÈ¡µÃORACLE³§¼ÒÈÏÖ¤ÊDz»¹»µÄ£¬¹Ø¼üÊÇÕæʵ»·¾³µÄÀúÁ·£¬±ÊÕß´ÓÊÂORACLE DBA¶àÄ꣬¾­ÀúORACLE°æ±¾´Ó8iµ½10g(×¢£º¶ÔÓÚÒ»¸ö¹«Ë¾»òµ¥Î»µÄÕæʵ»·¾³£¬¶ÔÓÚ°æ±¾µÄ×·ÇóÊ×ÒªµÄ£¬¹Ø¼üµÄÎȶ¨ÐÔ)£¬²Ù×÷ϵͳ´Ówindows µ¥»ú¡¢Ë«»úµ½Ö÷Á÷IBM¡¢HPµÄUNIX²Ù×÷ϵͳ£¬ÒÔÏÂÊDZÊÕ߶àÄê´ÓÊÂORACLE DBAµÄһЩÐĵã¬Ï£ÍûÄܸø³õÑ ......

¡¾×ª¡¿Oracle Êý¾Ý×ÖµäÊÓͼ(V$,GV$,X$)

³£Óõļ¸¸öÊý¾Ý×ֵ䣺
user_objects : ¼Ç¼ÁËÓû§µÄËùÓжÔÏ󣬰üº¬±í¡¢Ë÷Òý¡¢¹ý³Ì¡¢ÊÓͼµÈÐÅÏ¢£¬ÒÔ¼°´´½¨Ê±¼ä£¬×´Ì¬ÊÇ·ñÓÐЧµÈÐÅÏ¢£¬ÊÇ·ÇDBAÓû§µÄ´ó±¾Óª¡£ÏëÖªµÀ×Ô¼ºÓÐÄÄЩ¶ÔÏó£¬ÍùÕâÀï²é¡£
user_source :°üº¬ÁËϵͳÖжÔÏóµÄÔ­Â룬Èç´æ´¢¹ý³Ì£¬FUNCTION¡¢PROCEDURE¡¢PACKAGEµÈÐÅÏ¢
cat»òTab £º°üº¬µ±Ç°Óû§ËùÓеÄÓû§ºÍ ......

ORACLEµÄ±í·ÖÎö²ßÂÔ


¶Ô±í½øÐзÖÎö£¬Í¨³£Çé¿öÏ¿ÉÒÔ¶Ô±í£¬Ë÷Òý£¬ÁнøÐе¥¶À·ÖÎö£¬»òÕß½øÐÐ×éºÏ·ÖÎö£¬µ«ÕâÈýÕßÄÄЩÊÇÏà¶ÔÖØÒªµÄ£¬ÄÄЩ·ÖÎöÏԵò»ÄÇôÖØÒª£¿Í¨¹ý±¾ÆªÎÄÕµÄʵÑéÏàÐÅ´ó¼ÒÒ²»á¶ÔÖ±·½Í¼ÓиüÒ»²½µÄÁ˽â.
1.Ê×ÏÈ´´½¨²âÊÔ±í,²¢²åÈë100000ÌõÊý¾Ý
SQL> create table test(id number,nick varchar2(30));
Table created.
SQL> b ......

¡¾×ª¡¿oracle ¶¯Ì¬ÐÔÄÜ(V$)ÊÓͼ

C.1 ¶¯Ì¬ÐÔÄÜÊÓͼ
Oracle ·þÎñÆ÷°üÀ¨Ò»×é»ù´¡ÊÓͼ£¬ÕâЩÊÓͼÓÉ·þÎñÆ÷ά»¤£¬ÏµÍ³¹ÜÀíÔ±Óû§ SYS ¿ÉÒÔ
·ÃÎÊËüÃÇ¡£ÕâЩÊÓͼ±»³ÆΪ¶¯Ì¬ÐÔÄÜÊÓͼ£¬ÒòΪËüÃÇÔÚÊý¾Ý¿â´ò¿ªºÍʹÓÃʱ²»¶Ï½øÐиüУ¬
¶øÇÒËüÃǵÄÄÚÈÝÖ÷ÒªÓëÐÔÄÜÓйء£
ËäÈ»ÕâЩÊÓͼºÜÏñÆÕͨµÄÊý¾Ý¿â±í£¬µ«ËüÃDz»ÔÊÐíÓû§Ö±½Ó½øÐÐÐ޸ġ£ÕâЩÊÓͼÌṩ
ÄÚ²¿´ÅÅ̽ṹºÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ