jurongport.blogspot.com
Oracle: ADDM
http://jurongport.blogspot.com/2009/06/addm.html
Monday, June 15, 2009. ADDM (Automatic Database Diagnostic Monitor) is used to diagnose database performance issues. Its analysis can be performed across any two AWR snapshots. Three ways to run ADDM analysis:. Option 1 , Running ADDM Using addmrpt.sql. SQL @$ORACLE HOME/rdbms/admin/addmrpt.sql. Listing the last 3 days of Completed Snapshots. Instance DB Name Snap Id Snap Started Level. Ctgbu2 CTGBU2 6611 14 Jun 2009 00:00 1. 6612 14 Jun 2009 01:00 1. 6613 14 Jun 2009 02:00 1. 6614 14 Jun 2009 03:00 1.
jurongport.blogspot.com
Oracle: Killing DBMS_JOB
http://jurongport.blogspot.com/2009/07/killing-dbmsjob.html
Thursday, July 30, 2009. To check scheduled job:. Scheduled dbms jobs.sql. Set line 200 pages 200. Col log user for a10. Col job for 9999999 head 'Job'. Col broken for a1 head 'B'. Col failures for 99 head "fail". Col last date for a18 head 'LastDate'. Col this date for a18 head 'ThisDate'. Col next date for a18 head 'NextDate'. Col interval for 9999999.000 head 'RunInterval'. Col what for a60. From dba jobs dj) j;. What Jobs are Actually Running. Select * from dba jobs running;. Col log user for a10.
jurongport.blogspot.com
Oracle: test
http://jurongport.blogspot.com/2009/09/test.html
Thursday, September 3, 2009. Subscribe to: Post Comments (Atom). View my complete profile.
xiaohuajoke.blogspot.com
博你一笑: 最牛90后网上对话
http://xiaohuajoke.blogspot.com/2009/07/90.html
Thursday, July 16, 2009. 12288; GG：你嚎！ 12288; MM：你嚎，你在哪里伤亡？ 12288; GG：在王八里上网，你呢？ 12288; MM：也在王八里. 12288; GG：你是哪里人. 12288; MM：是鬼洲人. 12288; GG：哦，是山洞人. 12288; MM：你似男似女？ 12288; GG：当然是难生了，你肯定是驴身了。 12288; MM：是。 12288; GG：你霉不霉？ 12288; MM：还行吧，人家都说 是大霉女，你衰不衰？ 12288; GG：还好，很多人都说 是大衰哥. 12288; MM：真的呀，咱们多怜惜好不好？ 12288; GG：好鸭，你的瘦鸡号码是多少？下次不知道什么时候来聊天柿了。 12288; MM：咱别用瘦鸡，瘦鸡聊天多贵，就用你球球（qq）. 12288; GG：你真可爱，很想煎你。 12288; MM：慢慢来，虽然隔得远，蛋也有鸡会。 怎麽搞得，人跑哪去了？” 最後全部发完後还是剩下那一本。 於是 “还没拿到的人举手! 8221; 这时有个个子小小的女生举了手，老师问:“你叫什麽名字?
jurongport.blogspot.com
Oracle: June 2009
http://jurongport.blogspot.com/2009_06_01_archive.html
Tuesday, June 16, 2009. Basically, AWR (Automatic Workload Repository) is an Oracle built-in tool that collects performance related statistics and derives performance metrics from them to track a potential problem. Unlike Statspack, snapshots are collected automatically every hour by a new background process called MMON and its slave processes. Be default, the collected data is automatically purged after 7 days. Col SNAP INTERVAL format a30;. Col RETENTION format a30;. Select * from dba hist wr control;.
jurongport.blogspot.com
Oracle: April 2009
http://jurongport.blogspot.com/2009_04_01_archive.html
Wednesday, April 1, 2009. The Oracle Password File ($ORACLE HOME/dbs/ orapw. Stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect. Follow this procedure to create a new password file:. Log in as the Oracle software owner. Run command on OS level:. Orapwd file=$ORACLE HOME/dbs/orapw$ORACLE SID password=. Shutdown the database (SQLPLUS SHUTDOWN IMMEDIATE). Adding users to Password File:.
xiaohuajoke.blogspot.com
博你一笑: April 2009
http://xiaohuajoke.blogspot.com/2009_04_01_archive.html
Sunday, April 19, 2009. 亲爱的老婆大人： . 遵照您的旨意，我在书房里反省了一个小时四十三分零七秒，喝了一杯白开水，上了一次卫生间，没有抽烟，以上事实准确无误，请审查。 . 附上我的检讨报告，不当之处可以协商。 . 经过３个月的婚姻生活，我认为老婆同志温柔贤良，勤奋聪颖，是不可多得的好妻子，而身为丈夫的我却举止乖张，态度轻狂，所作所为确有值得商榷之处。 . 以下是我对自己恶劣行径的剖析，请领导批阅： . 1昨天的事情是我不对。你做的红烧茄子虽然有点咸，但是香醇可口，瑕不掩瑜，我不该指责你浪费盐。我这么求全责备，完全是暗藏嫉妒之心。不过再加点水是可以的。 . 2你说喜欢陆毅的时候，我不该信口雌黄说我喜欢梁咏琪，害得你两天不能理我，极其痛苦。仔细一想，我的回答确实很不妥当，因为你的花心还局限于内地，我却冲到了港台，我还是喜欢周迅好了。 . 3你喜欢看韩剧里的小政哥，我不该百般阻挠，你拿我和他比较我也不该表示抗议，因为人家小政哥都没有抗议。 . Subscribe to: Posts (Atom). View my complete profile.
xiaohuajoke.blogspot.com
博你一笑: 一次性交多久才算男人？
http://xiaohuajoke.blogspot.com/2009/07/blog-post_15.html
Wednesday, July 15, 2009. 我准备交半年的。可营业厅的mm说：现在搞活动，一次性交一年的送3个月。 我坚持要一次性交半年。我听见mm小声说了一句：才一次性交半年，真不是男人! Subscribe to: Post Comments (Atom). View my complete profile.
xiaohuajoke.blogspot.com
博你一笑: 爱不爱我？
http://xiaohuajoke.blogspot.com/2009/07/blog-post.html
Tuesday, July 14, 2009. 男生说：我己经证明了啊！四十摆在眼前！ Subscribe to: Post Comments (Atom). View my complete profile.
