Oracle database growth size
How 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
A 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
How 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…
ORA-38029 : object statistics are locked Recently
This 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…
Creating Table dynamically in Oracle Procedure
How 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…
Killing Locked Sessions in Oracle
Many 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…
Creating Custom Functions in Oracle
Here 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….
How to check Numeric value in Oracle
Currently 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…