blog.tanelpoder.com
Tanel Poder\'s blog: Core IT for Geeks and ProsTanel Poder\'s advanced Oracle Troubleshooting, SQL and performance tuning blog
http://blog.tanelpoder.com/
Tanel Poder\'s advanced Oracle Troubleshooting, SQL and performance tuning blog
http://blog.tanelpoder.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
5.5 seconds
16x16
32x32
64x64
128x128
160x160
192x192
256x256
PAGES IN
THIS WEBSITE
23
SSL
EXTERNAL LINKS
2,728
SITE IP
173.45.236.197
LOAD TIME
5.494 sec
SCORE
6.2
Tanel Poder\'s blog: Core IT for Geeks and Pros | blog.tanelpoder.com Reviews
https://blog.tanelpoder.com
Tanel Poder\'s advanced Oracle Troubleshooting, SQL and performance tuning blog
blog.tanelpoder.com
Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable | Tanel Poder's Performance & Troubleshooting blog
https://blog.tanelpoder.com/2015/03/29/sqlplus-is-my-second-home-part-8-embedding-multiple-sqlplus-arguments-into-one-variable
Tanel Poder's Performance and Troubleshooting blog. Linux, Oracle, Hadoop. Oracle Exadata Performance: Latest Improvements and Less Known Features. Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits? Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable. March 29, 2015. I’ve updated some of my ASH scripts. To use these 4 arguments in a standard way:. What ASH columns to display (and aggregate by). Geeky shorcuts for p...
Oracle Training and Seminars | Tanel Poder's Performance & Troubleshooting blog
https://blog.tanelpoder.com/seminar
Tanel Poder's Performance and Troubleshooting blog. Linux, Oracle, Hadoop. Tanel Poder’s Oracle & Linux Performance and Troubleshooting Seminars. Tanel Poder’s Advanced Oracle Training in 2015. I will announce my new training in early 2016! 2016 dates will be announced in January! Paypal accepts payments using major credit cards and you will get a receipt for your records. If you need an invoice, please email us at seminars@poderc.com. How to attend our online training courses:. With your company details).
LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051) | Tanel Poder's Performance & Troubleshooting blog
https://blog.tanelpoder.com/2011/03/20/lobread-sql-trace-entry-in-oracle-11-2
Tanel Poder's Performance and Troubleshooting blog. Linux, Oracle, Hadoop. Implicit datatype conversion in the parsing phase – something new I learned today! An index of my TPT scripts →. LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051). March 20, 2011. A few days ago I looked into a SQL Tracefile of some LOB access code and saw a LOBREAD. C=1000,e=2915,p=8,cr=5,cu=0,tim=1300390477245735. So, whenever a wait happened in your session due to an access using a LOB locator, the...
Full scans, direct path reads and ORA-8103 error hacking session video here | Tanel Poder's Performance & Troubleshooting blog
https://blog.tanelpoder.com/2011/08/11/full-scans-direct-path-reads-and-ora-8103-error-hacking-session-video-here-plus-itunes-podcast-address-2
Tanel Poder's Performance and Troubleshooting blog. Linux, Oracle, Hadoop. Are you getting the most out of your Exadata performance? V8 Bundled Exec call – and Oracle Program Interface (OPI) calls →. Full scans, direct path reads and ORA-8103 error hacking session video here. August 11, 2011. If you want to move to the New World - offload your data and workloads to Hadoop, without having to re-write your existing applications - check out Gluent. We are making history! Click to print (Opens in new window).
Alter session force parallel query doesn’t really force anything | Tanel Poder's Performance & Troubleshooting blog
https://blog.tanelpoder.com/2013/03/20/alter-session-force-parallel-query-doesnt-really-force-anything
Tanel Poder's Performance and Troubleshooting blog. Linux, Oracle, Hadoop. Asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time. Listing Exadata storage cells and their configuration info from V$CELL CONFIG →. Alter session force parallel query doesn’t really force anything. March 20, 2013. Jonathan Lewis has already written. About this behavior from the angle of PARALLEL hints. I’m writing a similar article just because the word FORCE. SQL ALTER SESSION FORCE.
TOTAL PAGES IN THIS WEBSITE
23
12c « SQLMDX
https://sqlmdx.net/tag/12c
Eventually it's all about data. Dsvolk Oracle News [ru]. Posts Tagged ‘12c’. Fetch first … percent. On December 19, 2015. New syntax for so called “Top N” queries was introduced in Oracle 12c. It can be used to return either fixed number of rows or specified percent of rows in a table. Obviously latter requires to know the total number of rows to return the result so let’s check what is happening under the hood in this case. Read the rest of this entry ». Context switches may not be an issue any longer.
built-in packages « SQLMDX
https://sqlmdx.net/tag/built-in-packages
Eventually it's all about data. Dsvolk Oracle News [ru]. Posts Tagged ‘built-in packages’. On September 27, 2014. Dbms comparison was introduced in 11g as a powerful tool to compare and synchronize table data in different tables. Even though it’s quite flexible it has some limitations:. 1 The tables are supposed to be in different databases. Therefore if you want to compare tables in the same database you will need to create fake db link. 2 The tables must have unique indexes. Blog at WordPress.com.
2014 September « SQLMDX
https://sqlmdx.net/2014/09
Eventually it's all about data. Dsvolk Oracle News [ru]. Archive for September, 2014. On September 30, 2014. Almost everyone who has some experience with Oracle knows about notorious notion called “context switches” between SQL and PL/SQL engines. You can find a great explanation of context switches by Tom Kyte here. Read the rest of this entry ». On September 27, 2014. Dbms comparison was introduced in 11g as a powerful tool to compare and synchronize table data in different tables.
2014 May « SQLMDX
https://sqlmdx.net/2014/05
Eventually it's all about data. Dsvolk Oracle News [ru]. Archive for May, 2014. Amending statistics list for autotrace. On May 24, 2014. I wonder why Oracle has not added possibility to change the list of statistics for autotrace but unfortunately that’s a fact. You cannot change the default format of the statistics report. However there are at least three different ways to view the extended list of statistics for given session. Advantage is the ease of monitoring several sessions with the same client id.
2013 December « SQLMDX
https://sqlmdx.net/2013/12
Eventually it's all about data. Dsvolk Oracle News [ru]. Archive for December, 2013. Query transformations in Oracle: join elimination. On December 14, 2013. Join elimination appeared in Oracle version 10gR2. Read the rest of this entry ». Query transformations in Oracle: or-expansion. On December 8, 2013. As you may know there are two types of query transformations in Oracle: heuristic-based and cost-based. Read the rest of this entry ». Blog at WordPress.com.
2014 October « SQLMDX
https://sqlmdx.net/2014/10
Eventually it's all about data. Dsvolk Oracle News [ru]. Archive for October, 2014. Yet another approach to overcome bloom filter bug. On October 4, 2014. Bloom filter may help to dramatically reduce amount of data to be read from partitioned table by eliminating unneeded partitions. Is a nice introduction into bloom filters. Unfortunately bloom filter doesn’t work with DML which causes a lot of challenges in 11gR2. However that note doesn’t suggest any workarounds. Read the rest of this entry ».
Perl « SQLMDX
https://sqlmdx.net/category/perl
Eventually it's all about data. Dsvolk Oracle News [ru]. Archive for the ‘Perl’ Category. Evolution of regular expressions. On July 2, 2016. Frankly speaking “evoulution” is not quite proper word to title this post. I’m going to show some extensions in regular expressions in different languages in compare to their implementation in Oracle. Oracle supports regular expressions according to POSIX standard draft 1003.2/D11.2 and two extensions. Matching capabilities for multilingual data.
2013 November « SQLMDX
https://sqlmdx.net/2013/11
Eventually it's all about data. Dsvolk Oracle News [ru]. Archive for November, 2013. Query transformations in Oracle: view merging. On November 14, 2013. Query transformations in Oracle is a part of query optimization. In short, query optimization can be divided into three parts. 1 Logical optimization: query transformation. 2 Physical optimization: searching for optimal access paths, join methods, join orders. 3 Cost Estimator: choosing the optimal plan. Read the rest of this entry ».
Tools « SQLMDX
https://sqlmdx.net/tools
Eventually it's all about data. Dsvolk Oracle News [ru]. 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. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. Blog at WordPress.com.
CBO « SQLMDX
https://sqlmdx.net/tag/cbo
Eventually it's all about data. Dsvolk Oracle News [ru]. Posts Tagged ‘CBO’. Query transformations in Oracle: join elimination. On December 14, 2013. Join elimination appeared in Oracle version 10gR2. Read the rest of this entry ». Query transformations in Oracle: or-expansion. On December 8, 2013. As you may know there are two types of query transformations in Oracle: heuristic-based and cost-based. Read the rest of this entry ». Query transformations in Oracle: view merging. On November 14, 2013. 2 Phy...
TOTAL LINKS TO THIS WEBSITE
2,728
T. Andrews Photo
Saturday, November 17, 2012. Wednesday, November 14, 2012. Saturday, November 10, 2012. Ko'ola Mountains and the Pali Lookout. Wednesday, November 7, 2012. Couple different takes on a lifeguard tower at dawn. Saturday, November 3, 2012. A few shots from the Makapu'u Beach Park on the eastern coast of Oahu at sunrise. The Makapu'u Point Lighthouse is visible in some of them. Wednesday, April 4, 2012. University of South Carolina. Sunday, March 11, 2012. 400mm's and the Referee/Umpire conspiracy.
魔法のブログ からから星☆
からから (ほし) は時空を超え異次元世界からアセンションして地球にやってきたMiroqの素粒子意識です(* `*). あとは審査員のコメントをいただいたりはしましたが、入選まではいかなくて企画出版の勧誘だったり みたいな( ;). 弓玉と楽しむ マヤ文明の叡智 暦 予言 占い マヤFBファンページ. NASA 米航空宇宙局 の専門家らの意見によれば、竜巻カトリーナが及ぼした被害よりも20倍大 きい被害を及ぼしうるとされている。 C) 2018 ブログ JUGEM. マヤ神話 ポポル ヴフ (中公文庫BIBLIO).
無効なURLです
Apache HTTP Server Test Page powered by CentOS
This page is used to test the proper operation of the Apache HTTP server. After it has been installed. If you can read this page it means that this site is working properly. This server is powered by CentOS. The website you just visited is either experiencing problems or is undergoing routine maintenance. For example, if you experienced problems while visiting www.example.com, you should send e-mail to "webmaster@example.com". Are you the Administrator? You should add your website content to the directory.
Tanel Poder\'s blog: Core IT for Geeks and Pros
Tanel Poder's Performance and Troubleshooting blog. Data, Databases, Cloud, Hadoop. Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication. January 24, 2018. I have uploaded the the video of my Secret Hacking Session: Oracle X$TRACE, Wait Event Internals and Background Process Communication to my Oracle performance and troubleshooting Youtube channel. The slides are in Slideshare. January 11, 2018. Since I’m running my Advanced Oracle Troubleshooting Training. Internals hacking ...
İşte Bu! – ıvırla karışık zıvır
Linux terminal altında ağdaki bilgisayarları listelemek. Linux terminal altında ağdaki bilgisayarları netbios isimleri ve ip adresi olarak listelemek için. Arp-scan -I eth0 -l perl -ne '/( d{1,3} .){3} d{1,3})/ and $ip=$1 and $ =`nmblookup -A $ip` and /([ :alnum:]-] ) s 00 ACTIVE /m and printf "%15s %s n",$ip,$1'. D{1,3} .){3} d{1,3})/ and $ip=$1 and $ =`nmblookup -A $ip` and /([ :alnum:]-] ) s 00 ACTIVE /m and printf "%15s %s n",$ip,$1'. Sudo apt-get install netdiscover. Yapacağımız bir kaç işlemle, m...
Taner Kandemir Kişisel Blog Sayfası | Kişisel Blog Sayfası
Taner Kandemir Kişisel Blog Sayfası. Geçmişe Dönüş: Plak Koleksiyonerliği. Plak Koleksiyonumdan Ufak Bir Kesit. Son yıllarda geçmişe dönüşün simgesi sayılabilecek bir hobi son derece ilgi görmeye başladı: Plak Koleksiyonerliği. It’s A Man’s World. 2 önemli ismin güzel bir düeti. Bu konserden sonra, kısa aralıklar ile iki isimde bu dünyaya veda etti. Muhtemelen bu konsere gelenler ne kadar şanslı olduklarının farkında değillerdi. 19 Kasım Uluslararası Erkekler Günü. International Men’s Day. Film endüstris...
Финанси, Контрол, Бизнес Софтуер, ERP Системи, Складови програми
Финанси, Системи за Контрол и Бизнес Софтуер. Top Best Wordpress Themes 2012. Пенсионни фондове и НОИ – Прости сметки. Последно време много взе да се спекулира по темата с пенсионните фондове и усещам, че в цялата тази „дискусия“ се крие нещо, което не ни се представя. Не е нужно да си икономист за да може човек да си направи една проста сметка какво може НОИ в бъдеще да ни предложи. Бързам да уточня, че […]. Коментари ( 2 ). АЕЦ Белене срещу ВЕИ. Коментари ( 0 ). OpenERP – интересно бизнес решение.
TAN FAT
Hearts; ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥ ♥facebook. Tanfat.com duh duh duh duh duh duh duh duh. Aya Jones @ Naomi Campbell’s Fashion for relief charity show 2015. Tuesday Feb 24 @ 12:00pm - reblog. Christopher Kane F/W 2011. Monday Feb 23 @ 12:00pm - reblog. Sunday Feb 22 @ 12:00pm - reblog. Regram from @styledotcom On the list of the sexiest runway shows of all time, according to fashion insiders now on Style.com (Ph. Rex USA) ✨ #Mugler #ThierryMugler. Saturday Feb 21 @ 12:00pm - reblog.
Vores verden
SOCIAL ENGAGEMENT