RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

d I'll see you over there in a minute. :-) thanks, bruce bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San D

ADMIN: Status of list server systems (and update about missing messages)

me. If you have any questions or concerns about anything, please let me know. Thanks, Bruce Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

RE: oracle client on PC's

Jeffrey, I've probably missed something, but if the application uses Merant's ODBC driver - which I believe is a wire-protocol driver, how come you need to install the client at all? Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contai

RE: Dblink versus odbc

connect back to an Oracle database. So ask your manager for more information on why they want to compare the two. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the

RE: Move datafiles, but can't delete them

running the DROP TABLESPACE command from. Then wait for some time (minutes) , and the datafile will be released by the OS and possible to delete. " To find out who has files open, you can use process explorer from www.sysinternals.com or tlist from the resource kit. HTH, Bruce Reardon NOT

RE: Email Notification

You might like to give the version of OEM as well - though if you reply to this message cut the Metalink extracts out to reduce message size Doc ID: Note:74269.1 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-SEP-1999 Last Revision Date: 23-APR-2002 Goa

RE: Email Notification

t show you See bugs 1180760, 1823589, 1935218 & 2268674 HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any

RE: what is oracle rdb?

Yes Oracle still sells it. Yes they still develop it - new versions released regularly with new features. It's integrated with VMS, had clustering for many years, support for Galaxy, existing applications etc See http://www.oracle.com/rdb/ & http://www.jcc.com/ and more Bruce NOTIC

10g for collab suite?

Has anyone heard when 10g will be the supported database under collaboration suite?? thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: SQL_Trace versus Statspack

ok at logons cumulative in v$sysstat Were the trace and snapshot for the EXACT same time interval? HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distrib

RE: Why compiling pkg hangs???

nverse of this with a given object_name to find who has the internal locks. (I know Yong will suggest this query needs a predicate in the where clause but it works for me and I haven't had time to test alterations.) HTH, Bruce Reardon mailto:[EMAIL PROTECTED] NOTICE: This e-mail and any a

RE: Re[3]: How do you generate primary keys?

And to reply to my own message - the flaw is rollbacks I guess you could use a savepoint after the sequence number, and if you want to "undo" the transaction put the record in an unused record history table, but all very messy. Bruce Reardon NOTICE: This e-mail and any attachments a

RE: Re[3]: How do you generate primary keys?

test and test. HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print o

RE: 9iAS Application Server

must (probably?) is from a process running on the server Anything scheduled via AT or Windows scheduler (or CRON etc if this is Unix)? HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an autho

RE: RE: How do you generate primary keys?

script is intended to be used prior to shutdown in single-instance Oracle, to prevent the loss of cached sequence numbers, should a SHUTDOWN ABORT become necessary. " Haven't tried this, but thought it could be useful. HTH, Bruce Reardon Specialist - Technical Systems mailto:[EMAIL PROTEC

RE: Finding the session causing compile to hang

code - the only problem appears to be in the name used for the column - any rows returned are actually blocked - is that correct? Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised

RE: Finding the session causing compile to hang

_internal WHERE mode_requested <> 'None' and mode_requested <> mode_held ; and use inverse of this with a given object_name to find who has the internal locks. HTH, Bruce Reardon -Original Message- Sent: Friday, 31 October 2003 10:59 AM I need to figure out a way to

ADMIN: Warning of potential list shut downs due to brush fires

t; in the upper-right corner of our main home page for more information or updates. thanks, bruce bergman President, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: probe database using OEM event or job

roups.google.com/groups?oi=djq&as_ugroup=alt.msdos.batch Multilingual Batch Programs http://gearbox.maem.umr.edu/~batch/multilingual.html Programs by Prof. Timo Salmi - THE author of the alt.msdos.batch FAQ http://garbo.uwasa.fi/pc/ts.html and then search for tsbat67.zip 184193 Mar

RE: Hiding passwords

T thepwd=) C:\Temp> " Enhance the batch to take some parameters and enhance get_pwd subroutine to search for that which matches the parameters. Anyway hope this is of use to some. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 24 September 2003 9:45 AM there is no co

RE: Insert performance

to consider how your index is accessed (probably not doing range scans on a primary key sequence). Obviously this will need testing to see how well it goes for you. HTH, Bruce Reardon -Original Message- Sent: Tuesday, 23 September 2003 1:45 PM Does anyone have any idea how to improve

RE: Isnumeric question

