Laurentschneider - laurentschneider.com - Laurent Schneider
General Information:
Latest News:
Monitoring details on your explain plan 12 Aug 2013 | 06:29 pm
We know how to generate an explain plan. SET AUTOT ON, the good old ambulance in Toad (which is no longer an ambulance those days), the explain plan button in SQL Developer or simply EXPLAIN PLAN Exp...
encrypt with openssl 5 Jul 2013 | 10:06 pm
I want to avoid cleartext password on my filesystem I encrypt my password with a secret key Whenever I call a script, I pass the secret key Of course you still need the key {MyKey}, but unless you ...
One more obscure syntax 1 Jul 2013 | 01:47 pm
As 10g introduced MODEL, which is mostly used to impress your colleagues but seldom used in production, 12c has a new syntax, MATCH_RECOGNIZE I gave it a first try to recognize trends in EMPs salarie...
Best Price 899.95$ for my book 1 Jul 2013 | 01:11 pm
I just discovered a best price for my book : Which is obviously more money than I will ever get from my editor
Google Reader end of life 1 Jul 2013 | 12:03 pm
For those of my readers who were using Google Reader, here are my comments 1) backup your data, read this : https://support.google.com/reader/answer/3028851 2) for the web gui, there is a one-click ...
ODBC 32bits for Windows 64bits 19 Jun 2013 | 06:21 pm
Windows-On-Windows 64-bit (WOW64) enables you to run 32bits applications in 64bits OS. You will see there is another powershell, another registry, another ODBC tool, another Oracle client. %SYSTEMROOT...
Oracle ODBC hello world with powershell 18 Jun 2013 | 05:44 pm
Demo : cmd /c "odbcconf.exe /a {configdsn ""Oracle in OraClient11g_home1"" ""DSN=helloworld|SERVER=DB01""}" Create a helloworld data source connecting to your DB01 tns alias in your OraClient11g_home1...
how to rename datafiles on standby 14 Jun 2013 | 09:27 pm
If you rename a file with alter database on primary, it will not occur on standby. If you want to rename it on standby to, you need to do it manually cancel the recovery (set dg_broker_start to false ...
Best practice : use double quotes, even in DBMS_STATS 11 Jun 2013 | 01:38 pm
Whenever you create a table, it is better to use double quotes to avoid invalid identified. SQL> CREATE TABLE /XXX(x number); CREATE TABLE /XXX(x number) * ERROR at line 1: ORA-00903: inv...
Rman backup compression 5 Jun 2013 | 05:15 pm
Did you know you can make your backup at least twice faster with a single line ? Demo : RMAN> backup as compressed backupset database; Starting backup at 2013-06-05_13:08:01 ... Finished backup at 201...
