starting an .exe job

Hi all, is it possible to start an arbitrary .exe out of PlSQL ??? I am running on NT4/Oracle 7.3.4 TNX > Frank Foelz < _ Scheidt & Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++4

Re: Performance issues

Is it so necessary to have table with 100 Mil. records? Now way how to break data into more tables? Jan Pruner On Fri 8. February 2002 05:53, you wrote: > Hi All, > > We are developing a system in which some tables in the database might be > having about 100 Million records. We are planning to u

Identifying Long Running SQL's

Does anyone have a script that can identify the most inefficient SQL code running in the application ranking from least to most efficient? Helen J Mitchell Oracle Database Administrator E - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helen J M

capacity planning??

Hi all   Can anyone send me a doc  or  white paper on capcity  planning??     regards, shibu

RE: svrmgrl

Well oracle IS the owner of the database. oracle has connected to the database as SYS. This is similar to connecting as INTERNAL. Go back to any database you have running the earlier versions of Oracle, connect as INTERNAL in svrmgrl and ask the same question again. Hemant K Chita

Re: Unix permissions

oracle will be writing to the directories ... so add the Oracle RDBMS owner in the group owning the directory OR let the owner of the directory be the application user but change the group to dba. In either case, you would need chmod g+w on the directory. Hemant K Chitale Principal DBA Chartered

pl/sql profiling shows big run time at "END" line?!?

AFAICT unrelated to the last post, but: I have a procedure with 8 IN params, 1 OUT param and all it does in an INSERT ... RETURNING id INTO out_param with out_param being the one OUT param, then a commit. That's the entire contents of the procedure. Yup, it inserts a new row and commits it - th

Performance issues

Hi All, We are developing a system in which some tables in the database might be having about 100 Million records. We are planning to use table and index partition's as a means to improve performance. Could you please share your experiences/views about handling such huge tables. Is this partitio

RE: ADI Warning

Just to add some more information on ADI. ADI sets up ODBC to connect to the database. When you define the database connection in the ADI setup screens, you can't find the information saved anwhere in the files the ADI Home on the PC. Therefore you cannot copy this information from one PC to a

high tkprof parse counts == real # of hard parses?

I've seen what looks to be conflicting evidence, so I'm trying to get a handle on whether the tkprof output I'm seeing with the parse counts == execution counts is "real" or not: What gets me is that it even happens for "static" statements that are happening in triggers - like this statement that

RE: Scrolling Sideways in SQL*Plus

I'm guessing you're using the sqlplusw client under windows. If so, I've had the same problem. In sqlplusw, go to the options menu and choose environment Set the buffer width to 1000 and press ok. This has solved it for me. HTH, Bruce Reardon -Original Message- Sent: Friday, 8 February

RE: Bitmap Indexes

Ethan, I have been using bitmap and b-tree indexes on the same table in our data mart since 7.3.4. Never had a problem with query performance. Now we have partitioned the tables in 8.1.7.x and most tables that were using bitmaps do not need to use them anymore. Just one table uses it, with b-tree

RE: MC/Serviceguard vs Sun Clusters

We have had file corruption before but never with Oracle. There is a product we use here that uses a priority database that does not do a two phase commit. When the disks fail over during the middle of a write it causes a huge issues. It took the vendor a week with a lot of our assistance to ge

Re: Where does a DBA go from here?

you're at the internals classes and the conferences. At this point in time, I tell managers that the only way I learn is to attend the conferences --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > So, there I am. I've taken the main Oracle courses -- Intro to SQL, > DBA > (Oracle 7!), Backup

Re:RE: MC/Serviceguard vs Sun Clusters

Walter, Which contractor? The fool who disconnected the heartbeat cable or the fool who installed the ServiceGuard software in the first place? Actually someone should have seen the fallacy of the install the day before ServiceGuard went online. Seems that the HP representative after a 12

RE: stopiing write to listener.log

Title: RE: stopiing write to listener.log You can try something like this: ORACLE_HOME=/u000/app/oracle/product/8.1.7; export ORACLE_HOME PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc; export PATH CURR_DATE=`date +%Y%m%d` $ORACLE_HOME/bin/lsnrctl set log_file $ORACLE_HOME/network/log/listener.log