ne(v_test || ' is NOT a number'); end if; end; / " HTH, Bruce Reardon -Original Message- Sent: Tuesday, 23 September 2003 11:00 AM On 2003.09.22 20:15, Teresita Castro wrote: > Hi!! > I want to made something like this ina query > > select decode( isnumeric

RE: log miner views contain object IDs and HEX values

Steve, Did you have set serveroutput on? I have found you need this before you'll get error messages from Logminer. I found this in Metalink note Note:69606.1 HTH in the future, Bruce Reardon -Original Message- Sent: Saturday, 20 September 2003 9:40 AM OK seems I must hav

FWD: Checking RMAN backup results

re's a problem, rather than doing manual > > checks every day for the previous night's backups. > -- > Rich Holland(913) 645-1950SAP Technical Consultant > print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E > - end returne

RE: Client hangs on some key values

ession - eg sql_trace or event 10046. HTH, Bruce Reardon -Original Message- Sent: Friday, 29 August 2003 2:14 PM New DBA on the block and already ran into my first problem: We have an Oracle Database (8.1.7.0) running on Clustered HP-UX. Oracle client running on a HP-UX (11) B2000 m

Results of OCS mailing list survey

Perhaps as OCS matures, there will be more demand. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing li

ADMIN: Warning about virus threats this week

orking, please contact me directly. I expect that these measures will be needed for the next few weeks, but after that I will return ListGuru's functionality to normal. Please bear with us during the intervening weeks. Thank you! Bruce A. Bergman ListMaster, Fat City Hosting -- Please see t

ADMIN: Collaboration Suite mailing list?

you would join and whether you think it would be valuable. PLEASE SEND REPLIES TO ME ([EMAIL PROTECTED]) PRIVATELY, not to the list! I'll summarize to the list, but there's no point in having a bunch of "me too!" type replies go to the list. ;-) thanks! bruce -- Please see

RE: Forms - as sysdba

g the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system. HTH, Bruce Reardon -Original Message- Sent: Friday, 22 August 2003 4:49 PM Robo You can connect as ifrun60.EXE "C:\...\..\logon2.fmx" Regards Suhen -Origin

RE: Urgent! Is it safe to aply patch Windows2000-KB823980?

eware psloggedon to see who is logged on to a server (may require admin privs on the target). Regards, Bruce Reardon -Original Message- Sent: Wednesday, 20 August 2003 3:49 AM Luis: We're patching like crazy, too. So far, none of our systems has experienced any issues. We're running

Oracle and Windows 2000 SP4 - any experiences to share

ndows server and got any good or bad experiences to share? Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Calif

Re: orafaq -- broke?

Definitely. I just need input like that from those who use it! So far the input as been far and few between... I will work on getting the message bodies searchable and let the list know when they're in there. thanks, bruce - Original Message - Hey Bruce, Any possibility of m

RE: HP-UX 11i/9.2.0.3/Strange Executions

tabase with filename pas_batch_db Oracle Rdb V7.1-10 Rdb/Dispatch V7.1-101 (OpenVMS Alpha) Regards, Bruce -Original Message- Sent: Tuesday, 22 July 2003 12:04 PM 10gR2 will automatically correct the errors. I'm waiting for the version that will know that I *meant* to type

Re: faq broke? -- Other options

Don't think that the only searchable archives are on orafaq. Fat City has the definitive archives that date back to the start of the list here. You should consider using the archives here as well. You can find them here: http://www.listguru.com thanks, bruce -Original Message-

RE: enterprise manager

s on the wrong track. HTH, Bruce Reardon -Original Message- Sent: Thursday, 17 July 2003 3:45 AM Martin, I am wondering if the OMS is running at all... oemctl status oms on UNIX or check the services applet if you are in Windows. Patrice. -Original Message- Sent: Wednesday, July

RE: FTP command -without user interaction

login.com (a.b.c.d,2828) 226 Transfer complete. ftp: 1570 bytes received in 0.20Seconds 7.85Kbytes/sec. ftp> bye 221 Goodbye. C:\Temp> HTH, Bruce Reardon -Original Message- Sent: Friday, 4 July 2003 4:09 PM Hi All, How to execute FTP command without interaction. Basically i want t

HP OpenView

Anyone in the HP/Oracle camp using HP's OpenView and its Smart Plug-in for Oracle to monitor databases? We are in the beginning stages of implementing. I'd be interested in hearing people's experiences. Thanks. Dave Bruce Computing and Communications Services University of Guelph

RE: Cannot allocate new log - checkpoint not complete

