RE: Problem with understanding Optimization methods.

Thank You! -Original Message- Sent: Thursday, January 08, 2004 9:04 AM To: Multiple recipients of list ORACLE-L Yes. On 2004.01.08 01:14, Denham Eva wrote: Mladen Thank You for this suggestion, works in that the CBO now see it this way SELECT STATEMENT Optimizer Mode=CHOOSE

RE: Problem with understanding Optimization methods.

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: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Problem with understanding Optimization methods.

over the full table scan. When you're really, really bored, you can read Practical Oracle 8i - Building Efficient Databases, it has a few pages about the parameters above. Read the Gospel of Jonathan and enjoy. On 2004.01.07 00:29, Denham Eva wrote: Hello Listers, A normal sql query from

Problem with understanding Optimization methods.

do to improve performance? Please remember that this query comes from a Data Warehouse tool and hence does not appear to accept hints. Any help will be much appreciated! Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat

Oracle and Active Directory

Hello List, The Company I work for is planning to go the Active Directory route. Does anyone know of any issues with the following versions of Oracle 7.3.x.x and 8.1.7.x.x? Regards Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL

MSSQL Link Server connection failure to Oracle 817

loaded the newest patches for OLEDB on the MSSQL for the Oracle Client, but nothing helps. Has anyone experienced this issue before? Regards Denham Eva Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network

RE: MSSQL Link Server connection failure to Oracle 817

failure to Oracle 817 -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 22:09 To: Multiple recipients of list ORACLE-L Subject: MSSQL Link Server connection failure to Oracle 817 Hello, To my surprise I see there alot

Archivelog - Disk space issue.

C:\Oracle\oracle. Oldest online log sequence 2334 Next log sequence to archive 2338 Current log sequence 2338 I can write a script (Perl) to remove all archive files 2334? Much appreciate any input or confirmation. Regards Denham Eva Oracle DBA Linux like TeePee

RMAN in NOCATALOG mode?

Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Oracle not available???

was running? No errors in the logs, nothing. Server: Win2k, Oracle 817. Has anyone experienced this before??? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL

RE: Oracle not available???

), if they are inactive. I would be curious to hear what memory utilization stats you have on the machine. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: DECODE or not to DECODE

ACCOUNT_TBL WHERE COL = '0' Obviously, I have worked out that this can not be done. The problem is also that the server is 7.3.4 and I need to use the code in a view. Does anyone have any solutions/work arounds for this? Any help will be appraciated. TIA Denham Eva Oracle DBA

DECODE or not to DECODE

for this? Any help will be appraciated. TIA Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com

RE: On TRUNCATE table does the indexes also get truncated.

Title: RE: On TRUNCATE table does the indexes also get truncated. Hello, I deserved that the comments that were made, it is after all logical that they will be cleaned out. However in my defence, there are some funny thoughts thatwent through through my mind just before I truncated that

Oracle to MSSQL conversion?

variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside

On TRUNCATE table does the indexes also get truncated.

Hello, When you truncate a table using:- TRUNCATE TABLE TEMP; does any of the indexes on the table also get truncated? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside

Another OCP slant...

www.braindumps.com Beyond the ethical implications and all the other issues. Has anyone on this list used the tips/suggestions to study for their OCP exams? Are they any good as an aid? Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside

RE: Dedicated Server problem ORA-03113

, and I have seen up to nine dedicated server connections before. Anyone experience this before? Regards Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared

RE: Online tech books

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

RE: Dedicated Server problem ORA-03113

to issues in N/W communication with Oracle datbases. There are a number of notes/articles on Metalink discussing this error. Hopefully some of that information helps you. - Kirti --- Denham Eva [EMAIL PROTECTED] wrote: That is the whole problem, there is no logged errors, or trace files. Everyone

Dedicated Server problem ORA-03113

experience this before? Regards Denham Eva Oracle DBA _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com

Which is beter a cursor or a for loop?

TABLE_NAME WHERE COL1 = 'Something')) LOOP Do a whole lot of stuff in database here.. LOOP END; I would guess that the cursor would follow similar execution criteria but using the cursor syntax. Any ideas? TIA regards Denham Eva Oracle DBA The real problem is not whether machines think

RE: Which is beter a cursor or a for loop?

IN (SELECT X FROM TABLE_NAME WHERE COL1 = 'Something')) LOOP Do a whole lot of stuff in database here.. LOOP END; I would guess that the cursor would follow similar execution criteria but using the cursor syntax. Any ideas? TIA regards Denham Eva Oracle DBA The real

