Re: Cronjob

This is not the only way. See my next post on this. Jared On Wednesday 24 April 2002 15:08, Alex wrote: -e Edit the current crontab using the editor specified by the VISUAL or EDITOR environment variables. The specified editor must edit the file in place; any editor that unlinks the

Re: Is sqlplus too slow to unload data?

On Tuesday 23 April 2002 21:53, Bin Wang wrote: Hi, Our application uses sqlplus + sqlloader to transfer data between databases. It takes nearly four hours to unload to data to flat files(1G), which is far too slow. In the application, the query looks like the following. All those 3,4,5

Re: Curious question about flushing the Pool

Tim, I've had opportunity to tune the database in an attempt to fix a poorly ( very ) designed application. This app may well benefit from CURSOR_SHARING=FORCE, but that would negate the use of histograms on one table that makes good use of them. That parameter may also have an effect on

Re: Curious question about flushing the Pool

I'll second that suggestion! To extend the analogy, how about a recycle pool for them? (So they don't fragment or otherwise clutter up the keep pool.) How about adaptive auto-pin in the keep pool based on execution frequency? (Never mind... Probably not really necessary. I'd settle for the LRU

RE: LOG_BUFFER Parameter Question

Thanks to all of you on this issue... -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 24, 2002 8:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: LOG_BUFFER Parameter Question Alternatively, you size it until

Re: Curious question about flushing the Pool

Comments? Corrections? Rants? I'll go for rant... I've had long and painful experience with a few pathological applications. One in particular contained hundreds of sets of common SQL statements - varying only in the literal values. Many were executed hundreds of thousands or even millions

Anyone using Enterprise Manager?

Hi, I have this problem with starting 9i EM as connected to Management Server After installation and configuration I started with default sysman. And changed the password after first login. It worked fine for that session but after closing and then restarting, EM Console does not seem to be

Re: good pl/sql coding/debugging tool?

I would suggest you to use TOAD because the DBA Module of this product is quiet good. Database Monitor and Unix Monitor could also be used. Another option is SQL Station from CA. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162

RE: monitoring multiple databases using PL/SQL -- follow-up question

Point 3 sounds correct.. Make sure that you also *monitor the monitor*!! Even if you just set up AT job or something that runs from a DBA desktop every 10-20 minutes, connects to the instance and select 'OK' from dual; to test the connection.. If it fails, flag an error through something like

RE: good pl/sql coding/debugging tool?

Other options would also be PL/SQL Developer from www.allroundautomations.com (though I had heard that they have also been taken over by Quest), and Lecco SQLExpert from www.leccotech.com (also available from yours truly ;P) Mark === Mark Leith

Cronjob

Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Which Server Machine?

Hi, What should be the basis of selecting a type of server machine? Single processor, two processor, four processor How many years down the road should one plan for? In web deployment, the web server will have connection(s) with data server and can be configured for connection sharing. What

RE: Any scripts to check the health of the database

This is something that I am looking for a way to check on an 8.1.7 database running on NT without me physically having to login myself. Is there some automated way to do this, that maybe can send an email to a computer operator?? Thanks, Dave -Original Message- Sent: Wednesday,

Re: good pl/sql coding/debugging tool?

give up windoze, go to linux and use TORA. joe [EMAIL PROTECTED] wrote: I would suggest you to use TOAD because the DBA Module of this product is quiet good. Database Monitor and Unix Monitor could also be used. Another option is SQL Station from CA. Regards M.Emre HANCIOGLU

How to Install oracle 9i on windows cluster.

Hi all I have to install oracle9i on windows 2000 cluster environment. whether i have to install it in cluster or not. and what are all the steps to follow. Rgds Ayyappan.S This communication contains information,

RE: Cronjob

0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

hi Mike, Go to my site (www.oracledba.co.uk), then Tuning = Custom Hit Ratio Enjoy! Cheers Connor --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...ok...ok...enough talk... can somebody PLEASE publish a reference location of this script? Thanks, Mike -Original

Re: Cronjob

0 6 * * 6 /d31/app . Look at man for crontab (on my linux it's man 5 crontab); The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day

Re: Cronjob

man cron man crontab you really need to do some research on your questions before posting --- [EMAIL PROTECTED] wrote: Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh

RE: Cronjob

Use vi. -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh

Re: Cronjob

0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 __ www.cichomitiko.cjb.net __ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 1:43 PM Hallo, I would like to have this cronjob run only

Can't Break In and Securing iAS on NT

I am reading through O'Reilly's Apache: The Definitive Guide, 1999. On page 42 it says: In plain English, this means, once again, that Win32 is not an adequate platform for running a Web server that has any need for security. Has anyone been able to get info out of MetaLink on how to secure

RE: Curious question about flushing the Pool

True - but then you're up for a definition of what constitutes filthy? A query like select to_char(x,'...'), substr(y,1,3),instr(..) (ie insert any appropriate Oracle function that could have static numeric/character arguments) and suddenly its filthy...Still, I'd like something more dramatic

Re: Curious question about flushing the Pool

Minor correction, cursor_sharing did work in versions under 8.1.7.3 (I used it in 8.1.6) but there was a bug relating to very specific usage. I never encountered it, I know you can look up the details of the bug on Metalink. Having said that, I used cursor_sharing=force instead of flushing the

RE: 9i new features, the saga continues?

Yes, I am *still* interested Joe. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having

9i new features, the saga continues?

Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was 9i data guard. joe

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

Good morning everyone: Since everyone was wondering what the Top 10 things were from IOUG Live!, I went to the source: Ian Abramson, Director of Educational Programming for the IOUG and the person that provided this jocularity. Here they are: Here is the top 10 list: Top 10 Lessons Learned

Re: Cronjob

Roland, The crontab fields are defined as: 1 2 3 4 5 program to execite 1 = minutes after the hour 0-59 2 = hours of the day 0-23 3 = days of the month 1-31 4 = months of the year 1-12 5 = days of the week 0-6 0=Sunday * = all possible values 0 6 * * 6 job to be run is placed here. States

OLAP Financial Function Calculators for Oracle 9i.

Hi I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain

RE: Which Server Machine?

IMHO, I would never opt for only 1 cpu. There should be at least 2, if you are going to be using parallel query, then 4 cpus. After 4, on many platforms, there is diminshing return on investment. That's my rule of thumb, and I have nothing to base it on but gut feeling. HTH, Beth

Buffer in Import

Does the parameter buffer in the import refers to bytes or number of rows ? Kind of confuse. I think it refers to the number of rows. buffer=5 --- is that 5 bytes, or 5 rows TIA Ramon

Re: good value for optimizer_index_cost_adj

My 1/2 cents on this... Another way of thinking of scattered -vs- sequential reads is that a scattered read is used when you know up front that you want to read several blocks and know which blocks they are. You can then use a vectored read to do this or farm them all out in parallel using

Re: Anyone using Enterprise Manager?

Check out note 114682.1 on Metalink.

RE: Is sqlplus too slow to unload data?

Hey Jared, I got quite a few folks waiting for your book now. I am really pushing Perl at the office:-) When is the scheduled release again? -Original Message- Sent: Thursday, April 25, 2002 12:03 AM To: Multiple recipients of list ORACLE-L On Tuesday 23 April 2002 21:53, Bin Wang

RE: Number of File systems to use.

Thank you very much Robert Freeman for your opinion. I am half way through your book of 9i new features. It is very good. Could some one else give some opinion on the need to spread IO even when using EMC storage please. --- Freeman, Robert [EMAIL PROTECTED] wrote: I'd stick to the idea

No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2. While testing our nightly load job that runs in two simultaneous streams (ascending and descending), we have been getting deadlock errors. The trace file shows the the rows waited on are no rows. In response to a TAR I opened

Re: 9i new features, the saga continues?

Joe, You give interesting points and topics. Yes, I am interested in your 9i new features. Thanks for the time you give to help others. Have a great weekend, donita :Date: Thu, 25 Apr 2002 05:13:37 -0800 :To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] :X-Comment: Oracle RDBMS

