Manage

Manage

Learn to apply best practices and optimize your operations.

• Consolidating databases in Oracle systems: Methods and tips

  A well-planned consolidation strategy can help overcome Oracle database sprawl. But there are different ways to consolidate your databases, each with pros and cons. Continue Reading

• Oracle LEFT JOIN vs. LEFT OUTER JOIN: What's the difference?

  Get an explanation of the different types of Oracle joins, including whether there's really a difference between the LEFT JOIN and LEFT OUTER JOIN syntax in PL/SQL. Continue Reading

• How Oracle RPA systems can automate business tasks for users

  Robotic process automation software can be integrated into Oracle environments to help strengthen business operations by augmenting workers with software robots. Continue Reading

• How to create Oracle Multitenant database user accounts

  Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading

• object-oriented database management system (OODBMS)

  An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects. Continue Reading

• Oracle Cloud IaaS security gets superhero status from Ellison

  TechTarget editors discuss security updates to Oracle Cloud Infrastructure and company leader Larry Ellison's vivid depiction of cloud-borne cyberthreats and bots to counter them.Continue Reading

• Oracle OpenWorld 2018 news, trends and analysis

  At its OpenWorld 2018 conference, Oracle tried to position its cloud platform as well-suited for enterprise uses. This guide compiles coverage of key developments from the event.Continue Reading

• Oracle Database monitoring, tuning deliver performance goods

  This handbook examines Oracle Database performance management trends and offers insight and advice on using performance monitoring and tuning tools in Oracle systems.Continue Reading

• 6 best practices on Oracle performance monitoring and tuning

  Database administrators need to effectively manage Oracle Database performance to ensure an efficient processing workflow. Let this checklist be your guide.Continue Reading

• What Oracle performance tuning tools can and can't do for DBAs

  Two Oracle experts discuss the tuning and monitoring capabilities of database performance management tools -- and the ongoing role that DBAs play in the process.Continue Reading

• The future of SPARC/Solaris is cloudy -- in multiple ways

  Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the technologies as part of its enterprise cloud strategy.Continue Reading

• Migrate an Oracle RAC database to new servers with zero downtime

  Most organizations can't afford any downtime on their Oracle systems. Here's how to move RAC databases to new server nodes and still stay up and running in an Oracle cluster.Continue Reading

• Design Hyperion for a natural class and a functional income statement

  Juan Porter explains what you need in Hyperion or Essbase for calculating a natural class and a functional income statement.Continue Reading

• Willis develops app to put a personal touch back in voluntary benefits

  Part two of a two-part article: Willis uses PeopleSoft 9.1 to bring back the personal feel to automated insurance selection for voluntary benefits.Continue Reading

• Willis develops app for real-time voluntary benefit selection

  Part one of a two-part article: Willis uses PeopleSoft 9.1 to create real-time automated insurance selection for voluntary benefits.Continue Reading

• The case for commodity hardware vs. Oracle Exadata architecture

  A former Oracle sales rep does a 180 by pushing his company not to buy an Exadata system, but to upgrade existing data center infrastructure instead.Continue Reading

• Oracle JD Edwards EnterpriseOne 9.1, World upgrade challenges and tips

  Quest President Patrick Kys talks about upgrading to Oracle JD Edwards EnterpriseOne 9.1 and World 9.3, and comments on application customizations.Continue Reading

• Handling database migrations, such as upgrading to Oracle 12c

  IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live.Continue Reading

• Q&A with Alyssa Johnson: OAUG president talks Oracle Fusion Applications

  Question and answer session with OAUG President Alyssa Johnson about the future of Oracle Fusion Applications and their coexistence with the cloud.Continue Reading

• How can today's DBAs contribute to big data databases?

  In the big data puzzle, data scientists and NoSQL are all the rage. Find out how traditional DBAs fit in, and what they have to do to stay there.Continue Reading

• Three tips for using Oracle insert syntax to insert multiple rows

  If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members.Continue Reading

• Oracle pro takes the thoroughbred view with IT, EBS upgrade

  CIO Wade Lewis has been in IT long enough to know that patience and planning are rewarded, particularly with an EBS upgrade.Continue Reading

• How to perform Oracle Flashback Transaction Queries

  Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions.Continue Reading

