tanelpoder.com

Website review tanelpoder.com

Tanel Poder Blog

 Generated on March 29 2026 01:44 AM

Old data? UPDATE !

The score is 61/100

SEO Content

Title

Tanel Poder Blog

Length : 16

Perfect, your title contains between 10 and 70 characters.

Description

- Linux, Oracle, SQL performance tuning and troubleshooting training & writing.

Length : 80

Great, your meta description contains between 70 and 160 characters.

Keywords

Very bad. We haven't found meta keywords on your page. Use this free online meta tags generator to create keywords.

Og Meta Properties

Good, your page take advantage of Og Properties.

Property Content
title Tanel Poder Blog
description - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.

Headings

H1 H2 H3 H4 H5 H6
1 3 0 0 0 0
  • [H1] Tanel Poder Blog
  • [H2] Online & Video Training
  • [H2] Talks & Videos
  • [H2] Latest Articles

Images

We found 5 images on this web page.

5 alt attributes are empty or missing. Add alternative text so that search engines can better understand the content of your images.

Text/HTML Ratio

Ratio : 46%

Ideal! This page's ratio of text to HTML code is between 25 and 70 percent.

Flash

Perfect, no Flash content has been detected on this page.

Iframe

Great, there are no Iframes detected on this page.

URL Rewrite

Good. Your links looks friendly!

Underscores in the URLs

We have detected underscores in your URLs. You should rather use hyphens to optimize your SEO.

In-page links

We found a total of 322 links including 0 link(s) to files

