在清理了大量无用对象后, 原来监控中查询表空间使用的语句执行缓慢.
系统中发现大量的latch: cache buffer chain等待.
清理回收站中…
另外, sqlldr指定了parallel参数对extents的分配有很大的影响.
表空间是auto allocate
指定parallel参数后, 分配extents基本都是64k,默认大小…
bosbl2s#[/]bdfFilesystem kbytes used avail %used Mounted on/dev/vg00/lvol3 1048576 426384 617352 41% //dev/vg00/lvol1 524288 130080 391224 25% /stand/dev/vg00/lvol8 8388608 4561488 3804328 55% /var/dev/vg00/lvol7 8388608 2760024 5584624 33% /usr/dev/vg00/lvol4 4194304 349688 3814656 8% /tmp/dev/vg00/lvol6 45940736 34216224 11647160 75% /opt/dev/vg00/lvol5 8388608 263856 8061336 3% /home/dev/vgbl2app/lvbl2app440451584 283026618 147585918 66% /opt/bboss/bl2/dev/vgbl2arch/lvarchlog200376320 30792172 158985448 16% /opt/bboss/bl2/oracle/arch/dev/vgbl2app/lvbl2crm797081600 531723310 248974669 68% /opt/bboss/bl2/crm
bosbl2s#[/]ff -s /dev/vg00/lvol6 | grep null./dce/sbin/dts_null_provider 58 58840…./(null) 199816 14139012274
bosbl2s#[/]lsofksh: lsof: not found
bosbl2s#[/var]/usr/local/bin/lsof /dev/vg00/lvol6 | grep 199816monitor_a 8454 bbossmon 1u REG 64,0×6 14141096056 199816 /opt (/dev/vg00/lvol6)sleep 26993 bbossmon 1u REG 64,0×6 14141096056 199816 /opt (/dev/vg00/lvol6)
bosbl2s#[/var]ps -ef | grep 8454root 27577 23815 0 16:22:54 pts/0 0:00 grep 8454bbossmon 8454 1 0 Jan 16 ? 91:30 /usr/bin/ksh /opt/mon/bin/monitor_agent.sh bl1bbossmon 27554 8454 0 16:22:49 ? 0:00 sleep 60bosbl2s#[/var]kill 8454you have mail in /var/mail/rootbosbl2s#[/var]bosbl2s#[/var]ps -ef | grep 8454root 28921 23815 1 16:26:03 pts/0 0:00 grep 8454bosbl2s#[/var]bdfFilesystem kbytes used avail %used Mounted on/dev/vg00/lvol3 1048576 426408 617328 41% //dev/vg00/lvol1 524288 130080 391224 25% /stand/dev/vg00/lvol8 8388608 4564840 3800976 55% /var/dev/vg00/lvol7 8388608 2760568 5584080 33% /usr/dev/vg00/lvol4 4194304 350232 3814120 8% /tmp/dev/vg00/lvol6 45940736 20421504 25334104 45% /opt/dev/vg00/lvol5 8388608 263880 8061312 3% /home/dev/vgbl2app/lvbl2app440451584 283026618 147585918 66% /opt/bboss/bl2/dev/vgbl2arch/lvarchlog200376320 33192578 156735065 17% /opt/bboss/bl2/oracle/arch/dev/vgbl2app/lvbl2crm797081600 532163377 248546012 68% /opt/bboss/bl2/crm
#ls | wc -l29592#du -sk14390876 .
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSystem name: HP-UXRelease: B.11.31Version: UMachine: ia64Redo thread mounted by this instance: 1Oracle process number: 0Ioctl ASYNC_CONFIG error, errno = 1
#cat /etc/privgroup# ORACLE async i/odba MLOCK RTPRIO RTSCHED#getprivgrp dbadba:#fuser /dev/async/dev/async:
#vi /etc/privgroup“/etc/privgroup” 2 lines, 44 charactersdba MLOCK RTSCHED RTPRIO#setprivgrp -f /etc/privgroup#getprivgrp dbadba: RTPRIO MLOCK RTSCHED#fuser /dev/async/dev/async: 3613o 3622o 3624o 3583o 3585o 3588o
最近做的工作基本属于sa. 数据库的工作不多.
儿子快6个月了, 全家人都围着小鱼忙活,
希望他脸上的湿疹早点痊愈, 另外再涨点儿分量, 光长个不长肉.
妈妈还在沈阳住院做放化疗, 希望疗程结束后, 妈妈能尽快恢复健康!
To use an HTTP proxy, you must teach Generic Proxy how to give the HTTP commands.
Proxy Prompt: (leave this field blank)
Proxy Command: CONNECT %h:%p HTTP/1.0\r\n\r\n
对海量小文件的文件系统进行归档操作时, gzip后mv vs mv后gzip哪个效率更高呢?
我这里的情况是, 后者效率更好; 前者gzip和后者gzip的效率相差近百倍!
地点：北京
要求：
根据能力，待遇范围7k-9k
有意请发邮件到
wajoynece at gmail.com
今天删除一个表空间
drop tablespace including contents and datafiles
执行完毕，df -h查看空间没有被释放，ls -l已经看不到被删除文件；
解决：
root@lab-rd-01:/# lsof | grep km_stress
oracle 19436 oracle 19u REG 8,7 10737426432 244535 /var/opt/oradata/rd/km_stress_test.dbf (deleted)
kill -9 19436后，空间立即得到释放。
_optimizer_sortmerge_join_enabled
10g以后，可以使用/*+ opt_param(‘_optimizer_sortmerge_join_enabled’,'false’) */提示，
在语句级别让CBO放弃smj连接选项。