• Evaluating the ROI of Oracle DB 12c Multitenant

  Formerly called Pluggable Database, the Oracle 12c Multitenant feature is going to cost extra. Is it worth the money?Continue Reading

• The Oracle-Salesforce deal, along with others, is good for end users

  The witty jabs between Larry Ellison and Marc Benioff may be over, but overall the Oracle-Salesforce deal is probably good for users.Continue Reading

• Sales reps out of control on issue of software license compliance

  A software vendor trolls a toll collection agency, and other ridiculous stories in the world of software license compliance.Continue Reading

• Oracle Sun hardware is not for hobbyists, by a long shot

  Old Sun enthusiasts lament the way it used to be, and the way it will never be again. Oracle Sun hardware is a whole other animal.Continue Reading

• Spend smart on Oracle ERP implementations

  Oracle ERP implementations usually take about a year-and-a-half, but a couple examples show that spending smart can shrink the timeline.Continue Reading

• Oracle Fusion Applications implementation: Slower than expected?

  A Forrester report says Oracle Fusion Applications forces a tough choice for users and may be why adoption is slow. But not everyone agrees.Continue Reading

• Excerpt: The key concepts of Oracle WebLogic server

  The Oracle Weblogic server is great, but it's important to understand a few key concepts. Read this excerpt from Oracle WebLogic Server 11g Handbook by Sam R. Alapati to learn why.Continue Reading

• Hyperion upgrade creates issues with migrating Essbase data

  One reader asks how to properly migrate Essbase data when upgrading from Hyperion 9.3.1 to 9.3.3 and then 11.1.2.1.Continue Reading

• Starting an Oracle virtualization project

  Contributor Frank Ohlhorst gives tips on how to start a server virtualization project in an Oracle shop.Continue Reading

• Oracle upgrades: Tips and trends

  If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades.Continue Reading

• Oracle Exalogic: Is Oracle's cloud-in-a-box really cloud computing?

  Oracle’s new Exalogic Elastic Cloud is the company’s announced foray into cloud computing. But does Oracle Exalogicfit the traditional model of cloud computing, and does that matter?Continue Reading

• Oracle Enterprise Manager improves, still far from Big Four

  Oracle Enterprise Manager Ops Center 11g now includes management tools for Sun products, but one analyst says Enterprise Manager is too Oracle-centric to be a big player in systems management.Continue Reading

• Oracle E-Business Suite users face EBS R12 upgrade challenges

  An upgrade to E-Business Suite R12 can offer many benefits, but EBS users have also reported a number of business and technical challenges during and after their EBS R12 upgrade process.Continue Reading

• Users consider Oracle EBS R12 upgrade as Premier Support for 11i ends

  Premier Support for Oracle E-Business Suite11i ends Nov. 30, and end users must decide whether to move to Extended Support, which brings fewer features and higher maintenance fees, or do an EBS R12 upgrade.Continue Reading

• Oracle demos Fusion Applications; Ellison talks up integrated systems

  Oracle executives demoed Fusion Applications at the end of the OpenWorld 2010 keynote on Wednesday. Meanwhile, CEO Larry Ellison dissed Salesforce.com some more and talked up Exalogic and Exadata.Continue Reading

• A nutritional supplement company does Oracle E-Business Suite upgrade

  USANA Health Sciences tackled three key business issues when it performed an Oracle E-Business Suite upgrade: third-party integration, employee turnover and new software modules.Continue Reading

• How to add disk to ASM diskgroup with two-way mirroring

  Learn how to add disk to ASM diskgroup with two-way mirroring and how to specify a failgroup in this tip from Oracle expert Brian Peasland.Continue Reading

• New Oracle Database 11g book offers 'underground' tips

  April Sims, a DBA at Southern Utah University and an Oracle Certified Professional, talks about her new book, “Oracle Database 11g Underground Advice for Database Administrators.”Continue Reading

• Duke Energy emerges from 'dark period' with PeopleSoft 8.9 upgrade

  Scared to touch a fresh PeopleSoft upgrade for years, Duke Energy finally bit the bullet and moved to 8.9. A new financial data hub helped ease the transition.Continue Reading

• Oracle users in wait-and-see mode with Oracle's stack computing strategy

  Oracle continued to press its stack message of integrated applications, middleware, database and hardware, but some Collaborate attendees have heard it before.Continue Reading

