garbagedump

weathered

weathered

issues I face at the workplace I love-hate & then forget about, just to face them again. solely for personal ref, please be cautious :) know a better solution? help me learn :D 0xweathered@gmail.com

sql | dev | automatic partitions for the lazy kind - automatic list partitioning

Oct 16, 20213 min read62 views

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

sql | dev | automatic partitions for the lazy kind - automatic list partitioning

sql | how to avoid multiple identical subqueries in the SELECT clause

Oct 16, 20212 min read39 views

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

sql | how to avoid multiple identical subqueries in the SELECT clause

sql | how NOT to avoid multiple identical subqueries in the SELECT clause

Oct 15, 20211 min read35 views

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

sql | how NOT to avoid multiple identical subqueries in the SELECT clause

dba | ORA-01000: maximum open cursors exceeded

Oct 15, 20211 min read24 views

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

dba | ORA-01000: maximum open cursors exceeded

sql tuning | calculating logical reads made by a query

Oct 15, 20211 min read28 views

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

sql tuning | calculating logical reads made by a query

sql | duplicating a resultset

Oct 15, 20211 min read34 views

there has to be an easier way other then CTRL+C CTRL+V, right? CARTESIAN QUERY SELECT X.* FROM ( 'INSERT SELECT STATEMENT HERE' ...

sql | duplicating a resultset