RE: Oracle Warehouse Builder Tutorial

Title: RE: Oracle Warehouse Builder Tutorial Mark, Take a look at OTN (http://otn.oracle.com/products/warehouse/index.html). There is a little information there. Unfortunately, there isn't much documentation on OWB. The online help docs with the product were all I found last year. There was

RE: encrypt back-up data

Title: RE: encrypt back-up data Veritas NetBackup can do thissearch the Veritas site for NetBackup Encryption 4.5. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT

RE: partitioning option licensing

Title: RE: partitioning option licensing As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year,

RE: PostgreSQL 7.4 release

One new feature that is not listed in the 7.4 release is Point In Time Recovery, which will hopefully make it into the 7.5 release. According to the PostgreSQL lists, it's in the works. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web:

RE: Stop using SYS, SYSTEM?

Title: RE: Stop using SYS, SYSTEM? Jared, I followed Robert Freeman's advice and created an RMAN user in all my DBs called backup_admin with SYSDBA privilege so that RMAN doesn't use SYS or SYSTEM. This allows you to change system passwords at will and not interfere with backups. Works just

RE: Overhead Associated with Signon Audit in Financials 11.0

Victoria, Check out Tom Kyte's new book- he encourages the use of auditing, especially Oracle's built-in auditing rather than home-grown. He provides a nice bench-mark test example to compare the performance of loading 30,000 rows into both cases and native auditing won. DIY auditing had a

Query Tuning Help

Title: Query Tuning Help I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows). SELECT a2.class_config_id, a1.schedule_name FROM class_config a2, class_schedule a1 WHERE a2.class_config_id =

RE: Query Tuning Help

al Message-From: David Wagoner Sent: Monday, October 27, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Query Tuning Help I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows).

RE: Query Tuning Help

.Thank you. -Original Message-From: David Wagoner Sent: Monday, October 27, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Query Tuning Help I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~35

RE: Query Tuning Help

,optimizer_index_cost_adj)? Is everything analyzed? On 10/27/2003 10:34:26 AM, David Wagoner wrote: I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows). SELECT a2.class_config_id, a1.schedule_name FROM

Share Data between PostgreSQL and Oracle

Title: Share Data between PostgreSQL and Oracle Anyone have experience doing this? I would like to hear your tips and experiences. Here's our situation. We have an Oracle DB on Sun Solaris 8 and a PostgreSQL DB on Linux (RH 7.3) that we need to share data between, specifically from

Effect on Oracle of changing server time from EST to GMT

Title: Effect on Oracle of changing server time from EST to GMT To support internationalization, we may need to change our server time zone from US EST to GMT. What effect, if any, will this have on the Oracle databases? Best regards, David B. Wagoner Database Administrator Arsenal

RE: how to keep statistics up to date for CBO

