Re: Oracle Migration 7.3.4.5 to 8.1.6.3

2002-03-07 Thread hemantchitale
Why 8.1.6.3 ? Go to 8.1.7.2 or 8.1.7.3. 8.1.6 has been desupported. What is the OS version ? Solaris 2.5.1 ? 32-bit 8.1.7 is certified on 2.6 and above. 64-bit 8.1.7 is on Solaris 8 (2.8) of course. That you have a Cluster -- is it OPS or single-instance database which fails over to the

RE: QUERY OPTION in export

2002-03-07 Thread
Your date format should match the tns_date_format in the machine that the export is run. Maybe you could use also to_date(). Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 07, 2002 2:24 AM To:

RE: Oracle Migration 7.3.4.5 to 8.1.6.3

2002-03-07 Thread
Hello Mark We did conversion from 7.3.4 to 8.1.6 with no problems on NT, with smaller DB's. Since the upgrade is mostly updates to the data dictionary I do not think that the size of the data matters. TAKE COLD BACKUP before the conversion. Yechiel Adar, Mehish Computer Services [EMAIL

How to use dbms_stats.

2002-03-07 Thread ayyappan . subramaniyan
Hi I want to know how to how to use dbms_stats. package and get the statistics This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended

Re: How to use dbms_stats.

2002-03-07 Thread Marin Dimitrov
- Original Message - From: [EMAIL PROTECTED] I want to know how to how to use dbms_stats. package and get the statistics short answer: begin dbms_stats.gather_schema_stats(ownname = '',cascade=true); end; for a detailed explanation take a look at

Re: Oracle Migration 7.3.4.5 to 8.1.6.3

2002-03-07 Thread Mark Cilia
Hi We have to go to 8.1.6.3 'cause we're using a case tool be CA (Computer Associates) and that's the Oracle version they support. In our cluster environment, we're not using OPS but a single instance which fails over a second node. Our first ideas (which are not acceptable) were import/export

help on the operator

2002-03-07 Thread Shishir
Hi Gurus! if any function which returns the collection type , to show that collection object in tabular format we use "the" operator with dual table which has one row and one column like followings: select * from the (select cast( function name l(parameters ) as return obeject type ) from

RE: Linux for Big(ish) Databases

2002-03-07 Thread James Morle
Bill, In general terms, I would say that it is certainly suitable. That answer is based upon the information you provide below. The real answer could only be ascertained by evaluating other requirements: A) Availability B) Scalability C) 'Cost' of each user - what do the transactions look like

list wrapped PL/SQL

2002-03-07 Thread John Dunn
Is there a query I can run to find out which PL/SQL packages are wrapped and which are not? Oracle 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: list wrapped PL/SQL

2002-03-07 Thread G . Plivna
It isn't an elegant solution but You can just look into source Something like SELECT owner ,type ,name FROM all_source WHERE line = 1 AND upper(text) like '%WRAPPED%' ORDER BY owner ,type ,name; Gints Plivna IT Sistçmas, Meríeïa 13,

Re: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Rachel Carmichael
and this one doesn't really conflict with anything I want to see. gotta get there early to get a seat in the front row so I can heckle better :) --- Joe Testa [EMAIL PROTECTED] wrote: yeppers i'll be there and (he crosses his fingers) if all goes well in our testing(Susan and I) for the

RE: Riddle me this Oracle riddle...

2002-03-07 Thread Freeman, Robert
Interesting, I wonder if this is 4000 bytes then for 9i and the manual was not updated? I will ask about this. So, this implies that my original answer would be b or c (depending on 9i behavior). This is what I understood Oracle to be telling me. RF Robert G. Freeman - Oracle8i OCP Oracle DBA

RE: where is tkprof?

2002-03-07 Thread Rachel Carmichael
patch set number? --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Jonathan, Some intelligent person at MD forgot to add the tkprof (Trace Kernel PROFile) with the NT versions. OWS has a patch for that. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message-

RE: IOUG : Was: PocketDBA

2002-03-07 Thread Adams, Matthew (GEA, 088130)
Title: RE: IOUG : Was: PocketDBA I'll be there (and presenting) again. Matt Adams - GE Appliances - [EMAIL PROTECTED] Another month has ended. All goals met All customers satisfied All staff ready and enthusiastic All pigs fed and ready to fly -Original Message- From: John

