Oracle – what is filling up my diag directory and sub-directories

Oracle – what is filling up my diag directory and sub-directories sqlplus / as sysdba SQL> show parameter diag NAME                     TYPE     VALUE ———————————— ———– —————————— diagnostic_dest              string     /oracle/SILVER [oracle@silver ~]$ cd /oracle/SILVER/diag [oracle@silver diag]$ ls asm  clients  crs  diagtool  lsnrctl  netcman  ofm  rdbms  tnslsnr Ok, so…

What is Oracle 12c dbms_stats.gather_schema_stats doing by default?

What is 12c dbms_stats.gather_schema_stats doing by default?  It uses predefined dbms_stats preferences.  Here an example of how to show those preferences on 12c – some of the listed preferences below are new to 12c.  Then an example of how to show what a gather_schema_stats call will do for default calls. Here is a call to dbms_stats.gather_schema_stats…

An Oracle SQLPlus / SQLCL script that generates sql statements then executes them

Here is a easy example of a sql script that generates sql statements and then executes them. Hope it helps.  Mike SET PAGESIZE 0 SET TERMOUT OFF SET TRIMSPOOL ON SPOOL executeStatements.sql SELECT ‘SELECT count(*) from dba_tables where owner=”’||trim(username)||”’;’ from dba_users WHERE ROWNUM < 15; SELECT ‘SELECT count(*) from dba_indexes where owner=”’||trim(username)||”’;’ from dba_users WHERE…

How to set import and export preferences in sqlDeveloper and sqlCL

The following controls both sqlDeveloper & sqlCL defaults. Select off the sqlDeveloper Menu: Tools->Preferences->Database-Utilities-Export or Tools->Preferences->Database-Utilities-Import