Performance Tuning of Oracle Database Backup

July 30, 2020

It is suggested to routine Oracle data source copy at non-pick hours. This thing cannot be done stringently to those companies or sites, which are running 24/7 and available worldwide.  During the copy, the efficiency of data sources might lower. Performance effect will depend on size data source and number of contingency clauses.

If the hot copy is taken during non-pick hours then it definitely will depend on dimension data source as well as copy location. If you take back-up in the area and put the copy in the same disk where the production data source located then during the copy, the efficiency of data source surely changed. If you take back-up at NAS then the efficiency of copy might degrade because copy definitely will depend on network bandwidth. If the dimension data source is large then the active of bandwidth will be using and the operation of copy can become slower.

If you are backing up data source using upload application then efficiency badly affected of server because upload application can consume more resources of CPU and memory. If during upload, sessions are trying to get report or efficiency multiple deals then the efficiency of data source surely affected.

RMAN is a good copy application of Oracle. Using RMAN you can take copy similar but during this similar function high source of the host will be employing. If the data sources used by classes worldwide and at the time of RMAN function, classes are trying to access data source then efficiency horribly affected.

In 24/7 operating data sources, it is not easy to maintain copy easily because the data source is being utilized by multiple sessions worldwide at any time from anywhere. Duplicating data source for support up data source function is totally depending on dimension computer file and dimension data source. If the data source is larger in dimension then it would take more time to finish as a well the source of host would take effect. During support up a data source, if any deal is occurring or any long term query is implemented then data source badly impacts of efficiency bottleneck. During Hot copy process, high numbers of store files have generated this function also functions host read in the area. If more than a single store destination designed in a data source then store function also takes so much system source. Finally, the result would be the efficiency degrading of the host.

In the new data pump function, we can perform upload similar. This similar function will eat high sources at the host level and efficiency can be impacting. I have seen so many accidents about the copy process either trapped or operating long and very next day also operating at choose hours.

There are lots of Oracle DBA Tutorials existing on the Internet. You can find out best single resource to get everything like DBA tips, performance tuning tricks and techniques, career-related job guidance, and the latest database-related news. Expert dba team club is one of this blog. You can gain more knowledge if you are interested in database domain skills.

How Is Spam Affecting Your Day?

July 20, 2020

I was really at a loss for words today;

960 emails !! 960 unwanted emails.

I shouldn’t say they were ALL unwanted. The three that I wanted to read were in there somewhere; I just had to look very hard for them.

Spam or UCM is becoming a bigger and bigger problem every day. As we get closer to the holiday season the amount of spam will grow even more.

I received an interesting email in the batch today. It was so obvious that it was a spam that it wasn’t funny. The thing that got me the most was they sent it to the wrong email address !! It was full of other addresses that I know were harvested off a message board.

With the new anti-spam law that will be signed by the end of the year, the amount of unwanted junk mail will be staggering. It is estimated that over 45% of the email people receive is spam.

My personal amount averages 450 a DAY!

So what does this mean for you? Your email box will be blasted with unwanted mail as long as the sender follows a few simple rules. 1) They must give a full header. This means that the sender has to clearly identify themselves 2) They must give you a real line to be removed from their mailing list.

Be that as it may, it will not stop your hardcore senders from moving to offshore providers to run circles around the laws.

Many ISP services already have spam filters in place to stop the flood of email going to your inbox. The problem with them is that they block the mail you want as well. You still have to wade through it all to get what you want to send to your inbox.

Spam will be with us as long as email address survives. The problem will really never go away as long as you have to keep posting your address to get the information you want from the internet and the crawlers keep harvesting those names to sell. New laws will only be effective until the next spammer figures out yet another way to get around the system.

In short; the best defense against spam is a good offense. Learn to use the tools available. By blocking as much junk email as we can will we be able to maybe put an end to it.

Or at least really slow it down.

Speaking Heart to Heart on the Internet and Anywhere

July 20, 2020

overconfidenceIdeally, whenever we wanted to talk to another person, we could do so over tea or coffee while relaxing on a cozy couch. Or if we are both Nichiren Buddhists–as I am–and the topic of conversation is a touchy one, we could sit down in front of our altar and chant Nam- myoho-renge-kyo together before we begin our dialogue (chanting is the Nichiren Buddhist form of prayer).

But in the real world, sometimes distance, time constraints and a myriad of other factors dictate that if we are going to verbally communicate with someone, we will have to do so either by phone, postal mail or electronically–that is, by fax, e-mail or via the World Wide Web.