RE: ORA-04098 Problem - Any Ideas??

Problem - Any Ideas?? Hi Denham EVa Try SQL ALTER TRIGGER SYS.JIS$ROLE_TRIGGER$ COMPILE ; -- If recompilation fails or if you are still not able to connect, disable the trigger SQL ALTER TRIGGER SYS.JIS$ROLE_TRIGGER$ DISABLE ; then your command thanks Banarasi Babu

RE: Perl

Title: RE: Perl Good question Raj! Hey Steve give us the run down on connecting to Oracle with Python. I've downloaded the Activestate version to try! Denham -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 4:04 PMTo:

ORA-04098 Problem - Any Ideas??

this? Funny enough the command ALTER INDEX indexname REBUILD; works fine??? TIA Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. DISCLAIMER This message is for the named person's use only

RE: Error extensions in the alrtXXX.log

one learn? without the proverbial "Roll up the sleeves and climb in under the hood" right? Hey, Jared I still intend to buy your book this year, perhaps in the next few months when I hopefully will get something back from the Taxman. Regards Denham Eva Oracle

Error extensions in the alrtXXX.log

and climb in under the hood right? Hey, Jared I still intend to buy your book this year, perhaps in the next few months when I hopefully will get something back from the Taxman. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand

RE: slowish query causing problems...

NDX9 if the columns are rearranged. Are a lot of updates/inserts/deletes performed on fwepcode1? If so you might get some gain by removing some indexes. Regards, Mark. Denham Eva [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] za cc: Sent by: Subject: RE

slowish query causing problems...

. The system is a Oracle 817 on Win2k. Pls advise, any options or help will be appreciated. Many Thanks Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. DISCLAIMER This message is for the named person's

RE: slowish query causing problems...

Certified Professional -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 6:29 AMTo: Multiple recipients of list ORACLE-LSubject: slowish query causing problems... Hello List, Pls help me on this problem. Our application

RE: Setting profile limits?

Bernardus for your input. Regards Denham -Original Message-From: Bernardus Deddy Hoeydiono [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Setting profile limits? Dear Denham Eva, Can explain more

Setting profile limits?

parameters ie CONNECT_TIME, SESSION_PER_USER, CPU_PER_SESSION etc remain the same as before the changes? Or will I be forced to change or set all the parameters? Thanks in advance for the help. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius

Finding User sessions = idle 30 min??

it is Oracle 817 DB on Windows 2k. Best Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential

Pro*C for Oracle 817 on Win2000?

for VC++ and Borland, under the c:\oracle\ora81\oci directories. Unfortunately I don't have access to these programs? Any help will appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie

SPIN_COUNT - 8i obsolete? What now?

is set as 2000. I get the following error. * ERROR at line 1: ORA-25138: SPIN_COUNT initialization parameter has been made obsolete Now what? what can I do to overcome the sleeps issues? Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius

RE: SPIN_COUNT - 8i obsolete? What now?

: SPIN_COUNT - 8i obsolete? What now? Denham Eva wrote: Hello Guru's I have run a script which indicates that of the three redo log latches two had occurences of sleeps. To overcome this usually you increase SPIN_COUNT by 50% or so. When trying to ALTER SYSTEM SET SPIN_COUNT = 3000

RE: SPIN_COUNT - 8i obsolete? What now?

you begin to tune for the sake of tuning and not because you are relieving a problem. if you are not getting reports of performance problems, why are you trying to fix it? the old adage if it ain't broke, don't fix it applies here. --- Denham Eva [EMAIL PROTECTED] wrote: Hello Guru's I have

RE: SPIN_COUNT - 8i obsolete? What now?

you no noticeable improvement. If the log switches are happening that frequently, you might look into resizing them. I'd first look at what is going on during office hours that's causing them to fill so fast. Rachel --- Denham Eva [EMAIL PROTECTED] wrote: Ouch! :) Rachel, It's

RE: CPU Problem

Title: RE: CPU Problem Cary, From the league of learners and eager apprentices. We eagerly devour any repetition on your part or that matter any other of the guru's. :) But seriously I for one don't have an in house guru to whom I can lookup to for gems of wisdom and guidance. I am sure I

OCP Exams - What to study out of?

come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand

RE: OCP Exams - What to study out of?

