Please help resolving report generation performance problem...

2002-04-07 Thread Denmark Weatherburne
is a Dell 4400 with Dual CPU and 1GB RAM We are using hardware RAID 5. Our database is OLTP with reporting. It is a small database (exported data is about 150 MB). I would appreciate your recommendations and advice. Thanks in advance, Denmark Weatherburne

ORA-12500 Listener error on Win NT

2001-10-01 Thread Denmark Weatherburne
! Regards, Denmark Weatherburne Belize _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL

[no subject]

2001-10-01 Thread Denmark Weatherburne
is there a possibility that this situation could cause the tablespace or instance to go offline or crash? Thanks for your comments and advice! Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! _ Get

How to resolve Dr. Watson errors on Oracle clients when printing from forms...

2001-09-26 Thread Denmark Weatherburne
have addressed this problem before. I would appreciate any feedback on this problem. Thanks in advance for your time. Regards, Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! _ Get your FREE download

Help tuning the SGA...

2001-09-26 Thread Denmark Weatherburne
drops to (4%) in some cases. This is a learning process for me, so I would appreciate some helpful advice. Thanks for your time. Regards! Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! This is after increasing

RE: Info= Help tuning the SGA...

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

FW:Using Oracle tools to automate hot backups...

2001-09-14 Thread Denmark Weatherburne
on the most efficient and effective tool for this process. Thanks in advance, Denmark Weatherburne Belize Knowledge is power, but it is only useful if it is shared

How to loop call to SQL script in PL/SQL...

2001-08-29 Thread Denmark Weatherburne
for the help. Regards, Denmark Weatherburne Knowledge is power, but it is only usefule if it is shared! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http

Help using find for Perl...

2001-08-29 Thread Denmark Weatherburne
executed it, no output resulted and after about 30 seconds the command prompt was returned. Definately the remote machine I was searching has lots of .bat files. Please help! Thanks in advance, Denmark Weatherburne Knowledge is power, but it is only useful if it is shared

Do you use Ora8 Perf. Mon. v8.0?

2001-08-27 Thread Denmark Weatherburne
that comes with Oracle for Windows NT. It has to be configured with appropriate counters to display graphs. Is this a useful tool? If anyone uses it, I would appreciate some documentaion on configuring it. Thanks in advance, Denmark Weatherburne Belize Knowledge is power, but it is only useful

Efficient way to monitor table growth...

2001-08-27 Thread Denmark Weatherburne
know I'll need to add another datafile to the tablespace soon. However, I'd like to find out which are the active tables in each tablespace and track the row insert growth on a daily basis. Any ideas? Thanks for your help. Denmark Weatherburne Belize Knowledge is power, but it is only useful

How to interpret Alert.Log Trace files...

2001-08-24 Thread Denmark Weatherburne
parameters can impact others. I know this is a lot to chew on, but feel free to send me to sites that might provide technical resources. Unfortunately, I don't have access to Metalink. Thanks in advance, Denmark Weatherburne Knowledge is power, but it is only useful if it is shared

No Subject

2001-08-23 Thread Denmark Weatherburne
the number of databases that are open? Thanks in advance for your input! Denmark Weatherburne _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http

Help interpreting Oracle CPU usage results on NT 4.0...

2001-08-23 Thread Denmark Weatherburne
? Thanks in advance for your time. Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L

Automating or scheduling backups from OEM on NT 4.0

2001-08-22 Thread Denmark Weatherburne
and scripts if possible. Thanks for your help! Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see

RE: Automating or scheduling backups from OEM on NT 4.0

2001-08-22 Thread Denmark Weatherburne
Tools and/or My Computer. HTH -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Denmark Weatherburne [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 11:12 AM

Help automating SQL Hot Backup script with batch file...

2001-08-14 Thread Denmark Weatherburne
\database\ctrlPROD.bak; alter database backup controlfile to trace; --SQL file appended to ORACLE_HOME\RDBMS80\Trace\(current Ora9.trc file); spool off Thanks in advance for your help, Denmark Weatherburne Knowledge is power, but It is only useful if it is shared

Re: RMAN cold backup?

2001-08-14 Thread Denmark Weatherburne
] _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: RECOVERY

2001-08-13 Thread Denmark Weatherburne
to complete recovery of a database is unavailable, I believe I can use Point in Time Recovery. I've never tested this scenario before. What approach is best? How can I determine what is the appropriate time to recover to? Thanks in advance, Regards, Denmark Weatherburne Knowledge is power

After restoring PROD to another NT server as DEV...

2001-08-13 Thread Denmark Weatherburne
is power, but it is only useful if it is shared! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET

Re: RAID or NOT to RAID? What's the diff???

2001-08-13 Thread Denmark Weatherburne
). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: RE: RAID or NOT to RAID?

2001-08-09 Thread Denmark Weatherburne
with these configurations to be efficient. Regards, Denmark Weatherburne Belize From: Berj Kacherian [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: RE: RE: RAID or NOT to RAID? Date: Thu, 9 Aug 2001 10:19:26 -0700 You've got the right idea. RAID 1+0 is the best that you can use, but also

RE: RE: RAID or NOT to RAID?

2001-08-09 Thread Denmark Weatherburne
with these configurations to be efficient. Regards, Denmark Weatherburne Belize From: Berj Kacherian [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: RE: RE: RAID or NOT to RAID? Date: Thu, 9 Aug 2001 10:19:26 -0700 You've got the right idea. RAID 1+0 is the best that you can use, but also

Fwd: RE: RAID or NOT to RAID?

2001-08-08 Thread Denmark Weatherburne
you agree to these terms:http://www.lazydba.com/legal.html _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne

Help Creating a new SID on NAS drive from hot backup

2001-08-08 Thread Denmark Weatherburne
configuration file. I used both the local and remote paths. Please tell me if I'm wasting my time or give me some help. Thanks in advance for your time, Denmark Weatherburne Knowledge is power, but it is only useful if it is shared

Testing posting to Oracle-L list...

2001-08-07 Thread Denmark Weatherburne
://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Recovery Question from Denmark W. in Belize

2001-08-01 Thread Denmark Weatherburne
is the function of the Online/offline REDO Logs? We are using TCP/IP over ethernet LANs and WAN with 256Kb fiber backbone and 100Mb NICs. Thanks in advance for your time, Denmark Weatherburne From: Blizzard, Michael [EMAIL PROTECTED] To: 'Denmark

Request for advice Re: Oracle export error...

2001-08-01 Thread Denmark Weatherburne
the dba_queue_table and SYS.EXPACT$ table? Thanks in advance for your time! Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! From: A. Bardeen [EMAIL PROTECTED] To: Denmark Weatherburne [EMAIL PROTECTED] Subject: Re: More details re Oracle export error... (w