Monthly Archives: settembre 2016

Oracle 12C Last Login Time
  • 28
    Set

Oracle 12C Last Login Time

In the previous releases, to be able to know the last login time of the user, we had to enable “AUDIT SESSION” and then query the AUD$ table. The SYS.USER$ table in Oracle Database 12c includes a column to store the last login time of the user. As part of the increased security features in 12c, last login...

Read More
11gR2 RAC installation and the ORA-15014 error
  • 21
    Set

11gR2 RAC installation and the ORA-15014 error

In 11gr2, we now have to place the Voting Disk and Cluster Registry files on ASM disks and we do not have the option of placing them on OCFS or raw devices as in the case of previous versions. When you run the root.sh script as part of the 11gR2 RAC installation, it will create an ASM disk...

Read More
Applicate Baseline
  • 13
    Set

Applicate Baseline

Have you ever been in a situation in which some database queries that used to behave well suddenly started performing poorly? More likely than not, you traced the cause back to a change in the execution plan. Further analysis may have revealed that the performance change was due to newly collected optimizer statistics on the tables and indexes...

Read More
ORA - 00257 archiver error
  • 1
    Set

ORA – 00257 archiver error

When we see this error, the first thing is to control the flash recovery area In the event that indeed the FRA was full, you can delete old archive logs from the filesystem then on rman use the following run { crosscheck archivelog all; delete noprompt expired archivelog all; } The CROSSCHECK command is used to determine whether...

Read More