(Senthil Rajendran) In the archived-log downstream capture process , the archived redo log has to be transported to the downstream database using redo transport services,the DBMS_FILE_TRANSFERa package, file transfer protocol (FTP), or some other mechanism. Once the archived redo logs are available
Other News
Understanding Oracle UCM 11g and Oracle ADF 11g Security Integration
(Andrejus Baranovskis) Combination of Oracle UCM 11g and Oracle WebCenter/ADF 11g technologies will help you to implement document management applications. There is a special area you should keep in mind – security.
The Maintenance Wizard: SQL Server 2005 (SP2) and Later
(Buck Woody) I’ve divided this article series into two parts. The first deals with SQL Server version 2000 and lower, if you still have that around. The second deals with SQL Server 2005 and later — but with a caveat. A fairly significant change in Service Pack 2 for SQL Server 2005 allowed for sepa
Aggregate Functions in SQL Server 2008
(Suthish Nair) What are Aggregate Functions in SQL Server? This article helps you to explore various Aggregate Functions in SQL Server.
Filtered Index in SQL Server 2008
(Suprotim Agarwal) Filtered indexes are a new feature of SQL Server 2008. They are optimized non-clustered indexes that can be created on a subset of rows.
PureScale Performance Proven
(Julian Stuhler) DB2 for z/OS provides mainframe users with unmatched levels of resilience and scalability through technology known as data sharing. IBM announced that similar capabilities would be delivered for DB2 for LUW, in an optional facility dubbed pureScale. Read on to learn whether DB2 pure
Retrieving the values for domains in SQL queries in the Oracle RDBMS – months, days, numbers and custom value sets
(Lucas Jellema) It happens quite frequently that in our database applications – in queries or in PL/SQL packages – we need to use the values from more or less standard domains or custom lists of values. For example the list of all months in the year – to show a breakdown list of some measure per mon
Monitor DB2 for Linux, UNIX, and Windows databases with Data Studio Health Monitor
(Dimple Bhatia, Saphian S Kono, Pavitra Jalasutram and Sriram Srinivasan) This tutorial introduces the IBM Data Studio Health Monitor tool for IBM DB2 for Linux, UNIX, and Windows databases. It walks you through the steps for monitoring the health of your databases, drilling down into the alert deta
Populating a SQL Server Test Database with Random Data
(Nagy Tibor) If you develop new functionalities for your SQL database then probably you already encountered the typical problem of testing large scale databases. I have to run a series of performance and functional tests on a database with a few million rows, but I do not have the necessary test dat
BCP – An Old Standby
Featured White Paper(s) Free Poster – SQL Server Perfmon Counters of Interest When you’re looking for a reliable tool to diagnose SQL Server issues, Perfmon is often the answer. No more wasting time trac… (read more) Featured Script Oracle: Howto: Rename or Move data files with database open Datafiles can be renamed or moved while the database is open. However, […]