RE: !!Please Read - Oracle-L is moving!!

: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in th

RE: Views for a table

Title: Message Query DBA_DEPENDENCIES where type='VIEW' and referenced_name='STUDENTS' and referenced_type='TABLE'. -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:50 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: !!Please Read - Oracle-L is moving!!

this? FYI... I've triedreplying to the email...Copying the message text and sending a new email... And, even when you sign up through the web site, you still need to perform a final confirmation via email... Argh! I'm guessing it may be Outlook since I'm using a beta version of Outlook 2003... Tim

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

any messages, thus waiting application racks up lots of timeouts... Hope this helps... -Tim Hi. I am looking at the bstat/estat report and see a high number of enqueue timeouts in the statistics section of the report. How do I tackle that? In the Niemec's book he receoomends

Re: Reasonable layout for DSS

tablespaces Yes, it can be argued that archived redo logfiles are busy, but their impact on database performance is not as direct as the impact of the online redo logfiles... Keith H. Just some ideas -- hope it helps... -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: SLA/metrics for RFP for programming services

there isnt enough trust (or desperation! :-) ) in the relationship to make it work anyway. Hope this helps... -Tim on 1/18/04 11:04 AM, Thomas Jeff at [EMAIL PROTECTED] wrote: Tim, Thanks for the reply. We are thinking more along the lines of metrics pertaining to identifying the required

Re: What to look for in STATSPACK report

this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does

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?)

to clearly be interpreting the phrase to_char as a column name... Hope this helps... -Tim on 1/14/04 3:24 PM, Daniel Fink at [EMAIL PROTECTED] wrote: Pardon if this is a duplicate, but the original has not shown up on the list after 3 hours... Is it possible in 9.2 to partition on a function

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?

= o.object_name and o.object_type = 'TRIGGER' and o. OWNER = :ow n AND ( t.table_name = 'OE_SOLD_TO_ORGS_V' OR o.ob ject_name = 'OE_SOLD_TO_ORGS_V' ) ORDER BY t.TRIGGER_NAME 787810128 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim estamp

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)

you are seeing. Hope this helps... -Tim Hello everybody thank for your answers, the size I'm talking about is summing up real sizes of archivelogs files, and I had each configuration of redo logs for one week, and the first one was for many months. There was not any change

RE: ORA-3113 errors after switching W2K server to new network

/reconnect every 30 minutes so does not fall fowl of the issue. T¬ _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message

RE: Verisign and MetaLink

the ntoe I read talked about Oracle Wallets and SSL within Java _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original

RE: table reorganizations

blkdiff constant. Indeed, table reorgs in such circumstances wouuld help so rarely that they aren't really worth worrying about. Hope this helps... -Tim I'm surprised at these responses. I'm asking what sql statement most people use to identify tables that need reorganization because

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: HOTSOS Conference

I'll be there... A get together would be great... Tim -Original Message- Sent: Monday, January 05, 2004 8:59 PM To: Multiple recipients of list ORACLE-L While perusing the HOTSOS site, I noticed that the deadline for the discounted registration for the HOTSOS conferences ends after

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

of trouble. Hope this helps... -Tim on 1/2/04 11:54 AM, Poras, Henry R. at [EMAIL PROTECTED] wrote: We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress

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 ?

for log shipping and log apply (executed via cron) that I wrote for SE on Sun Solaris some years ago. Attachments to this list get stripped off, so email me offline if you'd like 'em. No warranty, no guarantees -- just a starting point... Hope this helps... -Tim on 12/16/03 1:04 AM, Prem

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

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 on. There is a list of reserved words in the SQL Language reference. Hope this helps... -Tim Hello all, I'm

Re: 'internal' role and 9i

Oops! blush Thanks for the correction, Yong! Tim, I checked v$reserved_words. At least in 9.2.0.1, INTERNAL is not in there. Oracle should address this issue. When I trace the SQL GRANT SELECT ON SOMETABLE TO INTERNAL, it stops in parsing. Nonetheless, it's confusing to say

RE: Looking for help.

