Feed aggregator

How to test our Oracle database environment for free

Radoslav Rusinov - Tue, 2005-10-25 01:12
If you want to benchmark your new Oracle9i/10g database environment before to put it in production as a part of your migration procedure, then may be you are one of these who are facing with the problem: How to test my database, where to find a proper tool or program and how much I must pay for that?I just want to share a links to several free programs that can help you to test your Oracle Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com1

EuroOSCON 2005

Omar Tazi - Mon, 2005-10-17 05:20
I just landed a couple of hours ago in Amsterdam after a rather smooth flight from SFO through Chicago O'Hare. I came here to attend EuroOSCON 2005. I am looking forward to this conference where I will also be speaking on Wednesday and reconnecting with all my OSS buddies. I am sure a lot of people are wondering what Oracle is doing for open source, my presenation will touch on this of course but I will also be at the Oracle booth answering questions. Feel free to stop by if you're around.

What did Oracle and Zend Announce this Week?

Omar Tazi - Thu, 2005-10-13 18:21

Earlier this week, Oracle and Zend announced general availability of Zend Core for Oracle. This is exciting news, yet another sign that Oracle understands OSS and how commercial software can complement open source. Oracle is doing all it can to help developers out there with the performance, reliability and robustness they need. Let me try to shed some light on this announcement by answering some of the questions I have been getting.

Who's Zend anyway?
Zend is really the PHP company. They have Andi Gutmans and Zeev Suraski on their payroll, they are Zend's founders and also the original developers who helped PHP founder Rasmus Lerdorf rewrite a new PHP parsing engine in 1997. Andi and Zeev created the very popular open source Zend Engine. Zend's products are used by 8,000 companies worldwide including Lufthansa, Avaya, Sprint, HP and Boeing.

What's Zend Core for Oracle?
Zend Core for Oracle provides out-of-the-box IT organizations with a stable, high performance, easy-to-install and supported PHP development and production environment fully integrated with the Oracle Database. Without Zend Core for Oracle customers had to download all the pieces individually (Apache server, PHP, Oracle DB…) and cobble it all together. This was a very tedious, unpredictable experience that serious enterprises did not want to go through. Zend Core for Oracle is a one stop shop where you get one install file and you know it's going to work and if god forbid, it doesn't you get support from Zend (for PHP-related issues) and Oracle (for database-related issues). Safe feeling, isn't it?

Why should I care? LAMP is FREE!
This is the most frequent question and the answer is very simple. If free was the only criterion, then why is Geronimo not everywhere and why is Oracle still showing strong DB and application server sales, etc.? The truth is, people care deeply about more important things. We worked with Zend to do this because their customers as well as ours wanted us to deliver a solution like Zend Core for Oracle. There are 18 million websites out there written in PHP, scripting languages are too popular today for Oracle to ignore them. Zend is the leader in PHP deployments. It's also important to note that 25-30% of their customers run on Oracle (not all of them are LAMP worshipers). Oracle and Zend noticed that many already had their data in Oracle databases when they started using PHP to write web application. They enjoyed the quick turnaround and easy to deploy experience they got out of PHP. Others come from the LAMP stack and want more stability, performance, security and reliability and moved to Oracle DB. Also organizations with a significant investment in Linux and Oracle now have the option to deploy PHP apps on top of these databases and worry less about the issue of drivers then they may have seen in past. Zend Core for Oracle delivers an updated PHP OCI8 driver, which both companies have worked hard to make more reliable and stable for Oracle Database-driven Web applications.

Have you heard of OPAL? Well it's an acronym just like LAMP but it stands for [Oracle, PHP, Apache and Linux]. Believe me, it is more popular than you think. Zend Core for Oracle is an OPAL system - technically an OPA, it also runs on IBM AIX, Sun Solaris and Windows (currently still in beta).

Bottom line: The real challenge for open source software is to provide the ease of use and a clear chain of accountability that IT organizations require for mission-critical systems. Zend Core is a good answer to that.

What happened to Oracle's commitment to Java/J2EE?
Today, you cannot think ONE language. This is the SOA age. Web services don't care what flavor the portal or the back-end business or persistence logic is written in? We don't need to pick a winner, we support open standards and interoperability. Also, we make sure we keep our finger on the pulse. Scripting languages particularly PHP are very popular, our customers use them, therefore we need to provide them with a pleasant/seamless experience to their job. We are more committed to Java/J2EE than ever, our app server is the fastest growing J2EE container in the market, our tools support the latest Java and J2EE specifications as soon as they are out (and most of the times before – EJB3.0 basis or RI in Glassfish for example).
PHP is actually interoperating quite nicely with Java on various levels. First we have been supporting PHP for 2 years in the Oracle application server. One can write a PHP page and deploy the HTML file on the Oracle container and it will be parsed and rendered seamlessly. Second, PHP5 (unlike PHP4) has great support for SOAP, this means Java can call PHP-based web services and vice versa. Also using BPEL PM, users can orchestrate Web services such that PHP-based partner links can call Java-based services. Finally there is a JSR we are planning to support as soon as it’s ready. It's JSR-223, Oracle and Zend are part of the expert group. It essentially allows Java to call scripting languages and vise versa. With all this in place in the Oracle stack, people could rapidly write PHP pages (if they choose not to use JSF or they already have existing PHP code) and easily talk to back-end business logic written in Java that makes DB calls.

