is this DBA's only mailing list?

HI everyone I recently joined the list, and I think it is meant only for DBAs. Is that true? Also, can anyone suggest any similar mailing list meant for Oracle developers (that is those working with SQL, PL/SQL, Forms, Oracle apps, etc.) and those who are not DBAs? Thanks in advance Ajay

RE: lengthy URL's

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: lengthy URL's Just a slightly OT post here. It isn't unusual when writing to this list to come up with a few URL's

Re: Function Based Index - Not Used ???

JP, In the EXPLAIN PLAN, it says Card=262146, indicating that the query expects to retrieve over a quarter-million rows. Is that in fact correct? If so, the CBO is making the correct decision to perform a FULL table scan. What was the comparison of elapsed times between the two plans, the one

RE: is this DBA's only mailing list?

Yes, we even let developers use this list. Heck, if you want to throw out a perl question cuz I bet you'll get an answer. ;o) Dave -Original Message-From: Ajay K. Garg [mailto:[EMAIL PROTECTED]Sent: Thursday, May 29, 2003 7:46 AMTo: Multiple recipients of list

Re: Problem with TOAD

Cause: The synonym used is based on a table, view, or synonym that no longer exists. Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym. looks to me like one of the data dictionary views that toad

RE: dbms_stats broken

Interesting, I use dbms_stats with gather stale in 8.1.7.4 it behaves beautifully. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28, 2003 11:15 PMTo: Multiple recipients of list

RE: Function Based Index - Not Used ???

Naveen , these parameters look to be already set Doesn't FBI come in with 8.1.7 and Prem is on 8.16 and a comapatible of 8.10 is in place Failing that, as my second guess, 2 privileges need to be assigned to the user (QUERY_REWRITE and CREATE INDEX). The 2nd one is obviously in place to allow

Re: Which method is more efficient

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 29, 2003 3:14 AM 1. to totally eliminate redo, load your staging records into a global temp table. it has absolutely no redo and is very fast. Hi The above is not quite true. Global

Re: is this DBA's only mailing list?

best place for forms and reports are the odtug listservs at fatcity there is one called Developer 2000 and one called Designer 2000 From: Ajay K. Garg [EMAIL PROTECTED] Date: 2003/05/29 Thu AM 08:45:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: is this DBA's

Re: dbms_stats broken

Koivu, Lisa wrote: Hello everyone, Is anyone using dbms_stats and gather stale or gather auto in 9.2? Im trying to use dbms_stats gather schema stats with the stale option and it just isnt working in 8.1.7.4. This is documented on Metalink. Id love to hear from someone else if this is fixed

RE: is this DBA's only mailing list?

Ajay, The Oracle Development Tools User Group (ODTUG) has about a dozen different list serves and many are focused on development. Check out the web site www.odtug.com and you can register for those lists with a few mouse clicks. Good Luck! Maggie Respectfully, Maggie Tompkins - DCII

RE: is this DBA's only mailing list?

There are also dev-specific lists tho: Developer 2000: ODTUG-DEV2K-L, and Designer 2000: ODTUG-DES2K-L. Send an e-mail w/the text (for instance) SUB ODTUG-DEV2K-L To the address [EMAIL PROTECTED] to subscribe. HTH, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT

RE: Function Based Index - Not Used ???