RE: IOUG : Was: PocketDBA

2002-03-07 Thread Freeman, Robert
I will be at IOUG-A. Will be presenting Oracle Urban Legends on Tuesday afternoon. I'd love to meet any of you folks that will be there. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a

Re: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Rachel Carmichael
I see a list get-together forming.. --- Stephane Faroult [EMAIL PROTECTED] wrote: John Kanagaraj wrote: Hi Ari, I'll be at IOUG (and NYOUG and others) so please stop by to say hello. I now have a reputation for buying beer too, but I love meeting new people and

RE: Riddle me this Oracle riddle...

2002-03-07 Thread Freeman, Robert
Thanks for finding this I had searched high and low and somehow missed this reference. This doesn't quite jive with what Oracle has told me, so I'm following up for more detail from them. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The

RE: RECOVERY PROBLEM

2002-03-07 Thread Greg Faktor
Thanks All for help! I did not switch logfile after end backup statment. Now everything working. Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Karniotis, Stephen
OK. Everyone. My 2 cents now. I am the Focus Area Manager for the DBA Track at IOUG-A Live. Please encourage damangement (Gaja Terminology) to facilitate your attendance at this great event. Please remember that if you are a member of a local or regional user group, you receive a significant

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Deshpande, Kirti
How about a seat near the power outlets ?? Then, it will be a fun experiment for Joe Susan ;) I will be doing my first ever presentation at IOUG-A.. Just a Quick Tips (Q31) - Wait Events in a Nutshell.. (bring your lunch with you, if they allow it :) All Quick Tips Sessions are during lunch

RE: Hundreds of schemas in one instance?

2002-03-07 Thread Ben Poels
Hi The assumption is that every user of this system will have totally unique requirements. There will be no data sharing and no commonality of purpose. As far as alternatives I am not even thinking about multiple instances. Other alternatives include - many schemas and one tablespace, or many

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Freeman, Robert
Hello Rachel, I can't imagine IOUG-A without Marlene. Like Milk without cookies snow without cold RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take

row level lock

2002-03-07 Thread Shishir
HI list! I want to lock a table on row level ( not table level). how do we pass the pass that value in syntax which will lock only those rows. plz make me understand by giving an example. thanx in advance.. Shishir Kumar MishraAgni Software (P) Ltd.,Bangalore-560055, Indiawww.agnisoft.com

Oracle Names Server

2002-03-07 Thread Jack van Zanen
Hi All, I'm testing and planning implemetation of oracle names and would like some advice/pointers/gotcha's to put into my plan for damagement. Main reason: Ease of maintenance (We now have tnsnames file all over the place) Planned setup: Two names servers both in physically seperated

Names Server

2002-03-07 Thread Jack van Zanen
Hi All, From my names.log file I have the following error (?) Where does it come from (Where did I mess up my configuration) NNO-00807: Error: OCI_NO_DATA NNO-00267: warning: configuration database contains no data for server [root] NNO-00315:

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Freeman, Robert
Gotta go see that!! Live demo's. always fun! Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent:

DSD

2002-03-07 Thread Michael Cupp
Title: Message I'm looking for a solution to attach to a database and create a visual representation of the tables, columns and foreign keys. I'd prefer something that's free or try to buy - anyone have any suggestions? (I tried something from download.com called O-Schema, but it locks up

RE: Hundreds of schemas in one instance?

2002-03-07 Thread Baker, Barbara
Jonathan: Not at all related, but I could not help but think of my favorite recommendation from Metalink. As a workaround to a problem: Workaround ~~ The best workaround is to prevent your database from getting into this state where it cannot be opened.

Re[2]: Now: IOUG : Was: PocketDBA

2002-03-07 Thread dgoulet
Joe, You sly dog you! We've been trying to talk our manufacturing folks into using a standby database as a fault tolerant solution. Of course like always around here they want a proof of concept I was a little baffles at how to do it. Your presentation environment popped on the light

RE: Hundreds of schemas in one instance?

2002-03-07 Thread Smith, Ron L.
We use Netbackup along with an STK 9710. The reason I mention this is that with applications that have many tablespaces such as Oracle Financials the backups take much longer regardless of the total size of the database. Each datafile is considered a separate backup and takes a couple of

TWO Task error

2002-03-07 Thread Smith, Ron L.
I am trying to connect from my 7.3.3 SQL*NET desktop to a new 8.1.7 database on Unix. I am getting an ORA-03106 TWO TASK error. I can connect to any of our 8.1.6 servers. Why is 8.1.7 different? Did I set up something wrong? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

unable to apply patch

2002-03-07 Thread Harvinder Singh
HI, When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1 oracle we got error: There are no patches that need to be applied from patch set Oracle9i Patch set 9.0.1.2.0. Earlier we are able to apply the same patch on other machine. What might be the possible reason for this error? Thanks

Re: RMAN Configuration Question

2002-03-07 Thread Ruth Gramolini
I use one catalog for all my databases. You have to have a catalog in a separate database if you are going to backup the catalog database using rman but that is the only time I have ever heard of using more than one catalog. I must say, most of the Oracle support analysts, at least, don't

Displaying V$SYSSTAT row values in columns... any better way?

2002-03-07 Thread Orr, Steve
I want to display V$SYSSTAT row values in columns. The current query: - select to_char(trunc(86400*(sysdate-to_date( '01/01/70','mm/dd/rr hh24:mi:ss', 'stat38:stat39:stat40:stat41:stat44:stat105:'||

RE: row level lock

2002-03-07 Thread Ramon E. Estevez
Shishir, When you make the select statement at the end add the clause FOR UPDATE SELECT FIELD1, FIELD2 FROM TABLE WHERE FIELD1 = 40 FOR UPDATE Luck, -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ShishirSent: Thursday, 07 March, 2002

RMAN Catalog Configuration

2002-03-07 Thread Pat Howe
I asked the LIST to respond to the PROs and CONs of different RMAN catalog configuration options - Below is the summary of the discussion. By getting a good picture of the different configuration options and what their PRO's and CON's are - I will be able to choose the best setup for my

Re: MTS on 8.1.7.5

2002-03-07 Thread Suzy Vordos
It works great unless client connections use JDBC thin. There is a bug that causes them to appear hung due to unacceptable SLOOO response. Supposedly the bug was fixed in 8.1.5.2 8.1.6.3, but we still experienced problems as of 8.1.7.0. Haven't tested this under 8.1.7.2 or 8.1.7.3.

Restrictng tables during export/import

2002-03-07 Thread Harvinder Singh
We are testing Fine-Grained Access Control to export the complete schema excluding some tables. This works well for export but during import it try to import all tables. Is there any way we can restrict import of some tables using Fine-Grained Access Control .We are using function as specified

Re: DSD

2002-03-07 Thread Jan Pruner
I'm using CASEstudio. http://www.casestudio.com/rksoft/download/rkscase2.zip Cool soft, but it runs only on windows :-( JP On Thu 7. March 2002 16:03, you wrote: I'm looking for a solution to attach to a database and create a visual representation of the tables, columns and foreign keys.

DSD

2002-03-07 Thread Michael Cupp
Title: Message Sent 2 hrs ago - didn't get it yet, resending. I'm looking for a solution to attach to a database and create a visual representation of the tables, columns and foreign keys. I'd prefer something that's free or try to buy - anyone have any suggestions? (I tried something from

Re: Service Names

2002-03-07 Thread Suzy Vordos
Does your tnsnames.ora have SID or SERVICE_NAME for CONNECT_DATA? It should be SERVICE_NAME. Peter Barnett wrote: We are attempting to install SQLNet in a failover configuration. The environment consists of two AIX servers with version 4.3.3 OS, Oracle 8.1.7.2 on both servers. These

A rollback segment question on minextents

2002-03-07 Thread kumanan . balasundaram
Hi, I was wondering why Oracle force minextents for rollback segments to be two. Why can't we have minextents zero or no minextents clause at all. We can surely set initial extent to be large enough ourselves and next extent sized accordingly. Can someone enlighten me on the reason/thought

Re: row level lock

2002-03-07 Thread Ora NT DBA
Hi Shishir, This is oracle's default behaviour. As you update , insert or delete a row oracle places a lock at the row level. John HOugh [EMAIL PROTECTED] wrote: HI list! I want to lock a table on row level ( not table level). how do we pass the pass that value in syntax which

RE: Hundreds of schemas in one instance?

2002-03-07 Thread Post, Ethan
I will share one example of where a lot of small datafiles come in handy. I have a script that clones a database. Basically you supply a list of volumes on the target server that are available for datafiles and it will cycle through and decide where there is enough room for the file. If you

Primary keys

2002-03-07 Thread Harvinder Singh
HI, We have some history tables that are pointing to parent tables. Parent tables has primary key. Our developers are saying that we have foreign key from history table to parent table and we don't need primary key on history table. Does there are any benefits if we have primary

Re: Now: IOUG : Was: PocketDBA

2002-03-07 Thread bill thater
[EMAIL PROTECTED] wrote: Gotta go see that!! Live demo's. always fun! copies, i need copies. how the heck can i learn if i work for a bankrupt company that can't afford to either send me, or let me go to it because for how few people are left.;-) -- -- Bill Shrek Thater

Re: unable to apply patch

2002-03-07 Thread Connor McDonald
The software inventory and the software itself do not match up - if the software was copied from another machine or subsequently moved, then this may happen. hth connor --- Harvinder Singh [EMAIL PROTECTED] wrote: HI, When we try to apply patch 9.0.1.2.0 on 9.0.1.1.1 oracle we got error:

RE: unable to apply patch

2002-03-07 Thread Kevin Lange
Since there are so many options of Oracle that can be loaded when installing, maybe there was nothing in the patch for the options that you loaded. It could be just what it is saying ... that nothing that you have loaded has had a fix with this patch. -Original

RE: row level lock

2002-03-07 Thread Grabowy, Chris
Please correct me if I am wrong, but wouldn't you want to use the following... FOR UPDATE NOWAIT if the row is being updated/locked,you can report that to the user, and re-query the data to ensure they still want to update it. Otherwise, with just FOR UPDATE, the first update gets

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Robertson Lee - lerobe
will that presentation and indeed other Quick Tips be out on the net at some point in the future. Regards Lee -Original Message- Sent: 07 March 2002 14:13 To: Multiple recipients of list ORACLE-L How about a seat near the power outlets ?? Then, it will be a fun experiment for Joe

RE: Primary keys

2002-03-07 Thread Hamid Alavi
You can have a PK for your history table(like a sequence number) and add the PK from another table as normal column for this history table. There is no need for and Relationship to the history table. -Original Message- Sent: Thursday, March 07, 2002 9:13 AM To: Multiple recipients of

RE: Names Server

2002-03-07 Thread Karniotis, Stephen
Jack: It appears that the names server is up and running. Try this: 1. Invoke the namesctl utility from a dos prompt. 2. Type services (I think) to see what service names are processed. 3. Type status to see the status of the names server. Thank You Stephen P. Karniotis Technical Alliance

RE: row level lock

2002-03-07 Thread Grabowy, Chris
It is my understanding that Shishir is SELECTing a record, viewing it, making a change to thedataand then updating it. Normally, another user can slip in and update the row, so he wants to make sure that no one else does. For example, in a hotelroom reservation system, you would prompt

HOT BACKUPS

2002-03-07 Thread Gene Sais
I know this has been mentioned on the list before, but for my sanity check, will this Hot Backup Method work? 1) Alter system archive log current ; not really needed but can't hurt. 2) Check backup status. 3) Generate datafile listing to be used by step 5. 4) Alter tablespace tablespace_name

Re: help on the operator

2002-03-07 Thread Jonathan Lewis
The the() operator, which changed to the table() operator in 8.1 takes a single value that has to be a nested table or varray as its operand. What you are casting is the single row and single column that you select from dual, but that single item is the result of casting a result set into a

Re:MTS on 8.1.7.5

2002-03-07 Thread dgoulet
Tracy, For most applications I see no reason to use MTS, BUT there are a couple of locations where I do use MTS on 8.1.7 and have had few if any problems. It is actually a fair performer provided that you set the max_servers parameter rather generously. In total I find that MTS has one

Re: HOT BACKUPS

2002-03-07 Thread Igor Neyman
I would swap 7) and 8): backup control file then alter system archive log current. You also didn't mention step 9: copy archived logs onto backup destination media. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: RMAN Catalog Configuration

2002-03-07 Thread Ruth Gramolini
I will put some comments inline: HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:03 AM I asked the LIST to respond to the PROs and CONs of different RMAN catalog configuration options - Below is the summary

RE: Hundreds of schemas in one instance?

2002-03-07 Thread Jared . Still
Jared: The benefit is isolation. As much as possible keep the users from affecting each other. Performance effects are unavoidable but separate tablespaces would keep one user from gobbling up all the available disk space. Will definitely have to watch out for the data dictionary filling up

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Deshpande, Kirti
It will be at the IOUG web site... If not already there yet, just like all other presentations. - Kirti -Original Message- Sent: Thursday, March 07, 2002 11:19 AM To: Multiple recipients of list ORACLE-L will that presentation and indeed other Quick Tips be out on the net at some

RE: PCT_USED/PCT_FREE : Storage of 32mb images

2002-03-07 Thread Browett, Darren
Sorry about being vague about what I am trying to do, I will try to explain it better. We are implementing a GIS system called Arc/Info, thats allows us to store,manipulate spatially referenced data, one of the layers of information is orthophoto's, these are rectified aerial photographs that

Re: HOT BACKUPS

2002-03-07 Thread Gene Sais
Step 7 8 has always generated difference of opinions :-). And you are right, I forgot to mention step 9. Archives are backed up to tape 4x day (10gb/day). Thanks! Gene [EMAIL PROTECTED] 03/07/02 01:21PM I would swap 7) and 8): backup control file then alter system archive log current.

