Move SQL Tuning Sets between Oracle instances
:
SQL Tuning Sets (STS) capture the workload of an Oracle instance. Starting in Oracle 10g Release 2, these tuning sets can be transported from one instance to another to facilitate testing.
Oracle DBAs cite lack of security measures
:
Increasingly complex database environments are making it difficult for database administrators to secure systems and protect against a data breach, according to a new survey.
HP Talks Up Datacenter Revamp Rewards
:
Efforts to cut costs internally and rethink datacenter design are paying off for the company and its customers, it said at OpenWorld.
Oracle Focuses on Grid, Developer Tools
:
At OpenWorld, the database giant debuts updates and new offerings described as making deployment and development easier and more efficient.
Oracle Invites Customers and Partners to Think Green at Oracle OpenWorld San Francisco 2008
:
New sustainability-focused conference program will help customers and partners attending Oracle OpenWorld San Francisco 2008 “green” their businesses, address compliance and sustainability issues, and showcase best business practices that help companies minimize their environmental impact.
Customize the Experience
:
Use the built-in capabilities of ODP.NET to provide globalization and personalization.
Keys to Locking Down Storage Security on a Database
:
Security consultant Ted Julian of Application Security offers a detailed look in several steps at how he believes database security should be implemented, starting with data discovery and moving all the way through the implementation of intrusion detection.
Gather query tuning data via Oracle's dynamic performance views
:
The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS.
EMS SQL Manager for Oracle version 2.0 released
:
EMS Database Management Solutions announces the new version of EMS SQL Manager 2008 for Oracle a graphical tool for Oracle Database development and administration.
Navicat Oracle GUI Admin Tool - 8.1.2 is available
:
Navicat Oracle GUI Admin Tool is an ideal solution for Oracle administration and development that lets you create, edit databases, run SQL queries and connect to remote Oracle...
Using Database Advisors
:
Get advice on key management challenges and improve performance in Oracle Database 11g.
Copy legacy Oracle tables with SQL*Plus
:
You may be running Oracle 10g Release 2, but the applications you're supporting may have been written much earlier. Tables developed in versions of Oracle prior to 8i often used the LONG datatype to store large amounts of text.
SAP, Oracle Holding Out on Ubuntu?
:
As Canonical grows its Ubuntu partners, at least two important software vendors still do not support its version of Linux.
Oracle Delivers Oracle WebLogic Server 10g Release 3
:
Quickly following the July 1, 2008 announcement of the Oracle(r) Fusion Middleware strategy and plans for integration of BEA products, Oracle today delivered Oracle WebLogic Server 10g R3.
New IT Strategies Rock at Oracle
:
Consolidation, virtualization, commoditization and moving to Linux are fast becoming the mantras of forward-thinking CIOs, and Oracle has realized major benefits by adhering to them.
Oracle Introduces Oracle VM Templates
:
Oracle VM Templates offer a time-saving approach to deploying a fully configured software stack by providing pre-installed and pre-configured images of enterprise software.
Oracle Buys Global Knowledge Software
:
Oracle announces that it has agreed to acquire Global Knowledge Software LLC (GKS), a division of Global Knowledge, Inc.
Oracle Database 11g Sets New World Record TPC-H...
:
Today, Oracle announced a world record non-clustered TPC-H One Terabyte (TB) benchmark result for Oracle Database 11g running on a Sun SPARC Enterprise Server.
Oracle Counters SQL-Injection Holes With Update
:
There were an additional seven patches for PeopleSoft and J.D. Edwards applications, seven for the recently acquired BEA product suite, and six for Oracle E-Business Suite.
Oracle expands application testing support
:
Oracle has expanded support for previous releases of Oracle Database to help organizations institute hardware and software changes, including upgrades to Oracle Database 11g.
Sybase-to-Oracle Migration Accelerated By ANTs Software
:
ANTs software inc. introduces the Sybase-to-Oracle Accelerator Program, a new promotional offering that complements Oracle’s current Sybase Safe Switch Program...Sybase-to-Oracle Migration Accelerated By ANTs Software...
Cache Payback
:
Oracle Data Provider for .NET (ODP.NET) enables you to take advantage of features exposed by the underlying Oracle Call Interface. One such feature new in Oracle Database 11g Release 1 and Oracle Database 11g Release 1 Client is the client result cache.
Oracle Buys Skywire Software
:
Oracle today announced that it has agreed to acquire Skywire Software's application software business.
What will Oracle's price hikes mean for Oracle customers?
:
Oracle's decision to raise its list prices by 15% to 20% is cause for concern for both existing and prospective customers. But there are opportunities to offset those hikes, according to industry analysts.
Explore Oracle 10g's updated sample schemas
:
Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature.
Oracle Unveils Oracle Demand Signal Repository
:
Oracle Demand Signal Repository captures, cleanses and harmonizes large volumes of external demand data to give users insight to consumer and supply chain behavior.
Lab test: Oracle Database 11g shoots the moon
:
Oracle's enormous 11g release rumbles with an impressive array of performance and management aids, elegant application testing, standbys that earn their keep, and the promise of lower storage requirements.
Latest Release of Oracle SQL Developer
:
Newly available Oracle SQL Developer Release 1.5 delivers integrated source code control support, expanded Migration Workbench capabilities.
Back Up and Recover
:
New backup and recovery features in Oracle Database 11g save time and data.
Tip: Exposing logical attributes with virtual columns
:
Data modelers are often faced with the dilemma of how to model logical attributes in their data warehouse schema design. A new feature in Oracle 11g called virtual columns solves this dilemma...
Understanding roles in Oracle-stored procedures
:
One of the trickiest parts of Oracle's security model is the way that roles (collections of database privileges) interact with stored procedures, functions, and packages.
Where's proof that Oracle VM outperforms the competition?
:
Instead of certifying its applications to run on VMware, in November 2007, Oracle Corp. released its own hypervisor and virtualization management software, Oracle VM. But somehow the company can't provide comparative data or users to back up its performance claims.
Oracle Buys AdminServer
:
Oracle announces that it has agreed to acquire AdminServer, a rapidly growing provider of insurance policy administration software.
The Power of Two
:
This column introduces the ways Oracle SQL Developer and Oracle Application Express work together to aid your development efforts.
Re-Inventing Oracle Database Administration
:
DBA Invention Group announces the release of DBA Easy Control for Oracle, an automation tool that re-invents the administration of Oracle databases.
A Revolution Threatens the Relational Database
:
SAP’s in-memory database technology has Oracle-killer written all over it, and nothing would give SAP greater pleasure than knocking Oracle’s database out of its current position as top-dog in the SAP database kennel.
Oracle creates Web 2.0 division
:
Oracle is building a global division to offer businesses products, services and best practices for Web 2.0 collaboration.
Is your Oracle database really secure?
:
While Oracle databases are nowhere near as vulnerable as they were five years ago, there is still a great deal of attention being paid to them by both security professionals and hackers alike.
Oracle Completes Acquisition of BEA Systems
:
Oracle Corporation announced that it had received approval of the European Commission and subsequently completed its acquisition of BEA Systems, Inc.
CodeSnip: How to make use of parameterized cursor in Oracle
:
Often it is convenient to pass a given set of values as input parameter to a cursor. It is very useful where nested cursors are used. Parameterizing the cursor makes it more usable and avoids the limitation of hard coding values in where the clause. In this code snippet, Deepankar examines this technique with the help of the relevant SQL code.
Review: What to make of Oracle 11g
:
Mention "green solution" and databases aren't usually what jump to mind first. Yet Oracle has developed the latest 11g database as a more streamlined, greener product with new features...
Oracle's Fusion still causes confusion
:
More than three years after it was announced, Oracle's Fusion strategy is still causing confusion among users unsure about exactly what the strategy delivers, analysts say.
Oracle Expands Its Linux Base
:
Oracle claims that it continues to pick up users for its Linux offering and now is set to add new clustering capabilities to the mix.
The real difference between SQL Server and Oracle
:
For years now there's been a constant war between MS supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real importance lies.
Independent Oracle Users Group Plans for COLLABORATE 08
:
The Independent Oracle Users Group (IOUG) is again hosting their annual educational event COLLABORATE 08: Technology and Applications Forum for the Oracle Community, April 13-17 in Denver, Colorado.
Oracle Introduces Remote Data Capture Onsite 4.5.3
:
Oracle today announced the introduction of Oracle(R) Remote Data Capture Onsite 4.5.3, the newest version of the company's electronic data capture (EDC) solution...
Online Tool Improves Oracle Performance Analytics and Recommendations
:
This is a freely available online tool that analyzes the data from a user's own Oracle Statspack or Automatic Workload Repository (AWR) reports and presents clear, customized recommendations for improving the performance of the user's Oracle database...
Oracle-BEA deal gets the green light
:
The Oracle-BEA Systems Inc. merger was effectively approved by the federal government yesterday when the U.S. Department of Justice and Federal Trade Commission opted to terminate their antitrust review of the proposed deal early.
Oracle's Collaborate 08 Conference within a Conference
:
Are you an Oracle Content Management fan? Then here’s the event of the year for you. It’s Oracle’s Collaborate 08 conference and it’s happening April 13–17, 2008 at the Denver Convention Center in Denver, Colorado.
Oracle tackles the context conundrum
:
The trouble with keeping data in a standard relational database is that such information does not typically come with machine-readable descriptions of what the data is.
Oracle adds single-tenant option to CRM On Demand
:
Oracle Corp. today expanded its Software as a Service (SaaS) CRM application to include a single-tenant version, a move that will offer customers more flexibility and security, according to the company.
Database Security Best Practices
:
Join Application Security's Vice President of Marketing, Ted Julian, and Josh Shaul, Director of Implementation Services and co-author of "Practical Oracle Security" for an informative webinar on Best Practices in Database Security.
Oracle adds Data Integration Suite to middleware family
:
The latest addition to the Oracle Fusion Middleware family is designed to give users interested in Service Oriented Architecture (SOA) a one-stop-shop for data integration needs, according to one industry expert.
Consultant: How to deal with Oracle licensing
:
A consultant offered advice Tuesday regarding how Oracle customers can get the best deal and protect themselves while licensing software from the enterprise software giant.
Oracle on the psychology of patching
:
Oracle has a belated reply to a survey a few weeks back on how database administrators have never installed one of the company’s critical patch updates.
Capture an Oracle 10g audit trail in XML format
:
The Oracle database has long had the ability to audit selected types of operations against the database, storing the audit trail in a system table. This table, SYS.AUD$, resides in the data dictionary. On some operating systems, you can also write audit records to the operating system's own event logging subsystem.
Making the Case for Oracle Database on Windows
:
Read this Ovum Summit paper to see why one of the best-kept secrets in the IT industry is the depth of support Oracle offers to customers deploying its databases on Microsoft Windows platforms.
Oracle-BEA deal means tough choices for middleware buyers
:
Existing Oracle and BEA Systems Inc. middleware customers stand to benefit most from Oracle's planned acquisition of BEA, while new middleware buyers may soon have a confusing decision to make, according to one IT industry analyst.
Oracle Buys Document Capture Leader Captovation
:
Oracle announced today that it has agreed to acquire Captovation, a provider of document capture solutions that streamline the process of capturing mission-critical content for access from within business applications and processes.
MySQL AB & Carahsoft to Host a “Federal DBA Day” on January 24
:
MySQL AB today announced it will be presenting a free, one-day technical training class for senior Oracle database administrators who are interested in expanding their professional skill-sets by learning advanced MySQL techniques.
New way of auditing Oracle and UNIX password security
:
The latest version of ElcomSoft's Windows password recovery application makes it easy for system administrators to regularly audit all of the passwords on the network, including Oracle and UNIX passwords...