Advanced Oracle PL/SQL Developer’s Guide – Second Edition

March 29th, 2016 | Posted in Reviews | No Comments

The author Saurabh K. Gupta has wrote an excellent book about Oracle PL/SQL in its second edition. The book name is: Advanced Oracle PL/SQL Developer’s Guide – Second Edition
This book covers PL/SQL Programming Concepts and best practices in coding:
The book starts by introducing some Oracle Development tools such as SQL Developer and SQL*Plus.
The book covers Oracle 12c SQL and PL/SQL new features: Saurabh explained with examples the most important features for database developers also covered Multitenant and Database In-Memory options.
Design and performance are crucial parts of any good coding: the author explained cursor structure, exception handling, execution cycle, design considerations and guidelines to boost PL/SQL code performance essentially through data caching, hints to tune the PLSQL code and optimization features like Oracle Secure Files. The book also has sample codes the execution of a C program and Java class in Oracle database.
Security part is very important for any code development; Saurabh dedicated a chapter for this explains the fundamentals of database security solutions from Oracle: fine-grained access control, guides to safeguard an application against the injective attacks and explanation of the Virtual Private Database.
The book also covers techniques to maintain PL/SQL program code through Tracing and profiling.
In summary, I highly recommend the Advanced Oracle PL/SQL Developer’s Guide – Second Edition for every Oracle DBA and developer, for both beginner and experimented.

You can buy the book on amazon uk, es or us.
Buy Now the Book
Thanks,
Wissem



DAY AGAINST DRM –

May 7th, 2015 | Posted in Reviews | No Comments

Today is Day Against DRM, and like last year Packt Publishing is celebrating with a special 24 hour flash sale – all eBooks and Videos will be $10 until tomorrow.
Enjoy the offer now …
CLICK HERE!



Packt EBOOK BONANZA !

December 22nd, 2014 | Posted in Reviews | No Comments

After huge success last year, the Packt $5 eBook Bonanza is back and bigger than ever! From today until 6th Jan 2015, customers will be able to buy any eBook or Video from the Packt website for just $5!
Access to the offer now OFFER



Packt conducting a Day against DRM Campaign

May 6th, 2014 | Posted in Reviews | No Comments

Packt Publishing will be conducting a Day against DRM Campaign on Tuesday May 6th, 2014, during which all eBooks and Videos will be just $10 each for 24 hours only.
Enjoy Now! http://bit.ly/1q6bpha



Packt’s 2000th Title Campaign

March 25th, 2014 | Posted in Reviews | No Comments

Packt Publishing are launching an exciting campaign to coincide with the release of our 2000th title. During this offer Packt is giving its reader a chance to dive into their comprehensive catalog and Buy One, Get One Free across their entire range of eBooks.

The campaign begins on 18th-Mar-2014 and will continue up until 26th-Mar-2014. Following are the benefits readers can avail during this campaign.

· Unlimited purchases during the offer period

· Offer is automatically applied at checkout

“Check out #Packt’s amazing Buy One, Get One Free offer bit.ly/1j26nPN #Packt2k”
Or
“Buy One, Get One Free on all of #Packt’s 2000 eBooks! bit.ly/1j26nPN #Packt2k”

Enjoy!,
Wissem



Oracle Database 12c Backup and Recovery Survival Guide

October 24th, 2013 | Posted in Reviews | No Comments

“The three main responsibilities of a successful DBA are to ensure the availability, recoverability, and performance of any database. To ensure the recoverability of any database, a DBA needs to have a strong backup and recovery skills set. Every DBA is always looking for a reference book that will help them to solve any possible backup and recovery situation that they can come across in their professional life.

Oracle Database 12c Backup and Recovery Survival Guide has the unique advantage to be a reference to all Oracle backup and recovery options available, making it essential for any DBA in the world. If you are new to Oracle Database, this book will introduce you to the fantastic world of backup and recovery that is vital to your success. If you are an experienced DBA, this book will become a reference guide and will also help you to learn some possible new skills, or give you some new ideas you were never aware about. It will also help you to easily find the solution to some of the most well known problems you could find during your career as a DBA. This book contains useful screenshots, scripts, and examples that you will find more than useful.