RE: Hundreds of schemas in one instance?

2002-03-07 Thread Orr, Steve
I understand the need for isolation. Sounds like a problem with social skills. :-) This could be symptomatic of TOO much contact with duhvelopers and damagement. ;-) -Original Message- Sent: Thursday, March 07, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Importance: High

Re: RMAN Catalog Configuration

2002-03-07 Thread Gene Sais
Thanks for the summary. I prefer option 3. One advantage I see is upgrade migrations of databases. For example: 1) You have many 8.1.7 databases that need to be upgraded. 2) You have 1 rman db for 8.1.7 and a sep. schema for each db. 3) You create a new rman db for 9.0.1. 4) As you upgrade

Re: RMAN Catalog Configuration

2002-03-07 Thread Gene Sais
One other thought is that RMAN doesn't back up oracle passwd files, init.ora file, oracle home files, etc. Also, RMAN does not back up redo logs. [EMAIL PROTECTED] 03/07/02 01:03PM I will put some comments inline: HTH, Ruth - Original Message - To: Multiple recipients of list

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Prakriteswar Santikary
Kirti, what's the IOUG web address ? thanks Santi -Original Message- Sent: Thursday, March 07, 2002 10:35 AM To: Multiple recipients of list ORACLE-L It will be at the IOUG web site... If not already there yet, just like all other presentations. - Kirti -Original Message-