Personally, I don’t think this reality is a bad one. Rather I believe it is neutral. By this I mean, whether value or anti-value is the result of our efforts to communicate with others depends not on the communication method we employ, but on our hearts. This thinking is totally in line with the Buddhist idea that all things have both a positive and negative aspect. It is up to me to bring out the positive aspect of the mode of communication I choose to utilize at a particular time.

If the only “right” way to communicate with others was to do so in person, then most of us would have no connection to any of the great spiritual or philosophical thinkers of the present or past, like Maya Angelou, Dr. Martin Luther King or even Fred Rogers, for instance, because most people have ever met these people face to face. However, many of us have nonetheless “met” these individuals through their writings, what is written about them or on television and the radio.

In addition, anyone who has lost a dear relative knows that communication with that person does not cease just because you are no longer able to “see” her or him as you once did. On the contrary, we humans often remain deeply connected to our departed loved ones.

So I fall back on what the 13th-century Japanese founder of Nichiren Buddhism, Nichiren, wrote in a letter titled “The Drum at the Gate of Thunder”: “Merely seeing each other face would in itself be insignificant. The important thing is the heart. “Whether the heart is expressed in person, in writing, on the phone, or on television and radio, I think ultimately what matters is your heart when trying to communicate.

With a husband and three children under the age of nine at home, and with a large extended family, I have plenty of opportunities to test this theory. When I haven’t created harmony within my own heart when I’m fearful or angry I have difficulty communicating in a way that creates harmonious relationships with others. Basically, my fear and anger come down to my lack of faith that I have a divine nature that Nichiren Buddhist call a Buddha-nature.

When caught in the cycle of weak faith, I fall into seeing others as the source of my problem and I feel incapable of effecting change. Without faith in my Buddha nature, hopelessness and despair run rampant in my psyche.

But when I return to the basics of prayer, spiritual study and deeply believing in my ability to deeply change things for the better, I can create the best reality for all. Then I can communicate from my highest self my Buddha self. As a result of doing so, I am able to harmonize my interpersonal relationships with both those that are near and far.

Life to life communication is difficult no matter the mode of conveyance. Fortunately, with sincere prayer (or intent, for those who don’t practice a religion) human beings have the capacity to express our deepest selves and to truly reach others by using a variety of methods. For me, prayer to profoundly connect to the people in my immediate environment and to those who are seemingly separated from me by time, space or simply point of view is the most effective way to ensure that I will “meet” them heart to heart.

 

Do you know how DATA lost from your computer?

July 7, 2020

More than 95% of the people and businesses I spoke to experienced data loss. However, the sad fact is that most businesses are not very ready and do not understand the serious risk of data loss.

Do you have an accident plan?

The information you store on your computer can be lost in many ways. Many people are unaware of the various ways in which their data can be safely stored.

First, there are obvious ways.

Physical damage to a computer, such as a fire or water damage, is one surefire way to lose all information on your computer. Although insurance can cover physical damage to your machine (s) and you can replace the correct hardware, no insurance policy can recover your data.

Another common way for individuals to lose the data they have worked hard to build is THEFT. As with many computer disasters, insurance can cover physical hardware, but there is no policy to store the information stored on your hard drive and other physical media.

If you don’t have a backup solution, your data is at risk every day.

There are many other things that can cause partial or complete data loss. Other common events are:

Data corruption (failed CRC or MD5 checks),

Hard drive failure (more hard disk is getting closer to MTBF, or “mean time between disk” rated at the factory)

It is not unusual for a machine to reboot after replacing critical system files, such as a Windows OS package or a driver update application.

Human error – simply deleting a file or directory occurs more often than you think. Not to mention the “non-emergency” cancellation by an unhappy employee.

Viruses and worms – Although protection is easily available and widely used for these digital pests, data loss associated with them is still widespread.

These are just a few of the potential threats that can hit a computer that is not backed up at the time.

Now ask yourself, “What can I do?” You may ask. In fact, there is one simple solution for all your data integrity needs: external backup information.