FBI is supported on 8.1.6 (that is what I use them on), but you may be right (Babout the compatible setting. (B (BDennis Williams (BDBA, 80%OCP, 100% DBA (BLifetouch, Inc. (B[EMAIL PROTECTED] (B (B (B-Original Message- (BSent: Thursday, May 29, 2003 7:46 AM (BTo: Multiple

RE: SAP Hands SAP DB over to MySQL

Okay, I've got a question for you people knowledgeable in SAP. Who would trust their financial and payroll data to MySQL? I'm not saying this to knock MySQL. It is just that your financial and payroll data is among your most valuable data in the corporation. Only recently was a transaction

[Q] Benchmark rate and ORACLE database?

I am compare the SUN server performance with ORACLE database. Can anyone tell me following 4 values which one most import for ORACLE database: CINT2000 CFP2000 CINT2000 rates CFP2000 rates Thanks. __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with

RE: dbms_stats broken

Hey Lisa (Monkey?), Yes, I had a problem with the stale option, too, at least under 8.1.6. It would bomb out with no more rows or something like that. Under 8.1.7.4 on Solaris, I no longer had that problem but I did have some poorer explain plans than with good ol' ANALYZE. See the Burned by

RE: is this DBA's only mailing list?

I'll quote the list manager Jared's comments which he made in a mail long back "This is an Oracle mailing List" So youshould be allowed topost anything related to Oracle. Regards Naveen -Original Message-From: Ajay K. Garg [mailto:[EMAIL PROTECTED]Sent: Thursday, May 29,

RE: is this DBA's only mailing list?

Ajay - While most of us are DBAs, we also deal with SQL and PL/SQL a lot. When the developers get stumped, who do you think they ask? Their DBA of course. I don't work with Forms, but I've seen plenty of Forms questions asked and answered here. There are people here who work with the Oracle Apps,

Re: Re: Which method is more efficient

so GTT's help reducing redo when you do inserts and deletes? but not for deletes? there was a post by tom kyte on dejanews from a few years back where someone asked the redo question and he recommended GTTs. here is the link... did I misread it?

RE: dbms_stats broken

Darrell, I put dbms_stats into production, on 8.1.7.4, over two months ago have not had a problem. Here is what I did to compute the stats automatically. (BTW: this runs under system) create procedure compute_daily_stats is begin for a in (select distinct table_owner from

Export Long Dies with no error

I am running an Oracle 8.1.7 export on a 2G table which contains a Long column. The export runs for several hours and then just dies with no error anywhere. I tried to use direct=y but I get an error about character sets. Any ideas? Thanks! Ron Smith If you are not the intended recipient of

Re: Re: Which method is more efficient

oh it wasnt none, it was cut in half. I skimmed it. my bad From: Richard Foote [EMAIL PROTECTED] Date: 2003/05/29 Thu AM 08:45:46 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Which method is more efficient - Original Message - To: Multiple

RE: dbms_stats broken

I haven't used it, but here is what we are doing: we created a simple package which loops through dba_tab_modifications and finds itself (the same way as oracle would) which tables are stale: where the sum of inserts, updates and deletes is more than 10% of the number of rows, and than run

RE: Diff between 7.x,8,9

You can find the Oracle documentation at technet.oracle.com. This is free, but you must register. Each new version of the Oracle documentation has a section titled New Features. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday,

RE: exp, dbms_stats, RMAN and rollback segments

Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to

Online index creation on 9.2

On 9.2.0.3, I have experienced a problem with online index creation. When creating indexes on what I suppose most would consider to be large tables (with nasty, sharp, pointy teeth and a bad disposition), when Oracle is doing its initial data gathering, sorting, slicing, and dicing in

RE: skip scan index

Thanks, Wolfgang! I really hope to meet both you and Cary one of these days. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 11:05 PM To: Multiple recipients of list ORACLE-L I was about to post the results of my

SQL Loader Concatenate date and time

All Im need to concatenate my log_date and log_time field (the 2 physical records into one logical record). I can find how to do it with a fixed length file but my case is a delimited file. Looking at the docs, it seems the continueif is used for delimited dtaa, I cant seem to get the

RE: is this DBA's only mailing list?

So, that means that our posts may be about the oracle of Delphi, the early leader in the executive decision support area? Idis redibis nunquam in bello peribis. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Naveen Nahata

RE: Which method is more efficient

Jared - Thanks. Wow, I learn a new trick each day on this list! Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 6:15 PM To: Multiple recipients of list ORACLE-L There are easier ways to test redo generation than

RE:

Hi Niall, We´ve already tried this. Anyway , thanks for your help. Antonio Niall Litchfield

10i

Got my first look at the 10i beta last night. I can't tell you much about it except to say that looking at some of the new stuff h ;-) While I'm certain many of the new features will not work perfectly for several releases afterwards, they look very

RE: dbms_stats broken

Lisa, I'm still using Analyze so I have no direct experience with this package. That being said, would the SET_TABLE_STATS work for the partitions that haven't been loaded yet? Mike Hand Polaroid Corp. -Original Message- Sent: Thursday, May 29, 2003 10:46 AM To: Multiple recipients of

RE: [Q] Benchmark rate and ORACLE database?

Oracle doesn't do heavy maths so integer benchmarks should matter the most. My advice is not to rely on standardized benchmarks but to ask the vendor for references and then check those references as step one and then organize a little benchmark of your own that would use typical transaction(s) of

RE: dbms_stats broken

Hi Darrell Kirti - It was late last night when I was looking at this. It seems I should be using GATHER EMPTY instead of GATHER STALE. However this will put statistics on partitions with no rows. When I load new partitions tomorrow (they are empty prior to the daily load), the number of

RE: Function Based Index - Not Used ???

Wow, there sure are a lot of Scott's in India... -Original Message- Sent: Thursday, May 29, 2003 9:30 AM To: Multiple recipients of list ORACLE-L JP, In the EXPLAIN PLAN, it says Card=262146, indicating that the query expects to retrieve over a quarter-million rows. Is that in fact

RE: Problem with TOAD

You will want to repost this to [EMAIL PROTECTED] Many users as well as the TOAD development team are on this list. Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and could try http://www.quest.com/support/ HTH! GL! Rich Rich JesseSystem/Database

RE: [Q] Benchmark rate and ORACLE database?

used to own the process. DEC no longer exists, people do not remember VAXBI, LAT, DECNET, SET HOST, SET DEFAULT, VT220 or even the KED/EDT/EVE editors. DEC hey, i resemble that remark... i even have all my DCL scripts and customizations for edt and eve.;-) -- Bill Shrek Thater

Capacity Planner question

Has anybody used the Capacity Planner (SYSMAN) part of OEM? We are trying to monitor usage of the Application Server, and have the repository set up to do so. However, I can't quite figure out what busy servers means. The number of busy servers is always very low, and doesn't seem to correlate

RE: RE: Which method is more efficient

Yes, I am in archive log mode and I have had 2 occurances of filling up the archive log filesystem, but I don't want to change one problem for another. Bryan -Original Message- Sent: Wednesday, May 28, 2003 3:20 PM To: Multiple recipients of list ORACLE-L have you run it? isnt that

RE: skip scan index

You know, of all the impressive things I've ever heard Cary Millsap say (and there have been a heck of a lot), the one that stands out the most in my memory is a series of quotes from his keynote at the 2003 Hotsos Symposium: An experiment that disproves a conclusion is a success. Knowledge in

Re: Online index creation on 9.2

What are the wait events of the slowed sessions? What is the correspondence with v$session_longops phases for the rebuild? Really, the answer to 75% of the questions in this group is look at v$session_wait. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Stephen Lee

Re: Export Long Dies with no error

Hi, I can't speculate as to why the export dies, but you can correct the direct=y character set error by setting the NLS_LANG variable in your user profile to whatever character set it is trying to export from. -- Joe Frohne Rawson Oaks Consulting http://www.rawsonoaks.com [EMAIL PROTECTED] or

RE: is this DBA's only mailing list?

DBAs only. No trespassing! Trespassers will be shot at. Do not go beyond this point if you're not a DBA. We do not want developers to learn or secrets. That might give them an idea that we're mere mortals. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]

RE: Which method is more efficient

Title: RE: Which method is more efficient Jared, Agreed, but what about the resources needs to find _which_ column changed ?? Would that offset the extra redo generated? Heck, I'd just generate the update statements based on two tables to _only_ update the changed columns. It is pretty

x$bh.dbablk values (repost)

I am reposting this in the hopes that someone can help me with this puzzler. I am working on determining which objects have 'hot blocks'. In two different sessions, I issue select count(*) from random_data where rowid_rownum in (1,2,3); repeatedly to see what happens with the touch count

Re: Unbreakable, my buns. Upgrade to 9.2/w2k

Title: Unbreakable, my buns. Upgrade to 9.2/w2k For my OID testing I decided to go with 9.2.0.3. I installed9.2.0.1 (software only) and the upgraded to 9.2.0.3 with no problems. Since I also documented the process so I will have all the steps down when I will do it in production I did it

RE: dbms_stats broken

Lisa et al, Am I missing something or did someone ever mention that for STALE to work, one needs to set MONITORING on required objects? Straight from the Fine Manual: Enabling Automated Statistics Gathering The GATHER STALE option only gathers statistics for tables that have stale statistics

RMAN - Remote vs Local Backups

Hi, Can anyone think of a reason(s) why oneWOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups upthe

RE: [Q] Benchmark rate and ORACLE database?

Mladen - Excellent points. When someone points out the vendor with the highest benchmark results, I ask Jeff Gordon is a consistent NASCAR winner and he drives a Chevrolet, does this mean that you will be buying a Chevy next?. To me the published benchmark results have about as much to do with

RE: HELP - Microsoft Access error SQLSetConnectAttr failed error.

Title: RE: HELP - Microsoft Access error SQLSetConnectAttr failed error. However, I was able to independently through odbctest and tnsping confirm that the odbc driver working and the alias working through Oracle's Net8. I also noticed with the odbctest that the user had a very small and

RE: lengthy URL's

Someone else told me it was blocked. Personally, I would take it up with my security admin. tinyurl.com simply redirects your browser, it isn't a back door to anything, and has no objectionable content. If a tinyurl url points to a URL that is caught by your firewall, that is an entirely

RE: 10i

Robert - Does this mean we can expect a new book Oracle10i New Features by that respected Oracle author Robert Freeman coincident with the 10i release? I'm ready! Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003

RE: SAP Hands SAP DB over to MySQL

Everybody is under cost pressures these days, right? Recently my boss required that I attend a few webinars hosted by Microsoft to hear their line on TCO because he didn't want the choice of our next platform to be a technical decision (we're on Tru64 unix). I don't think I'll be encouraged to

RE: Which method is more efficient

dunno about that. I was making the assumption that *which* columns changed was already known. This would require testing by someone familiar with the data. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/29/2003 10:24 AM Please respond to ORACLE-L

RE: SAP Hands SAP DB over to MySQL

Dennis, We're making very restricted use of MySql, but a greater use of PostGreSql which has atomic transactions already. I would say the two biggest reasons for converting are $$$ and speed. Otherwise if $$$ are the only consideration go with PostGreSql, it's totally free. MySql

RE: exp, dbms_stats, RMAN and rollback segments

HELP... Has anyone encountered rollback problems while running dbms_stats? -Original Message- Sent: Thursday, May 29, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL

Re: 10i

TEASE! Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: dbms_stats

Hi John, Yes, monitoring was set. I wouldn't see anything in *tab_modifications if monitoring wasn't set. Here's a new twist. What percentage are you comfortable with for valid estimates? I attended a seminar given by Jonathan Lewis a few weeks ago, and he stated that adequate statistics

RE: skip scan index

Title: RE: skip scan index Mladen, Come to Hotsos 2004 ... I can meet you too (unless you are attending 06/09 CTOUG meeting). Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

RE: RE: Which method is more efficient

ok so your goal is not speed. its reducing redo, correct? so you dont care if its slow? try using a global temp table. that may cut down your redo significantly. From: Rodrigues, Bryan [EMAIL PROTECTED] Date: 2003/05/29 Thu PM 12:44:52 EDT To: Multiple recipients of list ORACLE-L [EMAIL

RE: dbms_stats broken

Hi Mike, Yes, I could use it... but the GATHER EMPTY option set stats on the empty partitions correctly. I'm more concerned about having old stats on a partition that is now loaded. Thanks -Original Message- Sent: Thursday, May 29, 2003 12:30 PM To: Multiple recipients of list

RE: 10i

Dennis, What he probable means is the OCP upgrade exam will be just like the first OCP exams, Multiple and expensive... looking at some of the new stuff Ron [EMAIL PROTECTED] 05/29/03 01:24PM Robert - Does this mean we can expect a new book Oracle10i New Features by that respected Oracle

RE: RMAN - Remote vs Local Backups

Just a thought. Possibly to assist in recovery of the database box. If you have a complete media failure on the DB host, you greatly simplify the recovery process if your RMAN database is somewhere safe. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: SAP Hands SAP DB over to MySQL

The incentive? $$$, and lots of it. Larry E talked folks into trusting Oracle at it's inception, and I'll bet it was quite a bit less robust then than MySQL is now. Give MySQL a couple years and see what happens. It may never be appropriate for certain apps, but for small to medium plain

Re: RE: Which method is more efficient

how would you do that? if you dont know which columns have changed values? you would have to compare every column? how else can you do it? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/05/29 Thu PM 01:24:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

RE: exp, dbms_stats, RMAN and rollback segments

A Large Load or Update Before the Exp ... Delyed Block Clean out is one Reason that really pops out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again.

Re: RMAN - Remote vs Local Backups

Well How about if you are performing BCV snapshots of the storage under Box-A (prod server) and then mounting those BCVs on Box-B, mounting (not opening!) the database on Box-B, and performing RMAN backups? That would remove any resource consumption from the all-important Box-A as far as

C++ Issues

I am trying to track this down for a buddy, any ideas, I know nothing about C++. Thanks, Ethan Our application currently has presentation programs written in Microsoft Visual C++ that read Oracle Version 7.3.4

Re: RMAN - Remote vs Local Backups

-w A simple disk crash containing the database and the RMAN data woulf wipe you out. If bax-a crashed you could use box-b to recover your data. Ron [EMAIL PROTECTED] 05/29/03 12:54PM Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database

Re: x$bh.dbablk values (repost)

You are running into the classical problem with monitoring an experiment: To what extent (no pun intended) does the monitoring change the experiment. Referencing dba_extent pulls in the segment headers of all segments owned by 'BCA'. When you interrogate x$bh have nothing else in your sql. Dump

RE: HELP - Microsoft Access error SQLSetConnectAttr failed error.

Need more info: What are you doing when the error occurs? If it's vb code, can you post it? Can you connect from the erroring machine via sql*plus? Can you link a table via the odbc connection open it interactively? Does it make a difference if you define a new odbc data source link through

RE: SAP Hands SAP DB over to MySQL

They don't want the choice to hardware, OS and software to be a technical decision? Why not? TCO is part of technical decision-making, is it not? Sometimes they decide before input from below then try to force a solution on the tech people. In that kind of world, the firm which is best at

RE: skip scan index

Title: RE: skip scan index I just put the Hotsos Symposium 2004 announcement on our web page yesterday. The event will be held March 710 in Dallas. Its early yet, but we already have speaker commitments from Tom Kyte, Jonathan Lewis, Mogens Nørgaard, and me. Well add many more speakers in

RE: skip scan index

Thanks, Pete. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 1:30 PM To: Multiple recipients of list ORACLE-L You know, of all the impressive things I've ever heard Cary Millsap say (and there have been a heck of a

RE: exp, dbms_stats, RMAN and rollback segments

Steve, You may have to dig a little further... What happened to those table(s) in that schema prior to starting the export? Heavy DML, may be? This could be a case of 'delayed block cleanout'. Export triggered the cleanout and wanted to access the rollback segments. If no table data

Tablespace management.

After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as the options for tablespace management. Does anyone have any bad experiences with these? AUTOALLOCATE seems to come up with extents that are much smaller than I want and MANUAL segment management requires the use of

RE: lengthy URL's

[EMAIL PROTECTED] scribbled on the wall in glitter crayon at Thursday, May 29, 2003 2:05 PM: Someone else told me it was blocked. Personally, I would take it up with my security admin. who is the same as my exchange admin. no thanks, his head is still reeling from the last encounter.;-) --

RE: dbms_stats

I wouldn't call 1.4% [ (603826-595500)/603826 ] way wrong. Actually, for a 1% sample I find that pretty good. The problem I found with low sampling percentages is if you have skewed column values. If some values occur very often and others rather seldom, a 1% sample may only encounter the

RE: Which method is more efficient

Jared, That is correct the fields that are changed is known before going to this point. Bryan P.S. I just want to say thank you for all the responses to this question. We are still talking about the issue, but I am thankful for the input. -Original Message- Sent: Thursday, May 29,

RE: is this DBA's only mailing list?

We do not want developers to learn or secrets. That might give them an idea that we're mere mortals. Yeah, I've learned from reading this list that not all DBAs are the super-smart gods they set themselves up to be. Some are actually not too bright, based on things I've seen here. The

RE: skip scan index

Hey, with all that praise being heaped on you for publicizing your wrongness, who would ever want to be right? :-) At 10:51 AM 5/29/2003 -0800, you wrote: Thanks, Pete. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

RE: RMAN - Remote vs Local Backups

Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed RMAN as a high-level feature that would help you manage the backups for large server farms. They emphasized that the catalog was the way to go. With the catalog on another box, if the server was toasted, you

Re: RMAN - Remote vs Local Backups

Sure, several: 1) Centralized backup management, maybe there will eventually be a Box-C which can also be backed up by Box-B. 2) Maybe Box-B is a Veritas master media server or the equivilent with other backup software. 3) Most important: Box-A has a 'crash and burn', you don't lose your RMAN

RE: SAP Hands SAP DB over to MySQL

Thanks, Kip, Jared, Dick - that makes more sense. I now recall that Lawson also ships a free (non-relational) database with its software. Some sites use it for their first year conversion activities (and some much longer). It is much faster than Oracle or the other relational databases. When the

RE: dbms_stats

Lisa, Have a look at ML Note:44961.1 (and maybe Note:114671.1 could also help). The 1% sample may work for larger tables - I am not sure John -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 11:05 AM To: Multiple recipients of list

RE: Tablespace management.

Thomas - Oracle recommended Local and Uniform, so that is what I use for everything. It has worked out great. I even use autoextend and that hasn't bitten me but a couple of times. This is on 8.1.6 and 9.2. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: 10i

I thought the database was going to manage itself! Now I'm disappointed, I thought they were going to implement just one nice big GUI button that does everything. Patrice. -Original Message- Sent: Thursday, May 29, 2003 4:01 PM To: Multiple recipients of list ORACLE-L Dennis, What he

RE: C++ Issues

The executable is looking for the oracle-related variables in registry. Export registry and import it into another box and it will work. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 2:52 PM To: Multiple recipients

RE: dbms_stats

Hi Wolfgang, In the grand scheme of things, that probably isn't awful. However, if the analyze can't get the row count right (how easy is that?) then how can I trust it to get the rest of the statistics correct? Just my two cents. Thanks for your reply. Lisa -Original Message-

RE: is this DBA's only mailing list?

heretic! [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/29/2003 12:31 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: is this DBA's only mailing list? We do not want developers to learn or

RE: 10i

Title: RE: 10i Don't know about manage itself. Is supposed to find its own patches, download them and patch itself! HEY... if it has one big GUI button... and it is a GREEN button (Like SQL Navigator) ... our developers will LOVE it! April Wells Oracle DBA/Oracle Apps DBA Corporate

RE: dbms_stats broken

I looked at bug 1890016 on MetalClink and I'm confused. Did you run ANALYZE COMPUTE before running DBMS_STATS like the bug's test case? I thought this was a no-no??? If so, I'm wondering if it would it help to ANALYZE DELETE then rerun DBMS_STATS w/EMPTY, insert/update/delete test rows, force

Re: SQL Loader Concatenate date and time

Hello Bob, My first thought is to try something like: ... log_date CHAR TO_DATE(:log_date || ' ' || :log_time,'ddMon hh:mi:ss', log_time FILLER char, ... I may not have the syntax just right, and I can't take time to test it until later this evening (shouldn't be reading ORACLE-L now

Re: C++ Issues

Ethan Get him to install the 8.1.7 Client (Programmer) option on the Win2K Visual Studio machines. I noticed some slight source changes needed going from the 7.3.4 Proc*C version...i.e. EXEC SQL DECLARE's are needed everywhere nowbut they should be able to pre-process, compile and link. the

RE: exp, dbms_stats, RMAN and rollback segments

Hi Kirti, Sounds like you have the same suspicions as do we. So far as we know there isn't any heavy duty DML before the export and there isn't any other activity on the schema other than RMAN and DBMS_STATS. We don't understand how RMAN or DBMS_STATS ***could*** be the culprit but we've seen

RE: dbms_stats broken

I haven't read the note yet, but what Rich mentions here may explain why I haven't encountered any problems. I started out testing with copies of prod tables which had no stats at all. So their first stats were gathered with gather_shema_stats. [EMAIL PROTECTED] 05/29/03 03:14PM I looked at

RE: SAP Hands SAP DB over to MySQL

I knew a guy name Dawson who worked for Lawson which was keen on Informix. -Original Message- Sent: Thursday, May 29, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Thanks, Kip, Jared, Dick - that makes more sense. I now recall that Lawson also ships a free (non-relational)

RE: dbms_stats

The answer is as usual it depends. If the table has a reasonably uniform row size and the blocks are approximately evenly utilized, then the analyze can extrapolate the total number of rows fairly accurately even from a small sample. However, if the row size fluctuates wildly, or if the block

RE: is this DBA's only mailing list?

Dave, Promote them to their level of incompetence and then slide them sideways? Ron [EMAIL PROTECTED] 05/29/03 03:31PM We do not want developers to learn or secrets. That might give them an idea that we're mere mortals. Yeah, I've learned from reading this list that not all DBAs are the

  1   2   >