Excellent Idea! Need to explore this ASAP.
Did anyone ask for this in SQL*Plus as well ?
And Statspack ?
(I'm using scripts evolved over many years and many versions back: snap, list, spool)
#SQLPlus
#SQLcl
#statspack
/cc @connormcd.bsky.social
Quick tip! Take care when using the SQL_ID feedback option. #oracle #sqlplus
connor-mcdonald.com/2022/01/17/careful-with-...
Ernst Leber (@eletwit) gibt in der DOAG Datenbank Kolumne "sqlplus auf dem Tablet" eine Anleitung, wie man mehrere unabhängige Sessions auf einer #Cloud-Datenbank mit #SQLplus starten kann. http://ow.ly/2jzg50GCcZL
Fresh post! Your Friday SQL*Plus quick tip! #oracle #sqlcl #sqlplus
connor-mcdonald.com/2021/09/24/ezconnect-for...
New post! Be careful with the COPY command #sqlcl #sqlplus #oracle connor-mcdonald.com/2019/08/05/take-a-copy-o...
#oratidbit #sqlplus #db18c The SET FEEDBACK SQL_ID command displays the sql_id for the currently executed SQL or PL/SQL statement. The sql_id will be assigned to the predefined variable _SQL_ID.
#oratidbit #sqlplus SQL*Plus product-level security feature will be unavailable in Oracle Database 19c. The PRODUCT_USER_PROFILE (PUP) table provides a mechanism to control product-level security. Starting in 18c, the SQL*Plus PUP table is deprecated.
#oratidbit #SQLPlus With SET FEEDBACK ONLY command, so you can run queries but the resulting rows are not shown in the display. They are still queried and fetched, only the feedback is shown, no rows. Best for testing performance.
A little known but very useful little facility in SQL Plus
https://buff.ly/2AFQTvt #AskTOM … #orcldb #sql #sqlplus
A small video to elaborate on the sqlplus hash command usage. Enjoy the last AskTOM TV episode for 2018 ! https://youtu.be/Ybe3OCPeHoY#AskTOM #orcldb #sql #sqlplus
#oratidbit #sqlplus #db12c When connected to CDB, STARTUP/SHUTDOWN commands start/stop the container database... http://fb.me/7BN2LSwj5
#oratidbit #sqlplus Use the SYSTEM.PRODUCT_USER_PROFILE (PUP) table to disable certain SQL and SQL*Plus commands... http://fb.me/5vQbwr7wH
#oratidbit #db12cR2 #sqlplus To make SQL*Plus run "faster", invoke sqlplus with "-Fast" option. -Fast option sets... http://fb.me/4oArOMXtz
#oratidbit #db12cR2 #sqlplus New SET STATEMENTCACHE to allow statement caching of repeated statements to avoid... http://fb.me/8DtwGVcgZ
#oratidbit #db12cR2 #sqlplus New SET ROWPREFETCH to define the number of rows to prefetch from database at one... http://fb.me/2a1V8YaGs
#oratidbit #db12cR2 #sqlplus New SET LOBPREFETCH to define the amount of LOB data (in bytes) to prefetch from... http://fb.me/324QGXzBi
My first horror movie! (with spooky music) Grab popcorn and watch a career evaporate https://youtu.be/uCgbxGayjXA #oracle #sqlplus
