Featured blog posts
Oracle parallel query hints reference - part 7: PQ_DISTRIBUTE and partitioned tables
![]()
Oracle parallel query hints reference - part 7: PQ_DISTRIBUTE and partitioned tables
Christo Kutrovsky
Published : Oct 19, 2018
Last Updated : Oct 25, 2024
9
min read
Oracle parallel query hints reference - part 6: USE_PARTITION_WISE_GBY
![]()
Oracle parallel query hints reference - part 6: USE_PARTITION_WISE_GBY
Christo Kutrovsky
Published : Aug 27, 2018
Last Updated : May 13, 2025
4
min read
Oracle parallel query hints reference - part 5: PQ_DISTRIBUTE_WINDOW
![]()
Oracle parallel query hints reference - part 5: PQ_DISTRIBUTE_WINDOW
Christo Kutrovsky
Published : Aug 8, 2018
Last Updated : Aug 24, 2023
6
min read
Oracle parallel query hints - part 3: PX_JOIN_FILTER
![]()
Oracle parallel query hints - part 3: PX_JOIN_FILTER
Christo Kutrovsky
Published : Apr 19, 2018
Last Updated : Aug 24, 2023
5
min read
Oracle parallel query hints. A reference series part 2: PQ_REPLICATE
![]()
Oracle parallel query hints. A reference series part 2: PQ_REPLICATE
Christo Kutrovsky
Published : Apr 18, 2018
Last Updated : May 13, 2025
5
min read
Oracle parallel query hints - part 1: PQ_DISTRIBUTE
Oracle parallel query hints - part 1: PQ_DISTRIBUTE
Christo Kutrovsky
Published : Apr 10, 2018
Last Updated : May 13, 2025
15
min read
Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)
![]()
Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)
Christo Kutrovsky
Published : Dec 1, 2017
Last Updated : May 13, 2025
5
min read
Oracle's CREATE INDEX command can take a hint
![]()
Oracle's CREATE INDEX command can take a hint
Christo Kutrovsky
Published : Feb 25, 2016
Last Updated : Aug 24, 2023
2
min read
Exadata Join Offloading in Action
![]()
Exadata Join Offloading in Action
Christo Kutrovsky
Published : Jun 14, 2013
Last Updated : May 13, 2025
8
min read
What's in your Exadata Smart Flash Cache?
![]()
What's in your Exadata Smart Flash Cache?
Christo Kutrovsky
Published : Apr 21, 2011
Last Updated : Aug 24, 2023
5
min read
Designing for Exadata: Maximizing Storage Indexes Use
![]()
Designing for Exadata: Maximizing Storage Indexes Use
Christo Kutrovsky
Published : Aug 13, 2010
Last Updated : Aug 23, 2023
5
min read
Oracle's OPT_ESTIMATE hint: Usage Guide
![]()
Oracle's OPT_ESTIMATE hint: Usage Guide
Christo Kutrovsky
Published : Jun 21, 2010
Last Updated : Feb 2, 2026
2
min read
Adding Columns with Default Values and Not Null in Oracle 11g
![]()
Adding Columns with Default Values and Not Null in Oracle 11g
Christo Kutrovsky
Published : Mar 20, 2009
Last Updated : Aug 23, 2023
2
min read
Recent Spike Report from v$active_session_history (ASH)
![]()
Recent Spike Report from v$active_session_history (ASH)
Christo Kutrovsky
Published : Apr 15, 2008
Last Updated : Aug 23, 2023
3
min read
How to Make an In-Database listener.log File
![]()
How to Make an In-Database listener.log File
Christo Kutrovsky
Published : Apr 7, 2008
Last Updated : Aug 23, 2023
1
min read
Bind Peeking, Ad Hoc Queries, Stable Performance
![]()
Bind Peeking, Ad Hoc Queries, Stable Performance
Christo Kutrovsky
Published : Mar 12, 2008
Last Updated : Aug 23, 2023
4
min read
Pythian goodies: the answer to free memory, swap, oracle, and everything
![]()
Pythian goodies: the answer to free memory, swap, oracle, and everything
Christo Kutrovsky
Published : Dec 19, 2007
Last Updated : Aug 24, 2023
20
min read
How to Recover Deleted Oracle Datafiles with No Downtime
![]()
How to Recover Deleted Oracle Datafiles with No Downtime
Christo Kutrovsky
Published : Nov 7, 2007
Last Updated : Jan 31, 2026
7
min read
Aligning ASM Disks on Linux
![]()
Aligning ASM Disks on Linux
Christo Kutrovsky
Published : Mar 30, 2007
Last Updated : Aug 23, 2023
4
min read
Sequences in Oracle 10g RAC
![]()
Sequences in Oracle 10g RAC
Christo Kutrovsky
Published : Jan 31, 2007
Last Updated : Aug 23, 2023
3
min read
Oracle RAC Cache Fusion Efficiency: A Buffer Cache Analysis
![]()
Oracle RAC Cache Fusion Efficiency: A Buffer Cache Analysis
Christo Kutrovsky
Published : Nov 3, 2006
Last Updated : Aug 23, 2023
6
min read
Oracle: How to move a table to another schema?
![]()
Oracle: How to move a table to another schema?
Christo Kutrovsky
Published : Jul 21, 2006
Last Updated : Aug 23, 2023
2
min read
Oracle 10g R2 RAC - vip on wrong interface
![]()
Oracle 10g R2 RAC - vip on wrong interface
Christo Kutrovsky
Published : May 29, 2006
Last Updated : May 13, 2025
1
min read
ASM multi-disk performance
![]()
ASM multi-disk performance
Christo Kutrovsky
Published : May 12, 2006
Last Updated : Aug 23, 2023
3
min read
.svg){kind=small}
.svg){kind=small}
