Archive for the ‘oracle dba tips’ Category

Better Performance In Oracle

March 22, 2019 Comments off

PL or SQL has its roots in ADA, a high-level programing language. The conception of the PL or SQL block resembles the conception of block structure in ADA exploitation BEGIN and finish blocks. PL or SQL shares different options with ADA like the syntax “=” used for comparison and “:=” used for assignment, exception handling, and also the declarative syntax of process hold on subprograms. Over the years, Oracle DBA came up with new releases of PL or SQL. With Oracle information base administrator seven.0, Oracle information base administrator free PL or SQL two.0, that turned Oracle information base administrator into a lively DBA with the potential to store business and application logic within the DBA within the sort of hold on procedures, functions, and packages. It conjointly outlined the potential to declare programmer-defined records and arrays within the sort of PL or SQL tables. PL or SQL two.1 came into existence with Oracle information base administrator seven.1 and enabled the utilization of hold on functions in SQL statements. Also, dynamic SQL was introduced in PL or SQL for the primary time with the DBMS_SQL package.

Oracle information base administrator seven.2 was free afterward, and together with it came PL or SQL two.2. It had the potential to outline binary wrappers for PL or SQL hold on subprograms, so concealment code from different developers. Also, the DBMS_JOB package was introduced, that enabled programmers to submit jobs from among the DBA. ensuing unleash of PL or SQL was PL or SQL two.3, that was introduced with Oracle information base administrator seven.3. It increased the capabilities of PL or SQL tables with the power to outline new ways, and it conjointly enabled programmers to access the filing system from among the DBA. File I or O can be done exploitation the UTL_FILE package. Oracle information base administrator eight.x was a serious breakthrough within the Oracle DBA history with the introduction of objects and Java within the DBA. PL or SQL eight.x was free together with Oracle information base administrator eight.x and enclosed major options like native dynamic SQL, Java hold on procedures, and system- and schema-level DBA triggers.


Automatic Performance Tuning In Oracle Database Administrator

March 22, 2019 Comments off

Oracle DBA 10g revolutionizes SQL performance tuning by providing you with automatic performance diagnosis and tuning recommendations. A brand new expert diagnosis tool called Automatic DBA Diagnostic Monitor (ADDM) uses the new Automatic Workload Repository contents to analyze instance performance. The ADDM’s analysis includes a summary of DBA problems ranked according to the amount of DBA time they’re costing, as well as a list of recommendations to eliminate these problems. The ADDM’s recommendations may include modifying configuration settings or running one of the advisors listed in the previous section. Automatic Storage Management a significant component of the Oracle database administrator 10g push towards easier management is the new Automatic Storage Management (ASM) feature.

Traditionally, we have relied on third-party vendors, such as VERITAS and EMC, to provide storage-management tools for larger systems. The new ASM feature allows the automated management of disks while not resorting to third-party logical volume managers (LVMs). You can use Oracle’s new storage virtualization layer to automate and simplify the layout and management of all Oracle DBA files when you use ASM. Instead of directly managing various files and disks, you can pay attention to a relatively small number of disk groups.
If you would like further storage, you simply add new physical disks to the logical disk groups.

The Oracle database administrator 10g server provides you with an easy way of managing the memory needs of your DBAs. Automatically shared memory management and automatic program world space management use info collected from the instance to expeditiously assign each the most important parts of Oracle’s memory allocation—the system world area (SGA) and the program global area (PGA). Oracle database administrator 10g DBAs can use the Resource Manager feature to control and channel scarce DBA resources among the various users of the grid.
You can additionally use the new computer hardware feature to manage and monitor jobs moreover as prioritize them.

Why companies prefer remote database support?

March 19, 2019 Comments off

It’s a global world and for an organization, it is very important to keep its database healthy and in good shape, if it has to be presentable in this global scenario and cutthroat competition. For an organization hiring a remote DBA is much easier because they open the opportunity to all the DBA’s in the globe, and they get the best DBAs on the globe. When working remotely is considered a remote DBA is equally efficient as a locally present DBA himself. A DBA always works on the server which is remotely controlled. He never interferes with the hardware component of the server. He gets tickets on his machine and has a turn around time to complete the ticket and to further send it for verification.

For an organization its always effective to hire a remote DBA, as it is getting the best brains in the industry. Remote DBA’s are also much more affordable than a locally present DBA. An organization saves a lot by cutting the cost of hiring and retaining in-house DBA’s. Organizations are aware of the fact that the hiring process for a DBA is a cumbersome process, where the person interviewing the candidate should be highly experienced over the server, and to retain such a DBA is a tough task. We should always keep in mind that a DBA is always in demand.

