oracleÖÐblock
°´×ÊÁÏ˵V$BH²é¿´±íÀ´ÏÔʾÊý¾Ý¿âÀïÿ¸ö¶ÔÏóÀàÐ͵ÄÊý¾Ý»º³åÇøÀïÊý¾Ý¿éµÄÊýÁ¿.
È»ºó²éѯV$bh
select
owner, object_name
from
dba_objects o,
v$bh bh
where
o.object_id = bh.objd
and
o.owner =MOBILEADC
ÕâÒ»²éÕÒ³ö MOBILEADC Óû§´´½¨µÄ¶ÔÏó Êý¾Ý¿éµÄÏà¹ØÐÅÏ¢
Ò²¿ÉÒÔ²éѯ±íµÄÊý¾Ý¿ìµÄÐÅÏ¢
select
owner, object_name
from
dba_objects o,
v$bh bh
where
o.object_id = bh.objd
and
o.object_name =’NN_APPLICATION’;
v$BHÖÐÓиö״̬
The possible values of X$BH.STATUS are:
0, FREE, no valid block image
1, XCUR, a current mode block, exclusive to this instance
2, SCUR, a current mode block, shared with other instances
3, CR, a consistent read (stale) block image
4, READ, buffer is reserved for a block being read from disk
5, MREC, a block in media recovery mode
6, IREC, a block in instance (crash) recovery mode
¿ÉÒÔ²éѯ±í¿Õ¼äµÄ¿ì´óС
select tablespace_name,block_size from dba_tablespaces;
ÔÚ°²×°Êý¾Ý¿âµÄʱºòÎÒÃǽ«db_block_sizeÕâ¸ödefault block sizeÉèÖóÉÁË8k£¬ÄÇôÔÚ°²×°ÒÔºóOracleÊDz»ÔÊÐíÎÒÃÇÐÞ¸ÄĬÈÏ¿é´óСµÄ¡£¶ÔÓÚÒ»¸ö8196×Ö½Ú´óСµÄÊý¾Ý¿éÒ»°ãblock overhead»áÕ¼¾ÝÆäÖÐ100¸ö×óÓÒµÄ×Ö½Ú£¬ÄÇôʣϵÄ8096×ֽڵĿռä¾ÍÓÃÀ´´æ´¢ÎÒÃǵÄÐÐÊý¾Ý¿â£¬Èç¹ûÎÒÃDzåÈë1¸ö×Ö½ÚµÄÐÐÊý¾Ý£¬ÄÇôÕâ¸ö¿éÊÇ·ñ»áÔÊÐíÎÒÃDzåÈë8096ÐÐÄØ£¿´ð°¸µ±È»ÊÇ·ñ¶¨µÄ¡£ÆäʵÅ
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
//¿´¿´ÈçºÎ±àдһЩ¸´ÔӵĴ洢¹ý³Ì
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ΪÁËÑéÖ¤£¬ÎÒÏÈ´´½¨Ò»ÕŲâÊÔ±í
create table mytest(myid varchar2(30),myname varchar2(50));
´æ´¢¹ý³ÌΪ£º
create or replace PROCEDURE mytest2(id in varchar2,name in varchar2) as
begin
insert into mytest (myid,myname) valu ......
1.OracleDBConsoleorcl oem¿ØÖÆ̨µÄ·þÎñ½ø³Ì
2.OracleJobSchedulerORCL ¶¨Ê±Æ÷µÄ·þÎñ½ø³Ì
3.OracleOraDb10g_home1iSQL*Plus isql*plusµÄ·þÎñ½ø³Ì
4.OracleOraDb10g_home1TNSListener ¼àÌýÆ÷µÄ·þÎñ½ø³Ì
5.Or ......
oracle Ô¼ÊøµÄ״̬
oracleÔÚ´´½¨Ô¼ÊøºóĬÈÏ״̬ÊÇenabled VALIDATED
SQL> create table T2
2 (
3 VID NUMBER,
4 VNAME VARCHAR2(10) not null,
5 VSEX VARCHAR2(10) not null
6 )
7 /
Table created
SQL> alter table t2 add constraints PK_T primary key (vid); ......