MAHMOUDHATEM.WORDPRESS.COM
Hatem Mahmoud Oracle's blog | Just another Oracle blog : Database topics and techniquesJust another Oracle blog : Database topics and techniques
http://mahmoudhatem.wordpress.com/
Just another Oracle blog : Database topics and techniques
http://mahmoudhatem.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
4.5 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
17
SSL
EXTERNAL LINKS
41
SITE IP
192.0.78.12
LOAD TIME
4.484 sec
SCORE
6.2
Hatem Mahmoud Oracle's blog | Just another Oracle blog : Database topics and techniques | mahmoudhatem.wordpress.com Reviews
https://mahmoudhatem.wordpress.com
Just another Oracle blog : Database topics and techniques
mahmoudhatem.wordpress.com
September | 2016 | Hatem Mahmoud Oracle's blog
https://mahmoudhatem.wordpress.com/2016/09
Hatem Mahmoud Oracle's blog. Just another Oracle blog : Database topics and techniques. Latch acquisition/release call-graph : Dynamic tracing tools in action. September 30, 2016. In an oracle database, it’s very common for a process to hold multiple latch at different level in different mode (shared/exclusive) concurrently. The question is : Is it possible to draw a call graph to track the different step of acquisition and release for a particular process? Continue reading →. September 23, 2016. 8220;CR...
Tracing Memory access of an oracle process : Intel PinTools | Hatem Mahmoud Oracle's blog
https://mahmoudhatem.wordpress.com/2016/11/07/tracing-memory-access-of-an-oracle-process-intel-pintools
Hatem Mahmoud Oracle's blog. Just another Oracle blog : Database topics and techniques. Tracing Memory access of an oracle process : Intel PinTools. Tracing Memory access of an oracle process : Intel PinTools. November 7, 2016. November 17, 2016. This blog post is motivated by a conversation with Frits Hoogland on his great blog post The curious case of the missing semctl call. Https:/ software.intel.com/en-us/articles/pin-a-dynamic-binary-instrumentation-tool. Using PinTools we can trace all/range of me...
Training | Hatem Mahmoud Oracle's blog
https://mahmoudhatem.wordpress.com/training
Hatem Mahmoud Oracle's blog. Just another Oracle blog : Database topics and techniques. Don’t see the class that fits your schedule! Let us know we will add it for you! Troubleshooting Oracle performance using trace data (Event 10046). Troubleshooting Oracle performance using trace data (Event 10046). Troubleshooting Oracle performance using trace data (Event 10046). With your company information and purchase order attached. All online training will be conducted online using Citrix’ gotowebinar.com.
August | 2016 | Hatem Mahmoud Oracle's blog
https://mahmoudhatem.wordpress.com/2016/08
Hatem Mahmoud Oracle's blog. Just another Oracle blog : Database topics and techniques. RMAN recover : Incremental backup GAP. August 22, 2016. Suppose that we use the following standard backup strategy :. Incremental Lvl 0 every Sunday. Differential incremental Lv1 : all the other days. Backupset : ( 3:Sun/5:Mon/7:Tue /9:Wed/etc). Suppose now that we hit a media failure at the end of the week (Saturday night for example) and when trying to recover the database we receive the following error :. There is ...
DB Link password encryption/decryption : A step forward | Hatem Mahmoud Oracle's blog
https://mahmoudhatem.wordpress.com/2016/12/02/db-link-password-encryptiondecryption-a-step-forward
Hatem Mahmoud Oracle's blog. Just another Oracle blog : Database topics and techniques. DB Link password encryption/decryption : A step forward. DB Link password encryption/decryption : A step forward. December 2, 2016. In one of my previous posts i showed a way to recover the DB Link password. TEST ENV : Oracle 12.1.0.2.6/OEL6/UEK4. Some functions names used in DB link encryption/decryption give us very helpful information “r0 AES CBC. In CBC encryption mode! Based on my previous example here is the out...
TOTAL PAGES IN THIS WEBSITE
17
Oracle 12c pluggable and “common” directory recreation issue. | dmitry remizov's weblog
https://dmitryremizov.wordpress.com/2016/09/08/oracle-12c-pluggable-and-common-directory-recreation-issue
Dmitry remizov's weblog. Oracle 12c pluggable and “common” directory recreation issue. Oracle 12c pluggable and “common” directory recreation issue. September 8, 2016. Recently I did a stupid thing. DROP DIRECTORY DATA PUMP DIR; - issues from CDB$ROOT. Before that my PDBs was able to see this standard directory:. SELECT directory name FROM dba directories WHERE directory name='DATA PUMP DIR';. I’ve almost immediate recreate the directory as:. CREATE DIRECTORY DATA PUMP DIR as '/tmp';. SELECT directory na...
Don’t pre-empt the CBO from doing its work | Mohamed Houri’s Oracle Notes
https://hourim.wordpress.com/2015/07/02/dont-pre-empt-the-cbo-from-doing-its-work
Mohamed Houri’s Oracle Notes. July 2, 2015. Don’t pre-empt the CBO from doing its work. 8212; hourim @ 2:03 pm. This is the last part of the parallel insert/select saga. As a reminder below is the two preceding episodes:. Where I have explained why I was unable to get the corresponding SQL monitoring report because of the sqlmon max planlines parameter. Where I have explained the oddity shown by the SQL monitoring report when monitoring non active parallel server for more than 30 minutes. Observe careful...
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...
TOTAL LINKS TO THIS WEBSITE
41
موقع الشاعر محمود حمزة
موقع الشاعر محمود حمزة. إجمالى عدد زوار الموقع. من التأسيس حتى الآن. عداد الزوار والدول القادمين منها. موقع،الشاعر،محمود،حمزة،الصفحة،الرئيسية. الصفحة الرئيسية لموقع الشاعر محمود حمزة. مرسلة بواسطة الشاعر محمود حمزة. أحدث قصائد الشاعر محمود حمزة. وتاهت المرسا بقلم الشاعر محمود حمزة هنا. للاطلاع على ما نُشر حتى الآن من قصائد الشاعر محمود حمزة فى موقع سما فلسطين الأدبية. دنيا الرأى تنشر إبداعات الشاعر محمود حمزة. كلمات الشاعر محمود حمزة. كلمات الشاعر محمود حمزة. يا مصر محلاكى والثورة زفاكى. رفرف يا حر ودور.
خواطر أدبية بقلم : الشاعر محمود حمزة
خواطر أدبية بقلم : الشاعر محمود حمزة. الصفحة الرئيسية لخواطر أدبية بقلم : الشاعر محمود حمزة. مرسلة بواسطة الشاعر محمود حمزة. فهرس خواطر أدبية للشاعر محمود حمزة. إجمالى عدد زوار الموقع. من التأسيس حتى الآن. عداد الزوار والدول القادمين منها. الصفحة الرئيسية لخواطر أدبية بقلم : الشاعر محمود ح. 169; خواطر أدبية بقلم : الشاعر محمود حمزة. أسس هذا الموقع ويحرره الأديب مجدى شلبى 0108784120.
واحة أشعار الشاعر محمود حمزة
واحة أشعار الشاعر محمود حمزة. الصفحة الرئيسية لواحة أشعار الشاعر محمود حمزة. فهرس واحة أشعار الشاعر محمود حمزة. توهه بقلم الشاعر محمود حمزة. مرسلة بواسطة الشاعر محمود حمزة. إجمالى عدد زوار الموقع. من التأسيس حتى الآن. عداد الزوار والدول القادمين منها. الصفحة الرئيسية لواحة أشعار الشاعر محمود حمزة. يا مصر محلاكى بقلم : الشاعر محمود حمزة. C)2012 - واحة أشعار الشاعر محمود حمزة. أسس هذا الموقع ويحرره : الأديب مجدى شلبى 0108784120.
Hello! Welcome to Synology Web Station!
Web Station has been enabled. To finish setting up your website, please see the "Web Service" section of DSM Help.
Hatem Mahmoud Oracle's blog | Just another Oracle blog : Database topics and techniques
Hatem Mahmoud Oracle's blog. Just another Oracle blog : Database topics and techniques. SQL Injection vulnerability : CDBView Package. December 14, 2016. Here is a vulnerability i recently discovered inside the CDBView package (Create the cdb view) on my Database Patch Set Update : 12.1.0.2.161018 (24006101) .The package is granted to the “EXECUTE CATALOG ROLE” Role by default. The package is not even wrapped, but this is not a problem as we can easily unwrap it anyway :. Continue reading →. I just publi...
MahmoudHD81's blog - MahmoudHD81's blog - Skyrock.com
20/08/2016 at 5:14 PM. 20/08/2016 at 5:14 PM. Subscribe to my blog! This blog has no articles. Post to my blog. Here you are free.
Mahmoud Heeba Jewelry
You Mail Added Thanks. Some Thing Went Wrong Please Try Again Later. Ansial 2 gram 18 carat. The latest formations runoff 18 carat weight segment 4 grams. The latest formations runoff 18 carat weight segment 5 grams. The latest formations runoff 18 carat weight segment 7 grams. Ansial 12 gram 18 carat. Ansial 12 gram 18 carat. Welcome To Mahmoud Heeba Jewelry. Let them wondering about the secret of your style, Elegance and beauty has one address . Mahmoud Heeba Jewelry. 4 Cs Of Diamonds. How to Buy Gold.
محمود حیدری خلاری - Personal Site Mahmoud Heidari Khollari : محمود حیدری خلاری
رپورتاژ آگهی : حل مشکل خرید جم در بازی Clash of Clans در اندروید. رسانه های اجتماعی در سال ۲۰۱۴. ۵۳ توصیه مهم برای خرید خانه و آپارتمان. اگر این پنج نکته را نمی دانید، آپارتمان نخرید! نکات طلایی برای خرید خانه. Salam در سلام دنیا! Mahmoudh در شب ویژه شخصی من! در شب ویژه شخصی من! تکنولوژی و آی تی. شخصی ، دوستان ، سایت. رپورتاژ آگهی : حل مشکل خرید جم در بازی Clash of Clans در اندروید. رسانه های اجتماعی در سال ۲۰۱۴. ۵۳ توصیه مهم برای خرید خانه و آپارتمان. هنگام خرید خانه، ملک یا ساختمان نکات بسیار مهمی وجود...
Mahmoud Heidarian, Vancouver British Columbia
Photography Studio
Techniques Only A Few Know. Take Pictures Similar To A Professional Photographer. Great Tips And Tricks For Each And Every Photography Enthusiast! Takes Pictures Like A Pro Using These Tips. Achieve that Picture Perfect Kitchen of Your Dreams. 2018, Powered by WordPress. Techniques Only A Few Know. Do you wish to begin a photography hobby or career but have no idea the best places to start?
SOCIAL ENGAGEMENT