web analytics

Category: Oracle

Oracle database growth size 1

Oracle database growth size

Reading Time: 1 minuteHow can we check the size of database growth? I needed to know this while generating a report for management regarding DB size.

Now here a little scri

ORA-00054: resource busy and acquire with NOWAIT specified 0

ORA-00054: resource busy and acquire with NOWAIT specified

Reading Time: 1 minuteA you are working on a busy database than you will often see this error.

Description

It means that your session is trying to update an ob

Calculating difference of dates in Oracle 0

Calculating difference of dates in Oracle

Reading Time: 1 minuteHow to calculate difference between two dates in oracle, as subtraction of dates returns numeric value as difference. With some slight changes/enhancements we can track back the subtraction values to some readable date formats:...

ORA-38029 : object statistics are locked Recently 0

ORA-38029 : object statistics are locked Recently

Reading Time: 1 minuteThis error comes when analyzing tables in oracle. Basic issue in this error is  when you import table without data i.e structure/schema only, oracle will lock table statistics. You can view all the locked...

Creating Table dynamically in Oracle Procedure 1

Creating Table dynamically in Oracle Procedure

Reading Time: 1 minuteHow can we create a table inside an Oracle procedure. "CREATE TABLE tableName AS". We cannot execute this statement in procedures because upon creation of procedure it would give syntax error. We can implement...

Killing Locked Sessions in Oracle 2

Killing Locked Sessions in Oracle

Reading Time: 1 minuteMany a times user sessions are locked in some DML/DDL operation, than how to unlock those sessions because a new step or operation could not be done on the specific object that is locked....

Creating Custom Functions in Oracle 0

Creating Custom Functions in Oracle

Reading Time: 1 minuteHere it is a simple procedure to create and call a custom function in Oracle. A custom function is a simple PL/SQL subprogram that is used to calculate a value. It creation syntax is...

How to check Numeric value in Oracle 0

How to check Numeric value in Oracle

Reading Time: 1 minuteCurrently i could not find any suitable function for checking numeric value on some column. There are many workarounds to achieve this functionality, either cast the column value in Numeric and check, but this...