By Franck Pachot . We experienced the first planned outage this week-end, so let’s see how it is notified and what happens. EMEA Commercial 2 – Amsterdam Outage notification before: subject: Announcement: Upcoming Mandatory Maintenance for Oracle Cloud e-mail date: 16 Octobre 2015 1:49 message: Start Time / End Time: Saturday, October 17, 2015 9:00:00 PM CEST – Sunday, October…
By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to do things manually, have maintenance windows. You are ok with a RTO of 5 minutes (time to switchover with Dbvisit…
By Franck Pachot . In previous posts, I’ve installed SLOB on the Cloud Services, measured IOPS and CPU. There’s another resource that is even more important in a cloud environment: network. Tuneling port 1521 over ssh I’ve create a virtual instance by default where only ssh is opened: I don’t want to open other port, so I’m using it with…
By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a consistent state? We know the answer, but want to prove it. This is the kind of question you may have,…
By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the broker. Now we will list the properties that are managed by the broker, but whose default value is not imported from the instance parameters. LogXpt properties Here are the…
By Franck Pachot . When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which parameters are concerned? I’ve divided the parameters in two parts. All are set by the broker, but only some of…
By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back to physical standby. But you don’t want to stay in that state definitely because you will accumulate archived logs from the…
By Franck Pachot . In the previous blog post I measured the time it takes to insert 1 million rows. About 45 seconds when done row-by-row which goes down to 7 seconds when inserted in bulk. In both case, the commit was done only at the end. But in some cases you need to commit at each row, in order…
By Franck Pachot . Great events like IOUG Collaborate is a good way to meet experts we know through blogs, twitter,etc. Yesterday evening, with nice music in the background, I was talking with Leighton Nelson about cloning PDB databases. Don’t miss his session today if you are in Las Vegas. The big problem with PDB cloning is that the source must…
By Franck Pachot . There are several new features in 12c about Data Guard: cascaded standby, far sync instance. But there are also some architecture changes: new processes and new wait events. Here is an example of an AWR report of a LogXptMode=’SYNC’ DataGuard configuration in 11g – which means that the log_archive_dest is defined with: ‘LGWR SYNC AFFIRM’ That…
By Franck Pachot . The Oracle Database Appliance is really interresting for small enterprises. It’s very good hardware for very good price. It’s capacity on demand licensing for Enteprise Edition. But small companies usually go to Standard Edition for cost reasons. Then does it make sense to propose only Enterprise Edition to the small companies that are interrested by ODA?…
By Franck Pachot . If we don’t mind about loosing our changes, then can we disable logging for DML? This is a question I’ve heard a lot. Ok, you don’t need to recover your changes but Oracle may want to recover the consistency of its datafiles anyway. And that’s why datafiles blocks changed though the buffer cache always generate redo.…