Moreover, a remote DBA can provide better and longer support for the database. This is possible because the DBA himself will be at the leisure of working from home and thus becomes more productive.

Generally speaking, a remote DBA carries with him a long experience over various platforms and has a piece of good knowledge in performance and tuning of the database. Thus it is winning – win situation for an organization. A remote DBA will be much more responsible while working because he is aware of the fact that he is the only person handling the job and will be questioned if anything goes wrong, thus becomes highly productive.

What are the Responsibilities of Oracle DBA?

January 21, 2019 Comments off

Oracle DBA resposibilitiesThere are lots of responsibilities of Oracle DBA. Oracle DBA role plays a very significant part of the company. The database administrator is the key person of a company because he or she manages that database server which contains the company’s most important and sensible data.

Oracle database administrator manage database administration tasks like

  • general administration,
  • user administration,
  • security management,
  • network management,
  • space management,
  • backup and recovery,
  • performance and tuning of database servers,
  • migration and upgrade,
  • moving data across the databases and servers,
  • manages mysterious serious error like 600, 700, 7445 etc,
  • recover from human data loss errors,
  •  recover from logical corruption,
  • recover from physical corruption,
  • deployment of the standby database server,
  • maintain database licenses,
  • maintain database inventory,
  • maintain database documentation.

Version by version, Oracle introduces lots of new automation features and as per new feature database administrator’s job and tasks have been changing.

As new Oracle cloud DBaaS has been introduced. The new Oracle 18c database introduced too with a lot of autonomous features.  As per these new database versions and features tasks and responsibilities are changed.

Still, some people have the question in mind that Oracle is going to discontinued Oracle DBA role. Some of the experience and intermediate administrators fear due to this reason.

But it is an only rumor. Tasks and responsibilities are being changed as per the new version released by Oracle. Don’t bother about same. DBA always plays a key role in any company.

Tablespace Encryption Oracle 12c More Powerful

January 21, 2019 Comments off

remote dba expertsOracle Business Intelligence bring the complete specter of Business Intelligence functions, from reports of the whole company, scorecards, board panels, ad hoc interrogations, OLAP analysis, and search, to action generating collaboration, everything on an integrated technological infrastructure. Or at least this is what the vice president of Oracle Business Intelligence vise president Paul Rodwick claims. This new version is easier to be implemented for departmental needs and scales, offering the performance and unique scalability for the biggest and the most requesting enterprise based implementations.

Oracle Business Intelligence is the most complete, integrated and scales suite of Business Intelligence products, therefore the clients can easily obtain a better line up for the needs of their businesses and a better view on it.

This new version offers the one and only unified field from this domain, which is dedicated to accessing and analyzing the data from relational data sources, OLAP and XML. This way it enriches the user experience with a new integrated application of type scorecard and with various innovations in the modules of the report, view, searches and collaboration at an enterprise level. It also increases the performance, scalability, and security through a solid integration with Oracle Manager and the other components of Oracle Fusion Middleware.

The tablespace encryption Oracle 12c is obviously more powerful than the previous versions. It is the most complete and best-integrated infrastructure of Business Intelligence that offers extended possibilities of views.

By extending the functionalities from the Common Enterprise Information Model, 11g was the first solution that unifies technologies like Relational OLAP, Multidimensional OLAP and the enterprise based report on the same technological base. The improved possibilities of OLAP analysis allow the users to access and navigate through hierarchical data stored in Oracle Database and other relational data sources, all this by a common interface. A new thin client type integrated editor for the reports design gives the users the chance to publish both web-based interactive reports and best quality production reports, with a clearly defined format.

A new application, Oracle Score Card and Strategy Management, helps the users to follow if the parameters and key performance indicators line up with the strategy and objectives of the organization. The improved and activity oriented interface has a complete range of new filtering and creating instruments for interactive graphs, including map-based view options. Action Framework is a unique and innovating characteristic that includes the loop between understanding and taking action. This offers the users the possibility to start the action from their own board panel, like a business process or a web service.

The existing clients of Oracle Business Intelligence who use the previous version can upgrade them to the new version fast and easy, without any impact on the existing reports or metadata migration. By implementing of a database, Oracle Business Intelligence is the only available technological infrastructure in this domain that allows the system administrators to manage and monitor the sub-system performance from the same environment the whole IT suite is managed from.

Oracle Standby Database Concept

January 10, 2019 Comments off

