RE: measuring TPM

2004-01-28 Thread Post, Ethan
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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network

Statspack Will Not Install Oracle 9.2.0.4

2004-01-26 Thread Post, Ethan
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Statspack Will Not Install Oracle 9.2.0.4

2004-01-26 Thread Post, Ethan
') 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.net -- Author: Post, Ethan INET

HP-UX Can not authenticate via OS

2004-01-09 Thread Post, Ethan
-- Author: Post, Ethan 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 this mailing list

ORA-01401: inserted value too large for column

2003-10-16 Thread Post, Ethan
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Shell script broken, bdf adds new line for long filesystem name.

2003-10-07 Thread Post, Ethan
-- Author: Post, Ethan 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 this mailing list

more 64 bit vs. 32 bit

2003-10-07 Thread Post, Ethan
to the frontend. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Openworld Papers

2003-10-07 Thread Post, Ethan
Been off the list for a few days, anyone know if the papers from Openworld have been posted anyplace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Software Download

2003-10-07 Thread Post, Ethan
Well I found the Openworld papers on technet but now I can't find the software download page for Oracle 9 software, have they removed it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

unread message event

2003-09-03 Thread Post, Ethan
to be around instance start up). select location_name from loc$; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Listener Lockout Feature

2003-09-03 Thread Post, Ethan
-L FAQ: http://www.orafaq.net -- Author: Post, Ethan 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

RE: Listener Lockout Feature

2003-09-03 Thread Post, Ethan
Yeah -Original Message- Sent: Wednesday, September 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Whoops, disregard my last post - do you mean logging on to lsnrctl? -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE

RE: optimizer_max_permutations

2003-08-28 Thread Post, Ethan
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Free Training

2003-08-27 Thread Post, Ethan
Title: Message Anyone been contacted recently by Oracle with the offer of "free" training through their http://oracledirect.oracle.com/iccdocs/seminarList.shtmlwebsite? Is it all sales meterial? Is this part of a bigger customer retention move? Your thoughts. Greatly appreciated, Ethan

RE: perl/shell script for alert log

2003-08-27 Thread Post, Ethan
http://www.oracledba.co.uk/ Check out the alert log script in the admin section. Doesn't repeatedly check the same segment of the alert log file. - Ethan -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 12:14 PMTo: Multiple

RE: perl/shell script for alert log

2003-08-27 Thread Post, Ethan
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: perl/shell script for alert log

2003-08-27 Thread Post, Ethan
or customers ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Alert log....

2003-08-27 Thread Post, Ethan
://www.orafaq.net -- Author: Post, Ethan 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: perl/shell script for alert log

2003-08-27 Thread Post, Ethan
. I would suggest a governor of some sort in your servererror trigger. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Legal Mumbo Jumbo

2003-06-09 Thread Post, Ethan
the appropriate license. We may audit your use of the programs. Program documentation is either shipped with the programs, or documentation may accessed online at http://otn.oracle.com/docs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL

RE: 10046 tracing in PRO C programs?

2003-05-31 Thread Post, Ethan
101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney - Visit www.hotsos.com for schedule details... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

C++ Issues

2003-05-30 Thread Post, Ethan
: Post, Ethan 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 this mailing list, send an E

RE: Sun=/var/messages HP-UX=???

2003-03-14 Thread Post, Ethan
ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Is async IO configured on HP-UX?

2003-03-13 Thread Post, Ethan
call or will I get a timeout on async call then perform standard write? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Sun=/var/messages HP-UX=???

2003-03-12 Thread Post, Ethan
I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

How Reliable is Explain Plan in 9.2

2003-03-05 Thread Post, Ethan
recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: RE: How Reliable is Explain Plan in 9.2

2003-03-05 Thread Post, Ethan
expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: How Reliable is Explain Plan in 9.2

2003-03-05 Thread Post, Ethan
Title: Message A, that is what he is talking about, I wasn't aware of v$sql_plan. -Original Message-From: Toepke, Kevin M [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How Reliable is Explain Plan in

HP OpenView Service Desk

