 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
Location: Blogs
Bert Scalzo's Blog
|
|
| Bert |
Wednesday, November 19, 2008 7:29 AM |
Just a quick blog this week – some relatively easy suggestions on how to make Oracle run as fast as possible on minimal computer setups such as a notebook PC. My goal is simply to squeeze as much performance blood from the Oracle turnip as possible when deployed on limited capacity equipment. The suggestions below should work for most operating systems, including Windows, Mac-OS and Linux – simply interpret and apply the suggestions in a contextually appropriate manner.
- Exclude Oracle data files directory(s) from all anti-virus and anti-spyware automatic and manual scans. Myself, I exclude the entire “C:\Oracle” directory – where I place all my Oracle files.
- Eliminate all unnecessary background processes (demons) or services. Here are some basic examples (note that your computing environment needs and thus extraneous list will surely vary – so check with your local administrators to be sure and thus safe):
- Windows XP
- ATI Hot Key Poller
- Computer Browser
- Distributed Link Tracking Client
- Error Reporting Service
- Indexing Service
- Upload Manager
- Redhat Linux(s)
- anacron / cron
- httpd
- ISDN
- Net FS
- NFS Lock
- Send Mail
- Clean up (i.e. purge) the Oracle logging directory tree. For 9i and 10g, this was subdirectories such as BDUMP and UDUMP under your “admin/SID” directory. Starting with 11g, you need to look at the entire “DIAG” directory. Myself, I use a freeware called CCCleaner to purge all these files such that they don’t accumulate.
- Place the Oracle “DIAG” directory on a RAM Disk. This also has the side effect of automatically purging the files (step #3 above) when the laptop is shutdown.
- Exclude Oracle data files directory(s) from excessive or unnecessary last update timestamp maintenance.
- Windows
-
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\FileSystem\NtfsDisableLastAccessUpdate = 1
- Redhat Linux(s)
- chattr +A file_name per Oracle control, data and log file
- chattr –R +A directory_name per Oracle SID data directory
- Edit /etc/fstab for the Oracle Home and/or data file systems
Example: /dev/sda6 / home ext3 defaults,noatime 1 1
|
|
| Permalink |
Trackback |
Comments (1)
|
By kroy on
Tuesday, May 26, 2009 1:32 PM |
Interesting ideas.
Thanks for sharing the knowledge Bert! |
|
|
|
|
|
|
|
|
|
|