Most of the books currently available in the market concentrate only on the RMAN utility to backup and recovery. This book will be an exception to the rule and will become a must-have reference, allowing you to design a real and complete backup and recovery strategy. It covers the most important topics on Oracle database such as backup strategies, Nologging operations, new features in 12c, user managed backups and recoveries, RMAN (including reporting, catalog management, troubleshooting, and performance tuning), advanced data pump, Oracle Enterprise Manager 12c and SQL Developer.

“Oracle Database 12c Backup and Recovery Survival Guide” contains everything a DBA needs to know to keep data safe and recoverable, using real-life scenarios.”

Buy this book now ;
The Book

Enjoy!,
Wissem



E-books: 50% discount

October 16th, 2013 | Posted in Reviews | No Comments

Packt Publishing is giving everyone the chance to explore its full range of over 1600 DRM-free eBooks this Columbus Day at a massive 50% off at www.packtpub.com,
for 4 whole days.
The exclusive 50% discount code COL50 will be active on all eBooks and Videos until Thursday October 17th.
Click here

Enjoy!,
Wissem



Book: Oracle Database 12c Backup and Recovery Survival Guide

August 6th, 2013 | Posted in Reviews | No Comments

Happy to announce that the book “Oracle Database 12c Backup and Recovery Survival Guide” written by Mr. Francisco Munoz Alvarez and Mr. Aman Sharma will be available very soon. You can pre-order the book here ;

http://www.packtpub.com/oracle-database-12c-backup-recovery-survival-guide/book

Here is more information about the book:

http://oraclenz.org/?p=3101

Thanks,
Wissem



Oracle Data Guard 11gR2 Administration Beginner’s Guide

July 28th, 2013 | Posted in Reviews | 2 Comments

Introduction:

This book is written by my friends Mr. Emre Baransel and Mr. Nassyam Basha. In the following post, I am going to explain why every Oracle DBA should read this book.

2- The Book:

First chapter of the book explains the Data Guard architecture; what is Standby Database? What‘s physical / Logical / Snapshot standby database? Role Transition, Redo apply and SQL Apply? Switchover and fail over? Understand the concepts and the component definitions are a good start to successfully implement an Oracle Data Guard environment.

(more…)



Oracle Data Guard 11gR2 Administration Beginner’s Guide

July 2nd, 2013 | Posted in Reviews | No Comments


Glad, I have been asked by Emre Baransel and Nassyam Basha to review Their book “Oracle Data Guard 11gR2 Administration Beginner’s Guide“.
(more…)



E-Books Packt Special offers

December 25th, 2012 | Posted in Reviews | No Comments


Packt is pleased to announce a special eBook offer – stock your reader this Christmas! During this celebration, you can buy two or more Packt eBook’s of your choice for just $5 | €4 | £3 | AUS$5 each.
This offer is available from 20th December 2012 until midnight 3rd January 2013.

Find more information here : http://www.packtpub.com/news/stock-your-reader-christmas



Packt Publishing reaches 1000 IT titles and celebrates with their registred users!

September 22nd, 2012 | Posted in Reviews | No Comments

Birmingham-based IT publisher Packt Publishing is about to publish its 1000th title. Packt Publishing would like you to join them in celebrating this event and receive a surprise gift – to get involved you just need to have already registered, or sign up for a FREE Packt account.

During the event,  Packt will be inviting anyone already registered on http://www.packtpub.com/login, and who registers before 30th of September 2012 to receive a surprise gift!

Let’s register and discover what the surprise is :)




The Oracle Advanced PL/SQL Developer Professional Guide book review

July 1st, 2012 | Posted in Reviews | 3 Comments


The author Saurabh K. Gupta has successfully managed to write an excellent book about Oracle PL/SQL. The book name is: Oracle Advanced PL/SQL Developer Professional Guide.

From the concept to the syntax, this book covers what is needed to know to prepare the 1Z0-146 certification exam. It focuses on concepts, and lot of examples. If you want to learn or improve your PL/SQL knowledge, this book is for you.

