| Oracle DBA Tips and Articles |
|
| Free download of Tips and technical articles of Oracle DBA |
| In this section you can find out the Oracle DBA Tips,techniques,technical papers and howto. It will be helpful to every Oracle DBA for sharping skill set. |
|
| How to kill session or process in Oracle using sqlplus: |
|
|
In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. Article covers Oracle 8, Oracle 8i, Oracle 9i,Oracle 10g and Oracle 11g techniques.Download or Read full article from here |
|
| How to kill session in Oracle RAC database: |
|
|
Article covers how to kill or terminate session in Oracle RAC databases. It covers all RAC databases from Oracle 9i RAC, Oracle 10g RAC, Oracle 11g RAC.Download or Read full article from here
|
| How to kill session in Oracle 11g Database - New feature: |
|
|
Article covers how to kill or terminate session in Oracle 11g databases using new feature. Actually this feature was introduced in Oracle 10g rel. 2.Download or Read full article from here
|
| How to kill session or process using operating system commands: |
|
|
Article covers how to kill or terminate session and process using operating system command like kill -9, orakill, taskkill command in Unix, Linux and Windows command line.Download or Read full article from here
|
| How to resolve LRM-00109 with ORA-01078 errors: |
|
|
Article covers how to resolve LRM-00109 with ORA-01078 errors.Generally these errors are occurring due to not exist of pfile or spfile on system.Download or Read full article from here
|
| How to resolve full table scan with "like" operator in where condition using Oracle ConText index: |
|
|
Article explains how to tune full table scan while using like operator in where clause using Oracle ConText (interMEDIA) , CTXSYS schema install and uninstall on Oracle 8i, Oracle 9i, Oracle 10g.Download or Read full article from here
|
| How to resolve ORA-00490 with ORA-27301 errors: |
|
|
Article explains how to tresolve ORA-00490 with ORA-27300,ORA-27301,ORA-27302 errors while Oracle instance crashed.Download or Read full article from here
|
| Difference between Oracle on Windows, Unix and Linux: |
|
|
Article explains Oracle on Windows vs Oracle on Unix and Linux differences for memory,process,file system,security and other features.Download or Read full article from here
|
|