RE: TFM

April -- Get onto Metalink -> Top Tech Docs. There's more there than you'll be able to read in a lifetime. One thing to know is that once you install Applications, your life as a DBA *will* change. Good luck! Bambi. -Original Message- Sent: Thursday, February 07, 2002 3:07 PM To:

Re: FRAGMENTATION ISSUE?

Seema, From your posting, it is not clear to me about the content of the mentioned tablespace. If it contains all of one users schema you can just take export for that particular schema. The step when you are recreating the tablespace, create it with pct increase 0 and do create initial and next e

RE: ORA-01034, ORACLE not available

Did you create an instance using oradim*? -Original Message- Sent: Thursday, February 07, 2002 4:07 PM To: Multiple recipients of list ORACLE-L Hi all, I'm trying to create a database using 817 on Windows 2000. I used Database Configuration Assistant to create the database, when it r

RE: TFM

This is the beauty of Oracle Apps! -Original Message- Sent: Thursday, February 07, 2002 4:07 PM To: Multiple recipients of list ORACLE-L We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions ar

MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 Error

Listers, Environment: Solaris 7 running 64 Bit Oracle 8.1.7.2.x. Received an ORA-03232 error this morning after bumping up the HASH_AREA_SIZE on a QA box overnight. HASH_MULTIBLOCK_IO_COUNT is 0, and has been 0 for as long as I know, meaning that Oracle calculates the value on the fly for each i

Re:RE: MC/Serviceguard vs Sun Clusters

Yup, as setup by the HP specialist. Reply Separator Author: "Adams; Matthew (GEA; 088130)" <[EMAIL PROTECTED]> Date: 2/7/2002 10:14 AM Were you only running a single heartbeat connection? Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing li

RE: ORA-01034, ORACLE not available

have you confirmed ORACLE_SID is correctly set -Original Message- Sent: Thursday, February 07, 2002 1:07 PM To: Multiple recipients of list ORACLE-L Hi all, I'm trying to create a database using 817 on Windows 2000. I used Database Configuration Assistant to create the database, when

RE: Oracle and Document Management: any real stories?

To add to what Marin suggests... Oracle's interMedia Text option supports full text indexing and a powerful set of full text query operators. We use Oracle8i's iM Text to index and query about 15 million plain text and HTML documents. However, to get the docs in and out and create a "user-frien

RE: Unorthodox 8i install/upgrade

All, Thanks for the feedback. I'll give it a shot using symbolic links and let you know how it turns out. Mike -Original Message- Sent: Wednesday, February 06, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgra

FRAGMENTATION ISSUE?

Hi one of my tablespace is highly fragmented and that tablespace contains almost all objects and its default tablespace of one of users .I want to correct it thru export/import.Let me correct if any thing missing please. -Full export of current instance. -Drop that tablespace including contents.

Slightly OT: Looking for Java Info (Repeat)

> Hi All! > > I need some help doing research. > > I dabble with Java in my 'spare' time, and this has come to > the attention of my manglement, who recently requested a small > app/applet 'when I could get around to it'. Then it was 'when do > you think you can get to it?', and now they wa

Slightly OT: Looking for Java Info

Hi All! I need some help doing research. I dabble with Java in my 'spare' time, and this has come to the attention of my manglement, who recently requested a small app/applet 'when I could get around to it'. Then it was 'when do you think you can get to it?', and now they want it yesterday.

DB File Sequential Reads and Data Block Waits

Hi All, I have been asked

datafile compression

Hello everyone. Let me say first to all who are on the list group THANK YOU. From reading the emails I receive I have learned a LOT the past few weeks. My question here is. I am trying to find a way to compress the datafiles when I copy them to a backup folder on NT. Does anyone have a suggest

ORA-01034, ORACLE not available

Hi all, I'm trying to create a database using 817 on Windows 2000. I used Database Configuration Assistant to create the database, when it runs to "Create Database Files", it gave me error "ORA-01034, ORACLE not available". I took the default settings for SGA, buffer cache, log buffer size. Or

RE: Where does a DBA go from here?