Backups may be used to perform separate tape drives or other removable media, Offsite data provides a very clear, easy-to-use, and secure way to keep files in a secure location. They are safe (remember, if your office building fires a fire, your workplace will not only destroy the data but also prevent your tape from using expensive firewalls.

Data backup is easy to manage and protect your data offline in the most secure, economical way possible. If you are thinking about implementing a data backup for your company or personal computer, do yourself a favor and consider using a secure backup service. This is the simplest and most effective disaster recovery.

Your DATA is your life. What you are waiting for.

Three Ways To Jump start Your IT Career

June 29, 2020

an ideal studentWe all get stuck in channels from time to time, and that happens on the job as well.  You’ve thought about doing something unusual with your information technology career, but just haven’t pretty gotten around to it yet.  Sound recognizable?

You can make 2020 the best year yet for your IT career.  There are several graceful steps you can take to speed up your profession – but you have to take the step, not just think about it!

Learn something new.  One of the biggest causes you get tired of a job is that you’re doing the same thing daily.  If you happen to care for what you do, that’s great, but if not it’s time to break out of the box.  Besides, learning new expertise adds value to your career.  If you’ve been doing server work for a long time, take the time to learn some Oracle expertise.  If you’re a Network specialist, learn some Oracle DBA skills.

Get certified.   Not especially many of us get to work for the same corporation for the rest of our IT careers.  The only job security is the security you give yourself, and one of the ways to get that safety is to add professional certifications to your resume. Qualifications such as the OCP and OCA get you noticed and help you position out from the crowd.  Ask yourself what your resume would look like if you were laid off today, and then take steps to progress yourself and your professional rank.

Be prepared to take one stair backward in organize to take multiple steps advance.  You may be in a position I was in a while back when my company saw me as strictly a Database guy.  I wanted to get on the Cisco side of things, but there was this perception that I was “only a Network guy”.  I had to put down that company to get my shot.  There was some short-term economic pain, but in the long run, it was the best career move I’ve ever made.

People get classify in every field.  In his book “Often Wrong, Never In Doubt”, Donny Deutsch writes about a job candidate who wanted to become a junior ad executive, but couldn’t break in with his current employer – which was an ad agency!  He was classified in a support role, so he applied to other ad firms and was quickly hired.

Sometimes you have to seem outside your recent condition in order to create fresh circumstances for yourself.  Don’t be scared to obtain a stair backward in order to unlock up new possibilities for yourself.  There’s an incredible career out there, waiting for you – if you have the daring to make it and take it.

Why remote DBA from dbametrix?

March 3, 2020

dbametrixThere’s been a lot of discussion over whether hiring a remote DBA is really a win in the long term. Many people seem to think it’s not, but it really depends on how it’s done. If you’re supplementing your internal team with some expertise that you wouldn’t be able to hire or keep on your own staff, it can make a lot of sense. In our experience, a lot of companies can benefit from this type of relationship. Imagine that you’re a business who relies upon MySQL but doesn’t have huge racks full of servers — say, a car dealership. You don’t need to have a rock star on your staff, and chances are you can’t afford or find someone like that anyway — but it sure helps to have such a person available when needed.

Our pricing structure makes a lot of sense, too. No artificial roadblocks to try to force you to buy a package deal. No lock-in. No pressure to get per-server licensing. (Consider this. If you want your servers to run as efficiently as possible, would you hire someone who gets paid by the server?) Just by-the-hour, a-la-carte consulting, with the option to get onsite or other types of help if you want. This isn’t without its tradeoffs — in particular, you have to be an active participant in scheduling, since per-hour scheduling is less tolerant to slippage than having someone onsite for a whole day. But on the whole, it’s remarkably efficient.

We also align our compensation with your goals. We set things up so that serving you best is the same as serving ourselves best. You don’t have to rely on our nobility or altruism to goad us towards doing the right thing. We love the satisfaction of a job well done, but even without that, the financial incentive is for us to do what’s best for you.

Companies like other companies (we’re not the only ones) are disrupting the old models, which have a lot of silly lock-in and other things that just don’t serve the customers. There is plenty of fish in the sea. Everyone’s looking for help, and it’s hard to find. Why go the route of the lock-in, with the corresponding disincentive for improvement? Every efficiency we add helps us help more customers more quickly and better. So what if we’re “working ourselves out of a job?” It’s not as if there’s any scarcity of jobs!

We’re quite a bit different from other “remote DBA” companies. We are full-stack performance optimization experts — we work on a lot more than MySQL. You can think of us as performance Ninjas if you wish. But whether you’re hiring a Ninja or a remote DBA, you should look for an approach that values your interests equally with the consulting company’s. If you’re considering remote DBA support and you want to know whether it’s worth it, just ask us. We’d be happy to give you some satisfied customers as references.

SEO- Do’s and Don’ts

March 2, 2020

Excellent blogging with useful tips.

TechnoKeen

google rankingSEO is very essential in the present world to develop the business. Most of the web site owners make use of SEO techniques to increase the traffic towards their site and to increase the page rank with different search engines. Being in the top tank results of a search engine is not an easy task and there are many rules and regulations to be followed to stay in one of the top ranks. Algorithms used for calculating the page rank are not constant. So, it is not a good method to follow a single algorithm to develop the rank. The only method to develop the rank is to be honest with whatever the content pasted in the site and constantly updating the site as per the user requirements.

Here are some do’s and don’ts of SEO to increase the traffic towards the web site:

Do’s of SEO:

  • Always focus on…

View original post 362 more words

Ozone Depletion

February 27, 2020

An Environmental Crisis-Ozone Depletion

ozone depletionThe continent size hole in Earth’s ozone layer is precariously identical to an ailment that takes more time to heal if treatment is delayed. Much of the protective layer of stratospheric ozone above Antarctica has gradually disappeared creating what is commonly known as the ozone hole. The Antarctic hole now measures about 9 million square miles, nearly the size of North America. Moreover, a momentous depletion of Ozone levels has been recorded around the globe. Because of reduced ozone levels, more ultraviolet radiation reaches Earth. It does not only cause more skin cancer and eye damage but also harms crops.

The Real Culprit

Scientists have found that it is chlorine that creates the hole by devouring ozone molecules. The source of the chlorine is chlorofluorocarbons CFCs; man-made chemicals.

Ozone and the crucial role that it plays:

Ozone, a relatively simple molecule, consists of three oxygen atoms bound together. Yet it has dramatically different effects depending upon its location. It displays a destructive side near Earth’s surface where it comes into direct contact with life forms. Ozone reacts strongly with other molecules. Thus the large concentration of ozone near the ground proves toxic to living things. However, 90 percent of our planet’s ozone resides at higher altitudes, where, it does a remarkable job of absorbing ultraviolet radiation. The harmful radiation has a perfect portal in the absence of this gaseous shield in the stratosphere, through which to strike Earth.

The role played by science to understand the problem:

The graph plotting the scientific discoveries concerning Ozone depletion and its damaging effects is not a straight one but full of twists and turns. Investigators did not set out to determine whether human activity affects our environment nor did they know much about chemical pollutants. Instead, they began with basic questions about the nature of Earth’s atmosphere its composition, density, and temperature distribution.

Researchers faced a major stumbling block; virtually all gases, except for molecular nitrogen and oxygen, exist in such minute concentrations that available equipment could not detect them.

Mare research led to a precise method of identifying a compound by recording a special kind of chemical fingerprint; the particular pattern of wavelengths of light it emits or absorbs. Scientists call this pattern a spectrum. Further development produced a spectrometer that could measure small concentrations of ozone. Then scientists started paying attention to find out why, how and by whom Ozone depletion takes place. Very quickly CFC was identified as the culprit.

In 1972 Rowland, joined by Mario Molina, a colleague at the University of California, Irvine, decided to find out the harm caused by CFCs a refrigerant to the environment.

At altitudes above 18 miles, with 99 percent of all air molecules lying beneath them, CFCs show their vulnerability. At this height, the harsh, high energy ultraviolet radiation from the sun impinges directly on the CFC molecules in the stratosphere, breaking them apart into chlorine atoms and chlorine oxide radicals.

Since 1987, more than 150 countries have signed the Montreal Protocol (an international agreement). Modifications of that treaty called for a complete ban of CFCs with effect from January 1996. But chlorine from CFCs will continue to exist in the atmosphere for another decade despite the fact that the ban in effect. It may take until the middle of the next century for ozone levels in the Antarctic to return to 1970s levels.

Because of the extensive research that led to early recognition of the problem and steps that have been taken to address it, the potential consequences are much less severe than they otherwise would have been. More globally, but thanks to the scientists estimate, for example, that if active research in stratosphere chemistry had not been in place at the time the ozone hole was discovered in 1985, global ozone depletion, measuring 4 percent today, would be close to 10 percent in 10 years. Even larger ozone depletion would have been observed over the United States and Eastern Europe, thanks to the research, these larger losses have been avoided because basic research in the atmospheric sciences has already advanced to a level where it was able to explain the chemical reactions occurring in the ozone layer. That knowledge allowed other informed political and regulatory decisions to be made.

Finally:

The Royal Swedish Academy of Sciences awarded Rowland, Molina, and Crutzen the Nobel Prize in Chemistry for showing how sensitive the ozone layer is to the influence of anthropogenic emission of certain compounds in 1995. In explaining the chemical mechanisms that affect the thickness of the ozone layer, the three researchers have contributed to our salvation from a global environmental problem that could have catastrophic consequences the Academy noted.

As lawmakers and the public face new challenges in the struggle to protect the environment, they will increasingly rely on basic research to open new vistas and suggest new solutions about these pressing concerns.

How to clear Oracle certification exams

February 25, 2020

There should be little question in your mind that you simply face a test filled with specific and pointed questions. The Oracle certification exam test consists of around 60-70 questions that you simply must complete in 90 minutes.

Questions belong to at least one three basic types; multiple-choice with one answer, multiple-choice with quite one answer, and fill within the blank questions. you want to answer the fill-in-blank questions with the precise answer, including spelling, otherwise, you will miss the question.

Always take the time to read an issue a minimum of twice before selecting a solution, and always search for an Exhibit button as you examine each question. Exhibits include graphics information that pertains to the question. An exhibit is typically a screen capture of program output, a selected SQL statement, or GUI information that you simply must examine to research the question’s scenario and format a solution.

Not every question has just one answer; many questions require multiple answers. Therefore, it’s important to read each question carefully, not only to work out what percentage answers are necessary or possible, but also to seem for extra hints or instructions once you are selecting answers. Such instructions often occur in brackets immediately following the question itself, as they are doing for all multiple-choice questions during which one or more answers are possible.

Obviously, the sole thanks to passing any exam is to pick enough of the proper answers to get a passing score. However, Oracle’s exams aren’t standardized just like the SAT and GRE exams required for entrance to the school or grad school within the U.S; they’re much more diabolical and convoluted. In some cases, questions are strangely worded, and deciphering them is often a true challenge. In those cases, you would possibly get to believe answer-elimination skills. nearly always, a minimum of one answer out of a question’s alternatives are often eliminated immediately because it matches one among these conditions. It doesn’t apply to things. It describes a nonexistent issue, an invalid option, or an imaginary state.

After you eliminate all answers that are obviously wrong, you’ll apply your retained knowledge to eliminate further answers. Search for items that sound correct but that ask actions, commands, or features that aren’t present or available within the situation that the question describes. Also, look in other test questions for possible answers to the question you’re battling.
If you’re still faced with a blind guess among two or more potentially correct answers, reread the question. attempt to picture how each of the possible remaining answers would alter things. Be especially sensitive to terminology because sometimes the selection of words (remove rather than disable) can make the difference between a right answer and a wrong one.
Only when you’ve got exhausted your ability to eliminate answers do you have to guess at a solution. An unanswered question offers you no points, but guessing gives you a minimum of some chance of getting an issue right. Just don’t be too hasty when making a blind guess.

You can wait until the last round of reviewing marked questions, even as you’re close to run out of your time, or out of unanswered questions before you begin making guesses.

How to Face Technical Oracle DBA Interview

February 21, 2020

Facing personal technical Oracle DBA interview is very difficult because you need to concentrate on multiple areas like dressing, attitude, the body language of replying, face reaction, and tricky Oracle database administration questions.

Conceivably yet further disturbing than the queries you are going to have to answer, you are going to have to determine the just correct covering to be dressed into a job interview.  You craving to appear proficient and comparable to you are going to find in with the company.  A nice regulation of thumb for men is that you can’t overdress for the interview – a shirt and tie or a suit is always a safe choice.  For women, selecting kinds of stuff is more difficult.

For both men and women, choose a dress that you consider relaxed in and that matches you correctly.

You don’t want pants that are too stretched or a shirt that is too comfy across the upper body.  It will be a disruption for both you and your interview taker.  Beside the same layer, pick colors that outfit you but aren’t too dazzling or outlines that are excessively dark.  You desire the spotlight to be on your replies, not what you are wearing.

Memorize too that your general exterior is going to be moderated, and this comprises additional than the costumes you are wearing.  Cleanliness and brushing: be spotless, efficient and orderly.  It is most likely most excellent not to dress in a burly perfume – possibilities are you will be in a tiny area and it could formulate others painfully.  Your claws should be brief and fresh, your looks fresh and clean, and have mint candies with you or sweep your tooth instantly before making for the appointment.

You may be unsure what all of these elements have to do with your prerequisites and obtaining the job.  It has to do a lot with it, particularly if you are going to be compacting with the company’s clients face-to-face.  The organization will want to hire workers who are going to symbolize the organization in the most excellent likely light.

If you are facing any technical interview then you should need to prepare yourself first with all difficult interview questions like tricky questions, version related questions, and real-time scenario-based questions. You should need to consider the organization’s basic requirements and should be aware of the exact technical environment of the company before start facing these kinds of technical queries. The interviewer always tries to search for a candidate who can take care of their existing infrastructure as well as a quick learner with a nice performer. Keep in mind, every company has different technical specifications and different requirements. Your personality, dressing, knowledge, experience, and understanding will help you to get a job. For preparing the Oracle DBA interview, you can take the help of any decent book which covers all versions and tricky real-time scenario-based questions with proper explanation.