oracle Òƶ¯¸ßˮλ£º
²é¿´±íµÄ´óС£»
select a.blocks,a.bytes,a.bytes/1024/1024 from user_segments a
where a.segment_name='B_M_DZYH_CUST_SIGN_FACT';
Ê×ÏÈ
create table TEST_1228 as select * from user_tables;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
commit;
²é¿´±íµÄ¿Õ¼ä´óС:¼Ç¼Ϊ1
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
ɾ³ý±í
delete from TEST_1228 ;
commit;
²é¿´±íµÄ¿Õ¼ä´óС:¼Ç¼Ϊ2
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
Òƶ¯¸ßˮλ£º
alter table TEST_1228 enable row movement
alter table TEST_1228 shrink space
²é¿´±íµÄ¿Õ¼ä´óС:¼Ç¼Ϊ3
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
¶Ô±È1£¬2£¬3½á¹û£¬¼´¿É
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
&nb ......
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
1¡¢Óû§£º
¡¡select username from dba_users;
¸Ä¿ÚÁî
¡¡alter user spgroup identified by spgtest;
2¡¢±í¿Õ¼ä£º
¡¡select * from dba_data_files;
¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡select tablespace_name,sum(bytes), sum(blocks)
from dba_free_s ......
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
......