Title: OCP Exams - What to study out of? Thanks to everyone for their input. I am considering the 8i track. a. Because I work mainly with the 8i DB. b. I hear that for the 9i a attendance of a course is a prerequisite. Regards Denham -Original Message-From: Denham Eva [mailto

RE: Win2k Perl accessing Oracle Parameters?

with the aim at it being machine unspecific. (Jared, hope you can answer me on this. Want to get a copy of your book, unfortunately with the exchange rate and import taxes etc it will cost me R590,00. Quiet a chunk of the ole budget, maybe early next year.) Regards Denham Eva Oracle DBA UNIX

Win2k Perl accessing Oracle Parameters?

, hope you can answer me on this. Want to get a copy of your book, unfortunately with the exchange rate and import taxes etc it will cost me R590,00. Quiet a chunk of the ole budget, maybe early next year.) Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have

RE: ROWID question?

Title: ROWID question? Thanks for everyones input! -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: ROWID question? Hello Gurus Does Oracle reuse ROWID "numbers&q

ROWID question?

have of deleteing duplicates use the ROWID. If anyone has a suggestion on how else to do this I would be most grateful. Otherwise answer on my main question would be fine. Many Thanks Denham Eva DISCLAIMER This message is for the named person's use only. It may contain confidential

Archive files and their Management

backup? Should you keep all archive files until it is obviously pointless? Please advise. Many thanks Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. DISCLAIMER This message is for the named

Double Take and Oracle

. Damagement are smiling again, Thank God it was not an Oracle problem. Regards Denham Eva -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:19 PM To: Denham Eva; Multiple recipients of list ORACLE-L Subject: Re:RE: RE: RE: Double Take and Oracle

Double Take and Oracle

. So I have no one to turn to about this. (Apparently it works well with MSSQL). Anyone any ideas? The Enviroment is Windows 2K SP3. Oracle 817 Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie

RE: RE: Double Take and Oracle

, apparently in France. Convienant - I'd say. So I have no one to turn to about this. (Apparently it works well with MSSQL). Anyone any ideas? The Enviroment is Windows 2K SP3. Oracle 817 Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius

RE: RE: RE: Double Take and Oracle

which makes them IO hogs, although Oracle can be the same. In your case I would suspect that the hotbackup is the problem. Dick Goulet Reply Separator Author: Denham Eva [EMAIL PROTECTED] Date: 10/15/2002 7:08 AM Thanks for the input so far. Double-Take

RE: RE: Double Take and Oracle

compared to these Access on Steroids databases), management are insisting for the sake of conformity that this must work. At ever attempted startup another file gives an error, most frustrating of all is that there is almost no consistency to the errors. Denham Eva -Original Message- Sent

normal user obtaining program info?

impractical option, as the growth would be huge, the idea is to capture only the changes and users that update/insert/delete using undesignated software ie MS Access. Regards Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER

Can DB tell if connection from odbc?

Title: Can DB tell if connection from odbc? Hello Gurus Is there anyway that Oracle 817/Win2K can pick up whether the user is connecting via ODBC at all? As I understand it the ODBC comes in through the Net8 and therefore the above is not possible. Regards Denham Eva Oracle DBA In UNIX

Configuring 734 and 817 on same machine.

on this is very much appreciated. Regards Denham Eva DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission

Strange Data issue.....

to ascii to see if they are different in anyway but both Ms return ascii 77. Does anyone have any thoughts on this? TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named

Exportable Users?

/@sid grants=y indexes=y owner=ORDSYS file=ORDSYS log=ORDSYS OK what I would like to know is there a way to run a similar script which only produces a list of exportable users?? Many Thanks Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot

Listener Configuration - Oracle 7.3.4.5.2 on Windows 2000

as it is usually done on NT. When I tried starting the listerner from command line the exe execs for what appears like a few seconds and returns to prompt. There is no listener.log file generated at all. Anyone got any ideas? Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear

To create a new datafile or to increase a existing datafile.

to add a sixth datafile? Would appreciate any views on this point. Rgds Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential

RE: AW: OSUSER in V$SESSION capture in procedure?

