Archive for the ‘Uncategorized’ Category
Intel offers Time travel at OOW2008

I’m writing online at the keynote with Paul Otellini, after the strong commitment signal expresed by Oracle that Intel is their preferred platform.
He is introducing us to a brief historic recount of CPU, Business (example FedEX) and Animation (example Dreamworks) milestones.
The core idea is a perspective of accelerated demands our computing systems are facing, and succesfully achieving through the improvements the chip makers are offering to the market, specially Intel. The summary shows that Intel is helping to do more within the same time, which in perspective may be interpreted as a “slowing” time effect.
Shared with us the benchmark results for the brand new Xeon 7400 which with his 6 cores and capabilities for working concurrently with up-to 16 sockets, overpasess the Xeon 5400 and Itanium products. The commercial spot is “Oracle runs better on Intel”.
Revealed next innovation steps on Itaniun Tukwila and Xeon Nehalem EX, with count above thousands of millions of transistors.
Intel support to multicore exploit coulnd’t be more encouraging, they’ve developed and are offering a tool to discover the parallel oportunity on current application’s code.
Enterprise Cloud is a task that Oracle and Intel pretend to tackle in tandem. With deep cooperation among them, that goal seems already done, and we may see fruits from that tree quite soon I guess.
Stay tunned, I’ll continue this OOW2008 covering
Non tech post…. sunday!
I’m exhausted, today we had maintenance for a Peoplesoft database: boy, what a monster! lot of table moving and index rebuilds (were moved to another tablespaces), but if was faster than using export/import; did this same thing 2 years ago and it took 9 hours with exp/imp, now this baby has 6 times the size it had those days: 600Gb!!.
It required a 12 hour window, and fortunately all timings were accurately predicted, therefore we released the database on schedule…yes!!!
Tomorrow we will know if any of my proposals are accepted for Oracle Open World 2008 (crossing my fingers). San Francisco here we go!!!
Fortunately I’ve a couple of days off starting tomorrow, and you know? I’m going to rest a lot.
Have a nice week!
When your archive log destination is full
Have you experienced a sudden transaction blast, which fills your archive log destinations within minutes? Do you remember what your first reaction is? I’ll try to help you:
a) Erase the archive logs and later crosscheck them
b) Move previous archive logs to free-up some space
c) Close your application and trigger an archive log backup
But, and this is an awareness-but: What if you’re using Flashback recovery? What if this archive activity is the result of a very important process? think, that you may be in risk of losing a vital period of activity.
Well, you don’t have to worry anymore: the archive log destinations provide the flexibility of dynamic change, therefore you may issue an ALTER SYSTEM and redirect the output generated by the archive writer process to another directory. The statement is really simple:
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST='your new filesystem' SCOPE=MEMORY;
The best part of all, you don’t have to worry about operations on new archive log generated files or previous ones: the database keeps track of every file, saving the full path at the time of writing, therefore recovery and backup operations will have the right information to proceed successfully. You only have to worry about space availability.
I hope this post help you, please leave your comments and suggestions.
Leave a Comment
Comments (2)
Leave a Comment