Time to do some work! -Original Message- Sent: Thursday, February 07, 2002 4:07 PM To: Multiple recipients of list ORACLE-L So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup & Recovery, Network Admin, and Perf Tuning. Now where do I go for mor

RE: MC/Serviceguard vs Sun Clusters

Could you explain the file corruption in a little more detail? I cannot imagine how failover would cause file corruption, much less how a properly configured running Oracle instance can get 'absolutely destroyed'. Isn't that the purpose of having Oracle over say a nonlogged, singlethreaded, c

RE: Slightly OT: PVCS Tracker 7.0 Backup & Recovery Question

Bruce, The version of Oracle we are running is 7.3.4.0.1 on Sun Unix server version 5.5.1. We are able to establish a connection, but we're not able to startup the instance. The alert log says : ORA-01194: file 1 needs more recovery to be consistent. From the unix server-side, the

Re: Bitmap Indexes

Ethan, i'd have to go with the later as most cases we are ok with bitmap indexes(not a huge but not bad, 100G warehouse). Our fact tables have pk as btree and most others are bitmap, and any that point back to dimensions are definitely bitmap indexes. Now we have had a few that went bonkers bu

Where does a DBA go from here?

So, there I am. I've taken the main Oracle courses -- Intro to SQL, DBA (Oracle 7!), Backup & Recovery, Network Admin, and Perf Tuning. Now where do I go for more Oracle training? This is sparked by a recent perceived lag in one of our new databases. We've tracked it down to a possible hot bloc

Re:RE: Migration utility from 7.3.4 to 9i ??

Shaibal, "whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly." To avoid this situation, just after migration from 7.3.4 to 8i, we normally export full database to a null device so that this issue may be avoid

RE: What impacts index build times on partitioned tables?

Please check following Are you creating indexes with parallel clause or not? Are you using unrecoverable/nologging or not Is your sort_area_size is ok? What type of TEMP tablespace are you using with temp file or datafile and sizing of extents are proper? Is your target tablespace is not that

Re:Bitmap Indexes

Ethan, Our data warehouse has both bit map and b-tree indexes and we normally do not have a problem. One headache we do have is that one of the indexes is on a column that accumulates a lot on new values each time the warehouse is loaded which really makes a mess of the load process, namely

RE: Oracle and Document Management: any real stories?

Internet File System Separate product, but free. Todd -Original Message- Hilary Sent: Thursday, February 07, 2002 11:21 AM To: Multiple recipients of list ORACLE-L TOPIC: Oracle and Document Management: any real stories or information? Does anyone have any experience with Oracle and D

Re:Breakable 9i ?

I really hate it when someone like Uncle Larry makes a claim like this. Sure enough that one claim will spur someone to find a hole that they can then rub into everyone's face. It's kind of like tossing lit matches at a can of gasoline, sooner or later your going to get burned. It's just a matt

Bitmap Indexes

Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases,

Re: question on EXPLAIN_PLAN

Kevin, "select count(*) from table_name" This was the key on the basis of that I suggested this solution...Your Test definately don't have that high water mark... As regard still some slowness, check for number of extents and it is sizing...If more extents 'select counts' goes for full table sc

Re: question on EXPLAIN_PLAN

Re the HWM causing a slowdown: A needle in a haystack is much easier to find when the haystack has been removed. Jared On Thursday 07 February 2002 13:06, kevin wang wrote: > Hi, Rafiq > Thank you for your advise, and thanks everyone, the handsome guys, reply > me. > You are right, it se

Re: MC/Serviceguard vs Sun Clusters

I'm amazed that failover doesn't seem to be any more robust or reliable than the first time I worked with it 8 years ago, on some platforms anyway. Jared On Thursday 07 February 2002 08:55, Dejam, Ruth wrote: > I'll second this. I worked with Sun a few years ago at another place. > Here, we're

RE: stopiing write to listener.log

SHibu, In lsnrctl, set log_status=off. Chuan Oracle DBA Transact Communication, Ltd. -Original Message- Sent: Thursday, 7 February 2002 9:38 PM To: Multiple recipients of list ORACLE-L Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu -- Please

Re: question on EXPLAIN_PLAN

