Profile

Cover photo
Sayan Malakshinov
Works at PromSvyazBank
Attended Tashkent #145
114 followers|63,245 views
AboutPosts

Stream

Sayan Malakshinov

Shared publicly  - 
 
SQL> with function f return int is 2 begin 3 for r in (select value from v$mystat natural join v$statname where name like 'IM scan rows') loop 4 dbms_output.put_line(r.value); 5 return r.value; 6 end loop; 7 end; 8 select f() from t_inmemory where rownum<=1 9 ; 10 / F() ---------- 0 1 row ...
1
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
I've just noticed an interesting thing: Assume, that we have a simple query with “MIN(ID)” that works through “Index full scan(MIN/MAX)”: SQL> explain plan for 2 select 3 min(ID) as x 4 from tab1 5 where ID is not null; Explained. SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT ...
1
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
I've just published Simple oracle client for android: https://play.google.com/store/apps/details?id=com.xtsql.SimpleAndroidOracleClient
Posted on December 30, 2014 by Sayan Malakshinov Posted in oracle. I am happy to announce, that I've just published my first android app – Simple oracle client for android! Since this is only the first version, I'm sure that it contains various UI bugs, so I'll wait for reviews and bug reports!
5
Add a comment...
 
#FreeFlying  #paragliding  was very exciting! :) 
Starting position at an altitude of over 1,300m + flew up to +300m above

ps. зато след. 5 дней я "одиноко одинокий одиночка"©Ледниковый период :(
 ·  Translate
4
Ilya Deev's profile photo
 
Здорово! :)
 ·  Translate
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
It is well known thing and you can even find it on MOS, but I have a little more simple script for it, so I want to show little example. First of all we need to start script on local database: SQL> SQL> @transactions/global.sql Enter filters(empty for any)... Sid : Globalid mask : Remote_db ...
1
Add a comment...

Sayan Malakshinov
owner

General  - 
 
It seems strange to me: When all needed columns are in the index, filter predicates are expectedly applied to the index select a,b from xt_test where a=1 and (:b is null or b = :b) ----------------------------------------------------------------------------------------- | Id | Operation | Name ...
1
Add a comment...
Have him in circles
114 people
Игорь Афонин's profile photo
Pavel Popov's profile photo
Anton Bushmelev's profile photo
Nikolay Kravtsov's profile photo
Алексей Ч's profile photo
Anna Petr's profile photo
Михаил Поляков's profile photo
Aliaksandr Kokhno's profile photo
Baza NaKalinovke's profile photo

Sayan Malakshinov

Shared publicly  - 
 
Easy quiz: rownum < NaN. Posted on February 11, 2015 by Sayan Malakshinov Posted in oracle, SQL. As you know, NaN is a “Not a Number”. How do you think, what would be the result of the following query? (0f/0 == NaN) select count(*) cnt from dual where rownum < 0f/0; ...
1
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
Simple Android Oracle client is a simple app that allows you to execute sel...
2
1
Martin Berger (berx)'s profile photoSayan Malakshinov's profile photoAnton Bushmelev's profile photo
6 comments
 
+Anton Bushmelev sorry, but not in this version. i have plans to add templates, but i'l think about scripts too. Thanks! 
Add a comment...
 
Photos taken before video :) #paragliding  
4
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
I have a couple scripts for plans comparing: 1. https://github.com/xtender/xt_scripts/blob/master/diff_plans.sql 2. http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active.sql. But they have dependencies on other scripts, so I decided to create a standalone script for more ...
1
Add a comment...

Sayan Malakshinov
owner

General  - 
Posted on March 21, 2014 by Sayan Malakshinov Posted in oracle, PL/SQL, runstats, statistics, troubleshooting, undocumented. Craig Shallahamer wrote excellent article “When is v$sesstat really updated?”. And my today post just a little addition and correction about the difference of updating 'Db ...
1
Add a comment...

Sayan Malakshinov
owner

General  - 
In previous posts about caching mechanism of determinstic functions I wrote that cached results are kept only between fetch calls, but there is one exception from this rule: if all function parameters are literals, cached result will not be flushed every fetch call.
1
Add a comment...
People
Have him in circles
114 people
Игорь Афонин's profile photo
Pavel Popov's profile photo
Anton Bushmelev's profile photo
Nikolay Kravtsov's profile photo
Алексей Ч's profile photo
Anna Petr's profile photo
Михаил Поляков's profile photo
Aliaksandr Kokhno's profile photo
Baza NaKalinovke's profile photo
Work
Occupation
Oracle performance tuning engineer
Employment
  • PromSvyazBank
    Senior oracle performance tuning engineer, 2011 - present
  • BaikalWestCom
    Oracle developer, 2006 - 2011
Basic Information
Gender
Male
Relationship
Married
Other names
Саян Малакшинов, Малакшинов Саян
Story
Tagline
Oracle performance tuning engineer, JAPH
Education
  • Tashkent #145
  • East-Siberian State University of Technology