Tuesday, 27 November 2012

Book Review: Oracle Database XE 11gR2 Jump Start Guide by Asif Momen

The renowned Oracle ACE, Asif Momen deserves full credit in producing a quality work on Oracle database overview and awareness of related terms. The style of the Packt's book "Oracle Database XE 11gR2 Jump Start Guide" is a perfect KISS (Keep It Short and Simple). Best aspect being that the book successfully drives its objectives and maintains a consistent tone throughout. The scope of the book has been well measured and maintained. The content is aimed to give the readers an overview of concepts instead of digging the depts or internals. Quite often, I have seen readers misinterpret quick ref (jump start) guide against complete reference books. As Rome was not built in a day, one shouldn't expect to be an expert in the area by the end of a jump start guide.

Here is an outline of the chapters in the book -

Chapter 1 starts with a touch to Oracle corporation. Briefly, it covers the database editions offering from Oracle. One might expect a column on feature comparison across the editions - but Asif has provided the corresponding Oracle link under References section. The chapter ends up with the focus on Oracle database XE edition.

Chapter 2 talks about the installation of Oracle database XE edition. The chapter includes only what is required for one to start up with the things which justifies the purpose of the book.

Chapter 3 shows how to connect to the database and configure the listener. It also includes a section on SGA, PGA and AMM. However, memory management is separately discussed in chapter 8 too.

Chapter 4, 5 and 6 takes a refreshing tour of programming and development part of Oracle. Readers can refresh concepts like querying and manipulating data, database objects (tables, indexes, views,
sequences), Oracle subprograms (functions and procedures), packages, triggers, and exception handling.

Chapter 7 demonstrates the elementary usage of Oracle Application express. Since APEX comes with Oracle db XE installed, it might be useful for RAD using APEX.

Chapter 8 provides information on Oracle instance and the physical/logical database structure. Basic operations with tablespaces are well illustrated through scripts.

Chapter 9 discusses movement of data between the servers using export/import and data pump method. Export/import of full db, schema and a table are illustrated. I was expecting a comparative study
between data pump and conventional export/import with the list of available options available during export/import and data pump techniques.

Chapter 10 shows the step by step upgrade process from Oracle XE to other database editions.

Chapter 11 provides conceptual overview of backup and recovery concepts in oracle.

Chapter 12 gives you insights on best, may be better practices to tune the Oracle 11g XE database. It touches the concepts like explain plan, indexing techniques, statspack, and statistics.

The book would serve as a light Starter for those who chose the area and aim to tweak in more on the subject. Buy this book from the publishers link: http://www.packtpub.com/oracle-database-xe-11gr2-jump-start-guide/book

 

 


 

Monday, 12 November 2012

Its time to Light up!!

Wish you all great Diwali.

Here comes the lights. Have a safe, prosperous and lightening Diwali. Though we pledge for silent celebrations this Diwali in interest of air, but I still long for the excitement of noisy and smoky crackers.

May this Diwali enlightens your life with prosperity, happiness, care, affection, health, growth and all success.

[caption id="attachment_559" align="aligncenter" width="263"]Happy Diwali Happy Diwali 2012[/caption]

Thursday, 8 November 2012

Oracle NoSQL Kvstore (1.2.123) deployment demo

With the next turn fold of web2.0, database paradigms have molded their behaviors too to map the requirements and expectations. NoSQL is a database of modern times where the database platform is need based rather than rule based. Rather being generic, traditional or conventional, its more suited for limited - perhaps specific requirements. Leading software giants like Facebook, Amazon, Oracle have already came up with their own idea of NoSQL databases. Its difficult to digest the fact that current more than 130 flavors of NoSQL databases available.

I have tried to deploy a 3 node datacenter on Virtualbox using Oracle's NoSQL product offering. I would like to share the demonstration along with fair understanding. Here is the abstract and the demo doc for download.

Oracle NoSQL Overview


Oracle NoSQL offers a non relational, distributed and horizontally scalable datastore to achieve high availability with a simplified data model.

The article describes how to setup a 3-node Oracle NoSQL Kvstore datacenter on Oracle Virtualbox. The objective of the demonstration is to allow users to setup the datacenter on their local environment and carry out hands-on activities in regards to NoSQL administration.

