Configuring Kernel in Unix for install BD

Friends: How can I do for to configure the parameters os kernerl in unix ? How to calculate the values for this parameters ? Regards Eriovaldo --- UOL, o melhor da Internet http://www.uol.com.br/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ecandrietta INET:

RE: AIX vs Solaris

the Solaris Admintool seems to have very little functionality(create users and not much else). With SMIT on AIX you can do much, much more. Does anyone use any other party tools for easier Solaris syatems admin? John In comparison, I've always been less than impressed with Sun's Admintool,

RE: RE: Too many db calls: Follow up question

My preference is simply to have enough rollback, but you can have you cake and eat it too to some degree with some code like: cursor c is ... open c loop begin for i in 1 .. 1 loop fetch do stuff end loop commit exception when -1555 then close c; open c;

RE: RE: Too many db calls

Cary, Not that I'm advocating improper SQL (like 'select ... from dual') but I thought pl/sql held its cursors open anyway (by default). Cheers Connor --- Cary Millsap [EMAIL PROTECTED] wrote: Dick, I think you've misunderstood me. I'm not advocating the case for doing joins in the

use_async_io parameter

Is the use_aync_io = TRUE parameter now defunct? or do I still need it to use asynchronous IO on AIX. Platform is AIX 4.3.3 and Oracle 8.1.7 John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET:

RE: Cognos Reporting Tool

Make sure that damagement designates a power user to learn Cognos very well. It can really drain your database performance if the cubes are poorly designed and the users start running queries from hell. Hopefully they will give you a reporting server for Cognos to run against. Overall it is

Re: move USERS tablespace to locally managed

Thanks for a clear and illuminating article; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 7:08 PM One thing my article did not cover was of course the possibility that you end with up with a

Restricting connections thru Net8 Security

Hi All, I'm on 8.0.6 so LOGON TRIGGERs are ruled out. But I want the DB connections from only a set of machines, and none other. Can I implement some security by restricting DB connections to the database from only a specific set of machines? I want the listener to accept connection from X, Y, Z

Re: Cognos Reporting Tool

Rodd, We have used Impromptu and Powerplay with good success since 1995. There are 2 flavors of Impromptu (Administrative and User). The administrative version allows for the creation of an Impromptu catalog. The catalog defines the database (Oracle, DB2...), connect string, tables, and join

RE: Cognos Reporting Tool

Rodd, Insist on a creating a reporting database - apart from the OLTP system. Cognos does not report from an OLTP system very well. If you cannot create a separate instance, be prepared to create summary tables (summarized views). It will make your life, and the Cognos report-writers lives much

Re: Configuring Kernel in Unix for install BD

What's your machine(sun, ibm, hp...)? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 6:48 AM Friends: How can I do for to configure the parameters os kernerl in unix ? How to calculate the values for this parameters

Enabling export transportable tablespaces

Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to development system. I was unable to use transprtable tablespace feature. When i executed the EXP transport_tablespaces=y tablespaces= users file=tts.dmp the output will be

Re: How to make ORACLE Developer 6i understand ORACLE 8i client?

The developer 6i should have the net8 to install so you can connect to 8.0.5 Rick dist cash

RE: RE: Too many db calls: Follow up question

Thats what we've been doing...thanks for the sanity check. -Original Message- McDonald Sent: Tuesday, November 19, 2002 4:12 AM To: Multiple recipients of list ORACLE-L My preference is simply to have enough rollback, but you can have you cake and eat it too to some degree with some

Re: sys.aud$ - auditing user activities? - follow up

...um, if you say so. That really didn't answer my question, though... I hope that your solution did not include assigning users SYSDBA privileges in order to merely track/audit them? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November

RE: Query to predict failure on second extent of segment

Yes, again, that's a nice script, but it only addresses single extent failure. Maybe I'm just barking up the wrong tree. Screw it. I'll just convert to LMT and be done with it. :) Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

Dist - Since nobody seems to have responded, I'll take a crack at it. The Oracle9i documentation specifically says (in the Oracle9i Database Reference) that either FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL will override FAST_START_MTTR_TARGET. I would tend to believe them. In the

Re: Cognos Reporting Tool

