Profile

Cover photo
Gitesh Trivedi
Works at Dbametrix Solutions
Lives in USA
48 followers|22,670 views
AboutPostsPhotosYouTubeReviews

Stream

Gitesh Trivedi

Shared publicly  - 
 
:-Implementation of Oracle Features for gaining high PERFORMANCE:-

Different buffer pools are very useful in most of situation for effective using of Buffer cache. Identify all large segments needing full table scans. Place such segments in the RECYCLE buffer pool, separate from the smaller tables, which need to be placed in the KEEP pool. This will allow the smaller table blocks to be retained in the buffer cache for a longer time. Configuring separate pools will minimize occurrences of smaller segments being phased out of the buffer cache.

While you are considering implementation of Buffer cache partitioning then you should also need to consider size of segments. If you are targeting 100 segments for KEEP pool then you need to calculate total sizes of those 100 segments first and after that you need to configure KEEP pool size either equivalent or larger size. After implementation of multiple buffer pool concepts you need to monitor growth of those 100 segments constantly.

Off course, using multiple buffer pool and default buffer cache, you will get excellent performance benefits in 24 X 7 running databases.

For columns with high selectivity, B-Tree indexes are often the best solution. Consider reversing the indexes if they are expected to be lopsided where the number of rows per leaf block varies drastically. Best example of reverse key index is invoice number or student id.

If you are using any primary key table with other table joining then you should need to test index organized table concept too. Make primary key table as index organized table (IOT) and try to test your applications and monitor performance. Compare query performance before without IOT and after made it IOT. If performance is increasing then you need to test your every application before deployment to production database.

Always monitoring database performance you would get more ideas about how to take benefits from other available Oracle features. You should need to deploy every new implementation on your test database server and test new changes with your every application before deploy it directly to production database server. Sometimes, some feature may not give any benefits or decreasing performance.

Oracle DBA Interview Questions and Answer book always provides you smart way to gain all kind of new features and tricky queries with appropriate reply. Only depth knowledge doesn’t sufficient to crack technical interview but you need more guidance about tricky and real time scenario based questions and suitable explanations. My Facebook page will give you more guidance and help for same. Book you can find out from http://goo.gl/z0Mma8 and facebook page is https://goo.gl/UGQk2o  
 
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Reprint of 5th edition is on way. Thanks a lot to my students and readers. I got lots of emails with thanks and valuable suggestions. I am appreciating my all readers, students, and buyers.
USA (PRWEB) April 17, 2014 -- Kendba.com, a leading online tutorial centre for Oracle DBA, recently released its 5th edition of Oracle DBA Interview Q&A guide and this latest edition also covers the details of Oracle 12c. With the launch of the new edition, Kendba.com aims to help the learners get prepared to crack the coveted exam more easily.
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 

Excellent tips for career making and guidance for how to cracking toughest technical interviews of Oracle DBA
Which One Between SQL DBA And Oracle DBA Is A Better Choice?. Oracle DBA is better choice for earning more salary but fresher may have some issue for gaining job from today's market - PR12519009
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Here are some important tips and tricks to get your dream job quickly. Fresher Oracle DBA can get job easily without any struggle if he or she is using these tricks and tips without fail.
How Can A Fresher Find Oracle DBA Jobs Easily?. There are many important tricks for getting quickly fresher Oracle DBA job. - PR12447032
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Auto Approved AA Blog List of 2,00,000+ Download for ScrapeBox from here.....https://www.fiverr.com/gpt123/provide-you-200000-auto-approved-list-of-blogs-for-scrapebox-blast
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 

Be confident while you are sitting with HR department for understanding terms and conditions of their company. Clear your doubts for any terms and conditions during this phase. If you will be provided salary package then ask break up of salary and figure about take home salary. Because sometimes there will be lots of hidden deductions clauses exist in your package. Ask them politely and clear your every doubts. Don’t shy or keep in mind that you are fresher and you don’t have right to ask any query to your hr person during this negotiation stage. Always confident in your skill.
Should Oracle DBA Freshers Negotiate For Higher Salary In Their Interview?. Oracle DBA Freshers Have An Upper Hand In Negotiating Salaries - PR12438069
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Top 5 Effective Tricks to get Fresher DBA Jobs. How to succeed to get fresher Oracle DBA job quickly without FAIL - PR12421640
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Depth knowledge doesn't only require to clear tough technical job interview of Oracle DBA but you need some good guidance and understanding to understand tricky and real time scenario based queries asked by interviewer. Interviewer always scans candidate is suitable for his or her requirements or not. He or she asks questions as per their own environment and requirements. As a candidate you should need to understand their accurate requirement for facing interview and replying proper suitable answers.
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Most effective way to get fresher Oracle DBA job easily is to crack technical interview.
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
Oracle DBA Interview Questions Answers
Rate your self in Oracle Performance tuning or Disaster recovery. This is very common query of technical interview. You need to provide accurate answer and prepare yourself for providing explanation of your reply. You can get more detail from https://www.facebook.com/oracledbainterviewquestions
Exclusive and Unique Real time Scenario based and Tricky Oracle DBA Interview Questions and Answers...
1
Add a comment...

Gitesh Trivedi

Shared publicly  - 
 
For building strong career in IT, choosing of skill set is very important and primary task. Without knowledge of this, you might waste your time and money.
1
Add a comment...
Story
Introduction
Remote DBA expert Team provides remote Oracle DBA support and Remote Oracle DBA services
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
USA
Previously
India - Singapore - UAE - USA
Work
Occupation
Software Engineer
Employment
  • Dbametrix Solutions
    Software Engineer, present
Basic Information
Gender
Male
Other names
dbametrix
Most hopeless services and very rough behavior. I don't recommend this party for buying any electronics or electrical goods. I had very bad experience. Very worst behavior from owner. Never trust them. Ridicules and horrible experience.
Public - 8 months ago
reviewed 8 months ago
Most horrible internet service provider. Customer care department is also worst. I paid them 1 year subscription for 2 MBPS line. I found internet working for 2 days and 3 days not working. Everytime we need to call (chargeable) to customer care and they provide stereo type reply. Most irresponsible customer care staff and field engineers. I don't recommend Spidigo internet to anybody.
Public - a year ago
reviewed a year ago
4 reviews
Map
Map
Map
I visited Special Kerala Tour of Akhil Bharat from 16th October,2014 to 23rd October, 2014. It was excellent experience and got wonderful services from tour managers, found delicious meal every time and pleasant rooms at hotels. In short, I can say it was very nice trip. I am repeated customer of Akhil Bharat because we went Simla-Kulu-Manali before 2 years back using their services. Akhil Bharat is truly best.
Public - a year ago
reviewed a year ago