Oracle

Listener and Virtual IP

By Franck Pachot . When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That's the role of Transparent Application Failover, but this requires configuration on the client side. If(…)

Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c

By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.

SecureFiles on multi-datafiles tablespaces

By Franck Pachot . When we have a tablespace with multiple datafiles, we are used to seeing the datafiles filled evenly, the extents being allocated in a round-robin fashion. In the old time, we used that to maximize performance, distributing(…)

8 + 1 = 9, yes, true, but …

Btw: If you really would do that (the screen shot is from 12.1.0.2): SQL> alter system set sga_target=210m scope=spfile; System altered. SQL> alter system set sga_max_size=210m scope=spfile; System altered. SQL> alter system set pga_aggregate_target=16m scope=spfile; System altered. SQL>(…)

Service “696c6f76656d756c746974656e616e74” has 1 instance(s).

By Franck Pachot . Weird title, isn't it? That was my reaction when I did my first 'lsnrctl status' in 12.2: weird service name... If you have installed 12.2 multitenant, then you have probably seen this strange service name registered(…)

Trace files segmented in multiple parts as a workaround for bug 23300142

Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc(…)

How many members for standby redo logs?

By Franck Pachot . I see lot of databases with two members for redo logs and also two members for standby redo logs. Why not, but when asking I realized that there are some mis-comprehension about it. And what was(…)

Google Cloud Platform instances and Oracle Database

By Franck Pachot . When it comes to choose a cloud instance to run Oracle Database, you want to be able to run your workload on the minimum CPU cores. This is why in a previous(…)

Oracle 12cR2, RAC, Cloud, ACFS, PDB thin clones and asmadmin

By Franck Pachot . In the Oracle Public Cloud, fast provisioning gets all its meaning when creating a RAC database service: in one hour you can get an operational highly available multitenant database. You can even create it in Data(…)

Misleading wait event names clarified in V$EVENT_NAME

By Franck Pachot . The oracle wait event names were originally implemented for the oracle rdbms developers and are now use by the database users to troubleshoot performance issues. The consequence is that the name may be misleading because they(…)