DBA Q & A iPad App

The DBA Q&A (99¢) app presents a collection of Oracle-centric questions and their corresponding answers — written by an author who apparently has studied English as a second language — designed to mimic what a prospective candidate might be asked in a typical DBA job interview. Sweaty palms optional.

via http://www.theregister.co.uk/2010/08/14/ipad_apps/page3.html

Why would someone need an "app" for that?

What! Only 6 results?

mDBA - an iPhone and iPad app for Oracle DBAs

Grant Execute on SYS.DBMS_SYS_SQL, Smart DBAs say NO

The Oracle database ships with a supplied but undocumented PL/SQL package named SYS.DBMS_SYS_SQL. This package enables the execution of dynamic SQL but it also enables the parsing of a statement as a specific database user and with the privileges of this specific database user. This PL/SQL package is highly privileged, obviously. The EXECUTE privilege on this package is not granted to database user, by default. It should almost never be granted to any database user, ever. When asked to grant execution on this package to someone, a smart DBA will always say "no."

via http://joelkallman.blogspot.com/2010/08/application-express-and-parsing-of-sql.html
More from http://www.pythian.com/news/652/using-dbms_sys_sql-to-execute-statements-as-another-user/

Oracle Mergers & Acquisitions: Who’s Next?

With the Sun Microsystems deal closed, SoftwareAdvice.com thought it would be fun to guess who might be next on Oracle’s M&A agenda.

In the post that follows, SoftwareAdvice.com attempt to make a few educated guesses on Oracle’s next move based on the criteria they employed in their past acquisitions. They also want to hear from you. What company do you think will be Oracle’s next target? Be sure to take the survey and express your opinions.

Before we go any further, let’s put this all in context by looking at a graphical illustration of Oracle’s recent M&A activity.

 

continue reading at softwareadvice.com

 

SQLSaturday Open for Registration

On the weekend of May 22, 2010, the Portland Development community is coming together in a way never experienced before.

Using the University of Portland campus, SQLSaturday, Portland Code Camp, and Portland Bar Camp are combining and coordinating efforts to bring 800-1000 regional technology professionals together for the opportunity to immerse themselves in seminars, presentations, group exploration, and networking. Participants will be able to engage in their preferred technology, as well as to 'sample' other options

Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.

>> Click here to register.

Portland SQLSaturday is encouraging presentations related to interoperability of any of the SQL platforms, including T-SQL (SQL Server), PostgreSQL, MySQL, and Oracle PL/SQL. Abstracts for Platform specific sessions are also encouraged. The event is scheduled on Saturday May 22, 2010 from 8:00 AM until 10:00 PM.

Most sessions will be one hour and fifteen minutes (1:15), and a few 'deep dive' sessions will be longer (2.5 hours). The  'deep dive' sessions will be scheduled for 7:00 PM (after the snacks and refreshments.) Also, throughout the day, there may be opportunities for 30 minute 'SQL snack' sessions.

>> Click here to submit your presentation abstract.

I encourage all Oracle SQL and PL/SQL enthusiasts living in the Pacific Northwest to present in and/or attend this not-to-be-missed event.

Thinking Clearly About Performance (paper)

(download)

Creating high-performance as an attribute of complex software is extremely difficult business for developers, technology administrators, architects, system analysts, and project managers. However, by understanding some fundamental principles, performance problem solving and prevention can be made far simpler and more reliable. This paper describes those principles, linking them together in a coherent journey covering the goals, the terms, the tools, and the decisions that you need to maximize your application’s chance of having a long, productive, high-performance life. Examples in this paper touch upon Oracle experiences, but the scope of the paper is not restricted to Oracle products.

via http://method-r.com/downloads/doc_details/44-thinking-clearly-about-performance

Oracle’s SQL Performance Analyzer White Paper

(download)

The SQL Performance Analyzer offers a comprehensive solution to enable users to forecast and analyze how a system change will impact SQL query plans and run time performance, so they can tune their system before they make the change in production. The SQL Performance Analyzer identifies potential problems that may occur and makes suggestions for avoiding any SQL performance degradation. It provides quantitative estimates of the system’s performance in the new environment with high confidence and performs a comparative analysis of the response time of the SQL workload thus allowing for an easy assessment of the change. In this paper we describe the architecture of the SQL Performance Analyzer, its usage model, and its integration points with other Oracle database components to form an end-to-end change management solution.

So long, old friend... James Gosling's tribute to Sun