, Bruce Reardon -Original Message- Sent: Friday, 4 April 2003 3:44 AM To: Multiple recipients of list ORACLE-L Correct. The only potential disadvantage is that recovery will take longer when bringing up the database after a crash. Jay Miller -Original Message- Sent: Thursday

RE: Function problem

best effect from your histograms. If you put the values directly into the select then your histograms will be used for selectivity determination in creating Of course, it might be something else entirely... HTH, Bruce Reardon -Original Message- Sent: Friday, 21 March 2003 10:24 AM I

RE: optimizer_mode=FIRST_ROWS

d to use rule hints when accessing the data dictionary. Before this if you used the Oracle ODBC driver and were in first_rows mode we had to wait 5 - 10 minutes just to link a table in Access HTH, Bruce Reardon -Original Message- Sent: Tuesday, 18 March 2003 7:39 AM To: Multiple recipient

RE: Tablespaces - datafiles

Oracle max sizes) > some acceptable value I don't know for sure its possible but it seems reasonable to me.... Regards, Bruce Reardon -Original Message- Sent: Thursday, 13 March 2003 5:24 AM yup.. we haven't been bitten but we know the day is coming when its going to happe

Reports runtime -- install just that or everything?

AS in another ORA_HOME, but I'd prefer not to do that if I have a choice (bloat, etc). All I need is the runtime. Any thoughts??? thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services

RE: Purely for your amusement

Barbara, This might be an obvious comment, but isn't the where clause missing a few join conditions? eg - these 3 tables don't seem to get mentioned: ADMARC.CNR CNR, ADMARC.WOEMANIFEST_VIEW WOEMANIFEST_VIEW, ADMARC.WO_CHARG_VIEW WO_CHARG_VIEW Regards, Bruce Reardon -Origin

RE: shared tnsnames.ora

a common network share (that had better be available all the time). With respect to listener.ora and localhost - has anyone using OEM's Intelligent Agent (IA) got the IA to be able to discover databases where you use localhost in the listener - I haven't yet. Regards, Bruce Rear

RE: Alter table monitoring ... impact on performance??

that it will not affect performance significantly, while giving you a very helpful indication of which tables may have stale statistics. " HTH, Bruce Reardon -Original Message- Sent: Friday, 17 January 2003 10:26 AM I've seen mention a of negligible performance hit for this. I

RE: Tracing or not tracing, this is the question now.

Oracle DBA Oxford Health Plans www.oxhp.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.

RE: Info about running procs

o check out the prerequisites at http://www.ixora.com.au/scripts/prereq.htm HTH, Bruce Reardon -Original Message- Sent: Wednesday, 15 January 2003 7:29 AM > [EMAIL PROTECTED] wrote: > > Hi list, > > I'm looking for a Oracle system view or table where I can see all > actua

RE: dw tool question

robust in that area. So if you want to make a case for BO over Brio, you might want to start pushing the importance of good metadata, and start entering a lot of it into your database. With that as a opening ante, you might be able to sway the decision a bit. thanks, bruce -- Please see th

RE: dw tool question

igh and remind myself that every >company makes dumb decisions like this. I don't think either of those solutions will ultimately differ that much -- they are closer competitors than it would appear on the surface. Very similar offerings, just at different points on the complexity scale.

Re: dw tool question

on the market, including reporting tools. Some say it's worth the cost of the conference in what you save buying products. Anyhow, hope that helps. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City

RE: Export/Import Error and Validation !!!

problem would not reproduce. Note 199416.1 has more info: 8170-8172 not affected. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 8 January 2003 10:11 AM We attempted to reorg a table and data corruption resulted. We have isolated the issue and currently have a tar open with

RE: Oracle Application Server on .net

ot; You can download it from http://www.microsoft.com/windows.netserver/preview/default.mspx What error does the developer doing the install get? Regards, Bruce Reardon -Original Message- Sent: Wednesday, 18 December 2002 10:54 AM .Net is not an OS. The developer (here it comes) d

RE: Leading spaces in dbms_output.put_line

f you're on an older database, you can use CHR(10) and CHR(9) to produce blank lines and leading spaces respectively I have also found that 3) chr(0) works as well (found in http://www.quest-pipelines.com/Pipelines/PLSQL/archives/search.sql) Cheers, Bruce Reardon -Original Messa

RE: IOT Issues?

