August 24th, 2008 by onlyring
|
No Comments »
感觉自己的脖子酸已经有一段时间可,最近感觉脖颈特别累,估计是得了职业病了,唉,年纪不大,身体是越来越差了,真是太缺少锻炼了,而我这个人平时又没有什么活动,从学校毕业了到现近四年几乎没有锻炼过,生命在于运动,真是真理啊。从网上找了一些锻炼方法,记录供自己参考。
一:多游泳。因为游泳的时候头总是向上抬,颈部肌肉和腰肌都得到锻炼,而且人在水中没有任何负担,也不会对椎间盘造成任何的损伤,算得上是比较惬意的锻炼颈椎的方式。
二:日常保养
平时要注意少低头,工作一两个小时至少休息一次,休息时头向后仰,或平卧,让颈椎得到休息。颈椎病患者要注意不要来回转头,更不能旋转颈椎,斜搬按摩。
三:做体操,以下推荐简单体操一款。
A:基本姿势:每次做各项训练动作前,先自然站立,双目平视,双脚略分开,与肩同宽,双手自然下垂。全身放松。
B:前俯后仰:双手叉腰,先抬头后仰,同时吸气,双眼望天,停留片刻;然后缓慢向前胸部位低头,同时呼气,双眼看地。做此动作时,要闭口,使下颌尽量紧贴前胸,停留片刻后,再上下反复做4次。
C:左右旋转:双手叉腰,先将头部缓慢转向左侧,同时吸气于胸,让右侧颈部伸直后,停留片刻,再缓慢转向右侧,同时呼气,让左边颈部伸直后,停留片刻。这样反复交替做4次。
D:提肩缩颈:做操前,先自然站立,双目平视,双脚略分开,与肩平行,双手自然下垂。动作时双肩慢慢提起,颈部尽量往下缩,停留片刻后,双肩慢慢放松地放下,头颈自然伸出,还原自然,然后再将双肩用力往下沉,头颈部向上拔伸,停留片刻后,双肩放松,并自然呼气。
E:左右摆动:做操前,先自然站立,双目平视,双脚略分开,与肩平行,双手叉腰。动作时头部缓缓向左侧倾斜,使左耳贴于左肩,停留片刻后,头部返回中位;然后再向右肩倾斜,同样右耳要贴近右肩,停留片刻后,再回到中位。这样左右摆动反复做4次。
四:如何预防颈椎病
预防颈椎病的发生,最重要的是,要改善坐姿,埋头苦干时,也可间断地做运动。此外也要注意:
1、睡觉时不可俯着睡,枕头不可以过高、过硬或过平。
2、避免和减少急性损伤,如避免抬重物等。
3、改正不良姿势,减少劳损,每低头或仰头1—2小时,需要做颈部活动,以减轻肌肉紧张度。
Popularity: 5% [?]
August 24th, 2008 by onlyring
|
No Comments »
Here is what I like to do to get autotrace working:
1
2
3
4
5
6
7
8
9
| * cd $oracle_home/rdbms/admin
* log into sqlplus as system
* run SQL> @utlxplan
* run SQL> create public synonym plan_table for plan_table
* run SQL> grant all on plan_table to public
* exit sqlplus and cd $oracle_home/sqlplus/admin
* log into sqlplus as SYS
* run SQL> @plustrce
* run SQL> grant plustrace to public |
More…
Popularity: 6% [?]
August 24th, 2008 by onlyring
|
No Comments »
前端时间,用disk clone 方式从生产库clone一个数据库,结果数据库无法启动,遇到 ORA-03113: end-of-file on communication channel错误。
More…
Popularity: 6% [?]
July 30th, 2008 by onlyring
|
No Comments »
Oracle 10g 的bug 还真不少,这次又遇到了个未公布的bug.
数据库遇到07455,472错误,具体信息如下:
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_j010_5066.trc:
ORA-07445: exception encountered: core dump [kghadjust()+152] [SIGSEGV] [Address not mapped to
object] [0x000000018] [] []
Mon Jul 28 14:30:37 2008
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_pmon_25485.trc:
ORA-07445: exception encountered: core dump [kghadjust()+152] [SIGSEGV] [Address not mapped to
object] [0x000000018] [] []
Mon Jul 28 14:30:59 2008
CKPT: terminating instance due to error 472
Mon Jul 28 14:30:59 2008
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_lgwr_25503.trc:
ORA-00472: PMON process terminated with error
Mon Jul 28 14:30:59 2008
Errors in file /data/oracle/sprrprd1/admin/bdump/instanace_name_rvwr_25672.trc:
ORA-00472: PMON process terminated with error
Mon Jul 28 14:31:00 2008
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_psp0_25487.trc:
ORA-00472: PMON process terminated with error
Termination issued to instance processes. Waiting for the processes to exit
Instance terminated by CKPT, pid = 25505
得到ORACLE SR回复如下:
It seems that you has got the problem described in Bug4927533, which
is unfortunately not public and therefore not available on Metalink.
For more information please read Note:421947.1, Ora-7445 [KGHADJUST]
Pmon Process Terminated And Instance Crashed.
Fixed in version:
- Oracle 11.1
Workaround:
- Set "_BLOOM_FILTER_ENABLED" to FALSE.
No fix exist for Oracle 10.2.0.3.0.
I recommend that you use the workaround, this will solve your problem.
_BLOOM_FILTER_ENABLED 是一个UNDOCUMENT的参数.这个参数自10.2.0引入.
可以使用ALTER SYSTEM 命令动态修改,由于是隐含参数,所以要加引号.
ALTER SYSTEM SET "_BLOOM_FILTER_ENABLED"= false;
参数具体含义可以参考下面这篇文章
http://www.dbasupport.com/oracle/ora10g/hash.shtml
Popularity: 32% [?]
July 28th, 2008 by onlyring
|
No Comments »
A role groups several privileges and roles, so that they can be granted to and revoked from users simultaneously. A role must be enabled for a user before it can be used by the user.
The SET ROLE statement allows you to enable or disable a role for a current session.
When a user logs into Oracle, all default roles are enabled, but non-default roles must be enabled with the SET ROLE statement.
More…
Popularity: 37% [?]