The first two chapters focus on the PL/SQL concepts and design. Chapter 3 talks about Collections ; Nested tables, VARRAY with exercises.

The book also talks about external routines ; executing C and Java programs. In this book, Saurabh demonstrates how to implement VPD (Virtual Private Database).

Chapter 6 and 7 explain the use of Large objects; LOB; CLOB, BLOB and BFILE also, the 11g SecureFile LOBs.

The chapter 8 and 9 talk about Tuning methods and techniques to improve Performance; the 11g Result Cache, Tuning PL/SQL code and compilation techniques.

The book also explain tracing methods and Profiling.

The book contains a lot of tips , techniques and exercises to help you to achieve the 1Z0-146 certification exam.

In summary, the author Saurabh K. Gupta has produced a work of great quality and value. I recommend this book to all PL/SQL developers; beginners and advanced programmers.

Find the Oracle Advanced PL/SQL Developer Professional Guide book on: Packtpub | Amazon



Oracle Enterprise Manager 12c Cloud Control: Managing Data Center Chaos Book

June 3rd, 2012 | Posted in Reviews | No Comments


My friend and former ACE Director Porus Homi Havewala’s new book on
Oracle Enterprise Manager 12c Cloud Control, is now available, this is
the First published EM 12c Cloud Control book in the world.

If you are interested in learning about the capabilities of Enterprise
Manager 12c, please have a look. Electronic copies are available too.
I am requesting a book copy so I will post soon my review here.

http://www.packtpub.com/oracle-enterprise-manager-12c-cloud-control/book
Oracle Enterprise Manager 12c Cloud Control: Managing Data Center Chaos



Oracle Advanced PL/SQL Developer Professional Guide book review

May 31st, 2012 | Posted in Reviews | No Comments


I have been asked by Saurabh Gupta to review his book “Oracle Advanced PL/SQL Developer Professional Guide“.

This book will help developers to master the advanced PL/SQL concepts for 1Z0-146 exam.

Here is the book page link: Oracle Advanced PL/SQL Developer Professional Guide : http://www.packtpub.com/oracle-advanced-pl-sql-developer-professional-guide/book

In the next few weeks, I will write a review of this book to complete this post.



Packt Publishing Exclusive discounts in March + Upcoming events

March 8th, 2012 | Posted in Reviews | No Comments


Packt Publishing prepares for COLLABORATE 12 with discounts on Oracle titles all month
As a leading publisher of Oracle books/eBooks, Packt Publishing is inviting their readers to celebrate the upcoming COLLABORATE 12 conference being held in Las Vegas from 22nd-26th April.

(more…)



Oracle 11g R1/R2 Real Application Clusters Essentials – Book review

July 31st, 2011 | Posted in Reviews | No Comments

The authors, Ben Prusinski and Syed Jaffer Hussain , have successfully managed to write an excellent book about RAC 11gR1 and RAC 11gR2, something not really easy to accomplish, and they have clearly demonstrated the differences between both releases.

From the concept to the syntax, this book covers what is needed to successfully build a RAC environment. It focuses on concepts, installation, administration, backup and recovery, streams and data guard. If you want to build a highly available environment, this book is for you.

The two first chapters clearly focus on the high availability concepts and architecture of a RAC environment. Many DBAs jump directly to the syntax and forget about the concepts and the architecture. Those DBA will face serious problems with each new release of Oracle RAC. I highly recommend to read those 2 first chapters before jumping to the others. If you are a single instance DBA who never managed to install Oracle clusters, these two first chapters are also for you; read them and learn how to design the key components like networks and storage.

Chapters 3 and 4 discuss Oracle Clusterware installation including grid infrastructure and ASM. They help you build the first components of your clusterware.

Chapter 5 is about managing and troubleshooting Oracle 11g . After installing the grid infrastructure you will be faced with many background processes. This chapter teaches you the commands to successfully administer your clusterware components as well as troubleshooting any cluster issue.

Chapter 6 is about installing the RAC database with many tips and best practices to follow.