They make several products. We use Impromptu (reporting tool) to feed PowerPlay (OLAP tool). When we did the analysis several years ago, we chose PowerPlay. Building cubes was much easier with PowerPlay than with Oracle Express. Although Express probably scales better. We use PowerPlay to

Re: Netbackup [#2]

Sean Sorry for the wrong reply. You asked about NetBackup and I replied about BackupExec. We did NetBackup restore to another computer and it worked ok without problems. We DID built the directory structure beforehand so I do not know if he builds it himself when needed. Naveen - There is an

RE: Enabling export transportable tablespaces

Banarasi Are you using the Standard Edition of 8i, if so then tts is not available. You need the Enterprise edition HTH John -Original Message- Sent: 19 November 2002 13:18 To: Multiple recipients of list ORACLE-L Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0

Re: use_async_io parameter

just that name is defunct -- in 8i it became disk_asynch_io... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 3:04 AM Is the use_aync_io = TRUE parameter now defunct? or do I still need it to use asynchronous IO on

RE: how to download all the openworld documents?

Does anyone have a copy of Locking down your OAS by Aaron Newman? It is not posted to the open world docs page yet. Thanks Ben [EMAIL PROTECTED] -Original Message- WILLIAMS Sent: November 18, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Well, for myself, I'm glad to have ANY

db file sequential read

I'm search of perfection in an imperfect world. This problem involves a V7.3.4.5 DB on V2.6 Solaris. As part of our nightwork batch processing, a bunch of reports are run against the DB. I have a DBMS_JOB which reports when processes are waiting for events like db file sequential read. I

RE: Updated Question (sorry for the spam)

Not until 9i. I hope I can at least take partial credit for that, as I requested that functionality in a TAR when we were at 8.0. :) HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

RE: AIX vs Solaris

The administration of Solaris has always been much more straightforward than with AIX. AIX maintains this internal database (sort of) about how things are set up, so it doesn't take kindly to you doing stuff by hand. AIX has command-line commands (???) to do things, but they are usually very

RE: RE: Too many db calls: Follow up question

Jonas, The one thing to keep in mind is that a commit-loop can actually cause more problems than it solves, based upon your scenario. If nobody is performing transactions, you could run out of rollback segment space. Why? Because an rbs will be shrunk by the 2nd transaction that finds it

RE: Cognos Reporting Tool

We also have been using Impromptu for years (probably around 1994 or so). We really like it, have dozens of users using it. Even run our own little Impromptu Users Group meetings to share infromation. It's great to have end users more indpendant. We are still using the Client-server version. Have

RE: Enabling export transportable tablespaces

Babu - Two ideas for you. What is your COMPATIBLE parameter set? Enter the command show parameter compatible. Next, look in v$option with select value from v$option where parameter = 'Export transportable tablespaces'; Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: Enabling export transportable tablespaces

Are you on Standard Edition or Enterprise Edition? I guess this feature is not available in Standard Edition. You can check it by logging in to SQL*PLUS and it will show the header like this SQL*Plus: Release 8.0.4.0.0 - Production on Tue Nov 19 20:2:16 2002 (c) Copyright 1997 Oracle

RE: Hint-O-The-Day: MetaLink index pages search

Rich - Thanks for sharing the tip! Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 18, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Hey all, Just a helpful Hint-O-The-Day for quick searching of MetaLink. I'm sick of

ORA-6502 with cursor and MAX function

OK, severe brain fart here. On 8.1.7.4, the following fails: declare v_wowip.workorderno%TYPE; cursor c1 is select max(workorderno) wok from wip where assypartno = '33626'; begin for aa in c1 loop v_wo :=

Re: Cognos Reporting Tool

I've worked with it and used the tool. It is a very powerful tool; however, it is not easy to use at all. There is a steep learning curve. Their dog-and-pony show will gloss over the fact that only specialists can use it. It is not a tool for the general end user.

Re: Cognos Reporting Tool

I worked with Cognos a few years ago on the HP3000 system. They were good products, pricey put very good. Ruth - Original Message - From: Rodd Holman To: Multiple recipients of list ORACLE-L Sent: Monday, November 18, 2002 2:46 PM Subject: Cognos Reporting