Anchor Type Juice
Home Internal Passing Juice
About Internal Passing Juice
Code Internal Passing Juice
Contact Internal Passing Juice
Topics Internal Passing Juice
Videos Internal Passing Juice
Consulting Internal Passing Juice
Training Internal Passing Juice
Practical Linux Performance & Troubleshooting Internal Passing Juice
Dimensional Analysis of System Performance with eBPF & xtop Internal Passing Juice
Efficient, Always-On Thread Level Observability with eBPF External Passing Juice
Testing the Datadog Explain Plan Visualizer with Oracle execution plans Internal Passing Juice
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity Internal Passing Juice
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates) Internal Passing Juice
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates Internal Passing Juice
pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL Internal Passing Juice
The xCapture and xtop eBPF tools are now in beta, with a demo dataset Internal Passing Juice
CatVector Demo Website Internal Passing Juice
New Tool: xstack - Completely Passive eBPF Linux Stack Profiling Without Any Tracepoints Internal Passing Juice
Webinar: Testing High-Performance Vector Search With CatBench on Google AlloyDB Omni Internal Passing Juice
My Blog Has Turned 18 Years Old Internal Passing Juice
Catbench Vector Search App has Postgres Query Throughput and Latency Monitoring Now Internal Passing Juice
Using Postgres pg_test_fsync tool for testing low latency writes Internal Passing Juice
Find which Oracle SQL_ID hits the SQL*Net break/reset to client event Internal Passing Juice
New Tool: lsds - List All Linux Block Devices and Settings in One Place Internal Passing Juice
Optimizing eBPF I/O latency accounting when running 37M IOPS on a 384-CPU server Internal Passing Juice
xCapture v3: Linux Performance Analysis with Modern eBPF and DuckDB Internal Passing Juice
Core Function Words Translated between English, Spanish, German, French and Swedish Internal Passing Juice
When eBPF task->stack->pt_regs reads return garbage on the latest Linux kernels, blame Fred! Internal Passing Juice
TracepointArgs: List Any Linux Tracepoint with Their Arguments, Datatypes and Related Structs Internal Passing Juice
CatBench Vector Search Playground Internal Passing Juice
Embedding Vectors of the Same Image Rotated Over 360 Degrees Internal Passing Juice
SQL Plan Execution FlameGraphs with Loop and Row Counts Internal Passing Juice
Embedding Vectors vs. Vector Embeddings Internal Passing Juice
Video: Testing the Silk Platform in 2024 Interview (12 minutes) Internal Passing Juice
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a Single Cloud VM Internal Passing Juice
Visualizing and Comparing Embedding Vectors as Heatmaps (Videos) Internal Passing Juice
Visualizing and Comparing Embedding Vectors as Heatmaps Internal Passing Juice
Tracking, not Tracing, Linux Thread Activity for Complete System Visibility (eBPF Summit) Internal Passing Juice
Python Supports Profiling with Perf - How Does It Work? Internal Passing Juice
Can a User Process Consume Kernel Mode CPU Without a Syscall? Internal Passing Juice
Next Big Thing: X-Ray Vision for Linux Systems with eBPF Internal Passing Juice
Syscallargs: List All Linux System Calls With Their Arguments Internal Passing Juice
RTX4090 converted into an eGPU Internal Passing Juice
Oracle Hint Scopes and Join Level Cardinality Hint Internal Passing Juice
New Commenting System Internal Passing Juice
Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumps Internal Passing Juice
Oracle Index Parallel Degree Fix After Parallel Creation or Rebuild Internal Passing Juice
Report Current Oracle Session Wait Chains from GV$SESSION without ASH Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 13: OStackProf for Linux, Unix & MacOSX Clients Internal Passing Juice
Testing Oracle's Use of Optane Persistent Memory, Part 2 - Fast Log File Sync Waits Internal Passing Juice
Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits Internal Passing Juice
MySQL Now Shows its Thread Names at OS Level for Better Troubleshooting Internal Passing Juice
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2) Internal Passing Juice
My New Learning Platform and What I'm Up To in 2022 Internal Passing Juice
Achieving 10 GB/s Scanning Rate in a Single Cloud VM Internal Passing Juice
Testing The Silk Platform - Hands-On Technical Analysis of High-Performance I/O in the Cloud Internal Passing Juice
Virtual Conference: Troubleshooting Very Complex Oracle Performance Problems Internal Passing Juice
Do Not Use '>' in Your Command Prompt (and How to Stay Safe in Shell) Internal Passing Juice
Is Your Linux Version Hiding Interrupt CPU Usage From You? Internal Passing Juice
Video: High Performance Block I/O on Linux Internal Passing Juice
Achieving 11M IOPS & 66 GiB/s IO on a Single ThreadRipper Workstation Internal Passing Juice
Oracle Wait Event Name vs. Display Name Internal Passing Juice
Measuring Java JVM thread activity in Linux with task state sampling Internal Passing Juice
Reasons why SELECT * is bad for SQL performance Internal Passing Juice
High System Load with Low CPU Utilization on Linux? Internal Passing Juice
Hacking Session: 7 Levels of Hint Invalidity in Oracle SQL Internal Passing Juice
Hacking Session: Oracle SQL Monitoring - Understanding the Execution Timeline column and CPU usage Internal Passing Juice
Virtual Conference: Systematic Oracle SQL Optimization Interview Videos Internal Passing Juice
Oracle Fatal Background Processes Internal Passing Juice
Virtual Conference Update: Systematic Oracle SQL Optimization in 2020 Internal Passing Juice
Oracle Shared Pool Internals: List Chunk Position in the LRU List Internal Passing Juice
SchedLat: a Low Tech Script for Measuring Process CPU Scheduling Latency on Linux Internal Passing Juice
Announcing My Retirement (in 2030)! Internal Passing Juice
ORA-12850: Could not allocate slaves on all specified instances error and a workaround for my scripts Internal Passing Juice
Oracle Performance Troubleshooting Without OS Access, Part 1: Identifying CPU Scheduling Latency Internal Passing Juice
Video: Troubleshooting Complex Oracle Performance Problems (Jan 2020) Internal Passing Juice
Hacking Session: Troubleshooting Complex Oracle Performance Problems (January 2020) Internal Passing Juice
help.sql: Show TPT Script Purpose and Syntax Internal Passing Juice
Oracle State Objects and Reading System State Dumps Hacking Session Video Internal Passing Juice
New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1) Internal Passing Juice
Dump Current Oracle SQL Execution Plan Line ID Using Oradebug Internal Passing Juice
pSnapper: Linux Process Snapper Page and Videos Internal Passing Juice
Announcing Linux Process Snapper tool and a Linux Troubleshooting Hacking Session (3rd April 9am PDT) Internal Passing Juice
What Caused This Wait Event: Using Oracle's wait_event[] tracing Internal Passing Juice
Tutorial: Troubleshooting Linux SSH Login Delay - Why does logging in always take 10 seconds? Internal Passing Juice
Practical Linux Performance & Application Troubleshooting Training Details and Table of Contents Internal Passing Juice
Scripts for Drilling Down Into Unknown Optimizer Changes Internal Passing Juice
Visualizing SQL Plan Execution Time With FlameGraphs Internal Passing Juice
Generate Oracle SQL Monitoring Reports as HTML using SQL Developer v18.3 (no Flash needed) Internal Passing Juice
Log file switch (checkpoint incomplete) wait events and LGWR waiting for checkpoint progress Internal Passing Juice
Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions! Internal Passing Juice
Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too! Internal Passing Juice
Webinar: Troubleshooting a Complex Oracle Performance Issue Internal Passing Juice
My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourced Internal Passing Juice
Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication Internal Passing Juice
Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing too Internal Passing Juice
Advanced Oracle Troubleshooting seminar in 2018! Internal Passing Juice
Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Month Internal Passing Juice
GNW01: In-Memory Processing for Databases Internal Passing Juice
My BIWA Summit Presentations Internal Passing Juice
RAM is the new disk – and how to measure its performance – Part 3 – CPU Instructions & Cycles Internal Passing Juice
My New Youtube Channel Internal Passing Juice
Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention Internal Passing Juice
SQL Monitoring in Oracle Database 12c Internal Passing Juice
Advanced Oracle Troubleshooting v2.5 (with 12c stuff too) Internal Passing Juice
RAM is the new disk – and how to measure its performance – Part 2 – Tools Internal Passing Juice
RAM is the new disk – and how to measure its performance – Part 1 – Introduction Internal Passing Juice
The Hybrid World is Coming Internal Passing Juice
Old ventures and new adventures Internal Passing Juice
Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits? Internal Passing Juice
Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable Internal Passing Juice
Oracle Exadata Performance: Latest Improvements and Less Known Features Internal Passing Juice
Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used? Internal Passing Juice
About index range scans, disk re-reads and how your new car can go 600 miles per hour! Internal Passing Juice
Combining Bloom Filter Offloading and Storage Indexes on Exadata Internal Passing Juice
What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux? Internal Passing Juice
Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAIL Internal Passing Juice
Slides of my previous presentations Internal Passing Juice
Where does the Exadata storage() predicate come from? Internal Passing Juice
Oracle X$ tables – Part 1 – Where do they get their data from? Internal Passing Juice
cell flash cache read hits vs. cell writes to flash cache statistics on Exadata Internal Passing Juice
Hard Drive Predictive Failures on Linux and Exadata Internal Passing Juice
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2? Internal Passing Juice
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1? Internal Passing Juice
Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2) Internal Passing Juice
SGA bigger than the amount of HugePages configured (Linux – 11.2.0.3) Internal Passing Juice
Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately? Internal Passing Juice
Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql Internal Passing Juice
Oracle Performance & Troubleshooting Online Seminars in 2013 Internal Passing Juice
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too) Internal Passing Juice
ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support Internal Passing Juice
Oracle 12c: Scalar Subquery Unnesting transformation Internal Passing Juice
Oracle Database 12c R1 (12.1.0.1.0) is finally released! Internal Passing Juice
Getting the Most Out of ASH online seminar Internal Passing Juice
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production? Internal Passing Juice
Debugger Dangers – Part 2 Internal Passing Juice
List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts Internal Passing Juice
List Exadata Disk Layout and Topology with the exadisktopo scripts Internal Passing Juice
V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells Internal Passing Juice
Understanding what a hint affects using the V$SQL_FEATURE views Internal Passing Juice
Listing Exadata storage cells and their configuration info from V$CELL_CONFIG Internal Passing Juice
Alter session force parallel query doesn’t really force anything Internal Passing Juice
asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time Internal Passing Juice
ExaSnapper 0.7 beta download and the hacking session videos Internal Passing Juice
Peeking into Linux kernel-land using /proc filesystem for quick’n’dirty troubleshooting Internal Passing Juice
Even more Snapper – v4.03 now works in SQL Developer too! Internal Passing Juice
Manual “before” and “after” snapshot support in Snapper v4 Internal Passing Juice
Snapper v4.02 and the Snapper launch party video Internal Passing Juice
Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session! Internal Passing Juice
Troubleshooting high CPU usage with poor-man’s stack profiler – in a one-liner! Internal Passing Juice
Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script! Internal Passing Juice
Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-) Internal Passing Juice
Japanese translation of some of my blog articles Internal Passing Juice
What the heck is the INTERNAL_FUNCTION in execution plan predicate section? Internal Passing Juice
A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntax Internal Passing Juice
Snapper v3.61 released – and more work is in progress! Internal Passing Juice
Select statement generating redo – and lost write detection Internal Passing Juice
Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output Internal Passing Juice
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) Internal Passing Juice
The limitations of CURSOR_SHARING = FORCE and FORCE_MATCHING_SIGNATURE for SQL plan stability Internal Passing Juice
MOATS-like sqlplus “top” utility for RAC Internal Passing Juice
Oradebug hanganalyze with a prelim connection and “ERROR: Can not perform hang analysis dump without a process state object and a session state object.” Internal Passing Juice
Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?! Internal Passing Juice
Where is LOB data stored? Internal Passing Juice
Exadata Smart Scan predicate offloading and sequence.NEXTVAL Internal Passing Juice
Create a database link with the new host:port/service syntax Internal Passing Juice
Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis Internal Passing Juice
Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking Internal Passing Juice
Evil things are happening in Oracle Internal Passing Juice
What the heck is the SQL Execution ID – SQL_EXEC_ID? Internal Passing Juice
V8 Bundled Exec call – and Oracle Program Interface (OPI) calls Internal Passing Juice
Full scans, direct path reads and ORA-8103 error hacking session video Internal Passing Juice
Are you getting the most out of your Exadata performance? Part 1 Internal Passing Juice
What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? Internal Passing Juice
Another cache buffers chains latch contention troubleshooting example using LatchProf Internal Passing Juice
Tech Reviewer, Tech Reviewer! ;-) Internal Passing Juice
IOUG Select Journal Editor’s Choice Award 2011 Internal Passing Juice
Knowing what you want to achieve before thinking of how to achieve it – a query optimization example Internal Passing Juice
Running SELECT … INTO :bind_variable from SQL Internal Passing Juice
Latch contention troubleshooting case study and Flashback Database performance issues with LOBs Internal Passing Juice
MOATS: The Mother of All Tuning Scripts! Internal Passing Juice
An index of my TPT scripts Internal Passing Juice
LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051) Internal Passing Juice
Implicit datatype conversion in the parsing phase – something new I learned today! Internal Passing Juice
ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar! Internal Passing Juice
Exadata CAN do smart scans on bitmap indexes Internal Passing Juice
Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes? Internal Passing Juice
Finding Oracle Homes which Oracle instances are using on Linux Internal Passing Juice
New cursor_bind_capture_destination parameter in Oracle 11.2.0.2 Internal Passing Juice
Performance Stories from Exadata Migrations Internal Passing Juice
Is this valid SQL syntax? :-) Internal Passing Juice
Snapper 3.52 – With Oracle 9.2 support! Internal Passing Juice
Asynch descriptor resize wait event in Oracle Internal Passing Juice
A little new feature for shared pool geeks :-) Internal Passing Juice
COUNT STOPKEY operation (the where ROWNUM <= N predicate) doesn't process over ~4 Billion rows and returns wrong results Internal Passing Juice
Read currently running SQL statement’s bind variable values using V$SQL_MONITOR.BIND_XML in Oracle 11.2 Internal Passing Juice
The most fundamental difference between hash and nested loop joins Internal Passing Juice
Oracle Closed World presentation links Internal Passing Juice
Which number takes more space in an Oracle row? Internal Passing Juice
Exadata v2 Smart Scan Performance Troubleshooting article Internal Passing Juice
Dropping and creating tables in read only tablespaces?! Internal Passing Juice
The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements Internal Passing Juice
Oracle memory troubleshooting article Internal Passing Juice
Flexible Sqlplus command line history with RLWRAP Internal Passing Juice
Execution plan Quiz: Shouldn’t these row sources be the other way around ;-) Internal Passing Juice
Quiz: Explaining index creation Internal Passing Juice
cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting Internal Passing Juice
KGH: NO ACCESS – Buffer cache inside streams pool too! Internal Passing Juice
Non-trivial performance problems Internal Passing Juice
Calculate SQL_ID and SQL_HASH_VALUE from SQL text Internal Passing Juice
Oracle Latch Contention Troubleshooting Internal Passing Juice
Oracle Session Snapper v3.10 Internal Passing Juice
How to CANCEL a query running in another session? Internal Passing Juice
New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning Internal Passing Juice
Oracle Troubleshooting: How to read Oracle ERRORSTACK output?! Internal Passing Juice
Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris Internal Passing Juice
Oracle Wait Event reference Internal Passing Juice
Oracle Peformance Visualization… Internal Passing Juice
Bind Variable Peeking – execution plan inefficiency Internal Passing Juice
Recursive sessions… Internal Passing Juice
Sometimes things are easy (Part 1): How to fix wrapped execution plan text? Internal Passing Juice
Beyond Oracle Wait Interface – Part 2 Internal Passing Juice
NULL is not zero! Internal Passing Juice
Measuring what matters Internal Passing Juice
Finding the reasons for excessive logical IOs Internal Passing Juice
Explain Plan For command may show you the wrong execution plan – Part 1 Internal Passing Juice
Detect chained and migrated rows in Oracle – Part 1 Internal Passing Juice
What’s a good way to learn some Oracle internals every day? Internal Passing Juice
SystemTap is production supported in Redhat EL5.4 Internal Passing Juice
KGL simulator, shared pool simulator and buffer cache simulator – what are these? Internal Passing Juice
KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool! Internal Passing Juice
Oracle 11gR2 has been released – and with column oriented storage option Internal Passing Juice
latch: cache buffers chains latch contention – a better way for finding the hot block Internal Passing Juice
Select COUNT(*) and COUNT(column) are different things! Internal Passing Juice
Alter system kill session and ORA-00031: session marked for kill Internal Passing Juice
An interview with me Internal Passing Juice
How to detect when a cursor was closed from SQL trace output? Internal Passing Juice
Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile Internal Passing Juice
(Secret) Preview of Oracle 12g CBO leaked from Oracle labs… Internal Passing Juice
Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdump Internal Passing Juice
Using Perfsheet and TPT scripts for solving real life performance problems Internal Passing Juice
ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql Internal Passing Juice
Oracle Performance Visualization videos from Sydney Internal Passing Juice
Scripts for showing execution plans via plain SQL and also in Oracle 9i Internal Passing Juice
“Free” DBA_HIST AWR views in 11g… Internal Passing Juice
I have been troubleshooting since I was a kid! :) Internal Passing Juice
Tracing Oracle SQL plan execution with DTrace Internal Passing Juice
Seminar feedback and pictures from Singapore Internal Passing Juice
Read OS environment variables using DBMS_SYSTEM.GET_ENV() Internal Passing Juice
I’m an Oracle ACE Director now :) Internal Passing Juice
Oracle 11g: Reading alert log via SQL Internal Passing Juice
Another LatchProfX use case Internal Passing Juice
The real history of Oracle database revealed! Internal Passing Juice
Oracle, Timesten and PL/SQL support Internal Passing Juice
The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling Internal Passing Juice
60000 bind variables?! Maybe it’s time to use a temporary table instead… Internal Passing Juice
SQL_ID is just a fancy representation of hash value Internal Passing Juice
Performance Visualization, Capacity planning and Hotsos Symposium Internal Passing Juice
When was a table last changed? Internal Passing Juice
Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint Internal Passing Juice
Identifying shared memory segment users using lsof Internal Passing Juice
Reliable latch waits and a new blog Internal Passing Juice
Oracle memory troubleshooting, Part 1: Heapdump Analyzer Internal Passing Juice
Performance Visualization made easy – PerfSheet 2.0 beta Internal Passing Juice
A little oradebug enhancement in Oracle 11g Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 9 – Process stack profiling from sqlplus using OStackProf Internal Passing Juice
Transportable tablespaces and ROWID uniqueness Internal Passing Juice
VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles Internal Passing Juice
Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others Internal Passing Juice
Flexible sampling of any V$ or X$ view with sample.sql Internal Passing Juice
Case study on some rowcache internals, cached non-existent objects and a describe bug Internal Passing Juice
Why does even a small difference in SQL text cause a hard parse? Internal Passing Juice
Script: Display valid values for multioption parameters (including hidden parameters) Internal Passing Juice
The simplest query for checking what’s happening in a database Internal Passing Juice
Library cache latches gone in Oracle 11g Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX Internal Passing Juice
Closed database and WITH subquery Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf Internal Passing Juice
Another use case for WaitProf – diagnosing “events in waitclass Other” Internal Passing Juice
Killing an Oracle process from inside Oracle Internal Passing Juice
cursor_space_for_time To Be Deprecated Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain Internal Passing Juice
Debugger dangers Internal Passing Juice
Short note on KGX Mutexes Internal Passing Juice
Generating lots of rows using connect by – safely! Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL! Internal Passing Juice
Performance Tools Quick Reference Guide Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue Internal Passing Juice
Snapper shortcut Internal Passing Juice
Querying the current tracefile name, using SQL – with tracefile_identifier Internal Passing Juice
Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation Internal Passing Juice
Performance and Scalalability Improvements in Oracle 10g and 11g Internal Passing Juice
Using autonomous transactions for sleeping Internal Passing Juice
SQL*Net break/reset to client Internal Passing Juice
SQL*Net message to client vs SQL*Net more data to client Internal Passing Juice
SQL*Net message to client wait isn’t really what it’s thought to be Internal Passing Juice
Oracle hidden costs revealed, part 1 – Does a batch job run faster when executed locally? Internal Passing Juice
Excellent article on Oracle 11g PL/SQL function result cache Internal Passing Juice
Can you write a working SQL statement without using any whitespace? Internal Passing Juice
Expensive calculator… Internal Passing Juice
Why does Oracle parameter count change during session lifetime? Internal Passing Juice
Systematic application troubleshooting in Unix Internal Passing Juice
Perl version of Snapper Internal Passing Juice
Sqlplus is my second home, part 5: Reading the name of currently executing script Internal Passing Juice
Oracle Security, Part 2: Your read only accounts aren’t that read only Internal Passing Juice
Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variable Internal Passing Juice
A simple interview question Internal Passing Juice
How to resolve SQL object and column names all the way to base tables and columns in Oracle? Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 3: More adventures in process stack Internal Passing Juice
Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt Internal Passing Juice
Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP Internal Passing Juice
Operating systems are lazy allocating memory Internal Passing Juice
Advanced Oracle Troubleshooting Guide, Part 2: No magic is needed, systematic approach will do Internal Passing Juice
Oracle Session Snapper, part 2: Getting most out of Snapper Internal Passing Juice
Oracle 11g internals part 1: Automatic Memory Management Internal Passing Juice
Oracle Session Snapper – real-time session-level performance stats for DBAs Internal Passing Juice
Sqlplus is my second home, Part 1: HTMLizing your sqlplus output Internal Passing Juice
Session-level statspack Internal Passing Juice
A gotcha with parallel index builds, parallel degree and query plans Internal Passing Juice
My version of SQL string to table tokenizer Internal Passing Juice
Advanced Oracle Troubleshooting Guide: When the wait interface is not enough [part 1] Internal Passing Juice