Chapter 7 deals with back up and recovery of RAC databases. One of the most important task for a HA DBA. Tips and suggestions have been provided in this chapter.

After building the RAC environment, every DBA should care about the database performance; chapter 8 covers the most important components to focus on in your day to day monitoring.

Chapter 9 covers the upgrade of Oracle 10g R2 Clusterware to Oracle 11g R1 and how to Upgrade to Oracle 11g R2 Clusterware. This is a really important task for any HA DBA.

The chapter 10, in my opinion, one of the best chapters of this book, is about real-world examples; the authors shared their extensive experience of practical scenarios and examples.

The book ends with a great appendix containing a vast amount of Oracle RAC commands and tips.
In summary, the authors have produced a work of great quality and value. I recommend this book to all DBAs working on RAC systems for the following reasons:

  • Clear explanation of RAC concepts and architecture.
  • Clear step by step installation of clusterware and RAC databases.
  • Real-world examples and tips.
  • Troubleshooting guide for most common performance issues in RAC.
  • Good summary of the most important RAC commands.

Find the Oracle 11g R1/R2 Real Application Clusters Essentials book on: Packtpub | Amazon



Oracle 11g R1/R2 Real Application Clusters Essentials – Book

June 28th, 2011 | Posted in Reviews | 2 Comments

Few days before, I have started a conversation with Mr. Syed Jaffer Hussain about Real Application Clusters and about his new book “Oracle 11g R1/R2 Real Application Clusters Essentials”. During the conversation, Mr. Syed Jaffer Hussain explained to me why his book is different than other real Application Clusters Books. I have accepted to review the book and it’s actually a pleasure to do it.
Mr. Syed Jaffer Hussain is an Oracle 10g Certified Master (OCM), an Oracle Certified Professional DBA (OCP) – 8i, 9i, 10g and 11g
and an Oracle 10g Certified RAC Expert (OCE). He is also an Oracle ACE director.
You can visit his blog here : http://jaffardba.blogspot.com
and you can also buy his book here: Book
In 2 weeks I will recieve the print version and then in 3 or 4 weeks I will publish my book review here in my website, in wiki.oracle.com, mix.oracle.com and in amazon.

Thank you,
Wissem EL KHLIFI



Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • T Robinson: In regard to the comment “In our case, RMAN didn’t found anything corrupted.” Please notice...
  • iftikhar: if we backup in multiple backupsets and will be command for restoring for more than one backupsets ,
  • Abey: Very helpful article.Thanks a lot. Can we follow this on oracle DG enabled deployment also?
  • Mauricio Daher: Need help configuring SBT for cloud backups. Does not seem to work for 12c. Thanks! RMAN>...
  • Leszek K: *.db_create_file_dest=’+ DATA’ create database command – why do you use full datafile...
  • Prabhakar Kumar: Thanks buddy!!! It really helps to DBAs who are novice to 12c ASM feature.
  • Wubeshet: I am getting the ORA-07445 This morning on the trace file. The following is the symptom of the problem. It...
  • Lakshmi N: Hi Thanks for the post. Just curious, is there a way to restore to a point wher my db is in no archive...
  • Shivakkumar P: This is really very good article. Iam learning Oracle 12c I used this to replicate testing from...
  • Uday: Hi Wissem, Once we apply the level 1 incremental backup to datafile copy it is no longed required. My question...
  • avnish: Can I set up active duplicate database in 11g standard edition (11.2.0.1)
  • Jaya V: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • Jaya: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • wissem: SQL Developer 4.0
  • oracleman consulting: great info thanks for sharing
  • Mike: Very nice article!! Thanks for sharing!!
  • yathish: I really appreciate if you can send me, if you have tutorial for 11g (11.2.0.1) RAC & ASM (prefer to be...
  • Farrukh Kamal: Fahad, I’m interesting in pursuing remote employment with Pythian. What tips would you suggest...
  • pavankumar: for the error it need to set env correctly http://orcl11gdba.blogspot.in/ 2014/08/asmcmd-08102-no-con...
  • wissem: Post result off; crsctl check has crsctl check crs

Oracle-Class Forums Latest Activity