RE: help on the operator

2002-03-07 Thread Post, Ethan
Get rid of select from dual! Hah, the next thing you will suggest is that we convert to the metric system! Marge: Now, I know you haven't liked some of my past suggestions, like switching to the metric system -- Abe: The metric system is the tool of the devil! My car gets forty rods to the

Cost vs Rule

2002-03-07 Thread Magaliff, Bill
I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev environments, but we have a few long txns that just take forever. At the request of some savvy developers, I turned on RBO, and it brought down execution times dramatically. I've been

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Alex Hillman
What is the discount? I saw only $85 discount for IOUG membership. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Karniotis, Stephen Sent: Thursday, March 07, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Now:

HOT BACKUPS

2002-03-07 Thread Charlie Mengler
Here is what worked for me this morning. + sqlplus -s + 0 sys/syss set pause off feedback off pages 0 echo off spool CCC_begin_hot_backups.sql SELECT 'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;' FROM DBA_TABLESPACES; SPOOL OFF @CCC_begin_hot_backups.sql EXIT ALTER TABLESPACE

RE: Now: IOUG : Was: PocketDBA

2002-03-07 Thread Karniotis, Stephen
Everyone: The address for the IOUG web site is www.ioug.org. The Conference site is www.ioug.org/live2002. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com

Re: Cost vs Rule

2002-03-07 Thread Joe Raube
How much have you played with Oracle Hints??? -Joe --- Magaliff, Bill [EMAIL PROTECTED] wrote: I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev environments, but we have a few long txns that just take forever. At the request of