RE: Curious question about flushing the Pool

okay, who do you still know inside Oracle who can push this enhancement? sounds eminently reasonable to me! Rachel --- Cary Millsap [EMAIL PROTECTED] wrote: I think an excellent Oracle kernel enhancement would be to bias in the LRU scheme against SQL that uses literals, just like the buffer

Oracle ODBC On Windows95 (Don't ask) :)

I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's are running Windows 95 (Old clunkers) Anyone know what I need to do for this? Can I use the 7.3 ODBC drivers written for Windows95 for connection to a 8.1.7? I've never done this before and can't

RE: 9i new features, the saga continues?

Joe, It took me a while to remember what you were refferring to and a search of my archived mail but I too appreciate the information about 9i that you were sending to us. Thanks for finding the time to spread the knowledge. Ron ROR mª¿ªm -Original Message- Sent: Thursday, April 25,

RE: 9i new features, the saga continues?

So those features aren't new any more; they're 6 months old. =) Paging Robert Freeman; Joe is cutting into the sales of your book here!! Grins to all on this sunny afternoon, Mike Hately -Original Message- Sent: Thursday, April 25, 2002 9:14 AM To: Multiple recipients of list

UNIX Courses

Hi all, What Unix courses/modules would you recommend for a budding Oracle DBA Thanx, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: 9i new features, the saga continues?

