Monthly Archives: marzo 2015

Migration of a table partitioning
  • 25
    Mar

Migration of a table partitioning

Migration of a table partition or sub-partition to a different tablespace no longer requires a complex procedure in Oracle 12c. When an “online” clause is specified, all dml operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. No dml operations are allowed if the partition|sub-partition is moved offline. some examples …...

Read More
Step from pid to sqltext of active session on single instance database Oracle
  • 17
    Mar

Step from pid to sqltext of active session on single instance database Oracle

If you have the process ID (PID) you can back to sqltext active session associated on database using the following steps: 1) Run the statement by inserting PID alter session set nls_date_format = 'dd-mm-yyyy hh24:mi:ss'; col machine for a20 col username for a15 col OSUSER for a15 col spid for a8 col program for a35 col username for...

Read More
Multiple indexes on the same column
  • 11
    Mar

Multiple indexes on the same column

Multiple indexes on the same column Until the release Oracle 11g was not possible to create more indexes on the same column of a table. Starting from release Oracle 12c, you can create multiple indexes on the same column as long as the index type is different. However, only one type of index is usable / visible at...

Read More
How purge old trace and dump files
  • 2
    Mar

How purge old trace and dump files

Starting from release Oracle 11g was indroduced a new feature which allows: 1. Viewing the alert.log 2. The relation between incident & problem 3. Creation of Packages & ZIP files to send to Oracle Support 4. Purging old diagnostic files This post we’ll be focusing on purging the old diagnostic files. There is now a special command line...

Read More