EddieAwad.com

A River of Useful or Just Fun Stuff 
Tags


Filed under

oracle

 
February 28, 2010

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.

Loading mentions Retweet
Filed under  //   conference   oracle   plsql   portland   sql   sqlsaturday  

Comments [0]

February 14, 2010

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

Loading mentions Retweet
Filed under  //   oracle  

Comments [0]

February 1, 2010

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.

Loading mentions Retweet
Filed under  //   oracle   sql  

Comments [2]

January 24, 2010

Why Oracle Application Express?

via youtube.com

Loading mentions Retweet
Filed under  //   apex   oracle  

Comments [0]

January 21, 2010

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

via blogs.sun.com

Loading mentions Retweet
Filed under  //   oracle   sun  

Comments [0]

December 22, 2009

Think Twice When Creating a Materialized View with the ANSI Join Syntax

When we attempt to create a materialized view with the ANSI join syntax we are surprisingly rewarded with an ORA error.

create materialized view mv2
  refresh fast
  as
    select
      t.key    t_key     ,
      t.val    t_val     ,
      t2.key   t2_key    ,
      t2.amt   t2_amt    ,
      t.rowid  t_row_id  ,
      t2.rowid t2_row_id
    from
      T INNER JOIN T2 ON ( T.KEY = T2.T_KEY )
;
      T INNER JOIN T2 ON ( T.KEY = T2.T_KEY )
      *
ERROR at line 12:
ORA-12015: cannot create a fast refresh materialized view from a complex query
 

While this behaviour appears to be a bug at first glance, Metalink note 420856.1 explains that it is really an undocumented limitation of fast refresh materialized views.

An examination of the EXPLAIN_MVIEW results for this case points to some behind-the-scenes transformations with ANSI syntax which may be causing the limitation.

select
  my_mv_capabilities
  ( 'create materialized view mv2
    refresh fast
    as
      select
        t.key    t_key     ,
        t.val    t_val     ,
        t2.key   t2_key    ,
        t2.amt   t2_amt    ,
        t.rowid  t_row_id  ,
        t2.rowid t2_row_id
      from
        T INNER JOIN T2 ON ( T.KEY = T2.T_KEY )'
  , 'REFRESH_FAST_AFTER_INSERT'
  ) as mv_report
from dual ;
 
MV_REPORT
--------------------------------------------------------------------------------
Not Capable of:
  REFRESH_FAST_AFTER_INSERT
    inline view or subquery in FROM list not supported for this type MV
  REFRESH_FAST_AFTER_INSERT
    inline view or subquery in FROM list not supported for this type MV
  REFRESH_FAST_AFTER_INSERT
    view or subquery in from list
 
via sqlsnippets.com

Got bitten by this bug today (or is it just a limitation?). I had to get rid of ANSI join and use the good old Oracle specific join syntax.

Loading mentions Retweet
Filed under  //   gotcha   oracle   sql  

Comments [0]

September 24, 2009

Oracle SQL Developer 2.1 EA1 Released

Oracle SQL Developer 2.1 Early Access 1 is available for download. Please review the Release Notes before you start. For all other supporting documents, please visit SQL Developer on OTN.

Here's the new feature list :
http://www.oracle.com/technology/products/database/sql_developer/files/NewFeatureList21.htm

Here's the OBE for the new Unit Testing:
http://www.oracle.com/technology/obe/11gr2_db_prod/appdev/sqldev/sqldev_unit_test/sqldev_unit_test.htm

via forums.oracle.com

Download it from http://www.oracle.com/technology/software/products/sql/index21_EA1.html

Loading mentions Retweet
Filed under  //   oracle   sql developer  

Comments [0]

September 20, 2009

36K "Oracle lang:sql" Scripts

In case you're bored, here are 36,000+ Oracle SQL scripts available for your reading pleasure through Google code search.

Loading mentions Retweet
Filed under  //   google   oracle   sql  

Comments [0]

September 17, 2009

A Quick Oracle Metalink Tip

Oracle Metalink (now known as "My Oracle Support" ) has over 300 scripts available. Log on to Metalink and then navigiate to:

Top of page - KNOWLEDGE - TOOLS AND TRAINING - DIAGNOSTIC TOOLS

There's a LOT of stuff available in diagnostic tools. Take advantage of it!

via oraclecommunity.net

Loading mentions Retweet
Filed under  //   oracle  

Comments [0]

September 17, 2009

Foreign Keys and their Usage in the Database (Discussion Paper)

(download)

The paper concludes:

So by all means use Foreign Keys, but don't blindly use them. Use them when it makes sense, when it solves a tuning issue or when maintaining a relationship between tables is crucial to the application running. Just don't use them because that is what you were taught and the relational model says you need them. And don't think you have achieved data integrity in your application if you do use them. You never will achieve it, all you will achieve is different grades of adherence. As you move to the Multimedia world be prepared to adopt a new world view, a fuzzy view and a view that will challenge your core concepts. My view is that the way to best way to tune and ensure optimal database performance is for management to create a culture that promotes excellent Developer/DBA practices.

via foreignkeys.blogspot.com

Loading mentions Retweet
Filed under  //   oracle  

Comments [0]