Denham Eva [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/22/2002 11:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: AW: OSUSER in V$SESSION capture in procedure? Wow, this worked exactly

OSUSER in V$SESSION capture in procedure?

WHERE OSUSER := V_UID; END rest of procedure.Includes insert etc END TEST Now obviously this returns more than one row as all the users use the same username through the app. Any suggestion? Many TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows

RE: AW: OSUSER in V$SESSION capture in procedure?

-Ursprüngliche Nachricht- Von: Denham Eva [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. Mai 2002 17:34 An: Multiple recipients of list ORACLE-L Betreff: OSUSER in V$SESSION capture in procedure? Hello Listers, I have what I hope is challenging problem. I am trying to create a procedure

RE: LOG_BUFFER Parameter Question

per tx * tx/sec * 3/2 *physical blocksize Anjo. Denham Eva wrote: Hello, I have been wondering about how to work out what the optimal LOG_BUFFER parameter, compared to the physical size of the REDOLOG file, for the best optimization and writes from

LOG_BUFFER Parameter Question

way of doing this. i.e. redolog file size is 10M and LOG_BUFFER is 512000. Can this be optimized better? Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal

Long running SQL Problem?

Table_1 WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2); TIA Denham Eva Oracle DBA This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com

RE: Long running SQL Problem?

Title: Long running SQL Problem? Hi List Thank you to everyone who took the time to answer, I never realised that there could be so many solutions :) Rgds Denham -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 27, 2002 10:53 AMTo

RE: Windows NT and Virtual Memory

Title: RE: Windows NT and Virtual Memory Rajesh, I had the same problem when we migrated to Oracle817. The solution was to setup MTS. Our server runs about 450 sessions/connections at a time now, no problems. I have the server set up to mts_servers = 15 and an initial dispatchers = 10. This

Tools for Scurity and Access to the Server?

. TIA Denham Eva Oracle DBA This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com

DB Link Problem

Title: DB Link Problem Hello List, Have a problem, Oracle 817 Win3K sp6 Trying to create a DB link between the production and the test dbs. The db_link creates fine ( so it appears). However when you try to run a script to reference the other, I get select count(*) from workorder@maxie

Database Link Problem

Title: Database Link Problem Hello Folks Just a resounding Thank You to all of you for your tips The Database Link now works :) Apologisies we use Win2k, maybe Windoze ;P will have something worth working with by Win3k:) Rgds Denham Hello List, Have a problem, Oracle 817 Win3K sp6

DataBase Modelling Tools

Title: DataBase Modelling Tools Hello List Apologise for the Off - Topic, but pretty desperate. Has anyone any suggestions as to a Database Modelling Tool, any preferences? I am looking for one for linux and preferably free, but does not have to be either. TIA Denham This e-mail

ORA-01406

Title: ORA-01406 Hi List, Please can anyone give me some pointers on this issue. We have third party app called Maximo with reports that run from within it. We are receiving an error on one of these reports. The Oracle error that comes out of it is ORA-01406 fetched column value was

RE: Oracle8i - Oracle9i issue??????

ORACLE-L Subject: Re: Oracle8i - Oracle9i issue?? C# ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Denham Eva [EMAIL PROTECTED] 22/02/2002 03:13 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

Oracle8i - Oracle9i issue??????

Title: Oracle8i - Oracle9i issue?? Hello Guru's I wonder if any of you have had this problem, we have a external company developing a software package in C#. On their Oracle9i test system, the software works fine, however once brought accross to our systems, which is an Oracle8i ( 817)

Optimize Method Q?

Title: Optimize Method Q? Hello Folks, Ok, I know that I have alot to learn, but when you do something believing that it will speed up things and it does but only for some queries and turns others into instant snales, a newbie like me really wonders. The situation is like this, I analyzed

jdbc connection to db don't die.

Title: jdbc connection to db don't die. Hi Guru's Please help, I am running Oracle 8.1.7 on Windows 2000. The problem is a third party product runs a jdbclient connection to the database, but it does not seem to disconnect. So over time we have a build up of connected sessions using

XML implementation

Title: XML implementation Hello Gurus, Management has now picked up the catch word XML. I now have to present a implementations plan - thursday. I naturally have no knowledge of the subject, but have spent hours now studying the docs. However there are so many possible choices and

Oracle Future???

Title: Oracle Future??? Hi Folks, Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of emails from a MSSQL mailing list, they were discussing the future of MSSQL. Some of the comments included comments about our DB - Oracle. I've added two here... ...With Hyperion

RE: XP vs. W2000

Title: RE: XP vs. W2000 So, Jared, I have heard of VmWare which is not as far as I know Open Source(Free). I don't know of Win4Lin, is it Open Source? and won't you email me a link to the site. Regards Denham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

RE: Internal Password

) 7456019 -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001 10:35 AMTo: Multiple recipients of list ORACLE-LSubject: Internal Password Hello Gurus I have a problem in that I was always able to login to svrmgrl

Internal Password