Or... Create a stored procedure that truncates the table... Grant execute on the procedure to the user... The user executes the procedure and then calls sqlldr... Tim -Original Message- Sent: Wednesday, November 12, 2003 12:45 PM To: Multiple recipients of list ORACLE-L yeah

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

that! Thanks again! on 11/11/03 11:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Thanks John, this is the way I have done it in the past. Tim, thanks for your clarification. Thought that was more or less what you meant, just wanted didn't want to see any myths started stating that MTS

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

, if you need the memory elsewhere... Hope this helps... -Tim Environment: AIX 4.3 Oracle 8.1.7 The application is a CAE tool which stores metadata for a hierarchy of 3D engineering design models. When a user opens a model at a given level in the design, the application retrieves data about

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

apps that treat database connections like cursors are another problem... :-) Tim, This bit: accomodate this application. Please be aware that you can mix dedicated and MTS by setting up different TNS names on different ports for each, so it is not an all-or-nothing seems to imply

Re: var source_data varchar2(12)

for communicating data values into or out of the PL/SQL block. Hope this helps... -Tim My original posting had a few lines truncated, so here I go again: I'm looking at a PL/SQL script that goes like this -- Header var Source_Data VARCHAR2(12) DECLARE Num1 NUMBER; BEGIN

Re: file sizes over 32GB

in the wall... :-) Just my $0.02... -Tim One of the guys here did some research and found that files over 32GB can cause data dictionary corruption. anyone have problems with this? we are using an automated transportable tablespace process with alot of logic and between many instances and servers

Re: This is just wrong

... on 11/6/03 12:09 AM, Paul Drake at [EMAIL PROTECTED] wrote: Tim, Oracle has even produced a developer's release of Oracle9.2 for Mac OS X, downloadable from OTN. that was released in Sept 2002. releases of 8.1.6 and 8.1.7 were supposed to be released for production usage, according

RE: shareplex: datatype unsupported

That goes for Shareplex too (sorry to state the obvious). I've been seriously bitten in recent weeks by problems with their stuff too. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider

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: PCTFREE and PCTUSED

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

RE: PCTFREE and PCTUSED

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

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: Re[2]: Sequences in OPS/RAC

The problem is that the ORDER clause comes at the expense of CACHE. You can use SQL tracing to verify that each use of the sequence causes an update of SYS.SEQ$ when ORDER is set, effectively rendering the CACHE setting a no-op. So, especially in an OPS/RAC environment, the use of ORDERED

Re: char(1) VS varchar2(1)

byte if they contain nulls. I once saw a recommendation to store your data in char columns if you don't want to have to worry about row size changes and PCTFREE setting... which is mostly a stupid suggestion anyway and doesn't work in case of nulls either. Tanel. P.S. Tim, I assume that we'll

Re: char(1) VS varchar2(1)

is shown by the one byte 0xff. The value of 99 in column C5 is shown by the five bytes 0x04c3646464. -Tim on 11/2/03 4:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: Hi! Just for the record, every column in a table has a length byte (or three, depending on column size). This works so

Re: RMAN Error

the backupsets is the one you intend. Hope this helps... -Tim Hi List, I am getting the following RMAN error. Any help would be really appreciated. RMAN script:- == RMAN replace script ts_system_backup { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3

10046 level 8 trace - help required with 'direct path write' wait

'. Is this just a traditional wait for a row lock to be released or something more sinister? Any help much appreciated. Also (daft question time) what units are tim= in? (ie how many seconds between tim=131853898 and tim=131853270). This SE 8.1.7.4.12 on Windows 2000. Thank you T¬ PARSING IN CURSOR #15

RE: 10046 level 8 trace - help required with 'direct path write'

OK - so I'd not got round to reading a recent previous post on the same issue, seems tim= is in hundredths of seconds for 8i. So I got that bit of the answer. Still pondering on those 'direct path write' waits though. _ Tim Onions Head of Oracle Development Speech

RE: how to get rid of default

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 Fleury INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 10046 level 8 trace - help required with 'direct path

Paul Oh well spotted, I'd completely missed that, cursor #14 is MUCH more complex and would require a fair degree of sorts. Thanks T¬ _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ..the speech-to-data Application Service Provider

RE: 10046 level 8 trace - help required with 'direct path write'

://www.orafaq.net -- Author: Tim Onions 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

RE: 2G trace files

://www.orafaq.net -- Author: Tim Fleury 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: 2G trace files

#, 'max_dump_file_size', 'unlimited'); gives: ORA-06502: PL/SQL: numeric or value error: character to number conversion error sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647 + 1); gives: ORA-01426: numeric overflow On Wed, 2003-10-29 at 14:24, Tim Fleury

RE: ORA-4031 error help.

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 Fleury INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: 10046 trace data question

PROTECTED] Sent: Wednesday, October 29, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: 10046 trace data question Does anyone know where tim= comes from? Is it from a certain epoch? e.g. PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5 tim=1042250821743271 hv

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

