raheeldba.wordpress.com
Raheel's Blog | Things I have learnt as Oracle DBAThings I have learnt as Oracle DBA (by Raheel Syed)
http://raheeldba.wordpress.com/
Things I have learnt as Oracle DBA (by Raheel Syed)
http://raheeldba.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Monday
LOAD TIME
1.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
9
SSL
EXTERNAL LINKS
19
SITE IP
192.0.78.12
LOAD TIME
1.391 sec
SCORE
6.2
Raheel's Blog | Things I have learnt as Oracle DBA | raheeldba.wordpress.com Reviews
https://raheeldba.wordpress.com
Things I have learnt as Oracle DBA (by Raheel Syed)
raheeldba.wordpress.com
Scripts | Raheel's Blog
https://raheeldba.wordpress.com/scripts
Things I have learnt as Oracle DBA. 1) Find out whether Oracle software installed and database created 32Bit or 64Bit? 2) Extract the DDL using DBMS METADATA.GET DDL Function To extract the DDL from dbms metadata. Ps -eo pcpu,pid,user,args sort -k 1 -r head -30. List processes by mem (KB) usage:. Ps -e -orss=,pid,user,args= sort -b -k1,1n pr -TW$COLUMNS. List processes by % cpu usage:. Ps -e -o pcpu,cpu,nice,state,pid,user,cputime,args –sort pcpu sed ‘/ 0.0 /d’. List all threads for a particular process:.
Raheel Syed | Raheel's Blog
https://raheeldba.wordpress.com/author/raheeldba
Things I have learnt as Oracle DBA. Author Archives: Raheel Syed. ICACLS – A magic command. July 10, 2015. One of our colleague was configuring Auditing on MSSQL Server using Arcsight (more info about the tool can be found here ) and one of the steps is to create SQLTRACE folder and SHARE the folder and provided the necessary … Continue reading →. ORA-01791: not a SELECTed expresssion. January 8, 2015. Not a SELECTed expression. Patching through OEM 12c in Offline mode. February 5, 2014. February 4, 2014.
Links | Raheel's Blog
https://raheeldba.wordpress.com/links
Things I have learnt as Oracle DBA. You will find all useful links gathered over a period of time mostly from https:/ support.oracle.com. And blogs. This Page will be updated with new links periodically. Apologies if you find duplicate links. You need to login to access MOS Document ID’s. Following are the categories:. Grid Control / Cloud Control. Linux: Node Reboots After “kernel: INFO: task ocssd.bin: blocked for more than 120 seconds.” in /var/log/messages [ID 1423693.1]. Checking Cluster Health Moni...
Raheel's Blog | Things I have learnt as Oracle DBA | Page 2
https://raheeldba.wordpress.com/page/2
Things I have learnt as Oracle DBA. Newer posts →. ORA-00001: unique constraint violated. January 3, 2014. IGNORE ROW ON DUPKEY INDEX hint is on rescue. This is the NEW feature in 11gR2 applied on INSERT statements, wherein duplicate values will be ignored rather causing ORA-00001 error. Development team wanted one of the STAGING table to be refreshed from PROD table without replacing the existing rows in the staging table. Verify by querying the EMP BK table. Recovering from rm -rf on a datafile. So we ...
Tools | Raheel's Blog
https://raheeldba.wordpress.com/tools
Things I have learnt as Oracle DBA. This Page is dedicated to Tools, which i have used or currently using it on day-to-day basis. Credit has been given to the author of the Tools. Ora cpu.pl tool for LINUX from Maxym Kharchenko. Http:/ intermediatesql.com/linux/ora cpu-pl-tool-for-linux/. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. Data Guard –...
TOTAL PAGES IN THIS WEBSITE
9
Mohamed Houri’s Oracle Notes | Qui se conçoit bien s’énonce clairement | Page 2
https://hourim.wordpress.com/page/2
Mohamed Houri’s Oracle Notes. September 5, 2015. Bind aware secret sauce (again). 8212; hourim @ 8:21 am. I am sure many of you have already become bored by my posts on adaptive cursor sharing. I hope this article will be the last one🙂. In part III. Of the installment I was unable to figure out the secret sauce Oracle is using to mark a cursor bind aware when count of the 3 buckets. Of a bind sensitive cursor are greater than 0. To make things simple I created the following function. Now change again th...
Degree of Parallelism is 16 because of table property | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/08/04/degree-of-parallelism-is-16-because-of-table-property
Mohamed Houri’s Oracle Notes. August 4, 2015. Degree of Parallelism is 16 because of table property. 8212; hourim @ 10:11 am. I have been pleasantly surprised by the following Note at the bottom of an execution plan coming from a 12.1.0.2.0 Oracle instance. As you can point it out, thanks to the above Note, we can immediately guess that the Optimizer decided to run the query in parallel because the T PAR table has been decorated with a DOP of 16. A nice 12c add. Unfortunately there is no Note indicating ...
Resumable time out | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/02/14/resumable-time-out
Mohamed Houri’s Oracle Notes. February 14, 2015. 8212; hourim @ 9:47 am. I was trying to create a very big table through a. Create table as select. I launched the create table and started monitoring it with Tanel Poder snapper script, v$active session history and the Real Time SQL Monitoring feature ( RTSM. This is what the monitoring was showing. However few minutes later Tanel Poder. Snapper started showing the following dominant wait event. No available free space left in TEMP tablespace. Popping up i...
Why Dynamic Sampling has not been used? | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/06/12/why-dynamic-sampling-has-not-been-used
Mohamed Houri’s Oracle Notes. June 12, 2015. Why Dynamic Sampling has not been used? 8212; hourim @ 10:15 am. Experienced tuning guys are known for their pronounced sense of looking at details others are very often ignoring. This is why I am always paying attention to their answers in otn and oracle-l list. Last week I have been asked to look at a query performing badly which has been monitored via the following execution plan:. As you can see apart from the optimizer index cost adj. About dynamic sampli...
August | 2015 | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/08
Mohamed Houri’s Oracle Notes. August 21, 2015. Cardinality Feedback: a practical case. 8212; hourim @ 5:36 pm. Here it is an interesting case of cardinality feedback collected from an 11.2.0.3 running system. A simple query against a single table has a perfect first execution response time with, according to the human eyes, a quite acceptable difference between Oracle cardinality estimates and actual rows as shown below:. It might be “possible” that when Oracle rounds up its cardinality estim...SQL selec...
Stressed ASH | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/07/09/stressed-ash
Mohamed Houri’s Oracle Notes. July 9, 2015. 8212; hourim @ 5:29 pm. It is well known that any record found in dba hist active session history has inevitably been routed there from v$active session history. If so, then how could we interpret the following cut and past from a running production system? 12,950 snapshots of SQL*Net break/reset to client. And 12,712 snapshots of an enq: TM – contention. Wait events in AWR not found in ASH. How can we interpret this situation? Typically the activity is mainly ...
Real Time SQL Monitoring oddity | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/06/23/real-time-sql-monitoring-oddity
Mohamed Houri’s Oracle Notes. June 23, 2015. Real Time SQL Monitoring oddity. 8212; hourim @ 1:45 pm. This is a small note about a situation I have encountered and which I thought it is worth sharing with you. There was an insert/select executing in parallel DOP 16 on a 11.2.0.3 Oracle database for which the end user was complaining about the exceptional time it was taking without completing. Since the job was still running I tried getting its Real Time SQL monitoring report:. How could this be possible?
Index Coalesce : sys_op_lbid | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2013/07/27/index-coalesce-sys_op_lbid
Mohamed Houri’s Oracle Notes. July 27, 2013. Index Coalesce : sys op lbid. 8212; hourim @ 8:44 am. A recent question on the oracle French forum. About rebuilding indexes remembered me to write a small note to show the existence of a more interesting option to use when maintaining an index but unfortunately not widely used. It is the COALESCE index command. Let me put a simple model and explain (a) how to identify indexes that might benefit from the COALESCE. Spot how the index become now (after it has be...
Index Efficiency | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/05/12/index-efficiency
Mohamed Houri’s Oracle Notes. May 12, 2015. 8212; hourim @ 7:03 am. I used Jonathan Lewis script. To locate degenerated indexes -or indexes that are occupying more space than they should–. Among those indexes I have isolated this one:. 16:20:33:TABLE1 - PK TAB1 Current Leaf blocks: 2,846,555 Target size:1,585,492. According to this SQL script. Above index possesses 2.8 million worth of leaf blocks while it should normally occupy half this number of blocks. Sys op lb id. While rebuilding the index has red...
Flash back causing library cache: mutex X | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/08/05/flash-back-causing-library-cache-mutex-x
Mohamed Houri’s Oracle Notes. August 5, 2015. Flash back causing library cache: mutex X. 8212; hourim @ 5:28 pm. Recently one of our applications suffered from a severe performance issue. It is an application running on a database(11.2.0.4.0) used to validate a pre-production release. This performance issue has delayed the campaign test and the validation process for more than 3 days. The ASH data taken during the altered performance period shows this:. As you can notice the dominant wait event is:.
TOTAL LINKS TO THIS WEBSITE
19
index
About Myself
Saturday, January 29, 2011. Monday, January 17, 2011. Closer to Paradise in The Hereafter Through Complete Faith in Islam. Come closer to Paradise in the hereafter through complete faith in Islam. It seems simple enough to understand but following it is something extraordinary. The term "coming closer to Paradise" means following the guidelines set in the holy book of Islam and living up to them. Once these guidelines are accomplished, one becomes successful in all parts of his life; finance. Paradise is...
Raheel Ayub
Trick – Change existing website into Mobile Friendly in an hour or two! April 22, 2015. HTML, CSS Tutorials. I wanted to write this post in detail along with my own written examples but unfortunately I’m like other thousands of UI/UX developers (around the globe) who are busy converting their (client’s) websites to make it work for mobile devices. For everyone who wants to change their website to make it mobile friendly for Google. If you really want to save SEO of your existing website. March 26, 2014.
Benefit Solutions - Raheel
Please enter your company name to the left to continue to BenefitSolutions.
RAHEEL BROTHER COMPANY
Manufecturer Importer and Exporter All Kinds Of Leather Garments. Manufecturer and Exporters All Kinds Of Leather Garments. Designed and Developed By: ITBM Corp.
Raheel's Blog | Things I have learnt as Oracle DBA
Things I have learnt as Oracle DBA. ICACLS – A magic command. July 10, 2015. One of our colleague was configuring Auditing on MSSQL Server using Arcsight (more info about the tool can be found here. One thing was very sure, this is related to permissions issue but how come? Then this magic command ICACLS actually did the trick. Here is the actual command. Icacls * /T /Q /C /RESET. ORA-01791: not a SELECTed expresssion. January 8, 2015. Include the “order by” clause column. In the SELECT statement. The be...
raheeldreamz | Just another WordPress.com site
Just another WordPress.com site. February 3, 2012. The website Pocketnow has come out with some exclusive details about Windows Phone 8 – the next version of Microsoft’s Windows Phone Operating System. Windows Phone 8 or Apollo is rumored to be adding support for multiple processors, more screen resolutions (rumored 4) and removable MicroSD storage capabilities. In addition, Microsoft is reported to be racing to include NFC functionality and tap to share capabilities. This is the main selling point here.
رحیل آسمان
ما همه به سوی آسمانیم. نوشته های روح الله رشیدی. لاله های بی ادعا. بسیج دانشجویی پیام نور تبریز. پله پله تا ملاقات خدا. سایت مقام معظم رهبری. آمارگیر حرفه ای سایت. آمارگیر حرفه ای وبلاگ و سایت. چرا باید بگوییم امام خامنه ای؟ سه شنبه هشتم مرداد ۱۳۹۲ ساعت 13:55. چرا باید بگوییم امام خامنه ای؟ این گفتاری است از دکتر محمد علی رامین . به نقل از سایت راسخون متن خیلی خیلی جالبیه. حتما تو ادامه ی مطلب بخوانید. برچسبها: چرا باید بگوییم امام خامنه ای. امام و امت به جای ملت و رهبر. نوشته شده توسط رحیل. وقتی می شنوم...
Raheel Farooq — Thinker and Writer
Made to learn…. The intelligent have plans; the wise have principles. غزل جانتا ہے زمانہ اسے / تڑپ جائیے تو صدا کیجیے. Urdu voice over in its cultural, artistic and aesthetic entirety! Raheel Farooq’s aphorisms on different aspects of life are widely quoted all over the world. His first book was a collection of ghazals but he has now established his identity as a prose writer as well. He is known for his classic accent, mellifluous voice and masterly command on Urdu language. You look so young in the pic...
Raheel Farooq | Moving around the world like I'm the only sinner!
Moving around the world like I'm the only sinner! Welcome to my WordPress blog! Let me introduce myself. I’m Raheel, a guy with no idea what to do in life. All I know is that I’m meant to serve some really great purpose. Like smoking plain cigarettes, having not-so-hot tea twenty times a day, flirting with sapiosexual ladies, winking at my own wife, or may be something even greater. Who knows! Humans are my love. So, let me confess I love you too (if you’re not a Google bot or something dirtier!
This website is currently unavailable.
The website you were trying to reach is temporarily unavailable. Please check back soon. If you are the owner of this website, please contact Technical Support as soon as possible.
SOCIAL ENGAGEMENT