Friday, November 29, 2013

How to create a sequence and a trigger that will emulate "autonumber" in other RDBMS systems

›
If you have been working with other RDBMS systems, such as SQL Server from Microsoft, you may be used to a datatype called AUTONUMBER, which...
Wednesday, November 27, 2013

How does the 11gR2 feature "deferred segment creation" work?

›
Starting from 11gR2 onwards, Oracle introduced a feature called deferred segment creation . This means that Oracle will not need to create a...

What is the difference between automatic segment space management and manual segment space management?

›
In a locally managed tablespace, there are two methods that Oracle Database can use to manage segment space: automatic and manual. Manual ...

How to identify processes that are consuming lots of CPU power

›
Here is one way to identify processes that are consuming lots of CPU on your sever that I have used successfully in the past. First, use t...

How to find size, free space, used space, allocated space for the tablespaces in your database

›
SELECT F.FILE_ID, F.FILE_NAME, ROUND(F.BYTES/1024/1024) "Allocated(MB)", NVL(TO_CHAR(ROUND(F.BYTE...

How to compare the content of memory parameter and spfile parameters

›
### Compare static (pfile) and dynamic (spfile) parameter setting: set pages 100 set lines 400 col init_value format a36 col spfile_value f...

How to clean away control character from a text file

›
I found this little example on the internet and saved it as a shorthand - it has come in handy many times. Unfortunately I have forgotten th...