Blog: Sayan Malakshinov


208 blogs updated: 0 min. ago
SQL validation during PL/SQL compilation
A recent posting on SQL.RU asked why Oracle doesn't raise such errors like "ORA-00979 not a group by expression" during PL/SQL compilation. ...
15
01-05-2017 01:41:06 Sayan Malakshinov Oracle
Intra-block row chaining optimization in 12.2
I've wrote in previous post 4. Next row piece can be stored in the same block only with inserts. When you run update, oracle will place new ...
12
21-04-2017 04:45:10 Sayan Malakshinov Oracle
How to speed up slow unicode migration of a table with xmltype columns
Recently I have had an issue with slow unicode migration of the database upgraded from 10g to 12.1.0.2. The main problem was a table with xm...
16
20-02-2017 02:54:32 Sayan Malakshinov Oracle
row pieces, 255 columns, intra-block row chaining in details
You may know about Intra-block row chaining which may occur when the number of columns in a table are more than 255 columns. But do you know...
20
12-02-2017 03:55:54 Sayan Malakshinov Oracle
How even empty trigger increases redo generation
Very simple example:
3
22-09-2016 01:21:33 Sayan Malakshinov Oracle
8 queens chess problem: solution in Oracle SQL
This is just another solution of this problem for a chessboard, but you can choose any size of the checkerboard: It works quite fast: 8*8 0....
13
13-06-2016 11:43:40 Sayan Malakshinov Oracle
8 knights chess problem: solution in Oracle SQL
This is just another solution of this problem for a chessboard, but you can choose any size of the checkerboard: It works quite fast: 8*8 0....
3
13-06-2016 05:07:35 Sayan Malakshinov Oracle
Maven: how to copy files after a build into several distribution directories
Sometimes it is convenient to copy jar-files automatically after a build into several different directories, for example if you have differe...
3
12-05-2016 01:45:18 Sayan Malakshinov Oracle
WINDOW NOSORT STOPKEY + RANK()
Recently I found that WINDOW NOSORT STOPKEY with RANK()OVER() works very inefficiently: The root cause of this behaviour is that Oracle opti...
3
12-03-2016 01:02:55 Sayan Malakshinov Oracle
Thanks to all #odevchoice voters!
And special thanks to all the great people who voted for me! I want to list all voters for all nomenees in one page: The query (using xt_htt...
16
16-10-2015 18:11:14 Sayan Malakshinov Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.