, to go through all the tablespaces, excluding tablespaces where COUNT(*) comes back as 0... Good luck! -Tim on 10/26/03 9:54 PM, Ross Collado at [EMAIL PROTECTED] wrote: Thanks Tim. Yes, for some it is a blast from the past! Unfortunately for me, for one of our systems still using this database

Re: ORA-4031 errors no a high Load Database

after an ORA-04031 is received, but we understand that they are occurring intermittently and that may not be possible... Thanks! -Tim on 10/27/03 4:59 AM, VIVEK_SHARMA at [EMAIL PROTECTED] wrote: Intermittent ORA-4031 errors Out of shared Pool :- Oracle ver 9203 Solaris 9 Concurrent Users

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(*)

to it, but this should be a start. Feel free to post the results of the query above to the list, if you wish... Hope this helps... -Tim on 10/27/03 6:24 AM, Linda Wang at [EMAIL PROTECTED] wrote: Hi, I have an online application that does a 'select count(*)' on a few tables. The 'select

Re: Coalescing tablespace

://www.EvDBT.com/papers.htm)... From 8i onwards, of course, the use of LMTs completely negates the discussion altogether. Thanks! -Tim on 10/27/03 7:49 AM, Cary Millsap at [EMAIL PROTECTED] wrote: It's a note created in response to hundreds of customers shouting about how VMS and DOS need defragmenting

Re: Coalescing tablespace

# and a.file# = b.file# and (a.block# + a.length) = b.block# group by t.ts#; The purpose of the LEAST(COUNT(*),65535) phrase is to prevent an overflow, due to max of 16 bits in which to specify the count... Hope this helps... Thanks! -Tim on 10/26/03 6:04 PM, Ross Collado at [EMAIL

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: Re: What happened to Howard Rogers ?

Because they said so. Signed, -Another former Oracle employee threatened by Oracle Legal about info posted to the internet He had great stuff on his site. Why did Oracle make him take it down? His stuff his very readable and informative IMHO. This e-mail, including attachments, may

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...

--- 06-DEC-2719 And here is the Julian date value for today... SQL select to_char(sysdate,'J') from dual; TO_CHAR --- 2452935 Hope this helps... -Tim Hi to all! We have an old app that manages something that my boss calls: boolean dates. He told me that exists

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

the shell script that will operate independently of its parent, you can just call the system() library call and be done with it... Hope this helps... -Tim The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official

Re: Cache a table

Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Wednesday, October 22, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Good idea. I located the meaning of TIM column (time to age buffer). BTW

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

Seema, SQL*Plus script gen_recompile.sql at http://www.EvDBT.com/tools.htm;. It's the eighth one in the list... -Tim Hi, Can someone send all object compilation script? Thx -Seema __ ___ Enjoy MSN 8 patented spam control

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

used for this purpose is defined using a TNS-string that raises the SDU and TDU parameters in SQL*Net, but don't expect a great deal of difference from this measure. As with anything else, writing appropriate application code has the best impact on performance. Hope this helps... -Tim on 10/19/03

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: Passed Net8 OCP Exam

://www.orafaq.net -- Author: Johnston, Tim 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: Opinions sought on possible TOAD replacement

the cost... Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 3:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Opinions sought on possible TOAD replacement We do something similar here. Developers gets

  1   2   3   4   5   6   7   8   9   10   >