Hi, Rafiq Thank you for your advise, and thanks everyone, the handsome guys, reply me. You are right, it seems like a High Water Mark problem, after lots of other try, finally I drop that table and re-create that table, copy data, build PK index, analyzed in same way as before, and test

RE: MC/Serviceguard vs Sun Clusters

Talk about serendipity -- I hope you payed that disconnected contractor a bonus for debugging your failsafe setup? -Original Message- Sent: Thursday, February 07, 2002 9:00 AM To: Multiple recipients of list ORACLE-L Rama, We did the MC/ServiceGuard thing some years ago. Worked we

RE: Unorthodox 8i install/upgrade

Ditto here. Me too! Me too! Me too! Bambi. -Original Message- Sent: Thursday, February 07, 2002 1:05 PM To: Multiple recipients of list ORACLE-L I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't need

Re:RE: Migration utility from 7.3.4 to 9i ??

Dick, Even if you take export/import route it should be fine. As far as the rowid is concerned it should be the same as rowid in version 8. so logically there will be a conversion of the row-ids from older format(v 7.3.4) to the new format( v 8 or v 9), and nothing is needed to be done explicitly,

Re: STATSPACK impact?

REF: PG 3 MARCH/APRIL 2000 DBAs can set specific level of running statspack. Level 0 & Level 5 does not impact resource usage that much so that you notice the difference. But Oracle warns not to run Level 10 cause it is marked as resource intensive. Level 10 Statspack collects all statistics from

TFM

We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on O

RE: Unorthodox 8i install/upgrade

I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't need to phone up a DC operator and have the CD put into the tray. Richard -Original Message- Sent: Thursday, February 07, 2002 12:33 PM To: Multiple reci

RE: What impacts index build times on partitioned tables?

Hello Cherie Your talk about other applications made me think that you allowed the DB to be accessed during this time. Anyway, I think that you need to monitor CPU, I/O, page faults and all the other nice things in the machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Or

Advanced Queueing

Hi - Is anybody using Oracle's AQ feature with MQ Series? If so, please contact me, I have some questions on what is needed - ie. Gateway from MQ, Gateway from Oracle. Thank you! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- Please see the official ORACLE-

9ias Security

Anyone seen this paper: http://www.nextgenss.com/papers/hpoas.pdf Someone in our apps group here gave it a read and is questioning a planned upgrade to 9ias. The upgrade is a month or so out, so I'll have the opportunity to ensure that things are up to date on any security patches, config se

RE: Unorthodox 8i install/upgrade

We have followed the HP model and set up a software distribution (HP calls it a Software Depot) node. We copy the CDs into appropriate directories as the Oracle administrator. Then we allow NFS mounts of the SD node file systems and install from the SD node. We also are running Samba here an

RE: MC/Serviceguard vs Sun Clusters

Title: RE: MC/Serviceguard vs Sun Clusters Were you only running a single heartbeat connection? Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi."     - Larry Wall (creator of Perl) >-

RE: export/import on the same server

Rachel and everyone else, Thanks much for your help in helping me do my first import/export. It actually worked the first time like I hoped it would. I went with the import by user schema. Got a couple of errors at the end of my import on some Replication procedures that are invalid but I d

RE: Has anyone installed 9i On Win XP Pro

Title: Message I did, but I haven't done much with it yet.  I think I used version 9.0.1.0.0, not the current release. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 07, 2002 9:21 AMTo: Multiple recipients of list ORACLE-LSubject:

Re: Oracle and Document Management: any real stories?

- Original Message - > TOPIC: Oracle and Document Management: any real stories or information? > > Does anyone have any experience with Oracle and Document Management that > they're willing to share? [I'm cross-posting to Oracle Apps and Oracle > Server.] > check Oracle Internet File S

RE: deleting a datafile on OPS

Jay is absolutely right. Paul, if you would like to know more about your datafile issue go to 'metalink.oracle.com' and check out 'Note:111316.1', which will explain everything about datafile re-org. --- "Miller, Jay" <[EMAIL PROTECTED]> wrote: > It isn't an OPS issue, you can't drop a datafile

DB File Sequential Reads

Hi Fellas, An old SIEBEL application running against a 7.3.4 database on NT. There are performance issues. A query which runs with in no time on the QA box, takes 2 minutes on the production. Optimizer is set to RULE. The access plan is the same on both the boxed for the query. On Production, V$