OK, I'm interested where do I start?
I recommend the PHP technology Center on OTN (Oracle Technology Network). In there you'll find a bunch of links to useful resources including upcoming events, installation guides, articles, blogs, best practices and last but not least a link to download Zend Core for Oracle. Zend also has a page on their website specifically for people who are interested in Zend Core for Oracle: www.zend.com/core/oracle. Finally I will be speaking at OSCON next week on this topic. So if you're planning to be there, feel free to drop by the Oracle booth and ask all the questions you want. If you are in the bay area I highly recommend attending the Zend/PHP Conference. Definitely check out Oracle's Ken Jacobs (aka Dr DBA) who will talk about Zend Core for Oracle and the relationship between Zend and Oracle.

Microsoft Befriends Foe and Takes Aim at iTunes

Omar Tazi - Wed, 2005-10-12 23:20

Yesterday (10/11/05) Apple announced record numbers and amazing profits. A third of Apple's revenue comes from iPod sales. So Apple takes the music/media business very seriously. Today Steve Jobs unveiled a new video iPod along with a new complementary version of iTunes that allows people to buy music videos. To top all this Walt Disney and Apple Computer have reached an agreement under which ABC and Disney Channel television shows will be available for download from iTunes for $1.99 per episode. Apple is clearly on a media roll.

All this is beautiful, Right?

Not really. Microsoft astutely chose this moment to settle its problems with RealNetworks in a two-part deal under which Microsoft pays $460M in cash to RealNetworks to settle the antitrust claims and $301M in cash to support RealNetworks' music and games efforts. Microsoft will recoup money by earning credits (amounts were not disclosed) for each Rhapsody subscriber referred through MSN. RealNetworks will support MSN Search and Microsoft will be a huge channel for RealNetworks music and also assist in the performance of RealPlayer on Windows. Here is another big win for RealNetworks: users of MSN Messenger will be able to play music from the Rhapsody catalog of 1 million songs while chatting. More details on this deal can be found here.

Bottom line:
Apple has iTunes the leading online music store, as well as iPod the leading digital music player. I hate to say it but the benefit of the M$FT/RealNetworks alliance is interoperability and openness. The truth is that Apple's strategy is based on customer lock-in (in fact I am one of those locked-in customers). Apple does all it can to make sure people who buy music via iTunes play it on the iPod. Can they continue to do this and maintain market leadership? Microsoft and RealNetworks beg to differ. Let’s see how all this media business unfolds and what role will Yahoo and AOL play in this battle. So stay iTuned... or not.

Oracle Database 10g: Best Practices for Windows Deployments

Radoslav Rusinov - Tue, 2005-09-27 09:09
This presentation is given on the Oracle OpenWorld this year. You can download it from here: Oracle Database 10g: Best Practices for Windows DeploymentsAnother interesting presentation from OOW 2005 is this one: What They Didn't Print in the Doc - HA Best Practices by the Gurus from Oracle Maximum Availability Architecture TeamRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Continuous Improvement vs. Delayed Perfection

Denis Goddard - Sun, 2005-09-25 13:10
Sometimes I get basted for the shortcomings of ADE. Sometimes, basted quite mercilessly. I accept such partially because, after all, I am The Guy Responsible.

But even more so, I accept it because I doubt that ADE's present limitations bother anyone more than they bother me.
I believe I know exactly what is wrong with ADE, both in terms of its current technical architecture, in and terms of the organization needed to properly develop and support it.

It's been a many-year battle to get to the point we're at today. The Proper Architecture is finally -- finally! -- actively being developed, under the name of ADE 4.0 and SCM10. I wish we could have worked on that architecture 7 years ago! The proper organizational structure first started coming together about this time last year, and now, with our Support and QA teams in Bangalore, with well-thought out and well-documented processes, and the with tools of Wiki and iSupport to support those processes, we're able to move forward.

Before coming to work at Oracle, I spent about 5 years working at Cummins Engine. Indeed, a few of the people now on my team (Purush, Rahul) worked with me at Cummins. Cummins was a great place, and I learned a lot there. A big part of what made it great was the attention to Total Quality. I won't bother explaining the full tenets of this religion here, but suffice to say, it's something that I see lacking inside Oracle. Well, my team and I are working to change that, by following Total Quality principles ourselves.

A great tenet of this "Total Quality" religion is:
Continuous improvement is preferable over indefinitely delayed Perfection
In other words, keep making things better with actions now, don't plan for a perfect world in some indefinite future. I have come to realize the wisdom of this philosophy, in everything from software to politics to marriage. I believe that ADE is at a tipping point, that ADE 3.2 will be a huge improvement, and that ADE 4.0 will be even better -- and very close to what I always wanted ADE to be.

Anyway, I didn't want to blather about all that, I wanted to share a rather enlightening little snippet from the Wall Street journal:

As engineers began cooperating and Mr. Srivastava's team worked
overtime to refine the tools, the quality of the code flowing into
Longhorn began to improve. The time to create a new "build" fell to
just a few days, allowing a faster cycle of writing and testing new


These guys take a few days to build their product -- and it's considered a major step forward?
Ooooh baby, I am so glad I am an investor in ORCL, and that I've invested my time in developing ADE!

Thanks for forwarding this to me, Jiri! :)

Oracle Database 10g Release 2 for Windows

Radoslav Rusinov - Fri, 2005-09-09 02:58
Oracle have released the official version of 10g R2 for Windows.The software can be downloaded from here: Oracle Database 10g DownloadsThe Windows-related documentation for R2 is already available as well: Oracle Database 10g Relase 2 Documentation LibraryRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com

Oracle 10g ASM vs. Linux Filesystems, Part 2

Radoslav Rusinov - Fri, 2005-09-09 01:13
Andrew Carr let me to know that there is an interesting follow up to the ASM vs. LVM article on the Wim Coekaerts Blog: ASM vs LVM Wim Coekaerts is the Director of Linux Engineering at Oracle. The post is discussing the interaction between OS buffercache and Oracle buffercache and how they are affected by using ASM or Linux filesystem.Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com2

Bitmap Indexes - History and Future

Radoslav Rusinov - Wed, 2005-09-07 13:05
A small introduction: Bitmap indexes are tailored to data warehouses.In its simplest form, a bitmap index on an index consists of one vector of bits (i.e., bitmap) per attribute value, where the size of each bitmap is equal to the number of records in the indexed relation. For example, if the attribute is day of the week, then there would be seven bitmap vectors for that attribute, one for each Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com5

Oracle 10g ASM vs. Linux Filesystems for non-RAC systems

Radoslav Rusinov - Thu, 2005-09-01 03:16
Bert Scalzo has published an interesting article in Linux Journal that compares the performance of non-RAC Linux systems, which are using the new Oracle 10g feature - ASM versus using of Linux filesystems: Optimizing Oracle 10g on Linux: Non-RAC ASM vs. LVMRadoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com2

A Big Set of Oracle Presentations from NYOUG

Radoslav Rusinov - Fri, 2005-08-26 03:41
On the web site of The New York Oracle Users Group (NYOUG) you can find some very interesting presentations from the recent NYOUG events:June 2005Things You “Know” - from Tom Kyte, Oracle CorporationResource Mapping: A Wait Time-Based Methodology for Database Performance Analysis – from Matt Larson, Confio SoftwarePresents the Resource Mapping Methodology and how it can be used for Wait-Event Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com3

Once More Into The Fray

Radoslav Rusinov - Thu, 2005-08-25 00:45
Mike Ault has published an answer to all comments about the recent published article from Don Burleson: Once More Into The FrayAdded from Rado: All of the comments (from Tom Kyte and other visitors) after the above blog post was deleted from Mike as he declares into his post and here: Comment on "Getting Credible Information" blog postAdded from Rado: Sorry but now I just have discovered that Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com3

The _PGA_MAX_SIZE post is updated

Radoslav Rusinov - Tue, 2005-08-23 12:50
I have updated my post about the _PGA_MAX_SIZE hidden parameter with additional information that pop-up in the past few days.I will appreciate any comments and corrections about my points if you think that they are wrong or you just have more valuable information that I can add to this post.Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Oracle OPatch Security Holes

Radoslav Rusinov - Tue, 2005-08-23 01:05
A new white paper is coming from one of the leading security companies - NGS (Next Generation Security) Software Ltd.It will be related to discovered problems after using of the OPatch utility for applying of Oracle patches and the title is "Patch Verification of Oracle Database Servers".Some quotes from this Eweek news story: Security Firm: Oracle Opatch Leaves Firms Uncovered:A total of more Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Pete Finnigan's Weblog

Radoslav Rusinov - Mon, 2005-08-22 10:28
Pete Finnigan has mentioned my blog in his Oracle Security weblog, especially the security-related post: How to see the MOD_PLSQL passwords in clear textThanks to him for his comments!I want to note that this information can be found at his book: Oracle Security Step-by-Step (Version 2.0) as step 8.1.2 from Phase 8 - Application Servers and the Middle Tier.Additional information online:Fact Radoslav Rusinovhttp://www.blogger.com/profile/18163031714036680150noreply@blogger.com0

Autotrace enhancement in 10g release 2

Adrian Billington - Mon, 2005-08-22 03:00
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005

Flashback restore points in oracle 10g release 2

Adrian Billington - Mon, 2005-08-22 03:00
Restore points enable us to capture a point in time for flashback operations. August 2005

Flashback version query in oracle 10g

Adrian Billington - Mon, 2005-08-22 03:00
We can now view the evolution of our data with flashback version query. August 2005

Enhancements to dbms_output in 10g release 2

Adrian Billington - Mon, 2005-08-22 03:00
Oracle finally "fixes" DBMS_OUTPUT. August 2005

Dml error logging in oracle 10g release 2

Adrian Billington - Mon, 2005-08-22 03:00
A new error logging mechanism for bulk DML statements. August 2005


Subscribe to Oracle FAQ aggregator