Amazines Free Article Archive
www.amazines.com - Sunday, May 26, 2019
Read about the most recent changes and happenings at Amazines.com
Log into your account or register as a new author. Start submitting your articles right now!
Search our database for articles.
Subscribe to receive articles emailed straight to your email account. You may choose multiple categories.
View our newest articles submitted by our authors.
View our most top rated articles rated by our visitors.
* Please note that this is NOT the ARTICLE manager
Add a new EZINE, or manage your EZINE submission.
Add fresh, free web content to your site such as newest articles, web tools, and quotes with a single piece of code!
Home What's New? Submit/Manage Articles Latest Posts Top Rated Article Search
Google
Subscriptions Manage Ezines
CATEGORIES
 Article Archive
 Advertising (133295)
 Advice (160816)
 Affiliate Programs (34734)
 Art and Culture (73674)
 Automotive (145642)
 Blogs (75018)
 Boating (9841)
 Books (17130)
 Buddhism (4124)
 Business (1328289)
 Business News (426309)
 Business Opportunities (366257)
 Camping (10952)
 Career (72762)
 Christianity (15839)
 Collecting (11636)
 Communication (115054)
 Computers (241947)
 Construction (38992)
 Consumer (49679)
 Cooking (17061)
 Copywriting (6567)
 Crafts (18204)
 Cuisine (7538)
 Current Affairs (20380)
 Dating (45774)
 EBooks (19685)
 E-Commerce (48193)
 Education (185180)
 Electronics (83491)
 Email (6389)
 Entertainment (159819)
 Environment (28933)
 Ezine (3038)
 Ezine Publishing (5443)
 Ezine Sites (1553)
 Family & Parenting (110897)
 Fashion & Cosmetics (196383)
 Female Entrepreneurs (11842)
 Feng Shui (130)
 Finance & Investment (310257)
 Fitness (105904)
 Food & Beverages (62849)
 Free Web Resources (7938)
 Gambling (30213)
 Gardening (25079)
 Government (10513)
 Health (629247)
 Hinduism (2206)
 Hobbies (44032)
 Home Business (91544)
 Home Improvement (251321)
 Home Repair (46116)
 Humor (4815)
 Import - Export (5449)
 Insurance (45118)
 Interior Design (29544)
 International Property (3485)
 Internet (190967)
 Internet Marketing (146303)
 Investment (22824)
 Islam (1168)
 Judaism (1357)
 Law (80457)
 Link Popularity (4592)
 Manufacturing (20838)
 Marketing (98746)
 MLM (14136)
 Motivation (18211)
 Music (26998)
 New to the Internet (9476)
 Non-Profit Organizations (4048)
 Online Shopping (129608)
 Organizing (7802)
 Party Ideas (11856)
 Pets (38081)
 Poetry (2234)
 Press Release (12670)
 Public Speaking (5618)
 Publishing (7522)
 Quotes (2407)
 Real Estate (126610)
 Recreation & Leisure (95247)
 Relationships (87449)
 Research (16157)
 Sales (80313)
 Science & Technology (110157)
 Search Engines (23445)
 Self Improvement (153090)
 Seniors (6229)
 Sexuality (35942)
 Small Business (49281)
 Software (82955)
 Spiritual (23461)
 Sports (116071)
 Tax (7658)
 Telecommuting (34064)
 Travel & Tourism (307161)
 UK Property Investment (3118)
 Video Games (13422)
 Web Traffic (11724)
 Website Design (56803)
 Website Promotion (36556)
 World News (1000+)
 Writing (35761)
Author Spotlight
SHOVON JOARDER

Shovon Joarder has been working as Freelance Marketing Project Manager for over four years. He also ...more
ANISH SAH

My Name is Anish Sah, I am an Internet Marketing and SEO Expert, Social Media Guru and young Entrepr...more
ADRIAN JOELE

I have been involved in nutrition and weight management for over 12 years and I like to share my kn...more
ALFRED MEARS

Former English Teacher; Musician (20+ years); Freelance Writer ...more
AMIT TIWARI

Amit Tiwari is a Digital marketing expert with over 4 years of experience and a wide variety of know...more


Disk Controllers and Oracle Server Performance Tuning by Gitesh Trivedi






Disk Controllers and Oracle Server Performance Tuning by
Article Posted: 08/22/2012
Article Views: 462
Articles Written: 83
Word Count: 530
Article Votes: 64
AddThis Social Bookmark Button