Yes! Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent:

sql monitor

hi! i am looking for tools to monitor the SQL of an application that connects to oracle to analyse it. whichs tools are available? who has experience with them??? tia bye daniel -- Daniel Wisser, Mag. ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone:

RE: Curious question about flushing the Pool

Wow, I think that's a brilliant idea. It would be a huge benefit to me, where all of our code is VB, and the developers refuse to use bind variables. My sql area is .5 GB and is 95% garbage. -Original Message- Sent: Thursday, April 25, 2002 9:03 AM To: Multiple recipients of list

Re: Can't Break In and Securing iAS on NT

Sounds like the only way to secure iAS on NT is not to put it on NT. You might try LINUX. It would at least let you use your existing hardware. And, it's free or relatively cheap depending on distro. Rodd On Thu, 2002-04-25 at 07:53, Boivin, Patrice J wrote: I am reading through

Re: Oracle ODBC On Windows95 (Don't ask) :)

Why not use 8i ODBC. I know that 8.1.5 installed on Win95. My guess is that 8.1.7 should too. If it won't use the 8.1.5 drivers. Rodd On Thu, 2002-04-25 at 09:28, Stefan Jakobsson wrote: I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's

DBMS_STATS.gather_database_stats

If you're not supposed to analyze SYS and SYSTEM then can anyone explain why the DBMS_STATS.GATHER_DATABASE_STATS procedure does? We have run into scenarios where the data dictionary becomes almost unusable until SYS gets analyzed again via this procedure. I.e. can't describe v$ views,

RE: 9i new features, the saga continues?

Keep 'em coming Joe! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: 25 April 2002 14:14To: Multiple recipients of list ORACLE-LSubject: 9i new features, the saga continues? Ok life has slowed down some and i've got some

Re: Buffer in Import

I believe that it refers to bytes. --- Ramon E. Estevez [EMAIL PROTECTED] wrote: Does the parameter buffer in the import refers to bytes or number of rows ? Kind of confuse. I think it refers to the number of rows. buffer=5 --- is that 5 bytes, or 5 rows TIA

Re: Cronjob

I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = tomorrow+06:00 - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to

Re: Oracle ODBC On Windows95 (Don't ask) :)

Install the 8.1.7 client on 95. [EMAIL PROTECTED] 04/25/02 10:28AM I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's are running Windows 95 (Old clunkers) Anyone know what I need to do for this? Can I use the 7.3 ODBC drivers written for Windows95

AUDIT_ACTIONS

103 SESSION REC I see entries in one of my AUD$ tables with a ACTION = 103 I'd like to know exactly what this action references. I've searched my 8i online doc set but got no hits. I'm willing to RTFM is somebody will point me at which FM I should use in this case. TIA HAND! -- Charlie

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

1.IOUG Live Sandwiches are made by Oracle you can't break in! UnBreakable, InEdible. Brian -Original Message- Stephen Sent: Thursday, April 25, 2002 9:03 AM To: Multiple recipients of list ORACLE-L n Good morning everyone: Since everyone was wondering what the Top 10

RE: Oracle ODBC On Windows95 (Don't ask) :)

Title: RE: Oracle ODBC On Windows95 (Don't ask) :) Are you just trying to setup an ODBC conenction? In Control Panel, you should see an icon for an ODBC manager where you can add dns entries . You STILL will need to install Oracle client. Use the db alias name for the Service name in the

RE: 9i new features, the saga continues?

Joe, That feature was really useful and interesting. I would be pleased to see you continue it John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack C. Applewhite Sent: 25 April 2002 16:33 To: Multiple recipients of list ORACLE-L

RE: UNIX Courses

Simon, Get hold of a cruddy Intel box. Install Suse 7.0 Linux and Oracle 8.1.7. Configure your environment so that your default shell is sh, bsh, or ksh. Play with it until it breaks. OReilly's Learning Unix, Unix in a Nutshell and Learning the Korn Shell can help with everything you need to

What block size are you using for your new 9i data warehouse?

We are building a new version 9.0.1 data warehouse on Sun Solaris 2.6 migrating to Solaris 2.8. We will be using striped disk that is striped using Veritas Volume Manager on EMC disk. The datawarehouse will be about 200 Gig. It will be written to throughout the day. To this point, almost

RE: Curious question about flushing the Pool

I lost the fight to have the code fixed, and so turned on cursor_sharing. Worked like a charm Been there, done that... but now I feel better knowing that a tenacious goddess of the DBA battlefields also lost this fight. :-) It's a tough fight when embedded SQL is scattered all over the place

RE: 9i new features, the saga continues?

Title: RE: 9i new features, the saga continues? Please refresh me, wasn't this Oracle's answer to Quest's market share? -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of JOE TESTA [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 9:14 AM To: Multiple recipients of

RE: 9i new features, the saga continues?

Go for it Joe!! I've collected them all so far, and am looking foreward to more. Rodd On Thu, 2002-04-25 at 08:33, Jamadagni, Rajendra wrote: Yes, I am *still* interested Joe. Raj __

RE: 9i new features, the saga continues?

I am still interested. Bring it on Cheers Lee -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 25 April 2002 14:14To: Multiple recipients of list ORACLE-LSubject: 9i new features, the saga continues? Ok life has slowed down some and i've got some free

RE: Buffer in Import

Thanks for clarify me. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hately MikeSent: Thursday, 25 April, 2002 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Buffer in Import It's bytes. Regards, Mike Hately

ora-470

Oracle 8.1.7, W2K SP1. This AM instance terminated by PMON due to error 470 detected in background process. List archive showing no matches and MetaLink articles don't seem to match either. Slim entries for problem in PMON and CKPT trace files. Nothing in SMON, LGWR or DBW0. Anyone got any

Re: Cronjob

I wrote a DCL script called crontab that re-submits itself every day. In the script, it checks what day it is and submits those jobs. A lot easier than running multiple submit jobs. I need to change something, I goto the crontab, just like Unix. Gene PS. Each OS has its advantages, still

RE: 9i new features, the saga continues?

All sarcasism aside, I'm interested too : Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: 9i new features, the saga continues?

Yes please, with a cocktail :) JOE TESTA wrote: Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was 9i data guard. joe -- Please see the official ORACLE-L

RE: AUDIT_ACTIONS

Charlie, I believe this may refer to the ORA- error generated by the attempt. Shirley Systems Admin Operations | Admin. et Exploit. des systèms Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région

{9i New Features: DataGuard}

Next installment of 9i new features, like always send hate mail to /dev/null. Also if I've lied in something feel free to correct/flame me for it. The Saga continues: Oracle 9i New Features: 9i Data Guard So you have Oracle 8i standby database, what is new with 9i standby also known as

RE: sql monitor

I have *lots* of experience with them ;P Take a look at SQLExpert: http://www.cool-tools.co.uk/Products/sqlexpert.html It can either monitor the SGA for poorly performing SQL, or can read source/binary/forms type files for bad SQL also.. As well as a wealth of other things - including the best

Clob, toad, and a trigger not working

I've encountered a weird error (no it's not my boss). It's on W2K and happens on 8.1.6 an 9i. I've got two tables with clobs CREATE TABLE CLOB_TEST ( EIDNUMBER, CLOB_TEST CLOB ) ; -- CREATE TABLE CLOB_TEST_AFTER ( EIDNUMBER, CLOB_TEST

RE: DBMS_STATS.gather_database_stats

Walter, this is actually a bug. It's supposedly fixed in 9i though I haven't tried it. Anybody? Do you still see a performance hit when you delete the statistics from the SYS objects? Regards, Mike Hately -Original Message- Sent: 25 April 2002 15:33 To: Multiple recipients of list

Re: 9i new features, the saga continues?

yes please -- of course, you COULD just post your paper from IOUG :) --- JOE TESTA [EMAIL PROTECTED] wrote: Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

You mention a partitioned table. Not an IOT I hope? Because SELECTs can cause deadlocks on an IOT if you partition it in the process (deadlock on DDL, as opposed to DML, locks). I used to have a trigger of death to check it, but I wouldn't recommend it, since you have to delete SYS tables to

RE: {9i New Features: DataGuard}

I have been working on this dataguard on 8I in this u can switch over the production to standby as production and switch back to orignal production by making the switch over production to standby again. The 9i OEM dataguard does not support 8I it only supports 9i so the only option is to

Re: AUDIT_ACTIONS

select * from audit_actions where action=103; shows SESSION REC but not sure what that means Charlie Mengler wrote: 103 SESSION REC I see entries in one of my AUD$ tables with a ACTION = 103 I'd like to know exactly what this action references. I've searched my 8i online doc set but

Re: Curious question about flushing the Pool

It sounds a cute idea at first sight (pardon the mixed metaphor) - but then what do you do about the situation where you deliberately have a handful of versions of the 'same' SQL which are identified by the presence of a literal string; or the SQL that you build with one literal and many binds

Begin backup fails sporadically

Version is 8.0.6.3.0 I have several databases using the exact same set of generic backup scripts. The script that puts all tablespaces into backup mode is generated automatically and done correctly. Same is true for the script which takes all the tablespaces out of backup mode. The problem I

Re: DBMS_STATS.gather_database_stats

My guess would be that they took the code straight from dbms_utility.analyze_database (which does the same awful thing...) hth connor --- Walter K [EMAIL PROTECTED] wrote: If you're not supposed to analyze SYS and SYSTEM then can anyone explain why the DBMS_STATS.GATHER_DATABASE_STATS

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

Can you please give more details on: While testing our nightly load job that runs in two simultaneous streams (ascending and descending). What do you mean by descending and ascending (simultaneous)? Thanks Waleed -Original Message- Sent: Thursday, April 25, 2002 11:19 AM To: Multiple

Re: Oracle ODBC On Windows95 (Don't ask) :)

If the 8.1.7 database is UTF8 character set, that version of ODBC won't work. Install the 8.1.7 client odbc drivers. Stefan Jakobsson wrote: I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's are running Windows 95 (Old clunkers) Anyone

RE: DBMS_STATS.gather_database_stats

I can't answer the question about the performance after deleting the statistics because we have a contract DBA here that insists it's okay to analyze the internal schemas even though he's the one that acknowledges the performance problem if the stats get a little stale! Unfortunately, he

RE: What block size are you using for your new 9i data warehouse?

Cherie: If you are using Oracle 9i, you can use mutliple block sizes! You still create your database with a default block size, but each tablespace (except system) can have a block size different from the default. Valid blocksizes are limited by OS, but they range from 2K to 32k. Check out

RE: Oracle ODBC On Windows95 (Don't ask) :)

There are free drivers from Oracle and Microsoft. They have different behaviors. One will fail, under certain conditions, where the other will not. Use the one that works for you. There is a third party driver that works under all conditions but you have to pay for it. I don't remember the

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

Stephane, No, this is not an IOT table. This is a TX type of lock on insert. Thanks for your reply. Cherie Stephane

Re: UNIX Courses

I suggest you download linux or bsd and play around. On Thu, 25 Apr 2002, Simon Waibale wrote: Hi all, What Unix courses/modules would you recommend for a budding Oracle DBA Thanx, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale

Re: Curious question about flushing the Pool

So have you tried dropping your SGA to 275MB so that the stuff that is useful can be found quicker and latches are held for a shorter time ? Also consider looking at cursor_sharing - it's a band-aid but it can work well in extremis. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of:

RE: AUDIT_ACTIONS

read ?/rdbms/admin/cataudit.sql insert into audit_actions values (102, 'LOGOFF BY CLEANUP'); insert into audit_actions values (103, 'SESSION REC'); insert into audit_actions values (104, 'SYSTEM AUDIT'); Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Charlie

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

that too I found that after I finished eating lunch, there was almost as much in garbage (inedible food) left in the lunch box as there was in food when I opened the box. The potato chips were usually good though :) --- Brian McGraw [EMAIL PROTECTED] wrote: 1. IOUG Live Sandwiches are

RE: {9i New Features: DataGuard}

It even adds the datafile on the standby database for u, only u have set it in the parameter file of the dataguard. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: {9i New

RE: Curious question about flushing the Pool

Some truisms I've found after losing the fight at several different locations: 1) If the programming staff was there before you got there, you will lose every fight 2) If the programming staff was hired after you got there, but has a prior working history with management, you will lose every

RE: Buffer in Import

The buffer size refers to the number of bytes placed into Imports internal buffer. Generally, you should make this value large, like 5 or 10m to accommodate large data imports. Small values increase import time and induce risk for large tables. Thank You Stephen P. Karniotis Product Architect

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

Basically the concurrency level = initrans (so if 2 jobs run - set it to 2), however for indexes set it to conccurency + 1. Anjo. [EMAIL PROTECTED] wrote: We are testing an upgrade of our warehouse from 8.0.4 to 8.1.7.2. While testing our nightly load job that runs in two simultaneous

RE: Buffer in Import

Title: RE: Buffer in Import Ramon, Bytes. IMHO, 5 is way to low if you have a lot of data to import. Try doubling it at least. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Ramon E. Estevez [SMTP:[EMAIL

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

My guess there is no triggers or referential constraints since it's a Data Warehouse. More details will help, Regards Waleed -Original Message- Sent: Thursday, April 25, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Is it a TX mode 4 (Share) deadlock ? Can you post a

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

Is it a TX mode 4 (Share) deadlock ? Can you post a section of the deadlock graph from the trace file. If you really have only two streams running, then you need only set initrans to 2 at a cost of (typically) 24 bytes per block to guarantee that the problem goes away. There are several other

RE: Cronjob

Ahmadsyah, If I remember correctly (my Vax is a couple of years old), we set up two jobs to accomplish this. One job ran every day. All this job did was to start the real job schedule job. the job schedule job interrogated what day of the week it was and ran other jobs. For example, if today

RE: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

Waleed, There used to be a single process that loaded the data. It ran too long and the application owners split the job out into two process. One started at one end and loaded data in ascending order and the other started at the other end and loaded in descending order. Both jobs run at

Re: No Rows Deadlock and PCTFREE, INITRANS on 8.1.7.2

Jonathan, Following is section of the trace file generated. It is a TX lock. I'm not sure whether it is mode 4. How can I tell? We upgraded using the migration script, not export/import. During the nightly loads we have always dropped the indexes on the foreign keys on this large fact

Re: DBMS_STATS.gather_database_stats

It's a long time since I checked but once upon a time the main reason why you weren't supposed to analyze the sys schema was that an analyze could require temporary space, which would require updates to fet$, uet$ and seg$ - which might be the tables that were causing the demand for space.

  1   2   >