oracle¹¤¾ß»·¾³
SQLPlusÊÇoracleÌṩµÄÒ»¸öÃüÁîÐÐÖ´ÐеŤ¾ß
SQLPlusÖÐÓÃÁ½ÖÖÃüÁ
sqlplus£ºÒÔÃüÁîÐеķ½Ê½½øÈëÊý¾Ý¿âÁ¬½Ó
sqlplusw£ºÒÔ´°¿ÚµÄÐÎʽÆô¶¯ÃüÁîÐй¤¾ß ×¢£ºÖ÷»ú×Ö·û´®£¬ÊäÈëÊý¾Ý¿âÃû³Æ
sqlplusw»·¾³ÉèÖãº
ÉèÖÃÿÐÐÏÔʾ³¤¶È£ºset linesize ³¤¶È£»
ÉèÖÃÿҳÏÔʾ¼Ç¼µÄ³¤¶È£ºset pagesize ÐÐÊý£»
sqlplusw³£ÓÃÃüÁ
ed ÎļþÃû³Æ£ºÊ¹Óñ¾µØ¼Çʱ¾½øÐбà¼
@·¾¶£ºÖ´ÐÐÎļþÖеÄÃüÁî
conn Óû§Ãû/ÃÜÂë [AS SYSDBA|SYSOPER]:Á¬½ÓÊý¾Ý¿â
show user£ºÏÔʾµ±Ç°ÕýÔÚÁ¬½ÓµÄÓû§
/£º´Ó¸´ÖÆÖ´ÐÐÉÏÒ»ÌõÓï¾ä²Ù×÷
Ïà¹ØÎĵµ£º
Oracle SQL PLUS »ù±¾²Ù×÷1
怬
c:\>sqlplus "sys/test1234 as sysdba" ÒÔsysdbaÉí·ÝµÇ¼
c:\>sqlplus/nolog ÒÔnologÉí·ÝµÇ¼
sql> connect sys/test1234 as sysdba
Connected.
Æô¶¯
SQL> startup &nb ......
²»´íµÄ×ÊÁÏ,ת¹ýÀ´,·½±ãÈÕºó²é¿´Ê¹ÓÃ!!!
--¼à¿ØË÷ÒýÊÇ·ñʹÓÃ
alter index &index_name monitoring usage;
alter index &index_name nomonitoring usage;
select * from v$object_usage where index_name =
&index_name;
--ÇóÊý¾ÝÎļþµÄI/O·Ö²¼
select
df.name,phyrds,phywrts,phyblkrd,phyblkwrt,sin ......
SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æСÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ» ......
´ó¼Ò¶¼ÖªµÀ£¬ÓÃPL/SQLÁ¬½ÓOracle£¬ÊÇÐèÒª°²×°Oracle¿Í»§¶ËÈí¼þµÄ¡£ÓÐûҪÏë¹ý²»°²×°Oracle¿Í»§¶ËÖ±½ÓÁ¬½ÓOracleÄØ£¿
ÆäʵÎÒÒ»Ö±ÏëÕâÑù×ö£¬ÒòΪÕâ¸ö¿Í»§¶ËʵÔÚÌ«ÈÃÈËÌÖÑáÁË£¡£¡£¡²»µ«»á°²×°Ò»¸öJDK£¬¶øÇÒ»¹»á°Ñ×Ô¼º·ÅÔÚ»·¾³±äÁ¿µÄ×îÇ°Ã棬»áÔì³É²»Ð¡µÄÂé·³¡£
&n ......
º¯Êý£º
1.ʹÓÃCreate Function Óï¾ä´´½¨
2.Óï
·¨£º
Create or replace Function º¯ÊýÃû[²ÎÊýÁбí]
Return Êý¾ÝÀàÐÍ
IS|AS
¾Ö²¿±äÁ¿
Be ......