2003-03-04 Thread Post, Ethan
Anyone running Oracle to support HP OpenView Service Desk, would like to know # of users supported, options and size of system? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Post, Ethan
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Post, Ethan
, i.table_name ) order by 3 desc; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Post, Ethan
on monitoring on the tables. alter table xyz monitoring; Then periodically check dba_tab_modifications. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Post, Ethan
-- Author: Post, Ethan 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 this mailing list

RE: Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Post, Ethan
Applications DBA DBSoft Inc (W): 408-970-7002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Post, Ethan
from v$statname n, v$sesstat v where v.statistic# = n.statistic# and name like 'redo size' and value 10 order by value desc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Programming languages that make DBA's lives easier

2003-02-21 Thread Post, Ethan
Title: RE: Programming languages that make DBA's lives easier That is a great link :) -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Programming languages that

RE: Know 1 database, know them all?

2003-02-18 Thread Post, Ethan
If you are always wrong then you must be right about one thing (being always wrong), so there is reason to be cheerful, at least you got one thing right. -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 2:19 PMTo: Multiple

RE: [new info] Redhat Advanced Server Dev Edition - RAC

2003-02-13 Thread Post, Ethan
-- Author: Post, Ethan 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 this mailing list, send

RE: Send Mail in Unix

2003-02-13 Thread Post, Ethan
I usually ... uuencode filename filename | mailx -s foo [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 13, 2003 11:39 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL

Listener Hanging 64 Bit Solaris 8 Oracle 9.2

2003-02-13 Thread Post, Ethan
Anyone had this issue? Oracle support has been helpless so far, even with mega trace files. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: AT command ??

2003-02-13 Thread Post, Ethan
: Thursday, February 13, 2003 4:00 PM To: Multiple recipients of list ORACLE-L Hi all, Can anyone give me some examples of AT command in windows? Thank you! Janet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services

RE: Oracle License for Training

2003-02-12 Thread Post, Ethan
in the future? Or should I leave all the egg$ in the Oracle basket? Musing for fun and profit. Rick Weiss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: [new info] Redhat Advanced Server Dev Edition - RAC

2003-02-11 Thread Post, Ethan
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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

2003-02-06 Thread Post, Ethan
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit. Lisa, Be aware that there are some issues with ML9 as I am finding out with swap. We are planning on going to ML10 which should fix the problem as well as using vmtune command

RE: Oracle 101 Performance Tuning comes to the rescue again!

2003-01-31 Thread Post, Ethan
Tom, would a monitor in place have notified the admins as to a locking issue? I usually run Steve Adam's enqueue.sql script to find locked objects. Also have monitors in place that generate an email when locked exceed a specific time. Pretty typical for me to call an app dev and ask him if

RE: Debate on rc commands Solaris and Oracle

2003-01-30 Thread Post, Ethan
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.net -- Author: Post

RE: Dictionary location or initSID.ora and PWDsid.ora

2003-01-24 Thread Post, Ethan
Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: unix time conversion function

2003-01-24 Thread Post, Ethan
Title: unix time conversion function Kinda...you can change the year to 1970 if you want, this also converts to minutes, not seconds. It is a really ugly function but it seems to work. You could always use perl. function f_minutes { # Funky function I use to calculate the number of minutes

RE: Producing .mdb output from sqlplus or SQL or PL/SQL

2003-01-24 Thread Post, Ethan
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL .mdb files are Microsoft Access database files. Best best is import the data from the database into Access using ODBC connection or to create a flat file. Access can work directly with the flat file (hey Access has been doing

Perl Breakdown

2003-01-24 Thread Post, Ethan
without calling another script. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: unix time conversion function

2003-01-24 Thread Post, Ethan
Title: unix time conversion function Yes I knew it was easier in perl, I prefer to distribute a single script whenever possible and I write pretty much everything in shell. However, I just figured out a trick to put the perl directlyin my .ksh scripts (see the post I posted a few minutes

Clean Up Win2K Event Log

2003-01-23 Thread Post, Ethan
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: create tablespace script

2003-01-21 Thread Post, Ethan
Title: create tablespace script Watch out because this also creates the DDL for the system tablespace, if you are using real temporary tablespaces it will not create the DDL for that. declare cursor c_ts is select * from dba_tablespaces; cursor c_df (p_tablespace varchar2) is select * from

filemon

2003-01-21 Thread Post, Ethan
Title: Message This may be a useful utility for those of you working with Oracle and NT. Found it while trying to diagnose issues on an AIX box which also has a program called filemon. http://www.sysinternals.com/ntw2k/source/filemon.shtml

Precise Purchased by Veritas

2003-01-21 Thread Post, Ethan
Title: Message Just saw this, perhaps it's old news. http://www.veritas.com/news/press/FeatureArticleDetail.jhtml?NewsId=21558

RE: Moving tables from one tablespace to another tablespace

2003-01-19 Thread Post, Ethan
impossible in export/import. HTH. Arup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: HOTSOS Symposium

2003-01-17 Thread Post, Ethan
Title: RE: HOTSOS Symposium I will be there, looking forward to meeting you, won't be staying at the hotel since I live in Dallas. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 10:29 PMTo: Multiple recipients of list

Minutes Since Midnight 2000

2003-01-17 Thread Post, Ethan
} )) print ${MIN_TOTAL} } I am sure there is a more elegant way of doing this, anyone care to share thier ideas/improvments/solutions? Thanks, Ethan Perl is not an option Jared ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED

RE: Moving tables from one tablespace to another tablespace

2003-01-17 Thread Post, Ethan
FAQ: http://www.orafaq.net -- Author: Post, Ethan 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

RE: Minutes Since Midnight 2000

2003-01-17 Thread Post, Ethan
-- Author: Post, Ethan 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 this mailing list, send

RE: Minutes Since Midnight 2000

2003-01-17 Thread Post, Ethan
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Who has package open

2003-01-16 Thread Post, Ethan
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-16 Thread Post, Ethan
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Database tracking

2003-01-16 Thread Post, Ethan
Title: RE: Database tracking I concur, I have used MRTG for this in the past, now I have an Access database that I connect to via ODBC and get my graphs. They are very handy for trending and analysis, If someone says I had a problem yesterday around 3 pm Igo look at the charts and I usually

RE: Unix Max Extent Script

2003-01-16 Thread Post, Ethan
this that they would like to share? There are many other SQL scripts that I would like to run from cron to evaluate SQL script results. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Unix Max Extent Script

2003-01-16 Thread Post, Ethan
that will do this that they would like to share? There are many other SQL scripts that I would like to run from cron to evaluate SQL script results. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network

Get Owner of Trigger or Table in Trigger

2003-01-16 Thread Post, Ethan
in these other environments and I want the same trigger to run everywhere without modification. Current plan is to figure out the owner and set the path for UTL_FILE based on that. Any ideas. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL

RE: Unix Max Extent Script

2003-01-16 Thread Post, Ethan
temperature of server room, log every bit of meaninless info to a log file yada yada yada -Original Message- Sent: Thursday, January 16, 2003 3:40 PM To: Multiple recipients of list ORACLE-L Post, Ethan wrote: Or perhaps this... Write a program that will manually allocate extents to each

RE: Get Owner of Trigger or Table in Trigger

2003-01-16 Thread Post, Ethan
, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Database tracking

2003-01-15 Thread Post, Ethan
Please respond to ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Database tracking

2003-01-15 Thread Post, Ethan
: http://www.orafaq.net -- Author: Post, Ethan 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

rdist Examples