articularly if still on Forms 4.5)? HTH, Bruce Reardon -Original Message- Sent: Friday, 13 December 2002 1:19 PM Listers, Solaris 7, 8.1.7.4 64 bit, E10K. Have a test IOT of around 120 million rows being created as we speak -- partitioned by month (3 months for the test), overflow by nam

RE: Increase size of data files and rollback segments

or not 2Gb - File limits in Oracle". This contains links to other notes with Port specific information. I hope this helps. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 11 December 2002 11:19 PM Hello Jeremiah I did some research on metalink and it says: 1) Do not u

RE: Increase size of data files and rollback segments

le (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to le

RE: Guidelines/Standards for supporting non-oracle databases

eas for thought. Cheers, Bruce Reardon -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other "small" databases such as Acce

RE: moving from dedicated connections to MTS

mmary is - you shouldn't need to use MTS just to get Oracle to work with a firewall Regards, Bruce Reardon -Original Message- Sent: Wednesday, 20 November 2002 4:30 AM Doc: 125021.1 talks about firewalls. Look for "USE_SHARED_SOCKET " to keep the dedicated connections. > -

RE: e: when is an error msg not an error msg ?

Paul, I've seen something similar under windows when somebody incorrectly defined an oracle_home environment variable. Might this be happening in you case? HTH, Bruce Reardon -Original Message- Sent: Thursday, 14 November 2002 9:59 AM "Sherman, Paul R." wrote: >

RE: Call for a featured speaker for St. Louis Oracle Users Group...

Does Australia get included in the travel expenses offer? :-) Cheers, Bruce Reardon -Original Message- Sent: Thursday, 14 November 2002 7:06 AM To: Multiple recipients of list ORACLE-L Group... > We would, of course, pick up all travel expenses, >From how far :-) ? -- R

RE: Solaris vs Windows 2000

BEA Weblogic servers to Dell servers running Red Hat / W2K. Their cluster special edition in 2002 had an article comparing performance for 2/4/8 CPUs (admittedly this test was using SQL Server). Have fun & let us know what you find... Regards, Bruce Reardon -Original Message- Sent: Tu

FW: AQ setup - from oracle-l

forwarded on at Dave's request. Bruce Reardon -Original Message- Sent: Thursday, 31 October 2002 4:03 AM To: Reardon, Bruce (CALBBAY) Hi Bruce The application user owns the AQ tables and put them in a separate tablespace. The user will need synonyms and grants for t

RE: ORA-04031

ror. Hope this helps, Bruce Reardon -Original Message- Sent: Thursday, 31 October 2002 3:10 AM To: Reardon, Bruce (CALBBAY) http://orafaq.net/archive/oracle-l/2002/04/22/062319.htm hi, I look at this article and I have the same problem. I am stand alone on this database with a big SGA

Queues - does anyone use them

he queues and queue tables - system or the application schema. Thanks, Bruce Reardon mailto:bruce.reardon@;comalco.riotinto.com.au -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

RE: SQL*Plus COPY error solved (sort of)

When you tried under NT, did you use sqlplus.exe or sqlplusw.exe? If you used sqlplusw.exe, this sounds like Bug No. 1504702 The workaround is to use the copy command from the character version of sqlplus (sqlplus.exe) rather than the GUI version. HTH, Bruce Reardon -Original Message

RE: PROCESS column in V$SESSION

is v$process.spid Run orakill with no parameters to see the join syntax for v$process and v$session Regards, Bruce Reardon -Original Message- Sent: Saturday, 12 October 2002 5:03 AM Charlie, = NT Domain = Machine Name Hope this helps. PS - do I get a Home Depot Discount

RE: 9.2 on Red Hat 8.0

through the compat- libs issue right now. Hopefully it will be fully installed and I can give some feedback as to how it runs in a week or so. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce INET: [EMAIL PROTECTED] Fat City Network Services

RE: auto start db???

Leslie, In addition to oradim.log and alert.log (as mentioned by others) check the event log for anything. Also, was this machine upgraded to W2K from NT4? If so, I remember a bug with autostart under this case - can't remember more details but check Metalink. HTH, Bruce Re

RE: RMAN and Disk Space

only be done if the free space is both continuous and at the start of the datafile. Have a look at Metalink Note:105208.1. HTH, Bruce Reardon -Original Message- Sent: Saturday, 5 October 2002 8:09 AM Since everyone's advocating RMAN here, I decided to start an RMAN backup for

RE: A really stupid question