remote dba expertsA monitoring standby database, as its name suggests, is a copy of a base of operations, held ready for use in place of the latter for availability in case of disasters and production database failure when the main base of operations has fallen and is not available. Usually, only the production data is cloned, is considered the secondary database or destination. The mechanics of implementing an emergency basis were officially available from Oracle 7. However, each new version of Oracle, the database has been waiting for a more robust and automatic. Regardless of the version, each implementation of databases expected to follow certain well-defined steps.

I have referred to the standby database and development, always within Oracle, such as the deployment of regular sleep and conventional, instead of a personalized approach described below. Based on the version, the current method to perform some steps may vary. However, the overall objective remains the same.

Refer to your version of Oracle-specific documents for details on setting up databases before, how they work, how to improve the availability, and what the relevant questions should be aware of before deciding to implement databases so out. Also, I’ve developed on the basis of some new features available in Oracle Standby and DataGuard.

Standby feature of Oracle was introduced in Oracle 7.3, so the previous version of Oracle does not provide database in standby mode. Oracle expects function is absolutely based on the changes and redo log file. Database standby function requires integrity checks inherent in the issue of the journal file and record changes in the control file.

The transactions take place in the primary database to the standby database to apply through the archive log. Archive logs are a copy of the redo logs. The transactions are written to redo log online after the process of commit, the redo logs are full, switch and stored (copied) Arch in background process. Thus, both primary and standby databases must be in ARCHIVELOG mode. Archived logs are copied to the network via a remote server in standby (either manually or automatically). In standby mode, the database is a constant state of recovery mode. All archived logs applied to copy the standby database, so that it can reach the contents of the primary database. In standby mode, the database is always behind the primary database for a few seconds.

Even if all archived logs generated to date have been implemented, which continues to lag behind, because transactions are being written at the primary online redo logs and can be applied after they are archived and copied. There are some new measures introduced to prevent this situation from Oracle 9i.

Overview on Oracle DBA Jobs

January 3, 2019 Comments off

fresher dba jobsOracle Database is a software package created and maintained by Oracle Corporation. Implementation of Oracle real application clusters (RAC) by Oracle DBA on various servers for multiple instances provides improvised performance.

Qualifications Criteria for Oracle DBA:

Oracle Database Administrator (DBA) has to qualify the training course in Oracle DBA with minimum understanding and background depth technical knowledge in computer science or information systems as Oracle is one of the most complex and sophisticated relational databases. It requires many skills learned at the college level to write and execute the commands and programs. To successfully understand the Oracle you should get trained from experts in Oracle and information systems professionals. One should be skilled in using MS SQL Server databases and have the ability to perform technical documentation and presentation professionally.

Exclusive Tips for Interview:

You should possess good communication skills and have the confidence to attend interview meeting all the requirements and skills necessary for Oracle DBA. Answer all the questions clearly without leaving any doubt. While explaining your achievements explain it to the point in a sequence of situation, task, action, and result. You should explain clearly about your past experience when asked by the interviewer. You should express willingness in doing the job.

Oracle DBA interview questions: Questions related to your strengths, weaknesses and about the changes you may bring at the workplace as an Oracle DBA are asked generally. Following are the frequently asked Oracle DBA interview questions.

  • Why do you want to be an Oracle DBA?
  • How did you get motivated to choose this for your career?
  • What contributions have you made while doing the previous job?
  • What is your long-term planning?
  • Which training courses did you complete?
  • Give an overview about Relational Database?
  • How will you work with multiple tables?
  • How do you handle errors while PL/SQL programming?
  • How can the performance be tuned in Oracle?
  • How do you backup database offline?
  • Explain about Oracle web cache and how do you start it?
  • Explain in brief about the data types in Oracle.
  • Why did you prefer our company?
  • For how many periods would you like to work for us?
  • At last, you are asked to clarify doubts, if any.

Behavior during the Interview:

You should be relaxed and make yourself comfortable throughout the interview. Express your opinion in a polite way and do not argue with the interviewer. Do not reply in a rude or harsh manner. After the interview does not forget to thank the interviewer for their time.

Work of Oracle DBA:

The Oracle DBA has to perform all the necessary activities for projects independently with less supervision. He should be expert and resolve issues of the complex database and develop solutions for DBMS tools, backup, and recovery, database performance tuning etc. He should perform migrations of database, structures, and upgrades. Oracle DBA has to maintain and utilize DBMS related procedures and standards, and know where they are located. New software and DBMS tools are to be researched, evaluated, and tested to function in accordance with the existing DBMS environment and applications. Any improvements in the current DBMS environment and its performance are monitored as per the requirements by Oracle DBA.