Disk Controllers and Oracle Server Performance Tuning


 
Computers,Software,Business
Many disk vendors allow multiple disks to be daisy-chained to one controller. Thus, although you might have six physical disks, there might be only one or two disk controllers. That won’t buy you much. Ideally, there should be a one-to-one correspondence between a disk and a controller, unless the controller throughput is substantially higher that the throughput of single disk, in which case the controller throughput ought to match the sum of the maximum potential throughput for all disks. However, as the databases get bigger and bigger and the number of disks grows exponentially, and organization will find it difficult to invest in an equivalent number of controllers. Accordingly, you should understand how many controllers are present and how many disks are connected with each controller.

It helps to be familiar with the conventions that vendors use to indicate disk and controller relationships. Usually, once the configuration has been set up, certain disks map to certain controller only. So prior to that actual setup, any disk may potentially be accessed by any controller. After setup, however, once a disk slice has been created, it may be accessed by only one controller. So if controller is busy working and other controllers are free waiting for an I/O request, they still cannot speed things up by accessing disk slice. Accordingly, tasks for controller will have to be serialized. Keep such facts in mind while distributing data across different disks.

Find out what kind of channel the vendor has used between the host computer and the external disks. Also be familiar with the kinds of controllers being provided by the vendor. Are they based upon SCSI standards or something else? Know what standards are available in the market and which of these standards have the support of mainstream vendors. If you are still in the vendor selection stage, select the one who offers the fastest and the best medium, if price is restraining factors then analyze the price versus performance and availability ratio. This area is really critical; you will spend a lot of time in the future tuning I/O and related aspects. So a little bit of homework toward this end will not hurt. If your organization has already purchased the hardware, any time spent in familiarizing yourself with the components will be time well spent. This is very important thing to understand in dba services.

It is very important to check your system contains how many disk controllers. How those disk controllers are connecting with disks. This information is very useful to understand logic of disk I/O and performance bottleneck of physical I/O of Oracle server for tuning prospective. So many times, disk I/O bottleneck found at Oracle database server but we never get actual root cause of performance degradation. Oracle disk I/O tuning is very critical and vital for ever Oracle server. If we configure Oracle server system accurately with keeping all requirement and future issues in mind during deployment period then it would be easy to analyze any disk I/O bottleneck well in advance. Oracle server would be running smoothly with high performance and availability.

Author is providing DBA Services and using strong database administration .

Related Articles - Oracle tuning, oracle performance tuning, oracle disk io, disk io tuning, oracle performance,







Email this Article to a Friend!

Receive Articles like this one direct to your email box!
Subscribe for free today!

 Rate This Article  
Completely useless, should be removed from directory.
Minimal useful information.
Decent and informative.
Great article, very informative and helpful.
A 'Must Read'.

 

Do you Agree or Disagree? Have a Comment? POST IT!

 Reader Opinions 
Submit your comments and they will be posted here.
Make this comment or to the Author only:
Name:
Email:
*Your email will NOT be posted. This is for administrative purposes only.
Comments: *Your Comments WILL be posted to the AUTHOR ONLY if you select PRIVATE and to this PUBLIC PAGE if you select PUBLIC, so write accordingly.
 
Please enter the code in the image:



 Author Login 
LOGIN
Register for Author Account

 

Advertiser Login

 

ADVERTISE HERE NOW!
   Limited Time $60 Offer!
   90  Days-1.5 Million Views  

 

Great Paranormal Romance

World News


STEPHEN BYE

Steve Bye is currently a fiction writer, who published his first novel, ‘Looking Forward Through The...more
GENE MYERS

Author of four books and two screenplays; frequent magazine contributor. I have four other books "in...more
STEVERT MCKENZIE

Stevert Mckenzie, Travel Enthusiast. ...more
SUSAN FRIESEN

Susan Friesen, founder of the award-winning web development and digital marketing firm eVision Media...more
PAUL AZORIN

Paul Azorin Chief Technology Officer at BairesDev Pablo Azorín is the Founder and Chief Techno...more
JAMES KENNY

James is a Research Enthusiast that focuses on the understanding of how things work and can be impro...more
TREENA MURPHY

Warm greetings to you!! Hello there, my name is Treena (Smiley) Murphy I am a part time blogge...more
LAURA JEEVES

At LeadGenerators, we specialise in content-led Online Marketing Strategies for our clients in the t...more
LUMINHOME LIGHTING

About Us Luminhome Lighting provide one-stop services in lighting design and manufacture of LED lum...more
KIRAN KAUR

Kiranpreet (Kiran) Kaur, D.D.S., who received her Doctor of Dental Surgery degree from the prestigio...more

HomeLinksAbout UsContact UsTerms of UsePrivacy PolicyFAQResources
Copyright © 2019, All rights reserved.
Some pages may contain portions of text relating to certain topics obtained from wikipedia.org under the GNU FDL license