Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use multiple dump files for large Oracle exports
- Even as far back as Oracle 8i, the Export utility could handle large exports by splitting them into multiple output files. Bob Watkins reviews how this is done prior to Oracle 10g and what changes are necessary for 10g and later. Oracle's Export utility exp is a useful part...
- Tags: Oracle Corp., Storage, Databases, Bob Watkins, database, Oracle Tips Newsletter, Export, FILE Parameter, Application Servers, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2007-05-29
- Render SQL*Plus output in HTML
- Oracle's SQL*Plus query tool can create output as HTML tables in addition to plain text. The output format is controlled by the SET MARKUP command. Bob Watkins offers more details in this Oracle tip. SQL*Plus has traditionally been thought of as a plain text SQL query tool. But...
- Tags: HTML, Bob Watkins, Render SQL*Plus, markup, Oracle Tips Newsletter, Oracle Corp., SQL*Plus
- Technical articles 2007-05-23
- Understanding roles in Oracle stored procedures
- Permissions in Oracle granted indirectly via roles are not available when compiling stored procedures, functions, and packages. Direct grants are required when creating these objects in the database. Learn more details in this Oracle tip. One of the trickiest parts of Oracle's security model is the way that...
- Tags: Oracle Corp., Advertising & Promotion, Bob Watkins, Abel, permission, Oracle Tips Newsletter, Database, Role, Marketing
- Technical articles 2007-05-15
- Encrypt backups using Oracle 10gR2's RMAN
- No IT pros want their company to make headline news because of a data breach. You can make your data less vulnerable to theft by using a new feature in Oracle 10g Release 2 that lets you make encrypted backups via Recovery Manager. A spate of recent news stories...
- Tags: Oracle Corp., Backups, Bob Watkins, password option, password, backup, RMAN, Oracle Tips Newsletter, Wallet
- Technical articles 2007-05-08
- Three ways to avoid Case Not Found errors in PL/SQL
- Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. Bob Watkins presents three ways to code around this error. PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE...
- Tags: Oracle Corp., PL/SQL, Databases, Bob Watkins, Programming languages, PL/SQL CASE, CASE statement, clause, Oracle Tips Newsletter, Solution, Statement, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2007-05-01
- Copy legacy Oracle tables with SQL*Plus
- Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. Bob Watkins shows you how in this Oracle tip. You may be running Oracle 10g Release 2, but the applications you're supporting may...
- Tags: Oracle Corp., Bob Watkins, LONG RAW, Oracle Tips Newsletter, Downside, Corporate Communications, Storage, Databases, Marketing, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2007-04-24
- Don't overlook STATSPACK in Oracle 10g
- Bob Watkins passes along a tip from a local Oracle Users Group seminar: don't ignore STATSPACK in Oracle 10g. It's still there, and it has some great new measurements. I had the privilege last month of hearing Rich Niemiec of TUSC speak about performance tuning at the Dallas...
- Tags: Oracle Corp., Oracle Application Server 10g, Bob Watkins, Application servers, Statspack, Oracle Tips Newsletter, Enterprise Software, Software
- Technical articles 2007-04-17
- Use Oracle 10g's DBMS_SCHEDULER to control batch job resources
- Unlike the older DBMS_JOB package, DBMS_SCHEDULER in Oracle 10g is integrated with Resource Manager to give you precise control over the resources consumed by batch jobs. Oracle 10g introduced a replacement for the venerable DBMS_JOB package. DBMS_SCHEDULER has many benefits over DBMS_JOB, such as easier specification of...
- Tags: Oracle Corp., Oracle Application Server 10g, DBMS_SCHEDULER, Resource Manager, Recruitment & Selection, Bob Watkins, job, job class, Resource Plan, Consumer Resource Group, window, Oracle Tips Newsletter, Human Resources, Workforce Management
- Technical articles 2007-04-10
- Comparing Oracle 10g column masking to relational views
- Thanks to the suggestion of TechRepublic member BrooklynPennyPincher, this Oracle tip compares two approaches to hiding column-level data on a report: the Virtual Private Database and relational views. In a previous tip, I described how a column's data could be masked hidden using Oracle 10g's Virtual Private Database...
- Tags: Oracle Corp., Oracle Application Server 10g, Listing B, Bob Watkins, Virtual Private Database, relational view, predicate, salary, Oracle Tips Newsletter, View, Benefits, Human Resources
- Technical articles 2007-04-02
- Use logon triggers to initialize user sessions in Oracle
- Application contexts enable you to store data in memory for applications to use. The After Logon database trigger is a convenient way to initialize a user session by setting application context values for it. This Oracle tip shows you why—and how—it's done. You may be aware of the old...
- Tags: Oracle Corp., SYS_CONTEXT, Databases, Bob Watkins, Enterprise software, HR_CONTEXT, Oracle Tips Newsletter, Database, Context, Application Context, Application Context Data, Storage, Hardware, Software, Data Management
- Technical articles 2007-03-27
- Capture an Oracle 10g audit trail in XML format
- Oracle 10g can be configured to write its audit logs to XML files in operating system directories. This tip shows the configuration changes that need to be made, as well as how to access the resulting XML files. The Oracle database has long had the ability to audit ...
- Tags: Oracle Corp., XML, Oracle Application Server 10g, Oracle Database, Databases, Bob Watkins, Financial accounting, audit, database, SYS.AUD$, operating system, Oracle Tips Newsletter, Finance, Enterprise Software, Software, Data Management
- Technical articles 2007-03-19
- 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. For several releases now, DBAs and developers have had access to three dynamic performance...
- Tags: Oracle Corp., SQL, V$SQLAREA, V$SQLTEXT, V$SQL, Databases, Bob Watkins, Programming languages, SQL Statement, performance, Oracle Tips Newsletter, View, Performance View, COMMAND_TYPE Column, Performance Management, Human Resources, Workforce Management, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2007-03-06
- 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. SQL Tuning Sets STS are a part of Oracle 10g's SQL Tuning Advisor feature. Each tuning set...
- Tags: Oracle Corp., SQL, Databases, Bob Watkins, Programming languages, SQL Tuning Set, DBMS_SQLTUNE, Oracle Tips Newsletter, Procedure, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2007-02-27
- Delete rows during updates using Oracle 10g's MERGE statement
- In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works. The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both...
- Tags: Oracle Corp., Oracle Application Server 10g, Storage, Databases, Bob Watkins, Listing B, clause, Oracle Tips Newsletter, Transaction, Statement, MERGE, UPDATE, INSERT, Application Servers, Business Intelligence, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-02-20
- Trade risk for speed with Oracle 10g's asynchronous COMMIT
- A new option to the COMMIT statement in Oracle 10g can defer the writing of committed data to the online redo log files. This involves a risk of data loss, but it speeds up the transaction response time. Find out more details in this tip. One thing that Oracle...
- Tags: Oracle Corp., Oracle Application Server 10g, Bob Watkins, Application servers, COMMIT statement, NOWAIT, Oracle Tips Newsletter, COMMIT, Enterprise Software, Software
- Technical articles 2007-02-13
- Hide sensitive data with Oracle 10g column masking
- Oracle 10g's Virtual Private Database VPD feature has the ability to automatically mask out set to NULL certain columns in the results of a query on a row-by-row basis. This tip shows how to create a VPD policy that requests the column masking option. Oracle's Virtual Private Database VPD...
- Tags: Oracle Corp., Oracle Application Server 10g, Databases, Bob Watkins, Application servers, Oracle Tips Newsletter, Column, PL/SQL Policy Function, Enterprise Software, Software, Data Management
- Technical articles 2007-02-06
- Look inside ASM disk groups with Oracle 10gR2's ASMCMD
- In Oracle 10g Release 2, Oracle introduced a new command line tool called ASMCMD that lets you look inside Automatic Storage Management ASM volumes. Get an overview of the ASMCMD commands, and learn about a few of the tool's quirks. In 10g, Oracle introduced a new kind of storage...
- Tags: Oracle Corp., ASMCMD, Automatic Storage Management, Bob Watkins, Application servers, disk, disk group, storage, Oracle Tips Newsletter, Oracle Application Server 10g, Disk Storage, File System Storage
- Technical articles 2007-01-30
- Detect hierarchy loops with Oracle 10g's new hierarchy pseudocolumns
- Hierarchical queries sometimes fail because the data contain rows that reference each other: a loop. Oracle 10g has syntax and two new pseudocolumns to aid in finding such loops. In a previous tip, I described how to sort the entries in a hierarchical query. For a hierarchical query...
- Tags: Oracle Corp., Oracle Application Server 10g, Bob Watkins, NOCYCLE parameter, loop, Oracle Tips Newsletter, Listing B, Application Servers, Enterprise Software, Software
- Technical articles 2007-01-23
- Convert databases to different platforms using RMAN
- The Oracle Database supports the direct movement of tablespaces from one instance of Oracle to another. In the past, the destination was required to use the same operating system platform as the original. Oracle 10g contains tools in the Recovery Manager RMAN to extend these moves to other platforms. ...
- Tags: Oracle Corp., RMAN, CONVERT DATAFILE, Databases, Bob Watkins, database, Convert Database, CONVERT TABLESPACE, tablespace, Oracle Tips Newsletter, Oracle Application Server 10g, Oracle Database, FORMAT Clause, Storage, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2007-01-16
- Resize BIGFILE tablespaces directly using ALTER TABLESPACE
- Database administrators can now resize Oracle datafiles at the tablespace level using the BIGFILE tablespace feature in 10g. Bob Watkins explains how in this Oracle tip. Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles,...
- Tags: Oracle Corp., BIGFILE, Storage, RAID, Bob Watkins, datafile, tablespace, Oracle Tips Newsletter, TechRepublic Inc., Hardware
- Technical articles 2007-01-09
