Main

related bits

0

processing priority

4

site type

3 (personal blog or private political site, e.g. Blogspot, Substack, also small blogs on own domains)

review version

11

html import

20 (imported)

Events

first seen date

2025-01-02 05:59:11

expired found date

-

created at

2025-01-02 05:59:11

updated at

2026-02-19 14:26:31

Domain name statistics

length

24

crc

56556

tld

2211

nm parts

0

nm random digits

0

nm rare letters

0

Connections

is subdomain of id

13642151 (wordpress.com)

previous id

0

replaced with id

0

related id

-

dns primary id

0

dns alternative id

0

lifecycle status

0 (unclassified, or currently active)

Subdomains and pages

deleted subdomains

0

page imported products

0

page imported random

0

page imported parking

0

Error counters

count skipped due to recent timeouts on the same server IP

0

count content received but rejected due to 11-799

0

count dns errors

0

count cert errors

0

count timeouts

0

count http 429

0

count http 404

0

count http 403

0

count http 5xx

0

next operation date

-

Server

server bits

server ip

-

Mainpage statistics

mp import status

20

mp rejected date

-

mp saved date

-

mp size orig

185019

mp size raw text

78529

mp inner links count

11

mp inner links status

20 (imported)

Open Graph

title

jolliffe.hk

description

Patrick's Oracle DBA Blog

image

site name

jolliffe.hk

author

updated

2026-02-18 16:38:53

raw text

jolliffe.hk | Patrick's Oracle DBA Blog jolliffe.hk Patrick's Oracle DBA Blog Skip to content Main menu Home About Contact Post navigation ← Older posts OR Dear Me!  When Cost Based OR  Expansion Gets it Wrong – Part 3 Posted by jolliffe.hk 0 …continued from Part 1 and Part 2 . OK, let’s return to original query before with no index in place and lets review the optimizer’s estimate of how many rows will be returned, and try to deduce where it came from. Note throughout this article, I will be referring to sections in Jonathan Lewis ‘s essential book, Cost-Based Oracle Fundamentals (CBOF). SQL> CREATE TABLE t (c NUMBER(2, 0) NOT NULL, 2* p VARCHAR2(4000)); Table T created. SQL> INSERT /*+append*/ INTO t 2 SELECT 3 mod(ROWNUM, 100) c, 4 rpad('X', 4000) padding 5 FROM 6 dual 7 CONNECT BY 8* ROWNUM exec dbms_stats.gather_table_stats(null, 't', method_opt=>'for all col...

Text analysis

redirect type

0 (-)

block type

0 (no issues)

detected language

1 (English)

category id

Programowanie (97)

index version

1

spam phrases

0

Text statistics

text nonlatin

0

text cyrillic

0

text characters

41726

text words

10950

text unique words

1372

text lines

1020

text sentences

196

text paragraphs

115

text words per sentence

55

text matched phrases

0

text matched dictionaries

0

RSS

rss status

32 (unknown)

rss found date

2025-01-02 05:59:14

rss size orig

100933

rss items

10

rss spam phrases

0

rss detected language

1 (English)

inbefore feed id

-

inbefore status

0 (new)

Sitemap

sitemap status

40 (completed successful import of reports.txt file to table in_pages)

sitemap review version

2

sitemap urls count

70

sitemap urls adult

0

sitemap filtered products

0

sitemap filtered videos

0

sitemap found date

2025-01-02 05:59:12

sitemap process date

2025-03-24 19:20:24

sitemap first import date

-

sitemap last import date

2025-08-04 06:02:26