RE: PCT_USED/PCT_FREE : Storage of 32mb images

2002-03-07 Thread MacGregor, Ian A.
I should have noticed you were using long raws. I would definitely move to BLOBS if your system supports it. The lob segment should be in a different tablespace than the data segment. This also allows you to name the lob segment which is quite useful. I would suggest a 4MB uniform extent

Re: help on the operator

2002-03-07 Thread Jonathan Lewis
It's the way of the future - From 8.1.7.2 (or maybe 3) PL/SQL at the server no longer does select sysdate from dual; when your code reads: m_date_var := sysdate; One down, six to go. Anyway, why do we need DUAL when we have X$DUAL which does take up any space or latching ? Jonathan

RE: Cost vs Rule

2002-03-07 Thread DENNIS WILLIAMS
Bill - Are you saying that you switched to RBO for everything? I thought the better procedure would be to remain CBO and put hints into individual SQL queries. Is this a possibility in your environment? You mention that you are a development shop. Does this mean that you create software and sell

RE: Cost vs Rule

2002-03-07 Thread Magaliff, Bill
not much - desire is to keep sql ANSI compliant due to cross-platform issues (want to be able to run the app on multiple db's) -Original Message- Sent: Thu, March 07, 2002 2:44 PM To: Multiple recipients of list ORACLE-L How much have you played with Oracle Hints??? -Joe ---

Number of Transaction Slots

2002-03-07 Thread Rajesh . Rao
I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at

Re: Cost vs Rule

2002-03-07 Thread Rajesh . Rao
Is your setting for db_file_multiblock_count too high? What's the optimizer mode? Have you set any of the optimizer_index_ parameters in the initialization file? These parameters might be driving Oracle to prefer a full table scan over a index scan. My 1.2 cents (after NY Taxes). Raj

RE: Cost vs Rule

2002-03-07 Thread Magaliff, Bill
Interesting point . . . but the flip side of your argument is that by putting hints in we, as the vendor, while not requiring you to use CBO (since RBO will just ignore the hints) are saying, 'Hey, you had BETTER use CBO if you want this thing to work the way we've designed it' interesting to

RE: Cost vs Rule

2002-03-07 Thread Shaw John-P55297
have you tried adjusting optimzer_index_caching and optimizer_index_cost_adj? -Original Message- Sent: Thursday, March 07, 2002 1:23 PM To: Multiple recipients of list ORACLE-L I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev

PL/SQL

2002-03-07 Thread Freeman, Robert
So, do you think I'm making a mountain out of a molehill over the PL/SQL %type stuff...? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

RE: Number of Transaction Slots

2002-03-07 Thread K Gopalakrishnan
The transaction slots are visible as KTUXESLT in X$KTUXE. You can get them using this SQL.. select count(*) ktuxeslt from X$ktuxe group by ktuxeusn; For a complete value you can get the slot size form V$TYPE_SZIE and do a simple math.. Let me know if you can't. I will do that for you Best

RE: Number of Transaction Slots

2002-03-07 Thread Freeman, Robert
To give credit where credit is due, this came from my friend K Gopalakrishnan... The transaction slots are visible as KTUXESLT in X$KTUXE. We can get the number of transaction slots in the rollback segments by select count(*) ktuxeslt from X$ktuxe group by ktuxeusn; The # of transaction

RE: Cost vs Rule

2002-03-07 Thread DENNIS WILLIAMS
Well, since hints are implemented within comments, I would assume that other databases would simply ignore them. If anyone has direct experience, that would be interesting. Being completely database-agnostic may play against tuning. Just a thought. I suppose you analyzed all tables when

RE: PL/SQL

2002-03-07 Thread Jamadagni, Rajendra
It depends ... to quote my SA, 'You can never be paranoid enough about security ... but you need to know when to stop and have a life. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion

Anyone use V$SESSION_LONGOPS ???

2002-03-07 Thread Orr, Steve
Is my V$SESSION_LONGOPS view broken? Check out the curious results below. Notice the changing SID-serial# and how elapsed seconds gyrates. None of the below sessions are in V$SESSION. The sql address and hash is not extant in V$SQL, V$SQLAREA, etc. (Note, we are using PQO with timed

RE: Number of Transaction Slots

2002-03-07 Thread K Gopalakrishnan
Rajesh, The transaction slots are clearly visible in the Undo Header dumps. I think this takes some 40 bytes space in the undo header block and this limits the number of ***concurrent** transactions for that undo segment. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original

Re: Number of Transaction Slots

2002-03-07 Thread Anjo Kolk
Basically the total ITL size can't be bigger than 50 percent of the available space for data for the block size. ((db_block_size - ovh) /2) / itl size Anjo. [EMAIL PROTECTED] wrote: I believe someone else had asked this question before, but I did not see a reply. Does anyone know the

Re: Cost vs Rule

2002-03-07 Thread Suzy Vordos
Tim Gorman wrote a good paper about using these parameters: http://www.evdbt.com/SearchIntelligenceCBO.doc Shaw John-P55297 wrote: have you tried adjusting optimzer_index_caching and optimizer_index_cost_adj? -Original Message- Sent: Thursday, March 07, 2002 1:23 PM To:

RE: Anyone use V$SESSION_LONGOPS ???

2002-03-07 Thread Jamadagni, Rajendra
No it is not broken, unless someone explicitly updates underlying information it is not visible I monitor this when I am creating or rebuilding indexes to importing ... at that time Oracle will populate relevant fields, and that is really useful. Raj

compiling in the order of dependency

2002-03-07 Thread Jamadagni, Rajendra
Hi all, has anyone written a clean script to perform compiles in the order of dependency in 9i db? Due to java objects if I join public_dependency and dba_objects, it fails with ORA-01436: CONNECT BY loop in user data error. When I write following script, it takes ages how do I tune this

RE: Cost vs Rule

2002-03-07 Thread Magaliff, Bill
always analyze - it's step 1 in any tuning I attempt usually use compute, but if estimate it's at least 15 or 20% -Original Message- Sent: Thu, March 07, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Well, since hints are implemented within comments, I would assume that other

Re: Displaying V$SYSSTAT row values in columns... any better way?

2002-03-07 Thread Stephane Faroult
Orr, Steve wrote: I want to display V$SYSSTAT row values in columns. The current query: - select to_char(trunc(86400*(sysdate-to_date( '01/01/70','mm/dd/rr hh24:mi:ss',

RE: Cost vs Rule

2002-03-07 Thread Magaliff, Bill
just changed index_cost_adj from 100 to 1 what is index_caching? -Original Message- Sent: Thu, March 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L have you tried adjusting optimzer_index_caching and optimizer_index_cost_adj? -Original Message- Sent: Thursday,

Re: Cost vs Rule

2002-03-07 Thread bill thater
[EMAIL PROTECTED] wrote: Well, since hints are implemented within comments, I would assume that other databases would simply ignore them. If anyone has direct experience, that would be interesting. Being completely database-agnostic may play against tuning. it has been my experience that those

RE: Anyone use V$SESSION_LONGOPS ???

2002-03-07 Thread K Gopalakrishnan
Steve, I suspect this could be another BUG like your old V$sysstat. By any chance you have set the _sql_exec_progression_cost to lowest values? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Thursday, March 07, 2002 12:19 PM To: Multiple recipients of

Re: Number of Transaction Slots

2002-03-07 Thread Jonathan Lewis
You've already got the main answer from KG and RF. The figures on Metalink look much too high - but they might be from an earlier version of Oracle. The size is strongly version dependent. In Oracle 9 (automatic UNDO only) the figures are closer to: 4K= 22 8K= 48 In

Re: A rollback segment question on minextents

2002-03-07 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: Hi, I was wondering why Oracle force minextents for rollback segments to be two. Why can't we have minextents zero or no minextents clause at all. We can surely set initial extent to be large enough ourselves and next extent sized accordingly. Can someone

DB2

2002-03-07 Thread Cunningham, Gerald
Title: Message Hi there, Does anybody know if there's a list such as this one for DB2? Or, a link to DB2 documentation (maybe something like the Oracle Concepts Guide)? Thanks! - Jerry

Re: Number of Transaction Slots

2002-03-07 Thread Jonathan Lewis
Anjo, Quick, correct you answer before anyone else gets in there. The guy is asking about the transaction table in the rollback segment header, not about the ITL. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host

  1   2   >