Re: SP2-0103: Nothing in SQL buffer to run.

Krishan Gupta wrote: > > Hi Oracle Gurus > > This might be very silly problem for you gyus, but I > am really geting headache. I suppose today my mind is > not working in sync. > > I am attatching the script which i wrote. When I try > to execute on sql promp, I get the result like this : > >

RE: Unorthodox 8i install/upgrade

I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went

Oracle and Document Management: any real stories?

TOPIC: Oracle and Document Management: any real stories or information? Does anyone have any experience with Oracle and Document Management that they're willing to share? [I'm cross-posting to Oracle Apps and Oracle Server.] The past 5 years, I've been hearing about how Oracle (1) is a document

OT: Has anyone installed 9i On Win XP Pro

Title: Message Just wanted to know if anyone has created a database on Win XP Pro using Oracle 9i.Gautam

RE: deleting a datafile on OPS

It isn't an OPS issue, you can't drop a datafile without dropping the entire tablespace. This has never been possible. -Original Message- Sent: Tuesday, January 29, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Hello list, Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle Parallel

Breakable 9i ?

TechRepublic: www.techrepublic.com BUGS BUST OPEN 'UNBREAKABLE' ORACLE 9i TODAY'S TOP STORY U.K. security researcher David Litchfield is expected to unveil several security flaws in Oracle's flagship 9i database software at the Black Hat Windows Security Briefings conference in New Orleans Frida

Re: Instream SQL

Try this: sqlplus -s

RE: SP2-0103: Nothing in SQL buffer to run.

