|
Category :
RDBMS Server
Oracle8i on Linux - Installing oracle8i
software on Linux redhat9 involves a few additional steps. Here are some of the steps
that will have to be done in order to install the software.
NAS disk locks - If you use
network appliance storage for your database storage needs, there is a
chance that you would have run in to the "unable to lock file- already
in use" error. Click on the link to see how you can
overcome the problem.
Sticky situation -
Ever run in to the problem with the sticky bit in Unix? If you have
then this is the article for you.
NAS space
management - If you've worked on
databases that use Network Appliance Storage, you've probably run in
to the issue of the NAS storage not releasing the space even after you've
dropped the tablespace and removed the datafiles. The article give a
few suggestions on how to handle to situation.
Oracle Software
Location - A Gotcha that you need to be aware of when the ORACLE_HOME
location on a machine is changed.
PGA
Management - Details on automatic PGA management
Configurations for
parallel query - Oracle's
recommendations on some simple machine and disk configurations for
optimal Parallel query performance.
Query optimization settings -
Database settings that we needed to do in order to get our queries
performing again.
9i Limitations -
A few limitations while using some of the 9i features that you need to be aware of.
Handy Unix commands
- A few Unix commands
that come in handy while troubleshooting or investigating database
problems or performance issues.
Oracle process
priority - Increasing the
priority of an oracle process at the Unix system level.
Unix memory
allocations - A few details on
memory allocations for oracle at the Unix system level.
Notes on UTLFILES - A few UTLFILE
details on how oracle handles file permissions as well some
information on 9i improvements to utlfile management. |