The article starts with a brief introduction to NoSQL and the Oracle offering. It lists the prerequisite products used for the demonstration and summarizes the setup information. Later the datacenter deployment has been demonstrated in detail supported with required screenshots.

NoSQL: The Introduction


NoSQL is one of the emerging database solution in the world today. Very often, it is misunderstood as anti SQL, but it is not true. It carries the name "Not Only SQL" for the fact that it doesn't uses SQL, contrary to the conventional database systems.

The key objective behind the evolution of NoSQL solution was to cope up the high growth of semi structured data and real time processing. The Web 2.0 platforms expressed their concerns over the availability, scalability, and flexibility of RDBMS products. On the other hand, NoSQL database facilitates, perhaps meant for high availability, flexibility and its scaling out capabilities. Several top tier websites like Amazon, Facebook and Twitter employ NoSQL solution to yield maximum availability and quick performance by virtue of its high throughput and low latency features.

Overall, NoSQL doesn't provides a soul database management system but just a data repository. Contrary to the ACID (Atomicity, Consistency, Integrity and Durability) compliance, NoSQL database solution complies with BASE (Basically Available, Soft state, Eventually consistent) model. Most of NoSQL databases are key value stores, while several database products have also been registered as columnar, document based and graph based under NoSQL category.

Oracle brings its own NoSQL database product which is built on Berkley DB java platform. Berkley DB has been a proven XML based storage model over the last decade. Oracle NoSQL database is a distributed key value store which is built on set of storage nodes. In recent times, Oracle NoSQL product has caught the attention in the community by to its inclusion in the Oracle Big Data solution for real time data processing.

Currently, the NoSQL database is available in two flavors namely, Community edition and Enterprise edition.

The Oracle NoSQL database product can be downloaded from the below link

http://www.oracle.com/technetwork/database/nosqldb/downloads/default-495311.html

Download the complete demo document from the below link

OracleNoSQL 3 node KVstore Deployment on Virtualbox

 

Do share you feedback/suggestions and observations.

Monday, 5 November 2012

Oracle 11g R2 Grid Infrastructure installation on 2 node cluster using Virtualbox

Hi Guyzz,

Though there is a lot of buzz on Oracle engineered systems, RAC deployments, 12c technical enablements but still certain basics and walkthrough demos appear to be quite handy and helpful for upcoming professionals in the area. In last few times, I was trying to refresh the demonstration of two node RAC database installation on a virtualbox. Here is an abstract followed by a detailed demo document.

I hope the post justifies the purpose and the efforts.

Introduction

Since its inception in Oracle 9i, the Oracle RAC (Real Application Clusters) technology has been an active topic of discussion in the community. Oracle 11gR2 RAC offers high availability, scalability (scaling out capability), manageability, reduced ownership cost, and cloud architecture platform. The RAC technology allows the establishment of multiple instances to a single database server which hosts an enterprise application.

Oracle 11g R2 RAC system necessarily works on grid architecture. The master RAC node must have grid infrastructure installed with the remaining nodes replicated accordingly. The Oracle 11gR2 grid infrastructure installation integrates oracle clusterware and oracle ASM. Oracle Clusterware is responsible for High Availability framework, process monitoring, event management and group membership. On the other hand, oracle ASM suffices the need of a conventional file system while offering multiple add-on features like online disk manipulation, auto I/O load balancing, stripping and mirroring of data and finally ease the data storage management.

The RAC customers/users often report their difficulties and issues in the installation phase. Before planning the grid infrastructure installation, it has to be prepared appropriately so that it suffices all the requirements of a clusterware and memory management. There are multiple areas to be looked upon before the grid installation like network, system kernel parameters, NTPD settings, node connectivity, and ASM disk setup. The document describes the prerequisites of a system to be planned for gird installation. Please note that the document is not a guide for RAC installation but a reference to provide hands-on with RAC installation on oracle virtualbox.

Approach

The document illustrates the installation of Oracle 11gR2 grid infrastructure and 2 node RAC database on virtualbox. The two virtualbox machine images installed with OEL, would serve as the cluster nodes. Initially, we will create only one virtual machine image and do all sorts of configurations required for the grid installation. The master node would be then cloned to create the second node participating in the cluster.

Memory requirements

The host system running the two virtual machine images must have sufficient memory to run both images simultaneously. RAM above 4GB would be best suited for the demo.

Software Requirement