Title: RE: how to keep statistics up to date for CBO I like to use a cron job that runs the following in SQL Plus: begin dbms_stats.gather_schema_stats(ownname= 'YOUR_SCHEMA_NAME', options= 'GATHER AUTO'); end; You should search the Oracle docs for your version of Oracle (you didn't

FW: Oracle Performance Software from Veritas

Just got this email from Veritas...apparently they are getting into the database performance business for Oracle (and SQL Server too I think). Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions "the most trusted source for STORAGE MANAGEMENT SERVICES" The

RE: Physical I/O and databases other than oracle

Title: RE: Physical I/O and databases other than oracle According to one recently published source*, in a well-tuned database system, the server should be CPU-limited. The reasoning here is that in a perfectly tuned system, the other bottlenecks of I/O, network, etc. have been eliminated, so

RE: Re: Cary's book -- Out of stock !

racle Wait Interface" from Gaja V., Kirti D., and R. Shee due out in March 2004. Can't wait! Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions-Original Message-----From: David Wagoner Sent: Monday, September 22, 2003 12:00 PMTo: Multiple recipients of l

RE: Re: Cary's book -- Out of stock !

Title: RE: Re: Cary's book -- Out of stock ! UPS just delivered my copy of Cary's book to the office! Can't wait to read it, but first I plan to finish the books I'm currently reading: - The Art and Science of Oracle Performance Tuning (Chris Lawson) - Oracle SQL High-Performance Tuning (Guy

RE: how can I see which database I am logged into without

Title: RE: how can I see which database I am logged into without You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the name from? You can

RE: how can I see which database I am logged into without

Title: RE: how can I see which database I am logged into without My point was that you can see different names by using different queries. But, you and Mike brought up a good point- I need to use the alter database rename global_name to XXX after cloning databases to avoid any such confusion.

International Language Support Experiences?

Title: International Language Support Experiences? We have a new requirement to support multiple languages in at least one of our databases. I'm reading the Oracle 9iR2 Globalization Support Guide (450 pages), but wonder if any of you can share real-life experiences regarding: 1. the

RE: RMAN Script Question

Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: 06 August 2003

RMAN Script Question

Title: RMAN Script Question I believe I have an RMAN script syntax error. The following script works fine: resync catalog; run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 0 skip inaccessible tag hot_db_bk_level0 filesperset 5 format 'data_full_%d_%U_%p_%c.bak'

RE: Consolidating Servers

Title: RE: Consolidating Servers This is exactly what I am working on right now! We have to consolidate down from about 5 servers to 2 (Prod. and Test/Dev.). My approach is to just move (clone) the DBs first. That's a job in itself, considering that the production DBs need to be moved during

Capacity Planning Methods?

Title: Capacity Planning Methods? How do you guys collect capacity planning metrics, such as DB size? Do you use StatsPack, Oracle OEM, others? I'm interested in an efficient method to track DB growth in GB month over month. Best regards, David B. Wagoner Database Administrator

RE: PERL reference

Title: RE: PERL reference The Deitel and Deitel book PERL: How to Program is the top rated PERL book on Amazon. Just got it myself but can't offer an opinion yet. I know it's used by the local technical college for their PERL class. It's cheaper at www.bookpool.com. 1. Perl How to Program,

RE: What books recommended for Data Modeling ?

I took the advice of Dennis Williams and just read "The Data Modeling Handbook" (http://tinyurl.com/j5wr) and found it to be excellent for normalization of OLTP systems. The authors clearly have lots of experience and offer many "rules" and best practices. The book is expensive for it's

RE: Capacity Planning Methods?

Title: RE: Capacity Planning Methods? Rich, I'd love to see the procedure and table that you use. Thanks for offering. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions

RE: Increase tablespace, which way is better?

Title: Message My first question is: Why are you adding a data file named "users" to your SYSTEM tablespace? Do you mean to add this to your USERS tablespace? Next, if you have an idea about the data growth or size of objects that you will place in the new datafile then you can better

Physical Design Question

Title: Physical Design Question Here's my situation: Damagement wants us to move 4 small production DBs to one server to save on licensing costs. Server is a Sun E4500, 4 CPUs, 8 GB RAM. There is a pair of internal disks that are mirrored with enough room for Solaris, swap, and 1 Oracle

RE: Physical Design Question

Title: Physical Design Question Thomas, Thanks for the comments. The databases are all different versions (8.1.7.3 to 9.2.0.2.0), at least for the time-being. In your suggestion to use 1 Oracle Home for multiple databases, then maybe later split into multiple Oracle Homes, do you have to

RE: SORT_AREA_SIZE question

You didn't specify which version of Oracle you are using, but if it's 9i then you should investigate the use of pga_aggregate_target instead of the older sort_area parameters. I've been using pga_aggregate_target in a hybrid OLTP/reporting database for about 8 months with great results.

RE: DBA Salary in California

Title: RE: DBA Salary in California Check out www.salary.com for an estimate. A quick check revealed a range of $68-90K with a median around $79K. Not sure how recent these numbers are. Best regards, David B. Wagoner Database Administrator -Original Message- From: Gabriel

RE: Listener Hanging 64 Bit Solaris 8 Oracle 9.2

://www.orafaq.net -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: US Travel for the DBA

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat

RE: Take Care of your DBAs

Title: Take Care of your DBAs I love this article. I forwarded it to damagement too because they havent been showing enough love for the DBAs lately ;-). Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway,

Table Partitioning in a Hybrid-OLTP System

Ive been reading the 9iR2 docs on partitioning, along with Tom Kytes excellent chapter on the subject. It seems that a Global index or unique, local indexes could be used effectively in an OLTP system, but both have their caveats. This is a hybrid system- its part OLTP but is also used

RE: Unix for oracle dba -- Suggest a book ?

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: warehouse builder's dependance on oem job system.

Title: warehouse builder's dependance on oem job system. You may have implied this in your message, but are you using Oracle Workflow in conjunction with OEM? That is the scheduling method that is taught in the OWB class by Oracle. I am currently learning OWB but have not setup

RE: Oracle SAN Experiences?

James, Thanks for the tips. Ive read your Sane SAN article several times and think its excellent. Ill check out the other article too. Best regards, David Wagoner Oracle DBA Cary, NC -Original Message- From: James Morle [mailto:[EMAIL PROTECTED]] Sent: Tuesday

Oracle SAN Experiences?

Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA

RE: How to move 200 GB db from prod to dev?

Title: How to move 200 GB db from prod to dev? Search the Oracle-L archives- this question has been covered several times recently. Also, Oracle DBA Tips Techniques by Sumit Sarin (2000, Oracle Press) has detailed instructions for cloning a database in Chapter 1. Note the error in the

RE: Remove Duplicates

Here is an interesting script I found on Metalink (Note:1019920.6) for removing duplicates, but I have not tried it yet: == Title: == Script to Eliminate Non-unique Rows === Disclaimer: === This script is provided for educational purposes only. It is NOT

RE: Oracle RAC and NAS

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David

New Oracle 9.x Pre-Install Script from Oracle

Just saw this todayhavent tried it yet. Excerpt from MetaLink: News Notes New Script: Pre-Install script which checks your Unix environment to ensure successful installation of Oracle 9.x version of RDBMS The Data Server Support team is pleased to release a new

RE: Installing oracle 9.0.1 on Sparc

://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: Remove an SID from sun solaris

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: DB freezes ... no indications of any kind

is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Excel's Oracle connectivity

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services

RE: alter index rebuild online

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services

Automatic PGA Memory Management via PGA_AGGREGATE_TARGET paramete

I just stumbled upon the Automatic PGA Memory Management section of the 9i docs. Ive never heard of this before. Does anyone know how long its been around? Anyone using it found any bugs, concerns, etc.? Granted, this is intended for *dedicated* server mode, it seems like a good option

RE: Automatic PGA Memory Management via PGA_AGGREGATE_TARGET para

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Solaris Kernel Memory Parameters Recommendations?

Ive read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation. The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself.

Convert TEMP tablespace to LMT?

What is the best way to convert a dictionary-managed TEMP tablespace to locally managed? Heres my situation, I created an 8.1.7 database with all dictionary-managed tablespaces. Then, I converted all tablespaces to locally managed, except SYSTEM and TEMP. The conversion packaged refused

Query to determine 32 or 64 bit?

Whats the query to determine if the Oracle version is 32 or 64 bit? I queried v$version but its not there. I know there is a query because Ive seen it before but dont remember it. david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor

RE: CREATE DATABASE scripts

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Virus Warning

Do not open messages with a Hi subject and a screensaver attachment. Its a virus circling around our company now. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919)

RE: Some 9i Questions - Help!

ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Comments on RMAN

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Script to Disable Constraint, Change Value, then Enable Const

to do this - do you have any more info? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Wagoner Sent: 27 November 2001 21:30 To: Multiple recipients of list ORACLE-L Subject: Script to Disable Constraint, Change Value, then Enable Constrain Listers

RE: Script to Disable Constraint, Change Value, then Enable Const

, use 'deferrable constraints, should work in your situation. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 28, 2001 11:24 AM Subject: RE: Script to Disable Constraint, Change

RE: Script to Disable Constraint, Change Value, then Enable Const

: Wednesday, November 28, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script to Disable Constraint, Change Value, then Enable Const David, You need a semi-colon after line2 i.e., update table1 ...; Rick -Original Message- From: David Wagoner [mailto:[EMAIL

Script to Disable Constraint, Change Value, then Enable Constrain

Listers, Does anyone have a script that will do the following: Accept user input for old data value Accept user input for new data value Disable table constraint Update record with new data value Enable constraint A script like this would help

RE: RE: Oracle Browser 2

Reply Separator Author: David Wagoner [EMAIL PROTECTED] Date: 10/29/2001 10:52 AM Dick, Can you elaborate a little on the instability of Oracle Discoverer 3000 with Oracle 9i database? I was planning to investigate Discoverer as an end-user reporting

RE: Instance Name in Sql Prompt

Add the following to your login.sql or glogin.sql file: set serveroutput on set termout off column instance new_value prompt_instance select substr(instance_name, 1, 10)instance from v$instance / set sqlprompt prompt_instance set termout on HTH, david David B.

RE: To Users of 9i

: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

RE: Physical access to servers for maintenance

://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Best Uses for Oracle Designer 2000?

Is anyone out there deriving much benefit from Oracle Designer 2000? My company has the product and I set it up but it looks like the initial investment in learning the product and creating everything in the repository will be extremely time-consuming. So, please tell me your favorite uses

Scripts for Rebuilding Indexes Nightly on Solaris

. Thanks in advance, David Wagoner Oracle DBA

RE: Scripts for Rebuilding Indexes Nightly on Solaris

Thanks for the tips and scripts! David Wagoner Oracle DBA -Original Message- Sent: Thursday, September 06, 2001 1:33 PM To: Multiple recipients of list ORACLE-L David - Use cron. Nightly might be excessive. Kick off a shell script (remember that cron executes as root, so you

RE: database upgrade policy?

you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: database upgrade policy?

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: database upgrade policy?

guess they are pushing it on everyone now. Anyway, we are in the process of upgrading our test databases to 9i (using Sun SPARC Solaris 8). If all is well we will upgrade production to 9i. David Wagoner Oracle DBA -Original Message- Sent: Wednesday, August 22, 2001 11:45 AM

Simultaneously Patch Multiple DBs on same Server?

Hi, I plan to install an Oracle patchset (from 8.1.6.0.0 to 8.1.6.3.0) on a server that has four databases and Im wondering if I have to run the patch 4 times or is there a way to make it update all 4 SIDs simultaneously? Anyone have similar experiences? TIA, David Wagoner

RE: Simultaneously Patch Multiple DBs on same Server?

Thanks to those of you who emailed me offline. Best, david -Original Message- From: David Wagoner Sent: Tuesday, August 14, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Subject: Simultaneously Patch Multiple DBs on same Server? Hi, I plan to install

RE: Designer 2000 install on Linux

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: sqlloader stops

Just a stab here... Check the .bad files to see if you are getting any data rows kicked out due to errors. If so, you might be exceeding the ERRORS parameter by the time you finish the third file. HTH. David Wagoner DBA -Original Message- Sent: Tuesday, August 07, 2001 4:15 PM

SQL*Loader question- Transforming Data

Im using SQL*Loader to populate a database table with transaction records. The data file contains some transactions that I want to exclude from the load and they all contain the same text string, something like xxx,yyy,FLAG_TEXT,xxx,yyy. Can I use a SQL statement in the SQL*Loader control

RE: SQL*Loader question- Transforming Data

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Data load options

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: [Q] does Personal ORACLE 8.1.7 support Win98?

I had the same problem- my Personal Oracle 8.1.7 installation hung up during creation of the test database on Win98. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919)