UKOUG Conference

Anyone going to he UKOUG conference and exhibition Dec. 9 - 11? Anyone been to previous ones who can vouch for the value of the conference? Anyone know if they are looking for more speakers? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ:

Re: Restricting connections thru Net8 Security

look into the protocol.ora parameters. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=1006500.6 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 6:13 AM Hi All, I'm on 8.0.6

RE: ORA-6502 with cursor and MAX function

Title: RE: ORA-6502 with cursor and MAX function so it is a number inside a char(12) ... try ... max(to_number()) and see if it works Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed

RE: RE: New development in Cobol or PL/SQL - please help

Dick, others - Question for you. Consider that a company's custom-written software is one of its largest hidden investments. To do it successfully, a company must not only invest a lot of programmer time, but time and effort from people all over the organization to dig in an really understand the

Oracle's File Mapping

Title: Oracle's File Mapping Hi! Did anybody out there attend the Open World presentation Optimize Performance with Oracle's File Mapping Feature? Could you please shed some light on this? Is this an Oracle optional product? Or is it a Veritas product? Thanks, Helmut

RE: Restricting connections thru Net8 Security

Try doing a search in Metalink for protocol.ora. Not sure if it can be done for every platform. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch

Reserving memory

[Saga Start] Recently on one of our production servers (W2K) the Oracle.Exe was consuming 99%-100% CPU and users were unable to create new sessions, getting ORA-12500 error. Even via server console we could not get a SQL*Plus or SVRMGR connection. Tried to shutdown DB using ORADIM but that

Re: Enabling export transportable tablespaces

you need to buy this feature - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 5:18 AM Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to

RE: ORA-6502 with cursor and MAX function

As an update, this DOES work if v_wo is defined as VARCHAR2(4000). And a DBMS_OUTPUT.PUT_LINE(LENGTH(v_wo)) shows 4000. I'm still a bit confused as to why it's casting to a length of 4000... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

Dist - Since nobody seems to have responded I take offence at that =) Obviously not everyone got my reply. Or I'm on you spam list Dennis. Cheers, Mike -Original Message- Sent: 19 November 2002 13:59 To: Multiple recipients of list ORACLE-L log_checkpoint_inte Dist - Since

RE: how to download all the openworld documents?

But if you come to IOUG Live, you GET a CD. So forget OW and come to Live!! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday,

moving from dedicated connections to MTS