Title: RE: SP2-0103: Nothing in SQL buffer to run. Try : SQL> start c:\general\ksg\ProcDisp.sql Rivaldi -Original Message- From: Krishan Gupta [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:32 AM To: Multiple recipients of list ORACLE-L Subject: SP2-0103: Nothing

RE: What impacts index build times on partitioned tables?

Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie

RE: MC/Serviceguard vs Sun Clusters

I'll second this. I worked with Sun a few years ago at another place. Here, we're an HP shop with 2 OPS clusters (2 node and 4 node). We finally moved our straggler Compaq cluster to HP a couple of months ago. I'll caveat by saying that we do have a couple of well seasoned SAs and DBAs so

RE: export/import errors

I just opened a low level TAR on these errors just to make sure my data is ok. Thanks, Dave -Original Message- Sent: Thursday, February 07, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Quick look in Metalink would suggest that this is a bug, I would report this to Oracle. I

Re: Remote Compromise in Oracle

Ray, Yes take a look at http://otn.oracle.com/deploy/security/alerts.htm they have workarounds posted with yesterdays date. ...JIM... >>> [EMAIL PROTECTED] 2/7/02 9:55:18 AM >>> The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Or

SP2-0103: Nothing in SQL buffer to run.

Hi Oracle Gurus This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync. I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this : SQL> @c:\general\ksg\ProcDisp.sql SP2-0103:

Re: export/import errors

Dave, Everyone gets these same errors. If you are not using replication then do not worry about these errors. If this is all you got then you are probably good to go. Rick

RE: export/import errors

You have packages with status INVALID. Correct them and the errors will go away. Been there. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 07, 2002 5:29 PM > To: Multiple recipients

[Q] MS Access to ORACLE migration guide line?

We plan to migrate some of our MS ACCESS database (97/2000) to ORACLE 8.1.7. Can anyone tell me where can I fond migration white paper or guide line? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl

RE: stopiing write to listener.log

1) lsnrctl stop RENAME %ORACLE_HOME%\NETWORK\LOG\LISTENER.LOG OLD.LOG lsnrctl start 2) see the sample in network\admin\sample. use trace_level=user (IMHO). Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Prakriteswar Santikary [SMTP:[

RE: What impacts index build times on partitioned tables?

I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] >

RE: export/import errors

Quick look in Metalink would suggest that this is a bug, I would report this to Oracle. I think there is a fix to it. Lee -Original Message- Sent: 07 February 2002 15:29 To: Multiple recipients of list ORACLE-L I just did my first export/import and of course I got some errors at the v

Re: MC/Serviceguard vs Sun Clusters

On Thu, Feb 07, 2002 at 07:18:34AM -0800, Kimberly Smith wrote: > Actually, the heartbeat has been the biggest pain in the but of > ServiceGuard. butt n. The larger or thicker end of an object: the butt of a rifle. My associates tell me I am an expert in this area... =

Re: SQL Insert question

Im afraid i cant answer that question Stephane , as i dont have much to do with the design of this DB... thanks for the query... regards IA Stephane Faroult <[EMAIL PROTECTED]>@fatcity.com on 07/02/2002 14:53:32 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multip

What impacts index build times on partitioned tables?

We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time

Remote Compromise in Oracle

The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Oracle Remote Compromise Systems Affected: Oracle 9, 8 Platforms: All Operating Systems Severity: High Risk Vendor URL: http://www.oracle.com/ Author: David Litchfield ([EMAIL

RE: stopiing write to listener.log

Peter,   How do you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't rememb

Re: Scrolling Sideways in SQL*Plus

try exiting sql plus and login in again then set the linesize 1000 (e.g.) first before you run anything else [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:33:40 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTE

export/import errors

I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing DRV'

DLL question

Okay, I can't find where this is documented. What .dll corresponds to ora805.dll in 8.1.6? Better yet, where is that documented? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FA

RE: MC/Serviceguard vs Sun Clusters

Actually, the heartbeat has been the biggest pain in the but of ServiceGuard. Its caused 99.99% of the failures. Granted once it was a failed network card. All in all though, I have been pretty happy with ServiceGuard. And ours is dedicated and protected:-) -Original Message- [EMAIL P

RE: JDBC errors?

Title: JDBC errors? When we had a similar problem it was cause of the JDBC driver that was being used. They had to upgrade from the one we had been using to connect to previous versions of the database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Beh

Re: Instream SQL

#/bin/ksh sqlplus -s / << EOF select 'x' from dual; exit; EOF Robert Pegram Oracle DBA --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have a batch script running on Unix and I need to > call a short SQL script > (3 or 4 lines). Can someone show me the syntax > to execute an inline SQL s

Re: RMAN full backup Vs Incremental level 0

You have to have an incremental level 0 in order to restore you database. If you are going to do backups once daily then you should do a level 0 one the first day of your cycle and then incremental backups after that. There are many levels of incremental and you should read about them to find out

Re: SQL Insert question

[EMAIL PROTECTED] wrote: > > Hi , > > this is puzzling me.. > > i have following table > > table name = Sierras. > Columns = > regno, > platfrom, > cost , > licence_ref > renewal_data > > i split this table up into 2: > > 1. Softwares > cols= > id, > regno, > platfrom, > > 2. Licences > id,

RE: svrmgrl

see? security :) --- àãø_éçéàì <[EMAIL PROTECTED]> wrote: > You also need to be an administrator. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: Igor Neyman [SMTP:[EMAIL PROTECTED]] > > Sent: Thu, February 07, 2002 3:38 PM

RE: Slightly OT: PVCS Tracker 7.0 Backup & Recovery Question

You know, not to cause you to worry but I have had issues with Tracker databases. In one case I could not export fully successfully. I worked with Oracle for about a week to try and get to the cause (I don't think I had their brightest working with me). Finally, Oracle said to rebuild the databa

Re: Re[2]: stopiing write to listener.log

THANKS . regards, shibu - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 7:43 PM erm. to Shibu. I forgot the smiley. It was only a joke !!! -Original Message- Sent: 07 February 200

RE: Re[2]: stopiing write to listener.log

Nice one, although the pipe still sounds interesting. Peter -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:56 À : Multiple recipients of list ORACLE-L Objet : Re[2]: stopiing write to listener.log Shibu, To get the listener to

Re: MC/Serviceguard vs Sun Clusters

On Thu, Feb 07, 2002 at 06:00:04AM -0800, [EMAIL PROTECTED] wrote: > Consequently we abandoned ServiceGuard & are > going to standby databases instead. > > Dick Goulet I have been very pleased with standby stability, but find it a little awkward wrt maintenance as availability demands increase.

  1   2   >