On a busy system, sometimes, the shutdown immediate takes a huge time.
In order to speed up the shutdown, do alter system checkpoint before the shutdown and it would improve the shutdown time somewhat.
Though not guaranteed, like everything else :).
Active Data Guard is a good new feature in 11g (although requires a license) which enables us to query the Standby database while redo logs are being applied to it. In earlier releases, we had to stop the log apply, open the database in read only mode and then start the log apply again when the database was taken out of the read only mode.
With Oracle 11g Active Data Guard, we can make use of our standby site to offload reporting and query type applications while at the same time not compromising on the high availability aspect.
How do we enable Active Data Guard?
Yesterday Carol Tagliaferri and Roy Swonger gave the Most Common Upgrade Mistakes talk in Moscone South. It was well attended and afterwards so many questions got asked that the whole upgrade development team had plenty of fun taking all those.
Wasn't "Go Green" the headline of last year's OOW?
The healthy food provided in the breaks ... :-(
The fourth edition of Oracle SQL by Example is an excellent resource for not only learning SQL but also for serving as a reference book for experienced users. This book covers the fundamentals as well as more advanced constructs in SQL.
One of the simple scripts I use from time to time monitors the amount of undo generated by a long running session by taking a session id (SID) as an input and joining v$session to v$transaction: column start_scn format 999,999,999,999 select tr.start_scn, tr.log_io, tr.phy_io, tr.used_ublk, tr.used_urec, recursive from v$session se, V$transaction tr where se.sid = [...]
WordPress allows me to see statistics about “referrers” – the places that people came from before getting to my blog. This can be interesting, and potentially useful, information. From time to time the referrer is the “WordPress Dashboard” – which I think means that my blog has appeared on the WordPress front page as one of [...]
Oracle had the new version of the Exadata Machine on display at Oracle Open World this week. It’s called the Exadata X2-8. That’s a catchy name. It sounds very Iron Manish! In fact they had these fellows on display next to the demo machines.
The X2-8 uses two 4U Sun Fire x4800 servers which each have [...]