2003-01-13 Thread Post, Ethan
=( /db01/foo/* ) (${FILES}) - (${HOSTS}) install -R; Here is what I run... rdist -f rdist.txt -y -R Works great, now how do I go from db01 to u01? Thanks ahead of time. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat

RE: SLA Trigger/Procedure

2002-12-03 Thread Post, Ethan
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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services

RE: SLA Trigger/Procedure

2002-12-03 Thread Post, Ethan
reset flag fi fi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

SLA Trigger/Procedure

2002-12-02 Thread Post, Ethan
/quarter/year). I suppose I will get around to it eventually but if anyone else wants to get started on it I won't mind! Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Security Focus Link - SQL Injection White Paper

2002-11-27 Thread Post, Ethan
of protecting against these types of attack. http://online.securityfocus.com/infocus/1644 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Slightly OT - Who would you take with you...

2002-11-25 Thread Post, Ethan
and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

1M STRIPE SIZE BEST?

2002-11-20 Thread Post, Ethan
opinions/comments as far as a best practice in setting stripe sizes would be greatly appreciated. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Invalid Objects but no errors

2002-11-15 Thread Post, Ethan
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RE: RE: CONSISTANT GETS

2002-11-15 Thread Post, Ethan
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Post, Ethan
: http://www.orafaq.com -- Author: Post, Ethan 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

DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM indexes?

2002-10-04 Thread Post, Ethan
Title: RE: ora-904 invalid column name Looks like this is the case, does it know something I don't know? Are indexes OK to analyze in the SYS and SYSTEM schemas? Looks like is correctly does not do tables. - Ethan

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-04 Thread Post, Ethan
on SYSTEM tables though. It's just a DBA account. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject

Cache OCI Calls to Improve Oracle Performance on Solaris[tm] Syst

2002-09-30 Thread Post, Ethan
Anyone tried this one? http://soldc.sun.com/articles/oci_cache.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Perplexed

2002-09-24 Thread Post, Ethan
have primary keys. Do I have duplicate storage for primary key indexes in one of the schemas? I can't figure it out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Perplexed

2002-09-24 Thread Post, Ethan
Ignore, I found the errors of my ways. Ethan Post perotdba (AIM), epost1 (Yahoo) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services

RE: Staspack Grapher/Viewer ?

2002-09-19 Thread Post, Ethan
? [Why buy when you can use Open Source!] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Stress Testing Peoplesoft App

2002-09-12 Thread Post, Ethan
Anybody have experience with stress testing software for Peoplesoft? Links, thoughts, comments etc... Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Migration Assistant Speeds

2002-09-11 Thread Post, Ethan
://www.orafaq.com -- Author: Post, Ethan 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

RE: Function-Based Index not working

2002-09-06 Thread Post, Ethan
caching the table to eliminate the io. I do not know if you can cache an IOT but then it should be even faster. Ron ROR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Clip Text Between Lines in Korn Shell

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

RE: ADV OT: Oracle-dba.com domain for sale

2002-08-29 Thread Post, Ethan
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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Auditing logons

2002-08-09 Thread Post, Ethan
, 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: Post, Ethan INET: [EMAIL PROTECTED] Fat City

RE: missed Anjo's web cast..

2002-08-08 Thread Post, Ethan
. Post, Ethan wrote: What's wrong with V$SYSSTAT, db block gets + consistent gets = logical io (there may even be a logical IO stat, can't recall and too lazy to look) and physical reads. Don't worry about the cache rate but track the rate of logical IO and physical IO. Ethan Post perotdba (AIM

RE: missed Anjo's webcast..

2002-08-08 Thread Post, Ethan
Title: RE: missed Anjo's webcast.. I think I will side with Anjo on this one, if my users are happy with 1 second response times and 99.9% of the data is coming completly through PIO that is fine with me. Of course that is an exageration but you get the point. Keep the customers happy and

RE: 20 Instances 1 Machine

2002-08-02 Thread Post, Ethan
of CPUs. Without actually knowing the nature of your applications, I'd say you're probably looking in the SunFire 6800 or SunFire 15k range (if you're looking at Sun equipment). Post, Ethan wrote: I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX

Oracle 9 Standard/Enterprise Diffs

2002-08-02 Thread Post, Ethan
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Monitoring occurence of snaphot too old

2002-08-02 Thread Post, Ethan
, 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: Post, Ethan INET: [EMAIL PROTECTED] Fat

RE: Locked Rows in the DB ... the search continues ...

2002-08-01 Thread Post, Ethan
: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

20 Instances 1 Machine

2002-08-01 Thread Post, Ethan
having enough memory but are there any other limitations I can expect? Anyone had to do this? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

  1   2   3   >