Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
sql | dev | automatic partitions for the lazy kind - automatic list partitioning
nah, using sample schema is way easier actually, lets go to HR lets say i want to make a stripped down table identical to the EMPLOYEES table, paritioned, by DEPARTMENT_ID column. so if i am using the HR.EMPLOYEES table, SELECT COUNT(DISTINCT DEPAR...
Oct 16, 20213 min read64
sql | how to avoid multiple identical subqueries in the SELECT clause
continuing from sql | how NOT to avoid multiple identical subqueries in the SELECT clause these won't work if your db is older than 12c. if it is lower, i guess the how NOT to is the how to, not an expert don't quote me on that. and no i don't want ...
Oct 16, 20212 min read40
sql | how NOT to avoid multiple identical subqueries in the SELECT clause
running 12c or higher? how to inline subqueries in SELECT clauses, or simply scalar subqueries, as you can guess by the name, is used to return a single value. but what if, i am having to query a specific table, writing identical subqueries to fet...
Oct 15, 20211 min read37
dba | ORA-01000: maximum open cursors exceeded
not the best place for explanations here, the below query shows the number of open cursors present in a session. if the number reaches the db parameterOPEN_CURSORS, ORA-01000 is thrown. OPEN_CURSORS := number of cursors each session can have open, pe...
Oct 15, 20211 min read27
sql tuning | calculating logical reads made by a query
one day a dba reported high resource usage by a query, but it was 'well-optimized' and the runtime was as expected, then what was wrong? logical read was high. to calculate logical reads made by a query: DECLARE READS NUMBER; OUTPUT NUMBER; ...
Oct 15, 20211 min read36