ed order I also found this site by searching Google for Oracle-L http://faqchest.dynhost.com/prgm/oracle-l/ try http://www.fatcity.com/ListGuru/my.php and http://www.mail-archive.com/oracle-l%40fatcity.com/<-- this has them threaded HTH, Bruce Reardon -Original Message- Sent:

Advanced Queues for dummies

t;. -Do you normally put your AQ tables in a separate tablespace? - Who normally owns the queues and queue tables - system or the application schema. Any suggestions, links or books would be appreciated. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http:

Followup: Apache core dumps after IP address change (solution)

core dumps (something I haven't seen it do in years) when restarting after a long period of uptime, then suspect a module/library problem. Side note: if anyone wants to know every nook and cranny where Oracle stores your IP address and domain names, I can tell you that now. :-) Thanks again! bruce

RE: ORA-04031

by Oracle support. However, realise those files will take up room and that when the error occurs the user will experience a delay whilst the dump file is written. HTH, Bruce Reardon -Original Message- X$KSMLRU is the free list chunks. On Thu, 2002-09-12 at 17:03, Jesse, Rich wrote: > A

RE: Rollback !

And you may well use Logminer to determine what that exact point in time is (and then use tablespace point in time recovery to do the actual recovery). Bruce Reardon -Original Message- Sent: Thursday, 29 August 2002 2:52 There is a way of undoing DDL and it is described in the RMAN

RE: Notification of failed backup

ll. If you have some more specific questions then get back to the list. Regards, Bruce Reardon -Original Message- Sent: Thursday, 29 August 2002 8:09 Does anyone have a script (or some method) that works on NT to send an email to someone if a backup failed? There are two types of backups curren

RE: Oracle 81745 upgrade and PL/SQL version

this stage I queried product_component_version and the PL/SQL version was shown as 8.1.7.3. It seems no-one else has seen this. I'll repeat the upgrade on 2 other databases (with and without JVM installed) and see if I can learn more. Thanks, Bruce -Original Message- Sent: Tuesday,

RE: Upgrade to 8.1.7.4?

tion with a version of 8.1.7.4) Have a look at the patches available for 8174 on your platform - this will give an indication of the critical bugs that are others have found and got patched. HTH, Bruce Reardon -Original Message- Sent: Tuesday, 27 August 2002 16:38 To: Multiple recipient

Oracle 81745 upgrade and PL/SQL version

8.1.7.4.0" in product_component_version. This one does have JVM installed so I don't know if the difference is related to that. Any suggestions are welcome. I don't know at this stage if this is a problem, but it is an (as yet) unexplained difference and I don't like those sort

RE: Win2000/8.1.7.3.0/SQL

or is that 1 db set to first_rows? If so try the query with a rule hint? Bruce Reardon -Original Message- Sent: Tuesday, 20 August 2002 8:49 Mike, > ...and it works great everywhere. Well, almost everywhere, and > there's the rub. Thie query works on my 7.3, 8.0, 8i

RE: db doesn't show in OEM ???

:71913.1. Are both databases listed in your listener.ora or is 1 using automatic registration? HTH, Bruce Reardon -Original Message- Sent: Friday, 16 August 2002 8:09 To: Multiple recipients of list ORACLE-L Are the databases listed in the tnsnames.ora file? Bryan -Original Message

RE: RMAN recovery stuck

o its good to learn that. Dennis - Is this the same hanging issue you had a month or so ago? Regards, Bruce Reardon -Original Message- Sent: Thursday, 15 August 2002 13:23 Call RMAN from command-line as follows: rman nocatalog log= debug trace= Both the "logfilename" an

RE: Dba tools on NT

ize, delete old files and so on) HTH, Bruce Reardon -Original Message- Sent: Thursday, 15 August 2002 11:23 readable. uh huh. sure how does this create a csv file? --- [EMAIL PROTECTED] wrote: > How many of those "non-cryptic" languages can dump a table >

RE: SOLVED: IFILE in node-specific init file in VMS

ing 81714 under NT4 SP6a. Did support give a reference to a Metalink note describing issues with blank lines in init files? Thanks, Bruce Reardon -Original Message- Sent: Friday, 2 August 2002 10:33 Blank lines in your init.ora are a very bad thing. Oracle support and Metalink get beat up

RE: List archives on line?

rds, Bruce Reardon -Original Message- Sent: Friday, 2 August 2002 6:51 Hi, Are there any list archives online ? Alot of some interesting threads are coming throught to me blank (probably my server is blocking content) but I still want to read them. Please let me know. Tha