• Oracle rolls out new lifecycle management for Sun environments

  Oracle has backed up its promise to support Sun environments with the delivery of Oracle lifecycle management software for Sun’s Sparc and Solaris products.Continue Reading

• How to decrypt an Oracle password using John the Ripper and checkpwd

  Learn how to decrypt an Oracle password with Oracle password crackers like John the Ripper and checkpwd in this tip from an Oracle security expert.Continue Reading

• SELECT statement syntax and examples

  In this chapter, learn how to use the SELECT statement with SELECT statement examples, including the basics of the SELECT statement syntax.Continue Reading

• Comparing servers for Oracle database 11g upgrades

  An Oracle 11g upgrade means server hardware will need more octane. Find out how to compare Oracle 11g servers for database upgrades and which servers will speed performance.Continue Reading

• How to use the CREATE SESSION command to track Oracle database logins

  Oracle security expert Brian Peasland explains how to use the CREATE SESSION command in an Oracle audit table to track Oracle user database logins.Continue Reading

• Oracle E-Business Suite manufacturing and supply chain management

  Find out what the Oracle E-Business software suite can do for manufacturing supply chain management (SCM). Learn supply chain planning and forecasting strategies for Oracle SCM software.Continue Reading

• How to concatenate rows into a single CLOB in PL/SQL

  PL/SQL expert Dan Clamage explains how to concatenate rows into a single CLOB in PL/SQL.Continue Reading

• How to solve an ORA-1555 error in the Oracle testing database

  Expert Brian Peasland explains to a SearchOracle.com reader asks why the ORA-1555 error is showing in the Oracle testing database but not in productionContinue Reading

• How to use SQL Developer to run SQL statements

  In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more.Continue Reading

• How to view and edit table column definitions

  In this chapter, learn how to edit and view column names and column definitions for a table, and when to use SQL Developer to do so.Continue Reading

• How to use SQL*Plus in Oracle

  In this section, learn how to use SQL*Plus in Oracle, which may be used to run SQL statement and scripts if an Oracle database does not have SQL Developer installed.Continue Reading

• How to work with the Oracle database home page

  In this chapter, learn how to work with an Oracle database, including how to start and stop the Oracle database and use the database homepage, before learning how to use Oracle SQL Developer.Continue Reading

• How to use SQL Developer to work with an Oracle database

  In this chapter, learn how to use Oracle SQL Developer to review or modify your database design, navigate database objects and create, export and import database connections.Continue Reading

• How to sort an SQL UNION query with special ORDER BY sequence

  SQL expert Rudy Limeback explains how to sort an SQL UNION query using a special ORDERY BY sequence.Continue Reading

• List the types of SQL subqueries

  In this chapter, learn about the three broad divisions of a subquery in SQL: Single-row, multiple-row and correlated subqueries.Continue Reading

• How to create an SQL CHECK constraint for two letters

  SQL expert Rudy Limeback explains how to create a SQL CHECK constraint for two letters when trying to write a query to retrieve data from two tables.Continue Reading

• How to disable Oracle constraints and triggers during an import in 10g

  An Oracle user asks expert Brian Peasland if constraints and triggers can be disabled on an Oracle import in Oracle 10g and how to complete this task.Continue Reading

• How to return a zero in SQL instead of no row back for a select count

  Want your row to return a zero instead of getting no row backs for some combinations when doing a select count in SQL? Find out how here.Continue Reading

• How to drop tablespace with missing datafile

  Oracle expert Brian Peasland explains how to drop a tablespace with a missing datafile and recreate the tablespace.Continue Reading

• How to use DISTINCT on just one column

  SQL expert Rudy Limeback explains how to use DISTINCT on just one column.Continue Reading

• Integrity constraints and referential integrity

  What is the difference between integrity constraints and referential integrity?Continue Reading

• How to create an index using a procedure in Oracle

  How can we create an index using a procedure?Continue Reading

• How to increase SGA_MAX_SIZE in Oracle

  How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup.Continue Reading

• Relational Database Management System (RDBMS) fundamentals tutorial

  New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system.Continue Reading

• XML for data architects: Designing for reuse and integration (Chapter 8)

  -Continue Reading

• How to validate zip code, city, and state code

  Continue Reading