the Win2k, compaq 8500R server recovered fine and so did the Oracle DB 817. BUT, now connecting internal demands a password, why? Also all known passwords do not work including the default one. Can anyone shed some light on what happened? and how can I fix it? TIA Denham Eva This e-mail message has

The Oracle List Archive?

Title: The Oracle List Archive? Hi, Forgive the rather dumb newbie question. However I regularly see people on this list refer to the archive. How can I access this? I have poked around at fatcity.com and not found much help! TIA Denham This e-mail message has been scanned for Viruses

Killed session - does it rollback?

Title: Killed session - does it rollback? Hi Gurus Just wondering, as DBA if I kill a session on the server. Does the server rollback the transaction automatically? TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more

Problems with SQL Server Link Server to ORACLE

Title: Problems with SQL Server Link Server to ORACLE Hi List, Problem receiving this error on a Link Server from SQL Server 7.0 and 2000 to Oracle 817 INSERTED INTO IR TABLE IR_MAXIMO_WORKORDER [SQLSTATE 01000] (Message 0) INSERTED INTO MAXIMO TABLE MAXTFMC..MAXIMO.IR_WO_IN [SQLSTATE

Number of Transactions per 24hr period? - Urgent

Title: Number of Transactions per 24hr period? - Urgent Hello List, Please help, I would like to determine the number of transactions processed by Oracle during a 24 hr period. Is this possible? TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by

RE: Number of Transactions per 24hr period? - Urgent

: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Number of Transactions per 24hr period? - Urgent Denham Eva wrote: Hello List, Please help, I would like to determine the number of transactions

row creation or update date??

Title: row creation or update date?? Hi This may be an easy question or mentioned before, apologize if so, But is there some way of finding a row in a table's creation/update date, without there being a date column specific for that purpose. Something like rowid? TIA Denham This

close_cached_open_cursors error

Title: close_cached_open_cursors error Hello Guru's I hope someone can shed light on this problem, more a nuisance really. The below Alter Session statement has been appearing in the *alrt.log file. ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION

RE: IP Address Change

Title: RE: IP Address Change Sean, I've been there, we use the same sort of enviroment as you do. The only problem I experienced was network resolution were the servers could not resolve the DNS name etc. Unfortunately if the user cannot connect to Oracle! It must be a database problem!:)

RE: Oracle on NT startup question

(corresponding to the SGA and PGA) that Oracle used. So what is the instance? Denham Eva EvaD To: Multiple recipients of list ORACLE-L @TFMC.co.za [EMAIL PROTECTED] Sent by: root cc: Subject: RE: Oracle on NT startup question 11/01/2001 12:25 AM Please respond to ORACLE-L

RE: Oracle on NT startup question

Title: RE: Oracle on NT startup question Hi You will have to use the oradim utility to remove the current service. Then recreate the service using the parameter -STARTTYPE SRVC. This then causes the system to start only the service and not the instance. [-STARTTYPE SRVC | INST | SRVC,

RE: Oracle on NT startup question

Title: RE: Oracle on NT startup question I am not sure I understand you correctly, but on NT Oracle runs as a service and an instance(the mounted database). The service must be started for the instance to be able to mount and connected to. However the service can be started without having to

Moving the ALert and Dump Locations

Title: Moving the ALert and Dump Locations Hi, Is it possible to move the Alert log and Dump Locations to another location? ie - Oracle 8.1.7 on Win2K c:\Oracle\admin\DBNAME TO e:\Oracle\admin\DBNAME... Just wondering, anyone got any ideas? TIA Denham

Monitoring Tool with a difference

Title: Monitoring Tool with a difference Hi Gurus, Ok, I urgently require recommendations for software which can monitor a Oracle Database for a 24Hr period and create a report on the health of the system. Please if anyone has used or is using software for this purpose please let me know.

RMAN - Useful or not?

Title: RMAN - Useful or not? Hi Everyone, I am investigating using RMAN for backup and recovery etc. What I would like to know is: Have you found it useful? or is it much like the old Oracle 7.3 EBU (Enterprise Backup Utility) were most DBA's created their own backup scripts and etc anyway?

A range function ??

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

RE: A range function ??

Thanks Folks, So far all the examples have worked wonderfully. Thank You all Denham Eva -Original Message- Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi, I would like to exclude an arrange of characters. there is for instance

RE: Two Instances at one oracle Server

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

Replication ??

: Denham Eva 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

Copying backups across a narrow pipe.

of any tools/Software which I could use to copy the file across, check the integrity and recopy if it had failed? Any suggestions will be appreciated Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network

  1   2   >