ORACLE SGAÖ®Êý¾Ý»º³åÇø£¨Data Buffer£©
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐøרÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³£ÓõÄÊÓͼ£º
X$BH¡¢GV$BH¡¢V$BH¡¢V$FIXED_TABLE¡¢V$FIXED_VIEW_DEFINITION¡¢DICT¡¢DICT_COLUMNS¡£
ÒÔ¼°Á½¸ö°ü£ºDBMS_SPACE ºÍ DBMS_ROWIDµÄһЩ³£ÓÃÄÚÈÝ£¬ÔÚºóÃæ»áÖð½¥Óõ½Ê±ËµÃ÷²¿·ÖʹÓ÷½Ê½£¬²»¹ý»¹ÊÇÏÈÒª´´½¨Ò»¸ö±í£¬²»È»Ê²Ã´²âÊÔ¹¤×÷Ò²×ö²»ÁË£º
ÔÚÒ»¸öÓû§Ï´´½¨Ò»¸ö±í£º
CREATE TABLE TEST_OBJECTS
AS SELECT * from USER_OBJECTS;
Èç¹ûÄǸöÓû§ÏÂûÓÐʲô¶ÔÏó£¬ÄǾͶิÖƼ¸´ÎÊý¾Ý£¬²ÅÄÜÌî³äһЩÊý¾Ý£¬Êý¾Ý³É±¶Ôö³¤£º
INSERT INTO TEST_OBJECTS
SELECT * from TEST_OBJECTS;
COMMIT;
´ËʱµÚÒ»¸ö£¬³£¹æʹÓÃÏ£¬Ò»¸ö³£ÓõĶÔÏó¾ÍÊÇROWID£¬ÄÇô¿´ÏÂËüÓÉÄļ¸²¿·Ö×é³É£º
¶ÔÏó±àºÅ¡¢Îļþ±àºÅ¡¢ÎļþÄÚ¿éºÅ¡¢¿éÄÚ²¿ÐкÅÂ룬ÎÒÃÇ¿´ÏÂÒ»ÕűíÄÚ²¿Ã¿ÌõÊý¾ÝµÄÕâЩÐÅÏ¢£º
SQL>SELECT dbms_rowid.rowid_relative_fno(ROWID) "Îļþ±àºÅ",
dbms_rowid.rowid_object(ROWID) "¶ÔÏó±àºÅ",
dbms_rowid.rowid_block_number(ROWID) "¿é±àºÅ",
dbms_rowid.rowid_row_number(ROWID) "¿éÄÚ²¿ÐкÅÂë"
from TEST_OBJECTS t;
Îļþ±àºÅ ¶ÔÏó±àºÅ ¿é±àºÅ ¿éÄÚ²¿ÐкÅÂë
---------- ---------- ---------- ------------
4 54646 588 0
4 54646 588 1
4 54646 588  
Ïà¹ØÎĵµ£º
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£¨×ªÌû£©
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora
Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
  ......
ÎÒÏë×î³õѧϰÊý¾Ý¿âʱ¶¼ÊÇÒÔstudent±í¡¢course±íºÍsc±íΪÀýµÄ°É
Ê×ÏÈ´´½¨ÕâÈýÕÅ±í£º±ØҪʱ¿ÉÖØд´½¨Óû§¼°ÃÜÂë²¢µÇ½
»·¾³£ºoracle 10g
declare
vcnt number;
begin
select count(*) into vcnt from user_tables where table_name='SC';
If vcnt = 1 Then
Execute immedi ......
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
Oracle RAC Workload Management:
service usage preferred instances available instances prority response time warning/critical
ERP &nb ......