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

oracleµÄÄÚ´æ½á¹¹

Êý¾Ý¿âµÄÄÚ´æ½á¹¹£º
    Memory structures are allocated to the Oracle instance when the instance is started.
The two major memory structures are known as the System Global Area(Also called the shared
Global Area)and the Program Global Area(also called the Private Global Area or the Process
Global Area)
SGA:
 The System Global Area(SGA) is a shared memory area.All users of the database share the
 information maintained in this area.The SGA and the backgroud processes constitute an Oracle instance.Oracle allocates memory for the SGA when an Oracle instance is started and de-allocates it when the istance is shut down.The information stored in the SGA is divided into multiple memory structures that are allocated fixed space when the instance started.
     DATABASE Buffer Cache:
     The database buffer cache is the area of memory that caches the database area,holding blocks
from the data files that have been read recently.The DB buffer cache is shared among all the users connected to the database.
     There are three type of buffers.
     Dirty buffers:Dirty buffers are the buffer blocks that need to be written to the data files.
The data in these buffers has changed and has not yet been written ti the disk.
      Free buffers :Free buffers do not contain any data or are free to be overwritten.When Oracle reads data from disk,free buffers are used to hold this area.
      Pinned buffers :Pinned buffers are the ones that are currently being accessed or explicityly  retained for futer use.(for example,the KEEP buffer)
      Oracle maintains two lists to manage the buffer cache,The write list(dirty buffer list) has the buffers that are modified and need to be written to the disk(the dirty buffers).
      The least recently used(LRU) list contains fr


Ïà¹ØÎĵµ£º

Oracle·ÖÒ³²éѯÓï¾ä


·ÖÒ³²éѯ¸ñʽ£º
SELECT * from 
(
SELECT A.*, ROWNUM RN 
from (SELECT * from TABLE_NAME) A 
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐз­Ò³µÄԭʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN >= 21¿ØÖÆ·ÖÒ³²éѯµÄÿҳµÄ·¶Î§¡£
ÉÏÃæ¸ø³öµÄÕâ¸ö·ÖÒ ......

oracle¸ù¾ÝÍâ¼üÃû²é¹ØÁªµÄ±í

1¡¢²éÕÒ±íµÄËùÓÐË÷Òý£¨°üÀ¨Ë÷ÒýÃû£¬ÀàÐÍ£¬¹¹³ÉÁУ©£º
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = Òª²éѯµÄ±í
2¡¢²éÕÒ±íµÄÖ÷¼ü£¨°üÀ¨Ãû³Æ£¬¹¹³ÉÁУ©£º
select cu.* from user_cons_columns cu, user_constr ......

oracleͬÒå´Ê

Ï൱ÓÚalias(±ðÃû),±ÈÈç°Ñuser1.table1ÔÚuser2Öн¨Ò»¸öͬÒå´Êtable1
create synonym table1 for user1.table1;
ÕâÑùµ±ÄãÔÚuser2Öвéselect * from table1ʱ¾ÍÏ൱ÓÚ²éselect * from user1.table1;
Óŵã×Ô¼º×ܽá°É¡£
ÀýÈ磺
ÔÚoracleÖжÔÓû§µÄ¹ÜÀíÊÇʹÓÃȨÏ޵ķ½Ê½À´¹ÜÀíµÄ£¬Ò²¾ÍÊÇ˵£¬Èç¹ûÎÒÃÇÏëʹÓÃÊý¾Ý¿â£¬ÎÒà ......

oracleµÄÂß¼­½á¹¹ºÍÎïÀí½á¹¹

1¡¢Êý¾Ý¿âµÄÂß¼­½á¹¹ºÍÎïÀí½á¹¹£º
   Oracle logically divides the database into a smaller units to manage ,store,and retreive
data efficently.
  Tablespace\Blocks\Extents\segment\
ÓÐËÄÖÖsegment:
data segment¡¢Index segment¡¢Temporay segment¡¢Rollback Segment
temporary segment:
Ar ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