Profile

Cover photo
Sayan Malakshinov
Works at PromSvyazBank
Attended Tashkent #145
121 followers|68,958 views
AboutPosts

Stream

Sayan Malakshinov

Shared publicly  - 
 
RESULT_CACHE: run-time dependency tracking
create or replace function f_without_deps(p_tab varchar2) return varchar2 as res varchar2(30); begin execute immediate 'select '''||p_tab||''' from '||p_tab||' where rownum=1' into res; return res; end; / create table a as select 'a' a from dual; create table b as select 'b' b from dual; ...
1
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
SQL*Plus tips: #7. How to find the current script directory
You know that if we want to execute another script from the current script directory, we can call it through @@, but sometimes we want to know the current path exactly, for example if we want to spool something into the file in the same directory. Unfortunately we cannot use “spool @spoolfile”, ...
1
Add a comment...

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...

Sayan Malakshinov

Shared publicly  - 
 
#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...
Have him in circles
121 people
Martin Berger (berx)'s profile photo
Alexander Malaev's profile photo
Jared Still's profile photo
Ilya Deev's profile photo
AmKad87's profile photo
Илья Захарчук's profile photo
Andrey Zaytsev's profile photo
Maxim Demenko's profile photo
kyle Hailey's profile photo

Sayan Malakshinov

Shared publicly  - 
 
PL/SQL function gets called twice if the result_cache is used
Recently I showed simple example how result_cache works with non-deterministic functions and observed strange behaviour: a function gets fired once in the normal query, but twice with the result_cache hint. Moreover, only third and subsequent query executions return same cached results as second ...
2
1
Thierry Brouwers's profile photo
Add a comment...

Sayan Malakshinov

Shared publicly  - 
 
How many times have you guessed the right answer? :)
select 1 n,0 n,2 n,0 n,1 n from dual group by grouping sets(1,2,3,2,1,0) order by 0; select 1 n,0 n,2 n,0 n,1 n from dual group by grouping sets(1,2,3,2,1,0) order by 0+0; select 1 n,0 n,2 n,0 n,1 n from dual group by grouping sets(1,2,3,2,1,0) order by 3+7 desc; select 1 n,0 n,2 n,0 n,1 n from ...
1
Add a comment...

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
Sayan 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...

Sayan Malakshinov

Shared publicly  - 
 
Photos taken before video :) #paragliding  
5
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...
People
Have him in circles
121 people
Martin Berger (berx)'s profile photo
Alexander Malaev's profile photo
Jared Still's profile photo
Ilya Deev's profile photo
AmKad87's profile photo
Илья Захарчук's profile photo
Andrey Zaytsev's profile photo
Maxim Demenko's profile photo
kyle Hailey'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
Саян Малакшинов, Малакшинов Саян
Apps with Google+ Sign-in
  • My Talking Angela
Story
Tagline
Oracle performance tuning engineer, JAPH
Education
  • Tashkent #145
  • East-Siberian State University of Technology