ORA SPACE

Oracle has released SQL Developer 1.5 (1.5.0.53.38)  last month. I tried that version recently, and found couple of new features that are worth mentioning. Following are the few of the new features that I found useful:

SQL Worksheet

• Flashback. For 10g and 11g, you can use flashback on your data. See the Flashback tab on Tables.
• Separate unshared worksheet for connections for long running queries. Use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet.

Navigator

• Run Manage Database report ( as SYS) to shut down and rest rat database
• Generate DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.

Figure 1: Sample output generated using Navigator: Generate DB Doc option

Connections

• Support for LDAP and Authenticated Enterprise users
• OS Authentication

Tuning

• Open *.trc file in SQL Developer for a formatted trace file.

Reports

• ASH and AWR reports

It seems that Oracle is continuously extending the functionalities available in SQL Developer with every new release. However, I am definitely looking for a dashboard kind of reporting for specific or multiple databases. Hope we should be able to get that feature in future from Oracle or via 3rd party extension.

References:

• OTN: SQL Developer Home Page

This year I got an opportunity to speak at UKOUG 2007 at one of my favorite technology i.e. AS Guard. Following are the session details:

Date: 05-Dec-2007
Time: 11:35 AM
Location: UKOUG 2007 at ICC Birmingham.
Topic: Design Disaster Recovery Site with OracleAS Guard 10g

Presentation Abstract:
OracleAS Guard 10g is a tool to design an effective disaster recovery site for OracleAS 10g applications.

This presentation will discuss general deployment topologies for OracleAS Guard and walk-through the setup process of Disaster Recovery Site using OracleAS Guard. Simplified failover, switchover and fallback scenarios using OracleAS Guard will be explained.

The presentation will also focus on the High Availability functionality that OracleAS 10g offers to DBAs and OracleAS Administrators and how this meets the business requirements.

I recently attended Oracle WebCenter 10g R3 Briefing conducted by Oracle. Putting a glimpse of that session:

Oracle WebCenter (a new member in Oracle Fusion Middleware family) is added as an extension to Oracle JDeveloper. It consists of following components:

Oracle WebCenter Framework – A Oracle ADF based user interface technology that can be used to embed AJAX-based components, portlets, content.
Oracle WebCenter Studio and Oracle WebCenter Composer – Tools that can be used to build and deploy user interface and business flows.
Oracle WebCenter Anywhere – Developing and deploying interfaces for multiple devices e.g. mobule devices and desktop applications like MS Office.
Oracle WebCenter Services – Allow to use Oracle Secure Enterprise Search, Oracle Content Database, and Oracle Records Database, and Web 2.0 capabilities.
Oracle WebCenter Spaces – Meant for group collaboration and communications.

Oracle WebCenter is considered as a common framework for Fusion Applications. Although it makes use of ADF (Oracle’s Application Development Framework), but is based on standards e.g. SOA, Web 2.0, JSR 168, WSRP 1.0 and 2.0. Using JSF Portlet Bridge developers can publish any Java Server Faces application as a portlet.

Oracle WebCenter has a capability for Content Integration using content components (based on JSR 227 Data Controls) to directly access content from a given repository and display in personalized manner using JSF View Components.

Oracle WebCenter Communication Services offers Threaded Discussions, Presence Server and Instant Messaging (Oracle Communicator).

Links: Oracle WebCenter Overview

Well, it was a long break, being off from my blog for a long time.

Now we will share the same rhythm of Oracle Technologies that I promised to share in my first post on this blog.

As promised in my earlier post, to conclude the OracleAS architecture, next post will be covering OracleAS Middle-Tier services.

Well, this is my first post to my first blog ever.

This is an attempt to put some technical insight into latest happenings in IT world related to Oracle technologies especially Oracle Application Server and Oracle E-Business Suite.