Following software can be procured from Oracle Technology Network in order to follow this demonstration

a) Oracle Virtualbox 4.2

b) Oracle Enterprise Linux 5.6

c) Oracle 11gR2 Grid Infrastructure (64 bit)

d) Oracle 11gR2 Database (64 bit)

Here is the complete demo document for download

Oracle Grid and Database software installation on Virtualbox


 

Thursday, 25 October 2012

Book Review: Oracle Database XE 11gR2 Jump Start Guide by Asif Momen

Hello guys,



 

Recently I have been asked by Packt to review their book "Oracle Database XE 11gR2 Jump Start Guide" authored by Oracle ACE Asif Momen. I am glad to have my copy in my account. I have gone through the book contents and it looks like a structured stairs for beginners in Oracle database track. I am a regular follower of Asif blog (http://momendba.blogspot.com) and no doubt, its a gem blogroll to follow.

 

The book is available for at the Packt's site

http://www.packtpub.com/oracle-database-xe-11gr2-jump-start-guide/book

 

Very soon, I will kick off spending my hours on reading through the book and hope I can distill out my feedback on my blog. Thanks all.

Saurabh

Saturday, 22 September 2012

Packt Publishing reaches 1000 IT titles and celebrates with an open invitation

Packt

Birmingham-based IT publisher Packt Publishing is about to publish its 1000th title. Packt books are renowned among developers for being uniquely practical and focused. Packt books cover highly specific
tools and technologies which IT professionals might not expect to see a high quality book on.

Packt would like you to join them in celebrating this milestone with a surprise gift – to get involved you just need to have already registered, or sign up for a free Packt account before 30 th September 2012.

Packt published their first book in April 2004. One of the most prolific and fastest growing tech book publishers in the world, they now have books on everything from web development to web graphics, e-learning to e-commerce, IT architecture to games, and app development.

Packt supports many of the Open Source projects covered by its books through a project royalty donation,  which has contributed over £300,000 to Open Source projects up to now. As part of the celebration Packt is allocating $30,000 to share between projects and authors in a genuinely unique way, soon to be disclosed on their website.

Dave Maclean, founder of Packt Publishing explains, “At Packt we set out 8 years ago to bring practical, up to date and easy to use technical books to the specialist tools and technologies that had been largely overlooked by IT publishers. Today, I am really proud that with our authors and partners we have been able to make useful books available on over 1000 topics and make our contribution to the development community.”

For more information about Packt, the kind of books they publish, and to sign-up for a free account before the 30th of September, 2012, please visit their website: www.PacktPub.com.

Friday, 21 September 2012

Adding my blog at BlogDash

http://www.blogdash.com/full_profile/?claim_code=66b1e0e26bc35a7684f439d84d5818fb

Wednesday, 15 August 2012

Celebrating 66th Independence Day


Happy Independence Day


Wishing 66th Independence Day to all Indians. A moment of celebration and pride, a moment to achieve high and a moment to wish long live independence from all darks and greys..


Jai Hind


Monday, 13 August 2012

NoSQL !! Not Only SQL

 

It was not before I heard of murmurs of Big data in the database glossaries that I heard of NoSQL databases. Almost all the Web 2.0 companies and big guns in the industry are diverting their radar on RDBMS alternatives. NoSQL is an unplanned product of all such researches and explorations. Started for something, did something and found something in the form of NoSQL. I am not in a criticizing tone but I am trying to defend the capabilities of RDBMS, which of course and perhaps would not be overshadowed by the scaling out features of NoSQL.

I thought it would be might of help to the community to pen down my findings on the topic. Its not complete but the findings are still in alive mode.

NoSQL: The Concept

The NoSQL Database is a new infant in the database world. The concept evolved in 2009 as the outcome of brainstorming done in the area of high volume storage. NoSQL provides a database model which doesn’t complies neither with the relational model of database nor with the ACID features of the database language. By name, it appears as a counter of SQL language, but its a myth. Both SQL and NoSQL can coexist in a system and share no relation between them. NoSQL stands for Not Only SQL.

By virtue of its violation of basic database features, NoSQL cannot be referred as the database by soul, but it appears just as a data store or repository where the acmodel is majorly need oriented. Till date, there are more than 160 NoSQL databases available in the market. The major users of NoSQL database model are Facebook, Linkedin, Twitter, Google and Amazon.

NoSQL offers a flexible database model which can be accessed and monitored from middle tier. It has no specific language of its own (unless UnQL comes in). One of the most famous model is key value pair model. Other model can be document centric, graphical, tabular, column oriented and object databases.

The Need

The basic idea after the NoSQL evolution is to design a distributed data store with large scale data flow. The WEB2.0 platform discovered new attributes of data access. The web data is not only read only but the readers are also allowed to interact with the web data. Subsequently, the web data generates huge traffic and the data size increases steeply. This exponential growth of industrial data (mostly from social media and search engines) require massive scalability, low latency and data on demand facility in a simplified database model.

The relational database worked well with the information storage philosophies but failed to justify the revolutionary growth of data in the current times. In addition, the relational database system provides a non distributed, vertically scalable, schema oriented and licensed platform for data management activities. NoSQL on the other hand, is an open source, non relational, distributed and horizontally scalable database system which can withstand high volume of mixed-up data with low latency but high availability.

NoSQL Features

The major accomplishments of NoSQL database are

  • Distributed architecture allows the implementation of replication mechanism to ensure consistent and unbreakable data flow

  • Horizontally scalable ensures that new server nodes can be added, if required to enhance the performance and efficiency. Note that RDBMS has no such property to scale horizontally.

  • Not schema dependent and non relational. Data storage paradigm is flexible as per the developer. In addition, there are no tables, constraints, join or relations to deal with. It completely behaves as a data store.

  • Compliance with BASE (Basically Available, Soft state, Eventually consistent). The BASE model talks more on the data availability and replication consistency of master servers. “Basically available” implies that the data must always be available partially and progressively after a transaction. The data consistency in NoSQL is not stringent as in RDBMS i.e. the data remains in soft state. It may or may not be readily available as soon as the transaction gets over. There is a scope of small amount of latency in the availability. Such degree of data consistency is best suited for social media and not finance sector. Thus, the data is eventually consistent but not instantaneous.

  • Complies with the Consistency and Partition tolerance of CAP theorem. CAP theorem states that a database model must obey anyone of Consistency, Availability or Partition tolerance. Note that conventional RDBMS compiles with Consistency and Availability.

  • Ability to store huge amount of structured or semi structured data and its retrieval

  • Not much technical expertise required

  • Less maintenance and administration overheads


As a new database in the industry, the NoSQL database received mixed responses. The database users who were loyal to relational model rejected the need oriented approach of this database. On the other hand, the people who were facing capacity issues with RDBMS readily adopted the NoSQL database. It was in 2009 when NoSQL started competing with RDBMS.

NoSQL categories

Key-Value stores - Based on Amazon' dynamo.

  • Columnar Family stores

  • Document database - inspired by Lotus Notes. Mainly for document centric and semi structured data

  • Graph database


NoSQL examples

Here are some pioneer and famous NoSQL databases used by the companies dealing with huge volumes of data.

I shall be back with more findings as they find me.

 

 


 

Monday, 6 August 2012

Oracle Engineered Systems: Hardware and Software Engineered to Work Together

Oracle Engineered Systems are highly efficient integrated systems which combine hardware and software to provide a complete enterprise solution to the customers or partners. The focus of the Oracle Engineered Systems is to give extreme performance, high scalability and maximum availability by reducing infrastructure complexity and setup cost. The pre assembled innovative systems have greatly simplified the requirements of a data center. One of the most complete enterprise systems in the current times, oracle engineered systems have everything to offer and fit the requirement. It can be understood as a box packaged box comprising of application support, operating system, virtualization, hardware management, networking support, and optimized storage scheme; all assembled to offer highly efficient and scalable solution to the customers.

Complete list of advantages drawn from Oracle Engineered Systems are as below
1. Integration of hardware and software components
2. Enhanced performance, claims 10x times faster than normal database
3. Low risk during installation and upgrades; high security
4. Accelerated deployment
5. Reduced complexity, IT cost and TCO (Total Cost of Ownership)
6. Single vendor support for purchase, deployment and support

Oracle engineered systems can be classified under below six solutions which we shall discuss briefly

1. Exadata
2. Exalogic
3. Exalytics
4. Oracle Database Appliance
5. Oracle Big Data Appliance
6. SPARC super cluster

1. Exadata
Exadata is one of the fastest database machines which work for both OLTP and data warehousing applications. It is a packaged integration of hardware and software comprising of server (Oracle 11g database servers), storage (Exadata Storage server), networking (InfiniBand), and virtualization. The Exadata machines are efficient to store upto 10 times more data and yield 10x-50x times better execution performance. The Exadata machine runs on the latest database version i.e. Oracle 11g Release 2.

Currently, there are two versions of Oracle Exadata namely, X2-2 and X2-8. The X2-2 version is a lower version with 2 to 8 twelve core database servers. The X2-8 version is best suited for huge requirements with 2 eighty core database servers. Depending upon the database size and performance requirements, these versions can be deployed in quarter rack, half rack and full rack configuration. Lower configurations can be upgraded to the next level with zero downtime, thus making it a scalable solution.

Key features of Exadata which contribute to the extreme performance are smart scan, hybrid columnar compression, smart flash cache, intelligent I/O resource management, smart flash logging, and storage indexes.

Oracle encourages its partners and customers (ISV) to have hands on Exadata and Exalogic through Oracle’s Exastack progam. The OPN members can utilize Oracle resources to achieve Oracle Exastack Ready or Oracle Exastack Optimized status. Oracle Exastack ready status qualifies an OPN member to be beneficiary based on their exhibition on Oracle products. A gold partner with Oracle Exastack optimized status has full access to technical resources from oracle and lab environments.

2. Exalogic
Exalogic is the high performance engineered system which is specifically designed for running Oracle Fusion Middleware, Oracle’s Fusion and Java based applications. Besides the enterprise applications, Exalogic works equally well for Linux or Solaris based applications. For Java based application mounted on Exalogic, performance can be improved upto 10x times with 5x more active users. Oracle applications run 4x times faster as compared to the normal servers with 3x times more active users. Key software engineered with the Exalogic hardware are Weblogic server, Coherence, JRockit and Hotspot, Exalogic elastic cloud software, Oracle linux, and enterprise manager for cloud monitoring and control. Exalogic is available in quarter rack, half rack, full rack and even multi racks (2-8) versions. Upgrades are possible from lower configuration to higher one with zero downtime and negligible maintenance issues.

An Exalogic unit is configured with cloud capacity too. The Exalogic Elastic Cloud is efficient to mount an application on a secure private cloud with extreme performance and simple management. All types of applications, ranging from small scale to large scale like mainframe applications can be based on Exalogic. The cloud capacity associated with Exalogic contributes to the enhanced application capacity and performance, reduced latency, and intensive database communication.

Oracle encourages its partners to take up Exalogic EX-CITE program. The program aims to demonstrate the efficiency and effectiveness of Exalogic on customers/partners business prospects.

3. Exalytics
After database and application engineered systems, Exalytics is the engineered system which focuses on the Business Intelligence applications. The Exalytics machine enables speedy analysis of data using In Memory (In Memory Parallel Analytics) processing engine.

The Exalytics architecture includes BI foundation suite (OBIEE), In Memory Parallel Essbase, and In Memory Parallel TimesTen database for Exalytics along with network components (Infiniband). Oracle TimesTen database is a relational In Memory database where the tables are cached under cache groups in the memory. Its existing capabilities have been enhanced for analytic processing by supporting columnar compression. Oracle EssBase is an OLAP server for analytic applications.

BI query reporting time improves by 18x times when Exalytics works with Oracle database. Combination of Exalytics and Exadata improves the BI query reporting time by 23 times.

The Oracle Exalytics machine is fed with four Intel Xeon E7-4800 processors where each one can provide 10 cores for computational purposes.

4. Oracle Database Appliance (ODA)
The Oracle Database Appliance is the engineered system which serves the lower capacity database services for OLTP and data warehousing applications. It is a shorter format (quarter rack) of Exadata machine which are expandable and promise higher capacity systems. In contrary to Exadata, ODA is affordable and offers easy implementations over skilled and risk deployment.

Oracle Database Appliance comes as a 4 rack unit (2 server nodes and 12TB storage capacity) running on Oracle Linux with 11gR2 RAC supported database. A complete ODA system is engineered with Oracle Linux, Oracle 11gR2 database (enterprise edition), RAC, grid infrastructure, enterprise manager, oracle automatic service requests and appliance manager. The automatic service request is an intelligent facility which can record and generate any hardware failure or replace requests. The appliance manager is a self efficient tool gets started in the deployment stage for assembling, installation and configuration tasks. In the later stages of maintenance and support, appliance manager is efficient to apply patches or reports a fixation for troubleshoot (if any).

It is best suited for non expandable systems and lower capacity customers. ODA is easy to implement, affordable and ensures high performance and serviceability.

5. Oracle Big Data Appliance (OBDA)
Oracle Big Data Appliance is the engineered system from Oracle to handle the growth of large scale enterprise data in the varied sections of the industry. The term Big Data refers to the techniques to counter the large enterprise data, both structured or unstructured, which grows at exponential rate like web data from twitter, linkedin, mapping sites etc. In a single rack, the Big Data appliance has 216 CPU processing cores and 648TB of raw storage. Starting with a single rack, the appliance can be scaled upto eight racks.

The Big Data appliance runs on Oracle Linux and Oracle JVM. Apache Hadoop from Cloudera is used for the distribution while NoSQL database (Oracle Berkeley DB) stores the data sets in key-value pairs. Using Map Reduce framework, the available data is organized and loaded into Oracle Exadata database machine. Key components which operate in this stage are Oracle loader and Oracle Data Integrator. Once the organized data is loaded, it is ready for analytical process and business decision making. The analysis is done in Oracle Exalytics In Memory machine. The statistical environment R is also used for advanced analytics at the decision stage. All the major hardware components i.e. Big Data appliance, Exadata and Exalytics share the InfiniBand connectivity so as to boost the network speed. In addition, the Big Data connectors do the load balancing between Big Data Appliance and Oracle Exadata machine.

The large data is diversified, organized and then analyzed. The Big Data platform operates in three stages namely, Acquire, Organize and Analyze. The infrastructure required for the Big Data platform can be divided as per the three stages.

Acquire: The stage where all available data is pulled and kept. Important components in this stage are Hadoop Distributed File System, and NoSQL Database.

Hadoop is an open source framework developed by Doug Cutting from Cloudera to counter large number of upcoming data requests. It is a file system which parallel takes the requests in large batches, breaks them into smaller requests and feeds into the distributed file systems. Cloudera manager tool is used to manage Hadoop.

Organize: Mapping, reducing and organization of data. Components at this stage are Oracle Exadata database machine, Oracle loader, Oracle Data Integrator, and Hadoop Map Reduce framework.

Analyze: Analysis and decision making stage. Oracle Exalytics does the job in the stage.

Decide and Visualize: Advanced analytics using R statistical environment

6. SPARC Super Cluster
The SPARC super cluster is the engineered system from Oracle to fit general purpose requirements of customers. It runs for all sorts of workloads. It integrates the high performance components like SPARC T4 compute tool, Exadata storage cells, Exalogic Elastic Cloud, ZFS storage appliance, Solaris 11, and enterprise manager. The components share InfiniBands connectivity.



Tuesday, 19 June 2012

Recent Articles at Exforsys (XML Storage and 11g Analytic Enhancements)

Hope you all are liking the book and my wish that it reaches my readers. I am satisfied with the good response of the readers. The fact that the book features into Oracle magazine (July-August 2012) issue and Oracle ACE newsletter has already overwhelmed me with joy and excitement.

Once again, thanks to Exforsys for publishing my two articles recently.

First article deals with the XML storage concepts in Oracle. The concepts have been theoretically explained within the scope of the article. Read the complete story at the below link

http://www.exforsys.com/tutorials/oracle-11g/oracle-xml-storage.html

Second article explains the aggregate and analytic enhancements in Oracle 11g database. The article explains the newly inducted LISTAGG and NTH_VALUE functions with examples. Read the complete article at the below link

http://www.exforsys.com/tutorials/oracle-11g/oracle-analytic-enhancements.html

Hope you all will like it. Do post your feedback, observations or suggestions.

Thanks to all,

Saurabh

Tuesday, 12 June 2012

Oracle Community: Partner News & Book Beat [Oracle Magazine July/August 2012 issue]

After ACE newsletter, the book makes into Oracle Magazine Book Beat section...great feeling and satisfaction that it reaches its readers...

Community: Partner News & Book Beat.

Saturday, 2 June 2012

Win a Free Copy of Packt's Oracle book

Gladly I would like to announce that Packt publishing has arranged a GiveAway contest for “Oracle Advanced PL/SQL Developer Professional Guide” especially and exclusively for the readers.

It’s easy to participate and walk away with your copy. All you need to do is just comment below the post and win a free copy of Oracle Advanced PL/SQL Developer Professional Guide  . Three lucky winners stand a chance to win an e-copy of the book. Keep reading to find out how you can be one of the Lucky One.



Overview of Oracle Advanced PL/SQL Developer Professional Guide
  • Blitz the 1Z0-146 exam

  • The Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book is recommended for the Associate level Oracle professionals aspiring for Professional level. The topics covered and demonstrated are in line with the Oracle University prescription for Oracle Professional certification, which justify the version updates to be advanced and not complex.

  • Master the advanced features of PL/SQL to design and optimize code using real-time demonstrations

  • The book aims to cover the advanced features of PL/SQL which are required to design and optimize the PL/SQL code. The recapitulation of PL/SQL programming and advanced features like collections, external procedures, server side result caching, implementing VPD to enforce row level security, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.

    Read more about this book and download free Sample Chapter: http://www.packtpub.com/oracle-advanced-pl-sql-developer-professional-guide/book

    How to Enter?
    All you need to do is head on over to this page and look through the product description of the book and drop a line via the comments to this blog post below to let us know what interests you the most about these books. It’s that simple

    Deadline
    The contest is open for a limited period and will close on 3rd July, 2012. Winners will be contacted by email, so ensure that you give real and correct email address when you comment!


    Enjoy reading, bye
    Saurabh

    Thursday, 17 May 2012

    An article suggestion from PacktPub.com

    Dear All All

    Packt publishers have extracted a chapter of my book as an article.





    PL/SQL: Using Collections

    The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. Besides the clear and precise explanation on advanced topics, it also contains example code and demonstrations, which gives a sense of application and usage to readers

    In this article by Saurabh Gupta, author of Oracle Advanced PL/SQL Developer Professional Guide, we'll cover the following topics:


    • Collections—an overview

    • Associative arrays

    • Nested tables

    • Varray

    • PL/SQL collection methods





    Click here to view the full article.

    Monday, 7 May 2012

    PL/SQL # Tip: Locally declared subprograms in PL/SQL

    Hi all,

    From long time, I am planning to start a blog section on PL/SQL programming tips. I have observed that as we grow more in technology, we skip some of the key features of language. When discovered later, the same tip appears to be an important bottleneck in programming.

    Here, we go with the first one!!

    We all know about the usage of local subprograms in anonymous blocks or subprograms. We declare local subprograms for private usage within the current block. They accomplish some small utility of the block and support modular programming. Few facts associated with the local subprograms are as below

    1. Local subprograms must be defined as the last construct in the declarative section. However, their prototype can be declared along with other constructs and identifiers in the declarative section. The concept is known as Forward Declaration.

    2. Results of locally declared functions in an anonymous blocks cannot be cached under 'Oracle 11g Result Caching' Scheme.

    3. Locally declared subprograms cannot be used within SQL statements which appear in the current block. Let us conduct a small case study

    create table t_demo_sql
    (a number,
    b number)
    /

    Table created.

    create or replace procedure p_ins_rec (p_data number)
    is
    function f_getnum(p_num NUMBER) return number
    is
    begin
    return (p_num*2);
    end;
    begin
    insert into t_demo_sql values
    (p_num, f_getnum(p_num));
    end;
    /

    Warning: Procedure created with compilation errors.

    SELECT NAME, ATTRIBUTE, TEXT FROM USER_ERRORS WHERE NAME='P_INS_REC'
    /

    NAME ATTRIBUTE TEXT
    ---------- --------- -----------------------------------------------------
    P_INS_REC ERROR PLS-00231: function 'F_GETNUM' may not be used in SQL
    P_INS_REC ERROR PL/SQL: ORA-00904: : invalid identifier
    P_INS_REC ERROR PL/SQL: SQL Statement ignored


    Instead, the results of local subprograms must be captured in local block variables. Thereafter, these block variables can be used within the SQL statements.

    Above features of local subprograms appears to be small but are very useful in day to day programming. Hope you all will like it!!

    Do share your suggestions, additional observations or feedback, which of course value a lot to me.

    Monday, 2 April 2012

    An Exclusive Thank You from Packt Publishing -- Any 3 Packt Ebooks for just $19.99

    Good Morning and Happy April month to all,

    Here is a great offer from Packt publishers for the week. Don't wait !! Hurry

    This week only and to thank you for your custom in the past we have two exclusive offers for you:


    1. Buy three Packt ebooks for just $19.99.

    2. Buy one book, you can get any Packt ebook for just $9.99.



    On a purchase of 3 ebooks, this offer will save you up to $80 off the list price.

    To take advantage of these offers, browse our book store to find the ebooks you want, add your ebook choices to your cart, and use the following discount codes at the checkout:


    1. Buy three ebooks for $19.99: [Promo Code: THOR20]

    2. Buy one ebook for $9.99: [Promo Code: DANYEB]



    This offer runs for 1 week only, so be quick and get your cut price ebooks before next Thursday, 5th April 2012.

    Packt Publishing Direct Marketing Team

    Use the link for pre order:
    http://www.packtpub.com/oracle-advanced-pl-sql-developer-professional-guide/book

    Bye for now,
    Saurabh

    Tuesday, 6 March 2012

    Enjoy reading...enjoy PacktLib

    Packt

    Hi,

    Nice to see a new development for Indian techies from Packt publishers. The publishers library PacktLib is now free for tech readers in India. Interested readers can create their account and use the library for free from 8 to 8.



    Find more information at http://packtlib.packtpub.com/......Enjoy

    Bye, Saurabh

    Saturday, 25 February 2012

    Methodical Performance Tuning Part 2 by Arup Nanda: AIOUG webcast

    Arup Nanda delivers yet again a useful webcast on Oracle performance tuning practices. This time he shows the utilization of V$ views to analyse the session level waits and statistics.

    Download links are as below

    http://arup.blogspot.in/2011/10/aioug-webcast-methodical-performance.html

    http://arup.blogspot.in/2012/02/aioug-webcastmethodical-performance.html

    Besides, the reviewing activities on "Book in Making" are going smooth. My regards to Ronald Rood, Kamran Agayev and Mohan Dutta, who are investing their efforts and valuable time in reviewing the book. Thanks for all  your responses on the book listing.

    Saurabh

     

    Sunday, 19 February 2012

    Upgrading to Oracle 11gR2, presented by Syed Jaffar Hussain

    Oracle ACE Director Syed Jaffer Hussain presents a webinar on upgrading database systems to Oracle 11gR2.

    http://www.youtube.com/watch?v=QcH7Z3w2AbM

    Have a learning and enjoyable experience

    Thanks

    Saurabh

     

    Wednesday, 1 February 2012

    Discovering the Author within me: My upcoming book

    Happily I would announce the listing of my upcoming book at PacktPub publishers website. The book is expected to be released by May, 2012.

    The book is for the Oracle Associate professionals who are aspiring for Professional level exam (1Z0-146 certification).

    "The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. Besides the clear and precise explanation on advanced topics, it also contains example code and demonstrations, which gives a sense of application and usage to readers. The book gives a deep insight that will help transform readers from mid-level programmers to professional database developers. It aims to cover the advanced features of PL/SQL for designing and optimizing PL/SQL code."--From PacktPub webpage

    http://www.packtpub.com/oracle-advanced-pl-sql-developer-professional-guide/book

    Wait until May but surely book your copies in advance.

    Thanks to Oracle and Luv u All,

    Saurabh

    Saturday, 28 January 2012

    A Conversation with Hans Forbrich

    Hans Forbrich, an Oracle ACE Director, talks about his path to becoming a prized speaker at Oracle User Group meetings around the world.

    http://medianetwork.oracle.com/video/player/961894745001

    Enjoy all

    Saurabh

    Tuesday, 17 January 2012

    Revise Partitioning Concepts in Oracle

    Hi all,

    Partitioning is one of the most stable, proven and efficient features of Oracle. It defines proper segregated format of data management along with boosting up the query performance. Recently, I published my article on Partitioning concepts at Exforsys. The article covers theoretical concepts involved in the feature. Continue reading the complete story from the below link

    http://www.exforsys.com/tutorials/oracle-11g/oracle-partitioning-overview.html

    Hope you all enjoy the reading. Post your feedback and comments.

    Thanks all. I'll be back with some more news and sharings. Bye for now

    Saurabh