Re: pga_aggregate_target and a memory leak

.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Has anyone done any scalability work on dbms_lock?

of any potential performance hits or scalability issues. Any ideas? TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: Oracle 8.1.7 can only use the first 15th indexes?

] - Original Message - snip (I assume the report intended to say the first 15 indexes on a specific table, 'cos the data dictionary alone has rather more than 15 indexes). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City

Re: data manipulation of a large unix file

data to the file before loading(its not negotiable). ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET

Re: how do I interpret this in bstat/estat

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Reasonable layout for DSS

: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Re: SLA/metrics for RFP for programming services

form of acceptance testing. It does us no good if the contracted ETL task capitalizes the box (like the runaway PL/SQL program mentioned by Ryan) and takes 3 days to complete. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 10:54 PM

Re: What to look for in STATSPACK report

anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: any student versions of 'business objects' ab initio or

Title: Re: any student versions of 'business objects' ab initio or informatica? Probably best to contact them directly? I suspect that Ab Initio in particular will be out of reach for this purpose. My understanding is that they choose their customers based on their capability to deliver a data

Re: SQL server and JOB

First, you may have to quit your job in Oracle... on 1/16/04 5:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED

Re: SLA/metrics for RFP for programming services

Title: Re: SLA/metrics for RFP for programming services How about specific deliverables within a specific period of time for a total amount not-to-exceed? Cant think of any other metrics that matter... on 1/16/04 2:19 PM, Thomas Jeff at [EMAIL PROTECTED] wrote: If you were to write up a RFP

Re: Partitioning question (duplicate?)

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Problem with archive log when testing recovery..., urgent

: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

Re: Should we stop analyzing?

hist_head$ where obj#=:1 and intcol#=:2 JMHO. . . . Regards, Donald K. Burleson www.dba-oracle.com www.remote-dba.net JWIHO. . . . (Just What I Have Observed) -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat

Re: pga workarea and ora-04030

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: What is the fastest way to dump oracle data into a human

faster (or any) it would be by doing Option 2 or 3 above. Does anyone know if I would see siginificant performance boost by using C? Any other suggestions? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City

Re: Backups in a DW Environment

for archive logging. Any thoughts? mohammed Hope this helps... -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Re: Difference on ArchiveLog (I'm rewriting the question)

FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: table reorganizations

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: DBA tasks

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Job question

price has has dropped to almost worthless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: stress testing

Henry, I use the attached shell script to gather and store VMSTAT information in a custom table within the PERFSTAT schema (i.e. schema belonging to STATSPACK). Allows for some nice reporting over time, rather than anecdotal here-and-there observations. Should work OK on Solaris, HP, and Linux.

Re: 10g new features question for beta testers

, and learn, for an original mistake is as rare as an original idea. on 12/22/03 5:34 PM, Mogens Nørgaard at [EMAIL PROTECTED] wrote: Imagine the banner text: Miracle A/S. The Legacy Support of Tomorrow. Filling the Gap (jeans) like nobody else. Thanks to Tim Gorman for inspiration. I don't

Re: standby database configuration in 9iR2 SE ?

to the standby /quote anyway i'm looking for manual recovery which is possible in SE. Regards, Jp. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Standby is only for Enterprise Ed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim

Re: Little competition

Title: Re: Little competition I can cut 45 minutes off my load times by shrinking the data file? And how much overhead gets added to DML statements as blocks madly shift on and off the freelists with each operation? Priorities, priorities, priorities... If youre using 9i or above, the table

Re: Code Conversion from MSSQL into Oracle

Title: Re: Code Conversion from MSSQL into Oracle 10 years ago or so, I wrote a 105 line script for the UNIX sed (a.k.a. stream editor) command to convert Teradata BTEQ scripts into Oracle SQL*Plus. Painful, yet thrilling, and it took only about a day of concentration with the OReilly Awk and

Re: Little competition

the weekend. Depends on your situation. There are cases for dense blocks and there are cases where you dont want to do this. again, what is so bad with what burleson said about the pctfree and pctused? From: Tim Gorman [EMAIL PROTECTED] Date: 2003/12/11 Thu AM 07:59:25 EST To: Multiple

RE: SQL Area Reloads

ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Windows clustering???

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: char is going away?

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: 24 x 7 x 365

Title: Re: 24 x 7 x 365 As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years. on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL

Re: SQL Area Reloads

Title: Re: SQL Area Reloads Sure, its free now. But has that always been the case? on 12/10/03 3:14 PM, Ashish Sahasrabudhe at [EMAIL PROTECTED] wrote: The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.

Re: Documenting databases

be different. The first challenge in our case was to build an inventory of databases (asking people is totally unreliable); I have used scripts from Tim Gorman which you will find on his site (http://www.evdbt.com) - from a security paper, which I have reworked to suit my case. The idea was to probe

Re: Hide schema from other user.

. Thank in advanced regards JKean __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City

Re: RAC and Forms6i

subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services

Re: OS Level Defrag

Title: Re: OS Level Defrag Ask him/her to demonstrate their point empirically and not speculate or cite hearsay. After all, they should not have any difficulty putting together a simple test case and then demonstrating how de-fragmentation aids performance. Databases simply do not manipulate

Re: Re[2]: Deleting partitioned data

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET

Re: Bad performance because of wrong characterset?

ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: Oracle Version 8 as read only

PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Oracle Version 8 as read only

] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: IOUG 2004

me to cover, send them on -- I will only have an hour but the more relevant the presentation can be, the better. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: 'internal' role and 9i

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 'internal' role and 9i

the least to create a role called internal. Yong Huang --- Tim Gorman [EMAIL PROTECTED] wrote: Barry, Why make life difficult? It's just a role, not a data object referenced by applications (hopefully). Change it's name to something that is not a reserved word and move

Re: Multi-threaded server - will it help in this case

-or-nothing seems to imply that MTS and Dedicated will each require their own listener ( different ports). Been awhile since I messed with MTS, but I don't recall that as being necessary. Is that what you meant? Jared On Tue, 2003-11-11 at 07:04, Tim Gorman wrote: Peter, MTS (or SS in 9i

Re: Multi-threaded server - will it help in this case

. Will use of the mult-threaded server improve performance in this situation, for example, by eliminating the overhead of starting a dedicated server for each connection? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL

Re: for years I have been using korn shell

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat

Re: Multi-threaded server - will it help in this case

that MTS and Dedicated will each require their own listener ( different ports). Been awhile since I messed with MTS, but I don't recall that as being necessary. Is that what you meant? Jared On Tue, 2003-11-11 at 07:04, Tim Gorman wrote: Peter, MTS (or SS in 9i onwards

Re: var source_data varchar2(12)

://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: file sizes over 32GB

you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: This is just wrong

Mac OS X? In my opinion, no. Not last september, not this september, not next september. never. Who really wants to run the server software on a Tier 3 platform, anyways? Paul Tim Gorman [EMAIL PROTECTED] wrote: I live on a Mac laptop. I chose to do so because there are only three

Re: This is just wrong

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat

Re: Sequences in OPS/RAC

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: char(1) VS varchar2(1)

meet at RMOUG training days this Feb? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: char(1) VS varchar2(1)

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RMAN Error

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: dba interview questions

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: dba interview questions

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Coalescing tablespace

Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Monday, 27 October 2003 2:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Coalescing tablespace Ross, Wow! That's a blast from the past! ALTER TABLESPACE ... COALESCE didn't arrive on the scene until v7.3, so prior

Re: ORA-4031 errors no a high Load Database

Title: Re: ORA-4031 errors no a high Load Database Vivek, You are using MTS/SS; have you configured the Large Pool to accommodate all of the UGA structures? If you do not have the Large Pool configured from its default of 0, then all of the UGA (i.e. session global areas, shared amongst the

Re: What happened to Howard Rogers ?

Title: Re: What happened to Howard Rogers ? That is quite standard. The meaning of full time employment does not admit the concept of working on my own time; mutually exclusive in many senses. In order to segregate your own time from that of a company, you have to be a temporary (i.e. contract)

Re: performance issue on select count(*)

://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Coalescing tablespace

- Sent: Sunday, October 26, 2003 8:04 PM To: Multiple recipients of list ORACLE-L Hi, For those like me still working on an Oracle 716 (hold the laughs), how do we coalesce a tablespace? Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman

Re: Coalescing tablespace

PROTECTED] wrote: Hi, For those like me still working on an Oracle 716 (hold the laughs), how do we coalesce a tablespace? Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: RMAN Incremental

Title: Re: RMAN Incremental Michael, Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at http://www.EvDBT.com/papers.htm, entitled Managing the Data Lifecycle. -Tim on 10/24/03 4:34 PM, Michael Kline at [EMAIL PROTECTED] wrote:

Re: how is it possible

/myscripts/shell_scr $ /home/ak/shell_scr $ whoami ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Boolean dates...

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: OT: How to call unix shell scripts from 'C'?

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Cache a table

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 10046 trace question

Title: Re: 10046 trace question DBMS_SYSTEM.KSDWRT should do what you want. First parameter is a numeric value 1 or 2, second is a string. If 1, the string is written to a .trc file (which is what you want). If 2, then string is written to the alert log. on 10/22/03 9:39 AM, Jamadagni,

Re: Boolean dates...

Title: Re: Boolean dates... ...and just by way of trivia, the Latin word kalends is the only word in that language to start with the letter K... on 10/22/03 6:09 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: The 15th of March. From http://www.infoplease.com/spot/ides1.html : Kalends

Re: using temp tables for staging databases?

-world reasons to change it from the default of 40. I'm sure someone else can... on 10/21/03 2:19 AM, Mark Leith at [EMAIL PROTECTED] wrote: Tim, Can you sum up a few situations when the need *has* arisen to change these values? Cheers Mark -Original Message- Tim Gorman

Re: Cache a table

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: object compilation scripts

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat

RE: Cache a table

employer or customers ** -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 6:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Cache a table Good points, Arup. Actually, I would argue that there is better reason to consider

Re: Data Transfer between two instances

http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: using temp tables for staging databases?

increase the speed of the data loads. Not worried about latch contention because its just for bulk loads. I know this bad in transactional instances. Has anyone used these in non-transactional data load instances? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim

Re: using temp tables for staging databases?

which says never use them. So I want to make sure Im not missing something. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/10/20 Mon AM 10:19:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: using temp tables for staging databases? All the time. Oracle Apps's

Re: Archivelog - Disk space issue.

-- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

Re: Concurrent Manager

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Concurrent Manager

Hemant, That configuration was usual for Apps 11.0.x and prior, but with 11i it is strongly recommended to take the default configuration and leave the ConcMgr on the apps-tier instread of the db-tier. Two major reasons: * The gains in manageability (especially upgrades) far outweigh the

FW: Concurrent Manager

of Forwarded Message -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: CBO and cartesian product

: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Re: Avoiding full table scan

Title: Re: Avoiding full table scan Same author (Jeff Maresh) has also published a new paper on physical structure of data warehouses to accommodate the life cycle of data. It is fantastic. Ive published both papers (Managing the Data Lifecycle and In Defense of FULL table scans) on my website

Re: workarea_size_policy=auto and performance efficiency [was: Re:

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Oracle Client for Macintosh

Title: Re: Oracle Client for Macintosh There are no downloadable clients. Only the server v9201, which is all character-mode (yay!)... on 10/1/03 8:24 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: I've searched TechNet and MetaLink but can't find a downloadable 8i, 9i, anything Oracle

Re: COBOL TO ORACLE

suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: workarea_size_policy=auto and performance efficiency [was: Re:

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Did Comp die in 9.2?

/ Any clues, or am I just doing something stupid? Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Using dimensions

Title: Re: Using dimensions Query rewrite from materialized views does not require dimensions; they are only used in certain fairly obscure situations. on 9/30/03 1:49 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Query rewriting to use materialized views requires dimensions to be defined.

Re: Statspack Report!

Title: Re: Statspack Report! Without looking at other parts of the report, there is no way of telling if this information is important or not. There is not enough timing information displayed to understand whether these issues are a significant part of your databases performance or not. Please

Re: workarea_size_policy=auto and performance efficiency [was: Re:

://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: BAARF

of arguing in front of management with Oracle certified DBAs that RAID 5 is not good, OFA is unnecessary, and uniform extents is the only way to go. Looking for a big stick to catch their attention with. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET

Re: BAARF

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Solaris /etc/system values for Oracle8i

-- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

workarea_size_policy=auto and performance efficiency [was: Re:

performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services

Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS

Title: Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS NAS mistakes: Not dedicating two (or more) network segments to NAS access only, segregated from other uses Should you just plug a NAS into a general-purpose LAN and start connecting servers to it? Why would more than one

Re: BAARF

to catch their attention with. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: How do we know that an index need to be rebuilt.

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network

FW: SQL help needed

endorsed by them. -- End of Forwarded Message -- End of Forwarded Message -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Apps 11.5.8 and 9i

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman

  1   2   3   4   5   6   7   >