Oracle ASH report introduced on Oracle 10GR2. It is kind of statistical data collected by Oracle Sampled data. The sampling is done on the current active sessions. Sampled data collected to circular buffer in SGA and the same can be accessed through V$ views. V$ACTIVE_SESSION_HISTORY view provides the sampled session activity for the instance.

Suppose by mistake if you drop a table in Oracle 10g Oracle 11g you can retrieve the table using Flashback table feature. Flashback feature works with recycle bin to recover the table. For this the recycle bin must be enabled for the database.

In Oracle 10g and 11g if you do a select * from tab; you can see many tables starts with Bin$ which we cannot drop using drop table command. These are the objects in the recycle bin which can be used for recovery purpose in case needed.

For Oracle database, it is mandatory to have 2 or more redo log groups which record the each and every change to the database. The LGWR process writes the changes to the redo log files in a cyclic manner. It starts writing into first redo group and moves to 2nd one and so on. After completion of the last group, the LGWR again starts writing with the first one.

Please find some simple calculations for income tax for the financial year 2012-13. Finance minister increased the tax exemption limit to 2Lakhs from 1.8Lakhs and 20% slab extended up to 10Lakhs margin. 30% slab is applicable for 10lakhs and above.

Google Plus One +1 button started coming in Google Adsense ads since October 2011. This gives additional relevance to the Adsense ads and it is useful to deliver more useful ads to the page users. Moreover the clicks on the +1 buttons are not counted as Adsense clicks and won’t generate any income to you.