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 …
Oracle – what is filling up my diag directory and sub-directories Read More »
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 …
What is Oracle 12c dbms_stats.gather_schema_stats doing by default? Read More »
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 …
An Oracle SQLPlus / SQLCL script that generates sql statements then executes them Read More »
The following controls both sqlDeveloper & sqlCL defaults. Select off the sqlDeveloper Menu: Tools->Preferences->Database-Utilities-Export or Tools->Preferences->Database-Utilities-Import
When you setup a share with VirtualBox – normally – it is only accessible to root (the priviledged user that mounted it). To give other users access to that share add (append) the group vboxsf – to the existing groups (note: important to append with the -a switch so that you do not lose existing …
Add a Linux user to access your virtualbox share Read More »
Need a very simple way to export Oracle data to CSV format – and import from CSV format? Here is a fairly easy example of doing both sides (import and export) using Oracle’s early adopter “sqlcl” product. And yes, there are many other ways to accomplish this. Once your have this method down – the …
Oracle SQLCL – Use SQLCL to simply export via SET SQLFORMAT CSV and import via load Read More »