-
编辑 删除
Oracle DBA 每天检查必备的sql（1）
1、检查表空间的剩余数SELECT tablespace_name, sum ( blocks ) as free_blk , trunc ( sum ( bytes ) /(1024*1024) ) as free_m, max( bytes ) / (1024) as big_chunk_k, count (*) as num_chunksFROM dba_free_space GROUP BY tablespace_nam2、check free, pct_free, and allocated space within a tablespaceSELECT tablespace_name, max_blocks, count_blocks, sum_free_blocks, to_char(100*sum_free_blocks/sum_alloc_blocks, '99.99') || '%'AS pct_free FROM ( SELECT tablespace_name, sum(blocks) AS sum_alloc_blocks FROM d
-
编辑 删除
Install Oracle10g Release2 on Fedora core 6
关键字: oracle10g fedora core参考文档:http://www.dizwell.com/prod/node/531、Fedora下安装所需的软件包在命令提示符下输入：rpm -q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc查看有没有安装还需安装libaio-0.3.106-2.2.i386.rpm和libXp包，命令为rpm -ivh libaio-0.3.106-2.2.i386.rpm2、准备工作(1)、创建oracle用户和dba组$ su - root#groupadd dba#groupadd oinstall#useradd -m oracle -g oinstall -G dba#mkdir /oracle#mkdir /oracle/10g#chown -R oracle:oinstall /oracle#mkdir /oso