RE: Oracle Heterogenous Services

27.1 setup and troubleshoot gencon on UNIX And have a look at http://technet.oracle.com/products/gateways Regards, Bruce Reardon -Original Message- Sent: Thursday, 1 August 2002 9:49 I think I am jumping into this thread a bit late. Take a look at http://www.unixodbc.com for some good in

RE: Recompiling blocked package - locating blocking session

ow >depending on the size of your * shared pool area and database activity." We haven't found this an issue on (low concurrent load) database. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 24 July 2002 1:24 Had a problem this morning where a package was inva

RE: v$sort_usage

Do you use global temporary tables? (select owner,table_name from dba_tables where temporary='Y';) If so the segments shown could be associated with that. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 17 July 2002 2:00 Hi, Could someone shed some light on how v$

RE: OEM Intelligent Agent and port numbers - How can I assign/configure a port

rer back to the Capacity planner is done via a callback mechanism. Capacity Planner will initiate a communication via 1808, and the Data Gatherer will initiate the response back via an arbitrary port, based on availability. " HTH, Bruce Reardon -Original Message- Sent: Tues

RE: How to?

so on HTH, Bruce Reardon -Original Message- Sent: Friday, 12 July 2002 9:58 Ramon, I know how to setup LogMiner to run. My question is if LogMiner can tell me where an user is logging in from what computer? Thanks, David -Original Message- Sent: Thursday, July 11, 2002 4:15

RE: DOS Script for pop up question ?

Bob, Is it really a DOS batch file or is it 95 or NT4 or W2K / XP - or does it need to run on all of them? This is important as the options vary. Anyway, below is a copy of a post I made in March 2002 describing some of the options: HTH, Bruce Reardon "In W2K it is easy, you can use

RE: dblink problem ( ORA-02019 )

Check the sqlnet.ora on both boxes - are they the same? There was a bug in 1 version where the domain would get selected from the default_domain present in sqlnet.ora HTH, Bruce Reardon -Original Message- Sent: Thursday, 11 July 2002 16:13 Hi many thanks to all who replied to my

RE: Redo log

around the same size or are some very small? As for LogMiner - if you're in archive log mode and you've backed up / got a copy of the archive logs from 2 days ago then yes LogMiner will be able to analyse them. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 3 July

RE: RMAN restore hung?

ed (not knowing if that can be done on Tru64)? Bruce Reardon -Original Message- Sent: Thursday, 27 June 2002 2:39 I am performing a test restore with RMAN on a test system, and for the past hour it appears to be hung on the restore. The only detectable activity is the control file seem

RE: V9.2 & SGA

hese "variably" sized structures (but not block buffers, they are reported separately)." Hope all this helps. Regards, Bruce Reardon -Original Message- Sent: Tuesday, 25 June 2002 11:43 Try shared_pool_size, large_pool_size, java_pool_size and shared_pool_reserved size. T

Forms 4.5, views and instead-of triggers

can then pass these onto our Developer. Also, is anyone else using Forms 4.5 with Instead-of triggers? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Servi

Forms system editor not creating temp file under Windows

editor instead of the system editor, but it would be better to allow the system editor (notepad) to keep working. I have tried altering the system editor to write or the NT4 version of notepad (by the registry setting forms45_editor) but this has no effect. Thanks, Bruce Reardon mailto:[EMAIL

RE: Installing Oracle 9i Developer suite

7;t see or interpret the information that is normally shown on the screen. Hope this is correct & helps, Bruce Reardon -Original Message- Sent: Friday, 14 June 2002 13:29 I'm installing Oracle 9i Developper suite on winXP and the doc says : If you use assistive technologies s

SQLPlusw output is white on white

gestions on what to try? As it is a server I haven't tried rebooting but I will try that if no other ideas come through. Any help is appreciated. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce

RE: set sort_area_size, sort_retained_size,hash_area_size but sti

Paula, and what OS / database version? eg if Windows is the server setup to use all 16 Gb of memory? Bruce Reardon -Original Message- Sent: Friday, 14 June 2002 2:29 Paula, what is the size of your hash_area_size, sort_area_size, and sort_area_retained_size? what does your explain

RE: sequence question

It is my understanding from a simple test that you will now have a "hole / gap" in the sequence numbers. So, does a gap REALLY matter (ie can you never have a gap) or is it just that you need to avoid gaps where possible. HTH, Bruce Reardon -Original Message- Sent: Friday, 14 June

  1   2   3   4   5   >