id
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)
first seen date
2024-04-21 04:46:56
expired found date
-
created at
2024-06-30 11:35:28
updated at
2026-02-14 01:41:58
length
18
crc
62794
tld
2211
nm parts
0
nm random digits
0
nm rare letters
0
is subdomain of id
69893241 (blogspot.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)
deleted subdomains
0
page imported products
0
page imported random
0
page imported parking
0
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 bits
—
server ip
-
mp import status
20
mp rejected date
-
mp saved date
-
mp size orig
174317
mp size raw text
102220
mp inner links count
79
mp inner links status
20 (imported)
title
About Oracle
description
About Oracle
image
site name
author
updated
2026-02-12 14:19:15
raw text
About Oracle skip to main | skip to sidebar About Oracle Simplicity is the ultimate form of elegance and sophistication Pages Home Presentations and papers Monday, February 19, 2018 Filter predicates with NVL on mandatory columns using the index Last Friday at work, I overheard a conversation between two DBA's about a performance problem of a job which usually ran in 10 minutes, now taking more than 4 hours. I helped them pinpoint the problem: a simple SQL query which took >95% of the time. Clearly this query was the culprit. The query selects from just one table but with 10 filter predicates of this form: nvl(column,'@') = nvl(:bind_variable,'@') And all 10 columns where part of a single unique constraint. The trace file showed the query being executed 1500 times and the unique index belonging to the unique constraint was not being used, resulting in 1500 full table scans. Your index won't be used if you use a function around your column, like shown here. Thi...
redirect type
0 (-)
block type
0 (no issues)
detected language
1 (English)
category id
230
index version
2025123101
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
56092
text words
14054
text unique words
2250
text lines
1738
text sentences
378
text paragraphs
190
text words per sentence
37
text matched phrases
2
text matched dictionaries
4
links self subdomains
0
links other subdomains
17 - forums.oracle.com, oracle-randolf.blogspot.nl, rwijk.blogspot.nl, blog.whitehorses.nl, deneskubicek.blogspot.nl, joelkallman.blogspot.nl, dgielis.blogspot.nl, community.oracle.com, bluefrog-oracle.blogspot.nl, asktom.oracle.com, tahiti.oracle.com, technology.amis.nl, jlcomp.demon.co.uk, apex.oracle.com
links other domains
30 - rwijk.nl, ogh.nl, oracle.com, use-the-index-luke.com, oraclecommunity.net, plsqlchallenge.com, oracle-and-apex.com, talkapex.com, danielmcghan.us, orchestrapit.co.uk, robstourpools.nl, muyeli.com, centrexcc.com, tanelpoder.com, laurentschneider.com, oracle-developer.net
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
39 - blogger.com, apexplained.wordpress.com, twitter.com, oracle-wtf.blogspot.com, jonathanlewis.wordpress.com, oracle-randolf.blogspot.com, richardfoote.wordpress.com, nuijten.blogspot.com, dgielis.blogspot.com, joelkallman.blogspot.com, ronr.blogspot.com, plsql-challenge.blogspot.com
links ext klim
0
links ext generic
0
dol status
0
dol updated
2026-02-12 14:19:15
rss status
32 (unknown)
rss found date
2024-04-21 04:46:56
rss size orig
44428
rss items
25
rss spam phrases
0
rss detected language
1 (English)
inbefore feed id
-
inbefore status
0 (new)
sitemap path
sitemap status
30 (processing completed, results pushed to table crawler_sitemaps.ext_domain_sitemap_lists)
sitemap review version
2
sitemap urls count
154
sitemap urls adult
0
sitemap filtered products
0
sitemap filtered videos
0
sitemap found date
2024-04-21 02:27:03
sitemap process date
2025-03-18 23:19:14
sitemap first import date
-
sitemap last import date
-