RE: URGENT !!! ORA 604

this is a know bug Arvind.. check metalink on this.. many articles on how to ger around this problem... if you dont have access to metalink... mail me privately.. -- From: Arvind Kumar[SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 05, 2000 1:59 PM To: LazyDBA

space allocated vs occupied - procedure

List, i have written a procedure which dumps the space allocated vs space occupied by a table/index in a schema(using dbms_space) i use this sctipt to size /re-size objects in my database. the procedure dumps the statistics in a table, e-mail if you think this would be of any help.

Re: Compare tow schemas

Hi! I don't remember the original place but here is one. You may want to adapt it to Your needs. Gints Plivna undef prex undef prefx undef a undef thisuser undef b undef REMOTESCHEMA undef REMOTEPASSW undef connstring undef c undef todaysdate variable prefx varchar2(3) declare i number ; j

Recover from noarchive database ?

Hi, My database is noarchive mode, what should I do to prevent the lossing any transaction ? Like for example incresing the REDO buffer to ? Will this decrese the performance ? any technique to share ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy

Recovery from noarchive db corrected

Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: v$buffer_pool_statistics

I'm theorising here.. It may well be version related... I know in 8.1.7.0 they've zero'd out a few of the figures in this view (possibly due to bugs in the way they were calculated in versions previous) I'm on 8.1.7.1 and the figures seem fine to date... hth connor --- Djordje Jankovic [EMAIL

Making use of 2 CPUs

Hi folks, I have noticed that even at 40% machine usage, Oracle is not using the second CPU on one of our servers. Any idea what the best way to get it to do that. I understood that DB_WRITER_PROCESSES 2 was only worth it if you had more than 2 CPUs.

Is ALTER TABLE ADD COLUMN a time-consuming operation ?

Hello List We are going to change structure of a big table (more than 250.000.000 rows). We need to add a column with NUMBER type. I'm unclear how Oracle do this operation. Does it mean that Oracle have to read and reformat all table blocks in order to update each row header? If yes, I can

RE: Constraints

Roland, Unique or primary key constraints will drop the associated index if disabled. If reenabled they would need to be done with the storage clause or will just go in the default tablespace. Iain Nicoll -Original Message- Sent: 05 April 2001 11:21 To: Multiple recipients of list

RE: Unable to Alloc Memory

On the SUN APP Server :- $ ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 2097148 stack(kbytes)2097148 coredump(blocks) unlimited nofiles(descriptors) 1024 vmemory(kbytes) unlimited $ ulimit -Hs 2097148 NOTE - On a Digital Inix

RE: advanced replication error v8.1.7 ORA-01403

If you there is error in the DEFERROR view, and you are sure that there are no error in replication you can try to delete it manually: execute dbms_defer_sys.delete_error(deferred_tran_id,'REPLICATION_SITE'); HTH, Sonja -Original Message- Sent: Wednesday, April 04, 2001

Re: Is ALTER TABLE ADD COLUMN a time-consuming operation ?

If the new column is nullable, it should very little time, since all that happens is an update to the dictionary. If it is not null, then the column will have to be physically added to each row with a value. [EMAIL PROTECTED] 04/05/01 07:15AM Hello List We are going to change structure of

RE: Unix memory used

Thanks Jared and Jacques and Dave and Michael, I seem to remember a discussion on top a couple of years ago, that's why I was suspect about the numbers it was showing. I've been to the sun big admin page, lots there to read. I'll track down some of the other suggested sites, as well as look for

RE: OT : Sinclair was RE: Metalink Again

I used to have a Spectrum +2? One of the little keyboards with rubber keys and a tape drive! Still have it in the loft at my parents with all the original games too! Damn how I used to love sitting in front of a screen blinking red/blue/green colours at me, screaming like a drowning cat while it

OT -- RE: Re: Metalink Again, tandy computers

I was in grade 11 when the TRS-80 came out. Our geography teacher had one at home, but he brought it in. In our electronics lab downstairs that teacher spent hours and hours working on his Apple IIE with Heathkit learning modules, which he later used to teach us Boolean logic and rudimentary

RE: OT : Sinclair was RE: Metalink Again

I have a copy of PC Magazine volume 1, number 1 in my bookcase at home. The only thing is we cut out a coupon that was on the inside of the back cover, so there is a corner missing. The one will all those wooden puppets standing on the computer, and Charlie Chaplin. I remember standing at

Re: Making use of 2 CPUs

This is most likely an OS issue. Forking threads across processors is handled by the OS. I know of no Oracle configuration to specify processor affinity. When I called Oracle Support on this a while back, they confirmed that there was no way to specify this. Does the processor sit idle at 0

Optimizer Question/Puzzle

Hi I have running the following two queries. If you look at the first query the cost is 37181 and takes about 16 minutes to run on (3CPUs Aplha Tru 64 Unix Oracle 8.0.5) whereas the second query (cost 561) which I thought would have run lot faster does not come back as quick (in fact I

RE: Making use of 2 CPUs

Hi Cameron, Oracle can use CPU affinity on NT. Note:108512.1 explains steps. regards... --- Martin Kendall [EMAIL PROTECTED] wrote: Thanks Cameron, I will get the Unix Guy to look at it. Martin -Original Message- Sent: 05 April 2001 14:16 To: Multiple recipients of list

Re: v$buffer_pool_statistics

I am on 8.0.4.4. I last checked it before I applied the patch coming from 8.0.4.0. I don't rememeber having those weird numbers on 8.0.4.0. So, it might be version related. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April

Re: No Listner...!!!!

Do you have a tnsname.ora file on the server and the client? Just s thot... Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 2:10 AM hi friends, I'm trying tough towards becoming a ful handed oracle 8 DBA. yesterday,

RE: OT : Sinclair was RE: Metalink Again

There is still have at least one Sinclair gas station left. It's near the intersection of Interstate 90 and U.S. Highway 151 in Madison Wisconsin. -Original Message- Sent: Wednesday, April 04, 2001 5:27 PM To: Multiple recipients of list ORACLE-L I thought it was a green dinosaur on

RE: Re: Metalink Again, tandy computers

Heck yeah baby, I learned BASIC and Assembler on that 2.77 mhz Z-80. I loved accessing video memory directly, and I thought it was edtasm. Dan -Original Message- Sent: Wednesday, April 04, 2001 9:50 PM To: Multiple recipients of list ORACLE-L Anyone besides me remember the old tandy

Re: OT : Sinclair Petroleum

Sinclair is still in business. They run their operations out of Salt Lake. They have a larger presence in the planes and rocky mountain regions. And the dinosaur is green. On Thursday 05 April 2001 09:35, Ben Schilling wrote: There is still have at least one Sinclair gas station left.

RE: OT : Sinclair was RE: Metalink Again

Ben, I can vouch for that one - I gassed up there last Saturday while driving from New Jersey to Minneapolis ( a loong drive) stayed overnight in Madison , a very nice town. Went into a little brewpub near the capitol, E Wilson street ?? - i forget Brian "Schilling, Ben" [EMAIL

RE: Is ALTER TABLE ADD COLUMN a time-consuming operation ?

Hi Eduard, This will be almost instantaneous, unless you specify DEFAULT value. Oracle doesn't need to keep any information of trailing NULL columns in the data blocks. Oracle will not change row headers until non-null value will be set. If you need this column to

BLOB vs. B-File

Title: BLOB vs. B-File Hi everyone - I'm looking for some information based on your experiences. We have an application that has large objects to store. They are wondering which way would be better - to store them as BLOBs within the database, or as bfiles outside the database. My instincts

Re: BLOB vs. B-File

If you're looking for a rule of thumb, I generally work by "Large size, small volume of files" = BFILE "Small size, large volume of files" = BLOB basically on the premise that databases are great for handling large volumes of small pieces of data, and file systems are good for a small volume of

tkprof for 10046 event

Hi, When setting event 10046 at level 8 it produces a trace file with wait events. Does anyone have a utility like tkprof which summarises the trace file to show a summary of wait events and timings per sql statement? Thanks, Steve Wilkes ___ Oracle DBA npower

RE: OT : Sinclair was RE: Metalink Again

Sweet Minneapolis! i did that drive once when I moved back to Jersey. Whoa what a drive!! -Original Message- [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Ben, I can vouch for that one - I gassed up there last Saturday while

RE: What kind of date format?

Chris, Since Oracle cannot handle milliseconds, one of my colleaque wrote a stored procedure to manipulate the date and then dump the sybase data into a flat file and used sqlldr to load into Oracle. Another solution will be load this date into a varchar2 column and use a combination of substr

RE: killing a thread

Title: RE: killing a thread I didn't see this in my $ORACLE_HOME/bin. Is this platform specific? -Original Message- From: C.S.Venkata Subramanian [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: killing a thread

PCTUSED??

Hi Friends I am wondering you people can give me indepth about How storage is manipulated in frequent inserts and occationally mass delete!! works. My problem here is I have 20G table with 15G Indexes!!! We deleted 98,99 data!! So I want to avail that deleted space. How can I do that with

Re: Oracle being scalable

Did you really mean the error page? RBG - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 11:26 AM Have you seen this? http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h tml Regards,

Re: Optimizer Question/Puzzle

When you've got plenty of rows on you're driving table, then using an EXISTS clause will typically mean an index lookup for everyone of those rows, where as the sort-merge is overcoming that by "brute force" so to speak... Its also important to realise that the 'cost' figure cannot be used

RE: Oracle being scalable

that page has been moved ... colour me surprised! Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent:

Re: Select won't work for view create

I have a select that works fine. However, it doesn't work fine when I try to create a view of the result set. There is nothing particularly fancy about the query, just a plethora of outer joins from the main table to the secondary tables. I get an error back about one of the tables not

RE: Oracle being scalable

The e-mail system chopped up the link, you have to edit it and put the tml back in... unless the page has actually disappeared... You can also get to it from the www.oracle.com main page, it's one of the links. Pat. -Original Message- From: Glasrot, Nechama [SMTP:[EMAIL PROTECTED]]

RE: Select won't work for view create

Hi Dan, are you referencing public synonyms in your statement? Lisa Rutland KoivuOracle Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104 Ft. Lauderdale, FL 33319 Phone: 954.484.3191

RE: Exp/imp into different version

Sure is. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message- From: Connie Milliken [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:26 PM To:

Exp/imp into different version

Is is possible to take a full database export from Oracle 8.0.5/HPUX and import it into Oracle 8.1.6/HPUX? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: tkprof for 10046 event

Hi Steve, I've not checked recently, but Guy Harrison used to have one on his web site. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 6 April 2001 1:52 To: Multiple recipients of list ORACLE-L Hi, When

RE: Oracle being scalable

When you click on the link...add 'tml'(as in ,html) to the URL...it was cut off on the hyperlink provided! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, April 05, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Did you really mean the error page?

Select won't work for view create

I have a select that works fine. However, it doesn't work fine when I try to create a view of the result set. There is nothing particularly fancy about the query, just a plethora of outer joins from the main table to the secondary tables. I get an error back about one of the tables not

Re: tkprof for 10046 event

Hi ! I have not seen any tool for formatting the wait event stats. Steve Adams has some script in his book (Oracle8i Internal Sevices page -16). You can write a similar script and explore the trace files. = Have a nice day !!

RE: Oracle being scalable

move the tml back up to the .h (wintergrp.html) http://www.oracle.com/ip/deploy/database/featurestory/index.ht ml?wintergrp.h tml -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: killing a thread

Title: RE: killing a thread I thought that was only for windows machines? Anyway, how do you use it? Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Thursday, April 05, 2001 12:17 PMTo: Multiple recipients of list

RE: Select won't work for view create

Now that is one fancy signature! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't work for view create Hi Dan,

Re: OT : Sinclair was RE: Metalink Again

Actually, there is more than one. There are at least three in Omaha, NE along. (Maybe more, but I don't drive by any others on a regular basis. Terry "Schilling, Ben" wrote: There is still have at least one Sinclair gas station left. It's near the intersection of Interstate 90 and U.S.

RE: OT : Sinclair was RE: Metalink Again

Sounds like denial after the fact to me. If you believe these quotes: http://www.geocities.com/SiliconValley/Vista/8009/bill.gates.quotes.html it's easy to think he changes his tune allot. -Original Message- Pierce Sent: Wednesday, April 04, 2001 5:51 PM To: Multiple recipients of

RE: Oracle being scalable

his email formatting broke the line in two, just add the "tml" to the ".h" and you'll get there Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, April 05, 2001 12:31 PM To: Multiple recipients

SQL QUERY HELP

Hi Gurus I have following data in table emp empcode empname SAL a001 X 2000 b001 Y 4000 c001 A 5000 d001 C 8000 If sal is =5000 there will be another columns grade and print A else B The outout would be like empcode empname SALGrade a001

RE: Select won't work for view create

With apologies to Oracle Corporation... Hope they don't sue me. ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin KostyszynSent: Thursday, April 05, 2001 10:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't

Rollback segments not shrinking

Can anyone tell me why we would get "unable to extend" errors in rollback but the segments will shrink when done manually - I thought that rollback segments would shrink when not used if another rollback segment needed the extents. We're way back on 7.3.4 on Solaris. Cheers Iain Nicoll --

Re: Exp/imp into different version

Connie, Yes it is. As a matter of fact it is part of a documented upgrade method outline in the Server Migration Guide. Cherie Machler Gelco Information Network

RE: Select won't work for view create

Dan, To create a view on a table, you must have Select granted directly to your User, not just via a Role, which works for Selects. Maybe that's it. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,

RE: What kind of date format?

Prakash, Thanks for the email. I think I will have to try to create one varchar2 field, then drop it after the data loaded. Thanks, Chris --- "Bala, Prakash" [EMAIL PROTECTED] wrote: Chris, Since Oracle cannot handle milliseconds, one of my colleaque wrote a stored procedure to

OT RE: Select won't work for view create

Yea, I noticed that. Lisa musta gotta raise. (congrats!) -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't work for view create Now that is one

RE: OT : Sinclair was RE: Metalink Again

On 5 Apr 2001, at 9:47, David Messer wrote: Sounds like denial after the fact to me. If you believe these quotes: That is certainly a possibility, but not "proven". The site you cite obviously is not a bona fide journalistic/historical/research site, and the content would easily fail any

RE: killing a thread

Title: RE: killing a thread Hi, It WAS for windows until 8.1.x, i believe. There is a kill in UNIX, no need for special utility. How to use: select spid from v$process, v$session where paddr=addr and sid = SID; then orakill SID spid thread will terminate... HTH Vadim Gorbounov

avoiding ora-1652 on temp tablespace

We recently released a new version of our software and suddenly we're blowing out our temp tablespace.The previous version never complained at 1000m. The new version is choking on 2500m. I don't want to keep adding space, although that's the conventional wisdom. I want to find the query or

RE: Select won't work for view create

Title: RE: Select won't work for view create -Original Message- From: Dasko, Dan [mailto:[EMAIL PROTECTED]] I have a select that works fine. However, it doesn't work fine when I try to create a view of the result set. There is nothing particularly fancy about the query, just a

RE: Oracle being scalable

thank you ... i finally got it Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, April 05, 2001

RE: Oracle being scalable

Title: RE: Oracle being scalable -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Have you seen this? http://www.oracle.com/ip/deploy/database/featurestory/index.ht ml?wintergrp.h tml Interesting. For those of you who haven't read the article, it says

RE: avoiding ora-1652 on temp tablespace

Start running explain plan for your queries. Sounds like you have a cartesian product somewhere in the code... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seley, Linda [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:41 PM To: Multiple recipients

RE: OT : Sinclair was RE: Metalink Again

Title: RE: OT : Sinclair was RE: Metalink Again -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] it's easy to think he changes his tune allot. That is the impression I also get. but that doesn't strictly disprove the veracity of the claim on the other site

RE: Select won't work for view create

Title: RE: Select won't work for view create That was the problem. Thanks. Dan -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 2:31 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't work for view create

RE: OT : Sinclair was RE: Metalink Again

But, Eric, I'm not out to prove anything. I'm only trying to show Gates in the worst light possible. My desire to do so derives from working day in and day out with Microsoft products. Regards, DM -Original Message- Pierce Sent: Thursday, April 05, 2001 11:22 AM To: Multiple

RE: OT RE: Select won't work for view create

Yea right! Someone in the office of our new parent company had too much time on his hands... -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:47 PMTo: Multiple recipients of list ORACLE-LSubject: OT RE: Select won't work for

RE: SQL QUERY HELP

Title: RE: SQL QUERY HELP -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] I have following data in table emp empcode empname SAL a001 X 2000 b001 Y 4000 c001 A 5000 d001 C 8000 If sal is =5000 there will be another columns grade and print

Re: SQL QUERY HELP

Try this. select empcode, empname, sal, decode(to_char(trunc((nvl(sal,0)+1)/5001)),'0','A','B') NewCol from emp / - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 1:40 PM Hi Gurus I have following data in table

skipping the sidjava.sh step in database create

Hi, If you are not using anything to do with Java is it then safe to skip running the sidjava.sh script that dbassist creates during database creation in Oracle 8.1.7? This step takes forever and uses a lot of System tablespace. Ben Poels Queen's University Kingston, Ontario -- Please see

Query question

Hello gurus please help I am running following query This takes forever to complete. select pay.gl_date from noetix_sys.noetix_current_period off 2 ,gl.gl_sets_of_books sob, gl.gl_periods per, 3 ar.ar_payment_schedules_all pay 4 where 5 pay.gl_date between per.start_date and

Re: Re: Re: bFILES Recovery Manager

hi thanx - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Wed, 04 Apr 2001 13:24:12 -0800 Subject:Re: Re: bFILES Recovery Manager On 4 Apr 2001, Cyril Thankappan wrote: Hello!

OT RE: Oracle being scalable

Title: RE: Oracle being scalable LoL! The "Winter Corporation"? Which databases were included? The Olympics one that IBM did on DB2? The Terraserver database? The SETI one? 2500 Transactions per second is the fastest they did? A conservative estimate of page hits per second (

RE: OT RE: Select won't work for view create

Yeah but it makes you look so cool, smooth and important!!! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Thursday, April 05, 2001 3:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Select won't work for

Re: killing a thread

I don't see an orakill in the $ORACLE_HOME/bin directory for either AIX or SUN at 8.1.6. Are you sure? Terry Vadim Gorbounov wrote: Hi, It WAS for windows until 8.1.x, i believe. There is a kill in UNIX, no need for special utility. How to use:select spid from v$process, v$session where

RE: Query question

Title: RE: Query question -Original Message- From: Mukesh Ghildiyal [mailto:[EMAIL PROTECTED]] I am running following query This takes forever to complete. select pay.gl_date from noetix_sys.noetix_current_period off 2 ,gl.gl_sets_of_books sob, gl.gl_periods per, 3

Re: Oracle start/stop scripts on AIX

I have worked on 4.3.3 AIX boxes recently, and none had /etc/rc.d installed. Jared On Wed, 4 Apr 2001, Ram Kumar wrote: AIX had started using the /etc/rc.d setup since 4.3.3. I think AIX 5L may incorporate most of the UNIX/LINUX generic features missing from its previous versions. Ram

RE: Query question

Mukesh, did you check the explain plan for both queries? -Original Message- Sent: Thursday, April 05, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Hello gurus please help I am running following query This takes forever to complete. select pay.gl_date from

FW: Dependent objects

Title: FW: Dependent objects Hi - Does anyone have (or know where I can find) a script to identify dependencies on a table? When we make table modifications, we would like to be able to run a script that recursively identifies dependent objects. We pulled one from Metalink, but it doesn't

RE: killing a thread

I can't find it either. Is the script you meant? $ORACLE_HOME/network/agent/jobs/oracle/cmanager/general/killsess.tcl [EMAIL PROTECTED] 04/05/01 12:16PM I didn't see this in my $ORACLE_HOME/bin. Is this platform specific? -Original Message- Sent: Thursday, April 05, 2001 1:00 AM

Re: Oracle start/stop scripts on AIX

AIX 4.3.3 listing below. All the directories are empty. The rc script appears to follow the linux world, local startup stuff. Guess I am stuck w/ the IBM way :). sp2f1n05:/etc/rc.dls -alr total 88 drwxr-xr-x 2 root system 512 Mar 21 17:43 rc9.d drwxr-xr-x 2 root system

tirggers

Hi Intelligent DBA's I was wondering if anyone knows how to create a trigger that would fire off at database startup time and run a script to do full table scans on several tables to get them into the buffer cache keep pool? Right now I do it manually and would like to automate the task.

RE: why is there dinosaur statues and evolution of human concious

Title: RE: why is there dinosaur statues and evolution of human conciousness / RE: OT : Sinclair was RE: Metalink Again I've said it before and I'll say it again. Eric, you have entirely too much free time on your hands. ;) Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear

RE: failed to extent to the next

Title: RE: failed to extent to the next -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] I used to use this script detect the tablespace fail to extent to the next and sent email to me everyday. It works fine. However, the other dba think next extent is not

RE: killing a thread

Hi! ORAKILL is only available on Windows NT/2000. Because Oracle uses a thread based architecture on Windows and all threads run within the same "oracle.exe". On UNIX, Oracle is process based and you can kill the corresponding process. hth, Helmut -Original Message- From: [EMAIL

Moving Intell. Agent Ports?

Anyone have any luck in reassigning the dbsnmp process to use different port numbers than the default 1748 and 1754? The setup: OMS and OEM 2.2 install on NT box,-- Ora 8.1.6 w/ Intell Agent installed on AIX The unix boxhas 3rd party apps that do not allow ports 1748 and 1754 open but

RE: why is there dinosaur statues and evolution of human concious

Title: RE: why is there dinosaur statues and evolution of human conciousness / RE: OT : Sinclair was RE: Metalink Again Keep it up, EP. I read every word. Even understand most of them! G -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent:

8.1.6 vs 8.1.7

Hello, I was wondering how stable the Oracle 8i release 3 is. We plan to move our DB in production to the latest version. Has anybody had problems migrating it? I was told by colleges that release 2 looks more stable than the other. How true is that? Any comments ? Thanks in advance, Jordi

RE: tirggers

What is the problem to write something like Select * from table_name for all tables that you need or if there are too many such tables - create a new table with names of the tables and use dynamic SQL . Alex Hillman -Original Message- From: Kevin Kostyszyn

RE: why is there dinosaur statues and evolution of human concious

dude- oh, that's right! here is the short version: "i'm sick of all these pissy people that don't have anything better to do than repeat the same old boring, trivial, predictable complaints about Bill Gates when they could be repeating more interesting, informative,

help - ora-12560

DBAs: There might have some one post before, but I can't recall the answer now. We have completely gone through oracle 8.1.6 installation on window 2000 server. When we run net8 configure assistant, The computer frozen. Then we have to cancel it but listener.ora has been configured. When we use

RE: Dependent objects

Title: FW: Dependent objects A couple of them here... http://www.timonions.com -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: FW: Dependent objects Hi - Does anyone have

RE: Query question

I presume, your query is running out of indexes. Run the explain plan and check if Oracle performs any full scan into a table. Then, create an index for that particular case. If for any reason, Oracle doesn't use the index created, apply a hint ( /+ /) into your SQL, meaning that your going to

speaking of Dr. Paul Dorsey / (Fwd) RE: Where to handle referential integrity and other data

Warning, the following comments (presumably in short form) are from somone who not only has a Phd, but a minor in philosophy. :) ep --- Forwarded message follows --- Date sent: Thu, 05 Apr 2001 14:40:29 -0800 T o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m F r o

RE: OT why is there dinosaur statues and evolution of human conciousness

I hadn't thought of that. It's not that I criticize Gate/MS for making money or being the first or best to use a particular business strategy. My income is derive, at least in part, from using MS technology. My annoyance and disgust is with such things as the MS policy of upgrades. I started

RE: Dependent objects

Title: RE: Dependent objects -Original Message- From: Yttri, Lisa [mailto:[EMAIL PROTECTED]] Does anyone have (or know where I can find) a script to identify dependencies on a table? When we make table modifications, we would like to be able to run a script that recursively

RE: 8.1.6 vs 8.1.7

Title: RE: 8.1.6 vs 8.1.7 I had some problem with external process. Zhong It's another beautiful day! -Original Message- From: Jordi Sanmarti [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 3:21 PM To: Multiple recipients of list ORACLE-L Subject: 8.1.6 vs 8.1.7

RE: OT RE: Oracle being scalable

did you see a category for the fastest biggest IBM mainframe IMS database communicating using EDI (or whatever that legacy data communications thingy is called that banks have been using for decades instead of IP) that runs in a legacy Z80 serial port simulator mode and boots off 8" floppies

  1   2   >