Hello all First a little background. We work with oracle 8.1.6.3.4 on NT or win2000 servers. The technical people have just move an application server behind a firewall. The application servers access a database that is a central repository of user connections (i.e. all applications on the

RE: ORA-6502 with cursor and MAX function

Even i get the same error on 8.0.6. Sorry 9i not available. Regards Naveen -Original Message- Sent: Tuesday, November 19, 2002 8:59 PM To: Multiple recipients of list ORACLE-L OK, severe brain fart here. On 8.1.7.4, the following fails: declare v_wowip.workorderno%TYPE;

Re: How to make ORACLE Developer 6i understand ORACLE 8i client?

yes, I understand. Bur what I want is Developer6i connect through 8i or 9i client. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: How to make ORACLE Developer 6i understand ORACLE 8i client? Date: Tue, 19 Nov 2002

RE: UKOUG Conference

Jeremiah, I know that there are several folks from the list that will be presenting. I have heard very good things about the conference from others who have attended in the past. They have posted their schedule on the website (www.ukoug2002.org) and it looks impressive. Time is

RE: moving from dedicated connections to MTS

Yechiel - This is an inexperienced reply, but since I will be facing your situation soon, I thought I would share my ideas also. 1. Most application servers can do connection pooling, so why use MTS as a second layer on top of connection pooling? 2. I believe Oracle uses a range of ports, so

Killing vs. disconnecting session.

Steve, Cary, Anjo can you explain me the difference between killing and disconnecting a session with an immediate option? I know that session's resources must be released, that rollback must be done and lock have to be released and that is all done by PMON. Why is the cleanup much faster

RE: UKOUG Conference

I will be presenting at the conference (Oracle9i New Features and RMAN Mission Possible). I was there last year and found it a pretty good experience. The sessions had good technical content. They have already selected speakers, but I can put you in contact with the people running the event, and

RE: AIX vs Solaris

There is an excellent tool called vi. -Original Message- From: John Dunn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 4:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: AIX vs Solaris the Solaris Admintool seems to have very little

RE: moving from dedicated connections to MTS

Doc: 125021.1 talks about firewalls. Look for USE_SHARED_SOCKET to keep the dedicated connections. -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: moving from dedicated

RE: db file sequential read

Charlie, First task I'd suggest is to make sure your world isn't being complicated by an imperfect report. If you mean that a single wait for db file sequential read (or db file scattered read, which is probably really what you're seeing because you mentioned reads of an index) consumes from 3 to

Standards: Semicolon or Backslash

Hi all, We're having a discussion over SQL scripting standards. We're trying to decide on best practice for ending a SQL statement. OPTION (A) - BACKSLASH -- BEGIN EXECUTE PL_SQL_BLOCK; END; / UPDATE TABLE SET COLUMN = VALUE / OPTION (B) - SEMICOLON

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

Sorry Mike. I was going from memory. I'm sure your reply was better than mine, not hard to do. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 19, 2002 9:54 AM To: Multiple recipients of list ORACLE-L log_checkpoint_inte Dist -

Transactions not getting commited :-(

Hello All, 8.0.6.2.0 Parallel Server on Solaris 2.6 nodes. We have intermittent outages, once every 2 days, here on a production database. What happens is that all DML transactions dont get committed or rolled back, and start filling up the transaction slots in the rollback segments. On a normal

Win2k/8.1.7.3/Optimizer Weirdness

Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL SQL select file_name from dba_temp_files; File Name - E:\ORANT\ORADATA\ECRMP\TEMP01.DBF 1 row selected. SQL select /*+ RULE */

Tivoli and RMAN

Hello all, just finished reading the chapter on RMAN/Tivoli and a .pdf on installation. It appears NO environment variables are read when using tivoli that all "enviroment stuff" has to be put in the tdpo.opt file. so all of the scripts that we wrote that uses enviroment variables will

RE: ORA-6502 with cursor and MAX function

Ran this example in 9.2.1.0 and it worked fine. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you.  

RE: Oracle's File Mapping

THis is a new feature in the 9iR2 database (I don't recall it being in 9iR1). It uses vendor supplied libraries to provide physical disk information within the database. I have not really played with it yet (I was just reading about it a couple of weeks ago) but it sounds interesting. There is

RE: Hint-O-The-Day: MetaLink index pages search

No probs. Also, don't forget to change Hits in Hitlist to 200, since there are currently 135 articles that match! And yes, a way to store these as a default would be nice. Maybe in the next MetaLink... :) Rich Rich Jesse System/Database Administrator [EMAIL

RE: Win2k/8.1.7.3/Optimizer Weirdness

I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL

Re: Win2k/8.1.7.3/Optimizer Weirdness

Same happens under 9.2. But, select /*+ RULE */ name from v$tempfile; works fine. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 1:16 PM Hi Listers: Has anyone ever seen

opinions on SAN devices for Oracle

Hi All, We are considering the following 3 SAN storage devices. If anyone can share any info on any I would appreciate it. They all have 2gig fibre channel. Hitachi 9200 EMC CX400 HP EVA 2c2d Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

Re: Tivoli and RMAN

Joe, My understanding is as follows. The environment variables that Tivoli is referring to are TSM variables such as DSMO_NODE (which is now TDPO_NODE) and DSMI_ORC_CONFIG. These are environment variables that TDP recognizes and uses. The environment variables you are referring to are used by

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

Just to add: The MTTR parameter overides the Log_checkpoint_interval and the ...timeout parameter. Oracle sets these log_checkpoint parameters dynamically when the MTTR parameter is set. Gillian DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Dist -Since nobody seems to have responded, I'll take a crack

HIT RATIO

Hi One of my database showing hit ratio low (=75% approx).I increased the parameters.After last reboot hit ratio was looking great.Last reboot was last week.I am wondering again this ratio is 73% approx. How to fix this problem except Init.ora prameter change? Thx -Seema

RE: Win2k/8.1.7.3/Optimizer Weirdness

I forgot to mention - there are no statistics on any SYS or SYSTEM objects - per the FMs. Anybody know why this happens? -Original Message- Sent: Tuesday, November 19, 2002 10:50 AM To: Multiple recipients of list ORACLE-L I was able to duplicate this on my 9.0.1.1.1 database running

Re: Win2k/8.1.7.3/Optimizer Weirdness

Same thing in 9.2.0.2 on linux Clark, Tommy R wrote: I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this

RE: Win2k/8.1.7.3/Optimizer Weirdness

This is 9.2 and Solaris: SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 19 14:16:21 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect rman817 as sysdba Enter password: Connected. SQL SQL SQL select /*+ RULE */ file_name from dba_temp_files; no rows

RE: HIT RATIO

Set up a dbms_job to run the command select 'x' from dual; every 10 seconds or so. I think you'll find that your hit ratio increases quite nicely. Oh, the only potential downside is that your overall system performance might go down, way down! But your ratios are great! It is kind of like taking

RE: UKOUG Conference

Oh Stephen... we have a request here! --- Fink, Dan [EMAIL PROTECTED] wrote: Jeremiah, I know that there are several folks from the list that will be presenting. I have heard very good things about the conference from others who have attended in the past. They have posted their

RE: Win2k/8.1.7.3/Optimizer Weirdness

Title: RE: Win2k/8.1.7.3/Optimizer Weirdness 9.2 on AIX ... same problem ... Wait they must have fixed it in 10i Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and

Partitioning

We have a table with around 80 million rows. The table has been partitioned by hash as there is no clear way of partitioning depending on range etc.. The data is very unevenly distributed in these partitions. Some of them even have 3 times the number of rows as compared to the other partitions.

RE: ORA-6502 with cursor and MAX function

One way to get it to work is to select MAX(RTRIM(workorderno)) instead. Why does this work??? I R'd TFM and it says nothing about MAX (not)working on any particular datatype. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...

Title: RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...) an Thank you for your answer. Your answer would solve my problem, except for the fact that i want a general purpose solution that would work in any table. What if the three columns in the table were varchar2?

RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...

Title: RE: SQL puzzle - using where (a, b, c) in select (a, b, c from... Thank you for your answer. This is not an answer to the problem as stated in the original description. Your statement deleted duplicate rows in widgets_copy even if they were NOT present in widgets. -Original

RE: Win2k/8.1.7.3/Optimizer Weirdness

Title: RE: Win2k/8.1.7.3/Optimizer Weirdness Here are the different explain plans. This is on an 8.1.7.0 db on Solaris.One idea isthe problem could be on the merge-join. I've heard of some problems with this operation. SQL select file_name from dba_temp_files;

Speaking of OTN

I'm trying to download from otn and I keep ending up at http://otn.oracle.com/software/htdocs/updatelink.html with

Re: Partitioning

Is there a single column/value that you could do LIST partitioning on instead of range or hash? Rick Rishi.Jain@VerizonWi

RE: Partitioning

Rishi, The algorithm for has partitioning in Oracle requires you to choose your partition count as a power of 2 (i.e. 2, 4, 8, 16, 32 partitions, etc) any other number will be unbalanced as you've seen. Cheers, Pete -- Peter Moore Systems DBA, Mid-Range Centre of Expertise, Global Service

TEMP segments

I just found a new command that creates TEMP segments. It is well known that index creations first create the index segments as TEMP segments then 'convert' them to index segments upon completion. What I just found out (thanks to a failed operation) is that 'CREATE TABLE AS SELECT' (ctas)

Re: HIT RATIO

Why do care about this? Are people complaining? Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 8:04 PM Hi One of my database showing hit ratio low (=75% approx).I increased the parameters.After last reboot

Oracle-L at UKOUG

Anyone interested in an Oracle-L get together at UKOUG for those of us poor souls who were not able to attend Oracle World? OW attendees welcome also! Dan Fink

RE: ORA-6502 with cursor and MAX function

Rich, What is the description of the field workorderno? The error says that your buffer string area is to small. It couls be that the returned number is super long and overflows the buffer. It works okay if the buffer is set to 4000? correct? Ron [EMAIL PROTECTED] 11/19/02 02:53PM One way to

RE: Win2k/8.1.7.3/Optimizer Weirdness

Title: RE: Win2k/8.1.7.3/Optimizer Weirdness It is very hard to believe that there is a big problem with merge join as it is the oldest join method, next to the nested loops. Hash join and star schema are much newer. I remember merge joins at least from version 5. Merge join was

Re: Partitioning

[EMAIL PROTECTED] wrote: We have a table with around 80 million rows. The table has been partitioned by hash as there is no clear way of partitioning depending on range etc.. The data is very unevenly distributed in these partitions. Some of them even have 3 times the number of rows as

converting to the cost based optimizer

I am just starting to look at converting to the cost based optimizer, and am hoping a few of you can share insights from having done so in the past. Our application is an oltp system developed on 7.3.4. We made liberal use of +0 and other RBO hints, and I am wondering if these are going to

RE: HIT RATIO

What problem? Seriously, the buffer cache hit ratio is a pretty meaningless value (for details on why, see Cary Millsap's papers on www.hotsos.com). Are your users complaining? Are you seeing behavior on the system (disk contention, etc.) that makes you expect that your users will be complaining

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

Gillian - But the documentation clearly says just the opposite. It says that if you set the LOG_CHECKPOINT_INTERVAL parameter, then that is what is used, rather than FAST_START_MTTR_TARGET. So I don't see how you can say that FAST_START_MTTR_TARGET overrides the LOG_CHECKPOINT_INTERVAL. Am I

Re: Partitioning

You can do the same thing in Oracle as you did in Informix. Create range partitions for 0-9 and use your mod 10 on the key. I believe you will have to add a column in the table to hold the mod number and make that the partitioning column. HTH, John [EMAIL PROTECTED] 11/19/02 11:38AM We

Re: converting to the cost based optimizer

We will be in the same process soon. We'll have to consolidate over 100 instances to something between 40-60 instances and switch from RBO to CBO. Any tips are welcome. --- Steve McClure [EMAIL PROTECTED] a écrit : I am just starting to look at converting to the cost based optimizer, and am

Re: Oracle-L at UKOUG

Fink, Dan wrote: Anyone interested in an Oracle-L get together at UKOUG for those of us poor souls who were not able to attend Oracle World? OW attendees welcome also! Dan Fink I am. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ:

Re: Partitioning

Rishi, In hash partitioning you have to select the number of partitions equal to the power of 2. i.e. 2,4,8,16 so on. Your problem of skewed partition size is well documented in hash partitioning if you don't choose correct number of partitions. Please refer to JLewis Book. He deals with this very

RE: converting to the cost based optimizer

Steve and Stepane, Take a look at Tim Gorman's 'Search for Intelligent life in the CBO' paper in the library section at http://www.evdbt.com', as well as some of my insights into the CBO (and the traps/pitfalls along the path from RBO to CBO) at 'http://www.geocities.com/john_sharmila/links.htm'

Performance of implicit cursors vs anonymous blocks

Hey all, Thanks for the input on the MAX problem. The idea of the statement itself was to help determine if it was better for us to have a SELECT...INTO statement in an implicit FOR..LOOP cursor or to just surround the SELECT statement with an anonymous block to check for NO_DATA_FOUND. From

RE: converting to the cost based optimizer

I've got 9.2 loaded up on my laptop, have for some time. I've been playing around with base trace files (haven't done that in a while) and discovered something interesting. I found within the trace file the actual execution plan for the SQL statement being run. Now, I don't mean the TKPROF output

Execution Plans in trace files??

Sorry for the double post all, someday I'll learn to get my subject lines right!! I've got 9.2 loaded up on my laptop, have for some time. I've been playing around with base trace files (haven't done that in a while) and discovered something interesting. I found within the trace file the actual

ASO Checksumming Parameters

I'm looking at configuring ASO. I have sqlnet.ora file on both the client and the server which looks like trace_level_client=16 sqlnet.encryption_server=accepted sqlnet.encryption_client=requested sqlnet.encryption_types_server=(RC4_40) sqlnet.encryption_types_client=(RC4_40) sqlnet.crypto_seed

  1   2   >