Overview
News
Technologies
Salaries
Products
People
Growth
Financials
Overview
- Linux, Oracle, SQL performance tuning and troubleshooting training & writing.
News
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier
Here's a little PL/SQL function create_partition_high_value_func.sql that allows you to write SQL queries against data dictionary for partition maintenance automation and examination operations, by converting the cumbersome LONG-datatype to VARCHAR2 on th
Read more
Report
Testing the Datadog Explain Plan Visualizer with Oracle execution plans
Datadog recently released a free online service explain.datadoghq.com where you can paste in your explained SQL execution plans with metrics as JSON text and it visualizes it for you. They support multiple different databases. Hopefully the interactive UI
Read more
Report
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity
Here are two scripts for showing GV$SYSMETRIC_HISTORY contents in a simple tabular way: vstat.sql - show up to one hour of current history at 1-minute granularity from memory awr/dstat.sql - show 1-minute granularity sysmetric history across your entire A
Read more
Report
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
Here's part 3 of my xb.sql & xbi.sql article series that I started writing back in 2019 :-) Part 1 - Show and format execution plans by querying V$SQL_PLAN data directly Part 2 - a href="https://tanelpoder.com/posts/xb-sql-...
Read more
Report
Pro access
Upgrade to see all 38 mentions
Upgrade to a paid plan to read every media mention of this company - funding news, awards, product launches and press releases from all the outlets writing about it.
Every media mention and press release
Funding news, awards and product launches
Fresh coverage from every outlet writing about the company
Upgrade now
Cancel anytime. Secure checkout. Instant activation.