SEO Keywords

Keywords Cloud

sql part oracle performance using session exadata linux execution troubleshooting

Keywords Consistency

Keyword Content Title Keywords Description Headings
oracle 117
part 50
troubleshooting 48
sql 41
performance 33

Usability

Url

Domain : tanelpoder.com

Length : 14

Favicon

Great, your website has a favicon.

Printability

We could not find a Print-Friendly CSS.

Language

Good. Your declared language is en.

Dublin Core

This page does not take advantage of Dublin Core.

Document

Doctype

HTML 5

Encoding

Perfect. Your declared charset is UTF-8.

W3C Validity

Errors : 0

Warnings : 0

Email Privacy

Great no email address has been found in plain text!

Deprecated HTML

Deprecated tags Occurrences
<u> 3

Deprecated HTML tags are HTML tags that are no longer used. It is recommended that you remove or replace these HTML tags because they are now obsolete.

Speed Tips

Excellent, your website doesn't use nested tables.
Too bad, your website is using inline styles.
Great, your website has few CSS files.
Perfect, your website has few JavaScript files.
Perfect, your website takes advantage of gzip.

Mobile

Mobile Optimization

Apple Icon
Meta Viewport Tag
Flash content

Optimization

XML Sitemap

Great, your website has an XML sitemap.

https://tanelpoder.com/sitemap.xml

Robots.txt

https://tanelpoder.com/robots.txt

Great, your website has a robots.txt file.

Analytics

Missing

We didn't detect an analytics tool installed on this website.

Web analytics let you measure visitor activity on your website. You should have at least one analytics tool installed, but It can also be good to install a second in order to cross-check the data.

PageSpeed Insights

Device
Categories

Free SEO Testing Tool

Free SEO Testing Tool is a free SEO tool which provides you content analysis of the website.