Perf Advice Needed: cache buffers chains, high waits, _db_block_hash_buckets

2002-02-27 Thread James Manning
db_block_buffers = 360448 db_block_lru_latches = 4 db_block_size = 8192 _db_block_hash_buckets = 720896 Ok, what I have so far is: - using itrprof, I saw that 35% of my elapsed time was based on waits of "cache buffers chains" latches. - checking v$latch_children (latch#=66), there are a good

IMPORTING a dump from a different system

2002-02-27 Thread Gavin D'mello
Hi All, I just got a dump file from Oracle 8i on an AIX system and was trying to import it in Oracle 8i on a Suse Linux System, but got the error 'IMP-00016: required character set conversion (type 46 to 871) not supported'. Can you help me out ? I know it has to do with the NLS_LA

RE: HP-UX Oracle Install

2002-02-27 Thread Ayyappan S
Hi   u can mount the NFS in the Unix machine and use the Spare disk. After mounting it u can install and do all the oracle stuff without any problems.     Ayyappan.S DBA This communication contains information, w

RE: itrprof broken?

2002-02-27 Thread K Gopalakrishnan
James, Cary Millsap's Hotsos also does the same profiling. But that is a paid service. Have a look at http://www.hotsos.com for more details. I have just sent a mail to Dan about the broken links in his site. Will let you know once I get some more info from him. Best Regards, K Gopalakrishnan

Re: HP-UX Oracle Install

2002-02-27 Thread Peter . McLarty
Hi As long as you don't have issues with having data files mounted remotely ie you have a pretty robust network between the server this shouldn't be a problem just clearly mark/document  the directories that you use on the server that you mount file systems from as sometimes clever sysadmins dele

Re: Importing SQL 7.0 tables

2002-02-27 Thread Jared Still
SQL*Loader can generate the sequence values. Hit the docs to find out, as I don't recall how to do it. Jared On Wednesday 27 February 2002 19:58, you wrote: > Thanks Suhen and Jared, > > Suppose SQL table consists of 3 columns, > and Oracle table consists of 4 columns. > > The first oracle c

RE: Problem running a report

2002-02-27 Thread hemantchitale
If the report was creating a large output file on the client (remote) PC, that would explain the waits on SQL*Net message from client. [the client would be SQL*Plus or Reports on the PC]. Depending on the network latency, the perceived runtime of the report can vary between sites. Does the repor

Re: Importing SQL 7.0 tables

2002-02-27 Thread Ferry Situmorang
Thanks Suhen and Jared, Suppose SQL table consists of 3 columns, and Oracle table consists of 4 columns. The first oracle column was Primary Key (Mandatory) that will get value from sequence.nextval. How to fill the value for Oracle databases Mandatory columns that comes from SEQUENCE VALUE on

HP-UX Oracle Install

2002-02-27 Thread Sujatha Madan
Hi, This may be more of a UNIX question, so please bear with me. We have a "test" server that has 1GB free space. We need to test our Oracle and application upgrade and there are no other servers other than this "test" server. Obviously there is not enough space. The powers above want to use tw

Re: RMAN with TSM on AIX

2002-02-27 Thread chao_ping

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Rachel Carmichael
you might want to consider rerunning the export then --- [EMAIL PROTECTED] wrote: > > That's fine Rachel, > > > > I agree with you . But the problem is that when I do the import , > import > > goes fine till the first split file and it hangs only at a > particular > > position. I am doubting th

RE: address parse

2002-02-27 Thread Larry Elkins
A product that sounds similar, PostalSoft from FirstLogic, was used on a project I was involved with. We didn't use it for the parsing out of the data, simply used to verify and clean addresses that were entered by data entry folks (Forms 5.0 and later 6i web deployed app using ORA_FFI to invoke t

RE: ORA-00379: no free buffers ... ???

2002-02-27 Thread Khedr, Waleed
I think you have to change some parameter in init.ora to set the 8k block buffers count. DB_8K_CACHE_SIZE Waleed -Original Message- Sent: Wednesday, February 27, 2002 6:49 PM To: Multiple recipients of list ORACLE-L Hi, I'm using 9i enterprise edition on Win2000. Here is what I got

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Deepender . Gupta
That's fine Rachel, > > I agree with you . But the problem is that when I do the import , import > goes fine till the first split file and it hangs only at a particular > position. I am doubting that when It switch from one split file to the > second split file it gives error. meaning which some

ORA-00379: no free buffers ... ???

2002-02-27 Thread Leslie Lu
Hi, I'm using 9i enterprise edition on Win2000. Here is what I got: SQL> select * from dba_data_files; ERROR: ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K I increased the db_block_buffers from 800 to 2000, but still have this error. The db_block_size is 4096.

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Rachel Carmichael
logfile is so you can SEE the results of the import if file1 file2 file3 are the names of the files you created with the split and export then you use those. for example, suppose the files you created were named firstexportfile and secondexportfile and you want to record the output of the import

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Post, Ethan
Maybe not the best advice. The job market is a bit rough at the moment. If you have a job I suggest keeping it unless you have a sure thing lined up. Ethan -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 4:26 PM To: Multiple recipients of list ORACLE-L

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Deepender . Gupta
Hi Rachel, Thanks for the reply but can you explain "substitute the filenames you need for and the other files" I have tried with the cat file1 file2 file3 | zcat > /home/oracle/dkg/imp/imp_pipe & also. I think the log file name doesn't have any meaning. Regds deepender

Re:RE: RE: Manager decrees "his" data warehouse design. Hel

2002-02-27 Thread dgoulet
S.A.M.E, Stripe And Mirror Everything. It's a concept that came from an individual at Oracle with a significant pile of alphabet soup after his name who has lost most of his credibility anywhere. He was speaking though of Network Attached Storage (NAS) stuff where you really don't have to worr

Re: Total Extents

2002-02-27 Thread Rajesh . Rao
How about counting rows from uet$? I have not tried it. Raj "Post, Ethan"

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Mohammad Rafiq
try to remove recordlength param and retry... Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 27 Feb 2002 14:02:12 -0800 Hi All, The compressed dump export file size of my database is more than 2 gb and my OS file size limitati

Re:RE: RE: Manager decrees "his" data warehouse design. Hel

2002-02-27 Thread dgoulet
Any query against an empty table always FLIES!! Dick Goulet Reply Separator Author: April Wells <[EMAIL PROTECTED]> Date: 2/27/2002 11:43 AM How much do you charge an hour? They want to build a table with 980 columns, because the queries fly if yo

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Rachel Carmichael
what did you use to do the IMPORT? this is what I've used on sun solaris after doing a similar export. you'll need to substitute the filenames you need for and the other files #!/bin/sh mkfifo wrkpipe umask 000 # # start the reader from the import pipe # imp "/" file=wrkpipe full=y commit=y bu

Re[2]:RE: Manager decrees "his" data warehouse design. Help

2002-02-27 Thread dgoulet
I don't know about questioning the design, it's more like questioning the sanity of the duhveloper. It's one of those more basic requirements. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 11:31 AM I think the column limit i

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Scott . Shafer
Run, don't walk. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: Don [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 27, 2002 12:48 AM > To: Multiple recipients of list ORA

itrprof broken?

2002-02-27 Thread James Manning
Does itrprof seem broken for anyone else? trace files I analyzed with it yesterday are failing now, and even tiny files aren't working: 500 Servlet Exception java.lang.OutOfMemoryError <> Their link for asking questions is 404'd right now: http://www.unal-bilisim.com/qa/discus/

Total Extents

2002-02-27 Thread Post, Ethan
Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Ne

RE: ORA-01000: maximum open cursors exceeded

2002-02-27 Thread Craig Munday
Title: RE: ORA-01000: maximum open cursors exceeded Sam, That sounds like a huge number of cursors, does the Java application really have 7500 cursors open at any one time?  I too have found that some Java applications have required a large number of open cursors but this is only because the

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jared . Still
Well, you know the saying, SAME is LAME. Let's just forget all this database crap. Use a humongous flat file, get yourself the GNU version of grep with the Boyer-Moore search algorithm, add cut, paste and awk. Who needs an RDBMS anyway? As for disks getting faster, in the words of James Morl

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Rachel Carmichael
Stripe And Mirror Everything --- Michael Cupp <[EMAIL PROTECTED]> wrote: > S.A.M.E.? > > -Original Message- > Sent: Wednesday, February 27, 2002 3:48 PM > To: Multiple recipients of list ORACLE-L > > > At one of the Oracle Application group meetings it was stated that it > is better to

Import from a dump which was split and compressed while export.

2002-02-27 Thread Deepender . Gupta
Hi All, The compressed dump export file size of my database is more than 2 gb and my OS file size limitation is 2 Gb so I compressed and split it into two parts while export. While export I got is "export terminated successfully without warning" but at the time of import,

RE: Users reading from rollback segments

2002-02-27 Thread Gupta, Brijesh
Here is the Query you are looking for. set lines 132 set pages 30 col rr heading 'RB Segment' format a18 col os heading 'OS User' format a10 col te heading 'Terminal' format a10 col sid format 9 col spid format 99 select r.name "ROLLBACK SEG", s.sid, s.serial#, s.username,osuser,START

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread April Wells
rows and columns... you know... like Excel. -Original Message- Sent: Wednesday, February 27, 2002 2:28 PM To: Multiple recipients of list ORACLE-L What is the meaning of "relational" in "relational database" again? Good grief. Regards, Patrice Boivin Systems Analyst (Oracle Certified

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Bellows, Bambi
Relational. Adjective. Of, or relating to, relatives. Generally pertaining to mandatory dinners or inane conversations regarding politics, religion, sex, money or military service. Of necessity, the tables are denormalized, that is, all semblance to normalcy is rejected, especially when discussing

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Michael Cupp
S.A.M.E.? -Original Message- Sent: Wednesday, February 27, 2002 3:48 PM To: Multiple recipients of list ORACLE-L At one of the Oracle Application group meetings it was stated that it is better to have large tables and forget normalization. Disks are getting faster and you can read a l

SNP0...SNPx Memory Hogs

2002-02-27 Thread Jack C. Applewhite
8.1.7.2.5 under Win2k Server I just discovered that my four SNP processes were sitting around, doing no work, taking up about 500MB of RAM. Is this normal? In Task Manager, the Oracle process was showing to be using about 1.4GB. After I issued "Alter System Set Job_Queue_Processes=0" it shrank

RE: Import placing data into wrong tablespace

2002-02-27 Thread Rajesh . Rao
The export dump will have the create table definition with the tablespace DATA. You have two ways to go about it: 1. Precreate the tables in the tablespace ENVTST_DATA and then perform the import with the ignore=Y. 2. Ensure user that not have any quota on DATA tablespace, enuf quota on ENVTST_

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Ron Rogers
At one of the Oracle Application group meetings it was stated that it is better to have large tables and forget normalization. Disks are getting faster and you can read a lot more data from one disk reather that getting your data from many disk locations. Also it doesn't really matter the size of

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Boivin, Patrice J
What is the meaning of "relational" in "relational database" again? Good grief. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services--

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jared . Still
Star schemas with bitmap indexes are pretty fast. Heck, even a single table with lots of bitmap indexes is pretty fast. That's what I'm doing now as an interims solution for one group until we can come up with a proper DW initiative. But I don't think I would care to rebuild 980 bitmap indexes

RE: Import placing data into wrong tablespace

2002-02-27 Thread Rachel Carmichael
ENVTST doesn't need unlimited tablespace, because SYSTEM has unlimited tablespace --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > ENVTST with unlimited tablespace, quota on DATA ??? > > - Kirti > > -Original Message- > Sent: Wednesday, February 27, 2002 12:20 PM > To: Multiple re

RE: Import placing data into wrong tablespace

2002-02-27 Thread Mohammad Rafiq
This may be due to when tables were created originally they were created with tablespace data..Export captures that defination and try to create it in that tablespace while import I have seen this behaviour recently while importing full dump of 8.1.6.3 to 8.1.7.2 and system stuff were crea

RE: Upgrade directly to 8.1.7.3?

2002-02-27 Thread Cunningham, Gerald
Hi Barabara, The wording is a bit clumsy, isn't it? I would think you'd be fine since you're not really applying a patch, you've already got the binaries in place. The 4th digit is just bug fixes, the upgrade scripts (catalog.sql, catproc.sql, catrep.sql, etc. should be the same across all 8.1.7

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Nelson Flores
Title: RE: Manager decrees "his" data warehouse design. Help! wow .. now my place of work seems oh so normal !! kinda boring really ... Nelson Flores Project Manager [EMAIL PROTECTED] - Information Technology Center http:

RE: Upgrade directly to 8.1.7.3?

2002-02-27 Thread Hand, Michael T
Barq, ;) I've been bouncing up and down through the 8.1.7 patches on Tru64, and have just backed out the 8.1.7.3 patch (to 8172(1)) because of bug 2220597, so I have a suggestion to avoid an addtional code tree. Deinstall the 8172 code then reinstall 817, migrate the production database, then ap

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Ji, Richard
www.kx.com -Original Message- Sent: Wednesday, February 27, 2002 2:38 PM To: Multiple recipients of list ORACLE-L By taking all the joins out I think they mean basically forcing Oracle to store the row data in the same blocks since you changes the rows to columns or some such. I saw a

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Bellows, Bambi
Also not uncommon when tracking medical data. Bambi. -Original Message- Sent: Wednesday, February 27, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Some of the tables in J.D. Edwards OneWorld have over 200 columns, VARCHAR is not used, only NUMBER and CHAR. Makes for some wide

Re: Users reading from rollback segments

2002-02-27 Thread Diego Cutrone
Jeremiah : What I meant was that the delayed_logging_block_cleanouts parameter (=FALSE) will make the next reader of the block to cleanout that block. Now, if this parameter's value is TRUE (default in Oracle 7 and 8.0) the next reader will NOT clean out the block (it will read the rollba

RE: Import placing data into wrong tablespace

2002-02-27 Thread Magaliff, Bill
ENVTST had the role RESOURCE, which includes UNLIMITED TABLESPACE on all tablespaces. Revoked that and granted unlimited tablespace on ENVTST_DATA and all seems to work. thanks -Original Message- Sent: Wed, February 27, 2002 1:58 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subjec

RE: Import placing data into wrong tablespace

2002-02-27 Thread Hand, Michael T
Bill, The default is to import objects back into the tablespace from which they were exported. Your surest bet is to create empty tables in the appropriate tablespace (by editing the imp/indexfile), then import the date. Mike Hand Polaroid Corp. -Original Message- Sent: Wednesday, Febr

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Post, Ethan
Some of the tables in J.D. Edwards OneWorld have over 200 columns, VARCHAR is not used, only NUMBER and CHAR. Makes for some wide tables. This product was originally some type of flat file database. Ethan -Original Message- Sent: Wednesday, February 27, 2002 1:28 PM To: Multiple reci

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Post, Ethan
By taking all the joins out I think they mean basically forcing Oracle to store the row data in the same blocks since you changes the rows to columns or some such. I saw a database out there a while back promoted by Joe Celko called KillerDB that does this but the data is still stored in rows.

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread April Wells
How much do you charge an hour? They want to build a table with 980 columns, because the queries fly if you index it heavily. It won't load... the indexes won't build from load to load if you drop them... but the QUERIES... they JUST F*L*Y! -Original Message- Sent: Wednesday, February 2

Re: Users reading from rollback segments

2002-02-27 Thread Jeremiah Wilton
The delayed_logging_block_cleanouts parameter does not force or suppress cleanouts. It just makes any cleanouts that do occur get logged as redo entries. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 27 Feb 2002, Diego Cutrone wrote: > Hi Glenn and list: > > "As you mention

RE: moving from unix to NT

2002-02-27 Thread Farnsworth, Dave
Jared, please point me in the right direction. I have used Perl for scripting odd procedures on Unix and NT. I would like to use it in Oracle also. Thanks, Dave -Original Message- Sent: Wednesday, February 27, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Perl is *much* m

Re:RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jared . Still
I think the column limit is now closer to 1000, but like you, I can't imagine willingly designing a table with a column count exceeding 2 digits. More than 15 or 20 and I start to question the design. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/27/02 10:58 AM Please respond to O

Re: Users reading from rollback segments

2002-02-27 Thread Diego Cutrone
Hi Glenn and list: "As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit)." If you're under Oracle 7 or 8.0, I think that you could set

RE: Import placing data into wrong tablespace

2002-02-27 Thread Deshpande, Kirti
ENVTST with unlimited tablespace, quota on DATA ??? - Kirti -Original Message- Sent: Wednesday, February 27, 2002 12:20 PM To: Multiple recipients of list ORACLE-L I have a user ENVTST with a default tablespace ENVTST_DATA. I have a user ENVTPA with a default tablespace DATA. I exp

Re:RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread dgoulet
I seem to remember reading somewhere that there can be a maximum of 255 columns in a table. Never created a table with half that many before. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/27/2002 10:28 AM April, I sincerely hope yo

RE: Oracle learning network v Oracle CBT-Select

2002-02-27 Thread Karniotis, Stephen
OPP stands for Oracle Partner Program. It is for ISV, System Integrators, Software Vendors, etc. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Mes

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jared . Still
April, I sincerely hope you're being facetious with the statement that "queries run so much faster if you take all the joins out" 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you

RE: moving from unix to NT

2002-02-27 Thread Jared . Still
Perl is *much* more flexible than UTL_FILE for flat file operations. There is simply no basis for comparison. The question in your case is this: Can you easily replace the PL/SQL procedures that are using UTL_FILE with a process that runs outside of the database? If so, myself and others on th

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Bellows, Bambi
Both. I was a consultant to this pharmaceutical company at the time and I honestly liked the job that I was doing, so I stuck it out. After I got over the initial shock of having an insane boss, I found the whole thing amusing. Seems he didn't trust the data center with cables for some weird re

RE: OS authenticated from Outside Domain/Firewall: PLS. IGNORE

2002-02-27 Thread George Hofilena
Please ignore this for now. I think I've found something. George -Original Message- Sent: Wednesday, February 27, 2002 10:15 AM To: LazyDBA.com Discussion We have a jsmith account that is OS authenticated in our TEST database. This account also exists in server X which is outside our

Import placing data into wrong tablespace

2002-02-27 Thread Magaliff, Bill
I have a user ENVTST with a default tablespace ENVTST_DATA. I have a user ENVTPA with a default tablespace DATA. I export user ENVTPA as SYSTEM, and then try to import into ENVTST schema, also as SYSTEM. Data is going into DATA tablespace, not ENVTST_DATA tablespace. Any ideas? Thanks -- P

OS authenticated from Outside Domain/Firewall

2002-02-27 Thread George Hofilena
We have a jsmith account that is OS authenticated in our TEST database. This account also exists in server X which is outside our domain and protected by a firewall. We've set up our firewall to allow Oracle connections to our TEST database to get through. This setup works fine. One day jsmith l

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Orr, Steve
Hi Bambi, > I once had a manager who was a paranoid schizophrenic. BEEN THERE! A former boss from hell got very angry (there's a reason they call it "mad") because he tried to fire me and found out he couldn't. Even so, he liked having me around because he needed me. I hung in there because th

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Boivin, Patrice J
Try Win98Lite, I doubt you can make it fit under 64K though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, February 27, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Subject:Re: Manager decrees "his" data wareh

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Boivin, Patrice J
Oracle Discoverer? Users could poke around with that, without knowing SQL. They won't be very quick about it though. I don't know the context, why did management come up with this scenario, is there a history behind all this? Sounds a bit strange to try to impose an impossible situation that ju

Re: Bug, tuning issue or bad sql?

2002-02-27 Thread dmeng
Ed - Sounds like you hit bug 1331849. Check Metalink for more info. Dennis "Ed"

Re: Bug, tuning issue or bad sql?

2002-02-27 Thread Anjo Kolk
Bug. Ed wrote: > Oracle 8.1.6.0 NT 4.0 > > I'm having a problem with a query which is basically just a bunch of UNION > ALL's that I want sorted in a certain way. The query runs flawlessly when I > limit the result set with a where clause, but when I remove it, the query > crashes when sorting

RMAN with TSM on AIX

2002-02-27 Thread Yahoo
Hi Gurus,Any body got any experience using TSM 4.2 on AIX 4.3.2 with RMAN?Any hints/suggestions will be most welcome.

Re: Oracle learning network v Oracle CBT-Select

2002-02-27 Thread James Manning
[Erik Williams] > What is OPP? http://otn.oracle.com/partners/oraclepartnerprogram.html -- James Manning <[EMAIL PROTECTED]> GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET:

RE: Bug, tuning issue or bad sql?

2002-02-27 Thread Jesse, Rich
Wow. Are you using CURSOR_SHARING=FORCE in your init.ora by any chance? We've had sporadic problems with that while CBO is on. Also, what does the explain plan look like? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, S

Re[2]: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread dgoulet
I've had a similar, although not identical situation some couple of years ago that never fully corrected itself. The CIO wanted a data warehouse & employed a math specialist with some database experience to handle it. My biggest problem was this toad went and got an OCP certificate just from rea

Re: Old Chestnut: Tablespace Fragmentation

2002-02-27 Thread Bill Buchan
Thanks to everyone for their comments on this. You've convinced me. I'll go away and worry about something else instead now! - Bill. At 04:43 27/02/02 -0800, you wrote: >I know this one has been done to death: use uniform extents to avoid >fragmentation; multiple extents don't hurt (wit

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Bellows, Bambi
I once had a manager who was a paranoid schizophrenic. Very exciting, let me tell you. But, one thing he told me in a rather roundabout paranoid way is that the way you deal with crazy bosses who were out to get you is to make friends with other people at your boss' level in the organization, ho

RE: Oracle learning network v Oracle CBT-Select

2002-02-27 Thread Hayes, Scott
In Canada we call it Ontario Provincial Police. > SELECT * FROM users WHERE clue > 0 0 rows returned What is OPP? > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 27, 2002 9:13 AM > To: Multiple recipients of list ORACLE-L > Subj

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Orr, Steve
> I call it a data repository. I call it a data suppository... Because nobody wants it after you've stuffed in a dark place. :-) -Original Message- Sent: Wednesday, February 27, 2002 9:08 AM To: Multiple recipients of list ORACLE-L We Have the same issue here. Large Tables , loade

Upgrade directly to 8.1.7.3?

2002-02-27 Thread Baker, Barbara
Solaris 2.6 Oracle 8.0.5 --> Oracle 8.1 --> Oracle 8.1.7.3 I have a Solaris box with a test and a production database. I have 2 code trees: 8.0.5, and 8.1.7 patched up to level 8.1.7.2. With Oracle's blessing (really, I opened a tar), I upgraded the test database directly from 8.0.5 to the 8.1

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jamadagni, Rajendra
Hmmm ... in an old project we had a manager with similar ideas... his ideas of design were, what should I say? 'revolutionary'? We finally named his design technique as 'Rainfall Design' because the ideas would come down like a heavy rainfall and then drain away immediately when logic was applied.

Bug, tuning issue or bad sql?

2002-02-27 Thread Ed
Oracle 8.1.6.0 NT 4.0 I'm having a problem with a query which is basically just a bunch of UNION ALL's that I want sorted in a certain way. The query runs flawlessly when I limit the result set with a where clause, but when I remove it, the query crashes when sorting (in the order by at the far

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Deshpande, Kirti
Buy him the 'Oracle8i For Dummies' as your departing gift, and suggest that he does this himself... Heck, if he can "design" it, let him have the privilege of "building" it as well :) Good Luck... - Kirti -Original Message- Sent: Wednesday, February 27, 2002 1:48 AM To: Multiple recip

Re: Old Chestnut: Tablespace Fragmentation

2002-02-27 Thread Edward Shevtsov
Bill, I believe in that case your query will spend most time on data transfer and the percent of seeking time will be tiny provided that number of extents is reasonable. One thing to note: sizes of extents should be multiple of db_file_multiblock_read_count in order to minimize number of I/O o

Re: Old Chestnut: Tablespace Fragmentation

2002-02-27 Thread Edward Shevtsov
Bill, I believe in that case your query will spend most time on data transfer and the percent of seeking time will be tiny provided that number of extents is reasonable. One thing to note: sizes of extents should be multiple of db_file_multiblock_read_count in order to minimize number of I/O o

RE: UPGRADATION

2002-02-27 Thread Ball, Terry
I wanted to do this at my last job. I called WWS and was told it was their best recommendation to put it in a new home. They would not support installing into the old home and if you have problems, you are on your own. Terry -Original Message- Sent: Tuesday, February 26, 2002 3:03 PM T

RE: Oracle learning network v Oracle CBT-Select

2002-02-27 Thread Erik Williams
What is OPP? > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 27, 2002 9:13 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle learning network v Oracle CBT-Select > > OLN is free for OPP members however, you n

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread אדר יחיאל
The boss is NOT always right but he is always the BOSS. Murphy said: If they want it bad (in 24 hours) they will get it bad. Let the guy have whatever he wants, just be sure to document his requests. Don't you want to get advanced after they fire HIM :-) Yechiel Adar, Mehish Computer Services

RE: Re[2]: address parse

2002-02-27 Thread Babich , Sergey
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread johnm9563
We Have the same issue here. Large Tables , loaded nightly But nobody uses them. Management calls it a Datawarehouse, I call it a data repository. Can a cusotmer find out what they need. NOPE Document your findings, to C.Y.A. Good Luck --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > When I wa

RE: Old Chestnut: Tablespace Fragmentation

2002-02-27 Thread Mercadante, Thomas F
Bill, It sounds like you are describing an ideal situation. Is this scan being done by only one user at a time? Then you are describing a dedicated database to one user? Lets face it, the above is not even remotely probable in todays world. And furthur, if you decided that the above setup is

RE: RETURNING clause

2002-02-27 Thread Babich , Sergey
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex

RE: Old Chestnut: Tablespace Fragmentation

2002-02-27 Thread DENNIS WILLIAMS
Bill - My Tech. Service Manager keeps reminding me that "disk isn't so simple anymore". You are probably on RAID for the higher read performance. Now your file is broken across several disks. Of course, to get the straight read, the controller can't service anyone else's requests while your scan c

Re: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Rachel Carmichael
You have this decree in writing? Okay, once you get that. Do what he wants, making sure everyone knows that this great new database design and application are all his idea (do this with a smile, with enthusiasm if you can manage it) hang on and wait for it all to fall apart. Otherwise, do yo

RE: Need some white papers on replication

2002-02-27 Thread Michael Cupp
What person? What address? Employed Where? If it's an unknown address, not in your system, etc then how did you get the msg? ;) -Original Message- Sent: Wednesday, February 27, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Unknown address, This address isn't in our system.

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Farnsworth, Dave
Your damager should be committed in the nearest mental institution ASAP. The guy is a moron. -Original Message- Sent: Wednesday, February 27, 2002 8:28 AM To: Multiple recipients of list ORACLE-L 1. Run, don't walk, to monster.com. 2. Update and print resume 3. Enjoy vacation (hopefu

RE: Old Chestnut: Tablespace Fragmentation

2002-02-27 Thread Babich , Sergey
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex

RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Orr, Steve
When I was consulting at a particular client, I saw the effects of this "approach" after the fact. Massive amounts of data were loaded into tables that were never accessed except to load data because the users couldn't do anything with it. Later it was thought that to fix this all they had to do w

RE: HUGE numbers is V$SYSTAT

2002-02-27 Thread Babich , Sergey
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex

Re: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread ltiu
Point #6 - I did not know Win98 can run under 64k RAM. Tell your Boss he needs at least 16MB RAM for Win98 : > > 6 - all users will be trained to use MS Access to get at "their" > data. (These are users that were just converted off from "green screen" > teminals within the last 45-days, to W

  1   2   >