background preloader

DZone: Programming & DevOps news, tutorials & tools

https://dzone.com/

Related:  jawa29Oracle

Managing the Lifecycle of Agent Gold Images To update a Management Agent using an Agent Gold Image version, follow these steps: From the Setup menu, select Manage Cloud Control, then select Gold Agent Images.Click the name of the required Agent Gold Image.Click Manage Image Versions and Subscriptions.Select the Subscriptions tab. Select the Management Agents that you want to update, select Update, then select To Current Version, or To Restricted Version.Accept the default job name for the Management Agent update job. 189 Career Quotes To Motivate and Inspire You - Database Star I love a good quote. Quotes can motivate you, inspire you, and give you a new perspective on things. I’ve made a massive list here of career quotes, which are quotes about career, jobs, and success in general. Whether you’re looking for inspirational quotes for Monday morning, or looking for new job quotes, these should provide a bit of motivation and insight. I’ve listed them alphabetically by author, and they are not in any other particular order or grouping.

SQL Limit: The Complete Guide to SQL Row Limiting and Top-N Queries - Database Star Do you need to get the top rows in an SQL query? Do you need to perform pagination, or find the top 5 or 10 results from a query? You can do that in SQL using a “row limiting” feature. Learn how to use this SQL limit feature in this article. Dive in Oracle: Encrypt and Decrypt Passwords in Database Sometimes we store passwords in database table regarding to business requirement. If we store password as plain text in table, Everyone who have access to database can read password easily. That's mean big security hole. So I decided to develop package for encrypting and decrypting password.

Oracle Flashbacklogs Cleanup: Oracle Flashback Logs Cleanup Step by Step to cleanup flashback logs without any downtime to the production server Have you ever gotten into the situation where flash back logs have been building up for years in the Flash Recovery Area of your database and that you are stumped as to how to clean them up manually? You are dealing with the production database and that no downtime is allowed unless it is utmost necessity. How do we cleanup the flashback logs from the Flash Recovery Area without any downtime to the production database? Before we go in to details, let us see what Flash Recovery Area and Flash Back Database are. ( Trust me, many people are so confused with these two terms and many actually think they are the same) Flash Recovery Area

A Brief Overview of Oracle Temporary Table (GTT) August 5 2015 Written By: EduPristine A Brief Overview of Oracle Temporary Table (GTT) There is no denying that Oracle database has evolved over the years. Some redundant features have paved way for ingenious additions to which Oracle Temporary Table (GTT) is one of the latest. 7 Ways to Capture Java Heap Dumps - DZone Performance Heap Dumps are vital artifacts to diagnose memory-related problems such as slow memory leaks, Garbage Collection problems, and java.lang.OutOfMemoryError.They are also vital artifacts to optimize the memory consumption. There are great tools like Eclipse MAT and Heap Hero to analyze heap dumps. However, you need to provide these tools with heap dumps captured in the correct format. This article gives you multiple options to capture heap dumps.

java.lang.OutOfMemoryError: GC Overhead Limit Exceeded 1. Overview Simply put, the JVM takes care of freeing up memory when objects are no longer being used; this process is called Garbage Collection (GC). The GC Overhead Limit Exceeded error is one from the family of java.lang.OutOfMemoryError and is an indication of a resource (memory) exhaustion. Patching Oracle Software with OPatch OPatch is an Oracle-supplied utility that assists you with the process of applying interim patches to Oracle's software and rolling back interim patches from Oracle's software. This chapter provides information on using OPatch for these purposes.This chapter includes the following topics: About OPatch OPatch is a Java-based utility that requires installation of the Oracle Universal Installer. What the Shell? Getting Started with Unix This chapter is from the book  ksh is another shell that offers command completion. You type part of a command, press twice, and ksh completes the command for you (see Code Listing 3.12).

How to Restore Oracle Database using RMAN (with Examples) As a Linux sysadmin, you might recover a system from backup, which may include Oracle Database. So, it is essential for all admins to understand how to restore oracle database from backup. Typically, DBAs will use Oracle RMAN utility to take a hot backup of the database. About – Geodata Master My Name is Emad Al-Mousa , i have been working in GIS and Database Administration field Since 2007. I have experience specifically in Oracle Database Administration, ESRI ArcGIS, and Microsoft Sql Server. The goal of my blog is to share technical articles specifically in Oracle Database Technology, and Spatial data administration (ESRI ArcSDE). Linkedin Profile:

How to Deploy Oracle Management Agent 12c – Gokhan Atil's Blog In my previous post, I tried to show how to install Enterprise Manager Cloud Control 12c, now I’ll show how to add target hosts to our Enterprise Manager system. I assume that you’re in a similar position (installed Cloud Control but haven’t added any target yet). As you know, we have to install Oracle Management Agent to the targets to be able to manage them via our Enterprise Manager. In OEM Cloud Control 12c, we can “Add Host Targets Wizard” which is accessible from the web interface. We can manually enter required information of host or we can use auto-discovery method.

Flashback Scripts - Oracle Database The following flashback scripts can be used to flashback a training environment automatically. Before use, please test thoroughly for your environment. It is also recommended that the following flashback article should be read.

Related: