Skip to content

Instantly share code, notes, and snippets.

View berx's full-sized avatar

Martin Berger berx

11 followers · 1 following
View GitHub Profile
@berx
berx / spfileparameter_on_cpus_21.html
Created November 15, 2022 20:23
interactive representation of spfile parameters derived from cpu_count 11 .. 21
This file has been truncated, but you can view the full file.
<!DOCTYPE html>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<html>
<head>
<title>PerfSheet.js</title>
<!-- external libs from cdnjs -->
<style>
body {font-family: Verdana;}
@berx
berx / spfile_parameters_on_cpu_21.csv
Created November 15, 2022 20:09
spfile parameters changed by cpu_count versions 12 .. 21
We can't make this file beautiful and searchable because it's too large.
VERSION,CPUs,PARAMETER,INSTANCE_VALUE
11.1.0.7,1,__db_cache_size,13220446208
11.1.0.7,1,__shared_pool_size,402653184
11.1.0.7,1,_cursor_db_buffers_pinned,15856
11.1.0.7,1,_db_block_buffers,1585890
11.1.0.7,1,_db_block_lru_latches,16
11.1.0.7,1,_enqueue_hash_chain_latches,1
11.1.0.7,1,_enqueue_locks,1590
@berx
berx / best_match_sqlite.sql
Created August 26, 2022 06:55
WITH RECURSIVE testdata as (SELECT 'Max' Name UNION ALL
SELECT 'Moritz' UNION ALL
SELECT 'Maximilian' UNION ALL
SELECT 'Maxim'),
testdata_num as (
Select row_number() over () rn, name, length(name) len
from testdata),
td_count(rn, len) as (
SELECT rn, len from testdata_num
UNION ALL
@berx
berx / index_decoupled.sql
Created January 22, 2022 11:42
Simple (and artificial) example how index-access and table access based on its row-id can be de-coupled.
create index DEPT_DNAME_DEPTNO on DEPT(DNAME,DEPTNO);
With DEPT_DNAME_NO as (
SELECT /*+ qb_name(DEPT_DNAME_NO) no_merge */
d1.dname, d1.deptno, d1.rowid as drid
FROM DEPT d1
WHERE d1.DNAME='RESEARCH'),
EMP_DEP_DNAME_ENAME as (
SELECT /*+ qb_name(EMP_DEP_DNAME_ENAME) no_merge*/
dw.dname, dw.deptno, dw.drid,
@berx
berx / spfile_parameters_on_cpu.csv
Created March 31, 2018 09:08
graphical representation of spfile_parameters changed by CPU_COUNT
We can't make this file beautiful and searchable because it's too large.
VERSION,CPUs,PARAMETER,INSTANCE_VALUE
11.1.0.7,1,__db_cache_size,13220446208
11.1.0.7,1,__shared_pool_size,402653184
11.1.0.7,1,_cursor_db_buffers_pinned,15856
11.1.0.7,1,_db_block_buffers,1585890
11.1.0.7,1,_db_block_lru_latches,16
11.1.0.7,1,_enqueue_hash_chain_latches,1
11.1.0.7,1,_enqueue_locks,1590
@berx
berx / spfileparameter_on_cpus.html
Last active March 31, 2018 09:19
spfile parameters based on CPU_COUNT
This file has been truncated, but you can view the full file.
<!DOCTYPE html>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<html>
<head>
<title>PerfSheet.js</title>
<!-- external libs from cdnjs -->
<style>
body {font-family: Verdana;}