Re: converting to the cost based optimizer
We will be in the same process soon. We'll have to consolidate over 100 instances to something between 40-60 instances and switch from RBO to CBO. Any tips are welcome. --- Steve McClure [EMAIL PROTECTED] a écrit : I am just starting to look at converting to the cost based optimizer, and am hoping a few of you can share insights from having done so in the past. Our application is an oltp system developed on 7.3.4. We made liberal use of +0 and other RBO hints, and I am wondering if these are going to cause us troubles when switching to CBO. We have been on 8i since April of this year, and I am just now starting to gather information on the inner workings of the CBO. I know it is where I want to be, I am just looking to see how painful/painless the transition will be. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: OT: Informix Training for Oracle DBAs
I just went to the DB2 UDB fast track for experienced DBA at IBM. If it's 4 days then it should be fine. Our course was only 2 days and we asked so much questions that we only saw two third of the topics (and we had done overtime). As usual, it depends a lot on who is giving the course. --- Gene Sais [EMAIL PROTECTED] a écrit : I just inherited responsibility for a set of informix databases. Has anyone taken the Informix Training for Oracle DBAs, 4 day crash course given by IBM Informix and was it worth it? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Cognos Reporting Tool
On DW project, we have used Cognos Impromptu and Powerplay tool in 1998-1999. We used the client-server version as Powerplay for the web was a tool bought from another company and was not quite integrated with the other Cognos products. The main drawback were that the Powerplay part to build the cubes was not scaling when using a multi-cpu box. There was no framework to guide the end-users with all the cubes we were producing. We had to develop one. Beside that, Cognos offer good products. In 2001-2002, when working at a different client, the team selecting the reporting tool for the datawarehouse choose Business Objects saying that Cognos did not even make it to the short list. The runner-up was Brio --- Rodd Holman [EMAIL PROTECTED] a écrit : Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: OT: Getting data out of DB2...any DB2 DBAs out there?
Beside Oracle, we have db2 mainframe and db2 udb on aix. I've asked asomeone working with DB2 mainframe and there is spufi which is like sqlplus and DB2 Interactive wich is more like the command center on db2 udb. I'll more details tomorrow. --- Thomas Day [EMAIL PROTECTED] a écrit : I used to use SPUFI (SP?) with TSO/MVS but that was many years ago. I would hope that there's something better. Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowycc: @fcg.comSubject: OT: Getting data out of DB2...any DB2 DBAs out there? Sent by: root 11/13/2002 02:15 PM Please respond to ORACLE-L Off topic post, please delete if not interested. I am trying to get data out of a DB2 database that I do not have access to. The original spec called for me to create a flat file, which they parse, and query the DB2 DB to get the specific requested data, and spool the requested data into a flat file, which is then FTPed back to me. I would prefer to send them (in Oracle/UNIX terms) a shell script calling SQL*Plus that uses some SQL to get the data I need, which is spooled to a flat file. Since this is on MVS, I assume it will have to be some SQL wrapped in JCL. I just do not know of an equivilent SQL*Plus in DB2, since I don't even know how to spell DB2. Since I will be proposing this approach, I was hoping to have an example JCL job in my proposal. So I was wondering if anyone has some example jobs that they would be willing to share? Many thanks!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: ORA-04030 Out of Process memory
How big was the OS process ? Monitor what the process is doing, any memory allocation in a loop ? I had this error once and it was an Oracle bug (804 on hpux 10.20), Oracle was having a problem releasing memory so after 100 000 calls of a function the process was crashing (ora-4030) because it was reaching the OS memory limit (700M) . --- Satyendra K Khare [EMAIL PROTECTED] a écrit : Please give some suggestions how to avoid this problem, it comes after 3 to 4 hours when i run a process through form, and it terminates then i have to down the database and up again to restart that procedure.. ORA-04030 Out of Process memory when trying to allocate 528 Bytes (call heap , user umc) ORA-06512 at OBJ.PS_MATCH, Line 1298 ORA-06512 at line 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satyendra K Khare INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Data Purging Strategy
Burnt mud ??? You're supposed to say peaty ! Or you could have said : Classic Glenmorangie, matured for 10 years in American white oak then finished in Sherry Butts. Light gold in colour, this product has a complex aroma full bodied, sherry wine notes with traces of honey. Sherry and nuts are both apparent in the flavour and these produce a warm, long lasting after taste. --- Steve McClure [EMAIL PROTECTED] a écrit : Sherry Finish? I thought you liked scotch that tasted like burnt mud? -Original Message- [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 10:55 AM To: Multiple recipients of list ORACLE-L That reminds me: Mark, your annual stipend is due. Make it a case of Glenmorangie this time, Sherry finish. :) Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2002 07:56 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Purging Strategy Hey Dennis, Mark Leith is the only person on this list allowed to mention 3rd party products. I am sure he bought the franchise from Jared :) John -Original Message- Sent: 06 November 2002 14:15 To: Multiple recipients of list ORACLE-L Prem - You are receiving some excellent advice from Tom and Tim. I would mention two items in addition: - If you ever hope to re-use the data you archive off-line, you must also archive all the related tables, because after all, this is a RELATIONAL database. - PrincetonSoftech has a product Active Archiving that looks pretty good from the demos I've seen. I haven't used it myself. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 06, 2002 6:54 AM To: Multiple recipients of list ORACLE-L Prem, I would re-visit the requirement. Why do you feel the need to delete the data from the database? What is the purpose for this type of requirement? It would be far easier to modify the requirement than to do what you are thinking of doing. Adding columns to database tables indicating that a record has passed it's retention policy and thus, is not included in queries, would be a much easier solution. Or, simply moving these records to historical tables in the database - and NOT deleting them from the system - is a much better solution. The data is always accessible and not available in the current tables. And you will not be playing the get the data from tape and reload it game with all of it's problems (writing an offload program, table structure changes offload program versions). Try and keep this as simple as possible. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, November 06, 2002 4:13 AM To: Multiple recipients of list ORACLE-L Dear List, I need some inputs from you all regarding purging data from the database. This is the requirement We define a retention period for all the data in the system. When the retention period is reached, the data should be deleted, but then at a later time, some user might request for this purged data. So it must be possible to retrieve this data. This is the strategy we have designed for this. When the retention period is reached, move the data from the main database to an offline database. Then delete the data from the main database. In the offline database, we cannot again keep it from long, so it has to moved to tapes. Now my question, how can we move this data to tapes and at the same time retrieve data from the tapes based on dates. i.e, the user will ask for the data on a particular date, so it must be possible to retrieve data from the tapes based on a date and load it to the database tables. Regards Prem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: 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
Re: question on data warehouse tools by oracle
It's nice to recommend but since you do not seems to really know the Oracle product how will you convince the managers to spend at least in the six figures (US money) ? Do you have any criterias ? Just to choose a reporting tool we had over 40 criterias that each companies had to to answer and that was to get on the short list. Oracle 9i, the partitionning option is needed in almost all DW (I do know clients doing data mining) Oracle Warehouse builder is the ETL and its in the developper suite Oracle 9i Reports Oracle 9i AS (that includes Oracle Portal I think) Discoverer will be needed Oracle Designer to design and manage all the deliverables Also, you might use Advanced queuing to organize the different jobs, the OEM pack can also help depending on the DBA. I do not remember if discoverer is bundled with the 9iAS. Last year I was in a biotech company that had that setup : all Oracle. Also, they had bought CDM, the Oracle meyhodology. Big big bucks !!! --- Rahul [EMAIL PROTECTED] a écrit : list, i'm in the process of recommending Oracle as a completel solution for a ;large data warehouse (for a central bank) . After doing thru some of the documentation on OTN ..i have the following info on the products i would need. Please comment if i'm missing something - 9i database (with data mining option ?? wil this help ?) - Oracle warehouse builder (is this the GUI to develope the ETL procedures etc ???) - Oracle 9i reports - 9i App server( portal, reports server) to deploy and distribute the reports - discoverer( required ?? ) (..do i realy require the following??? ) - OLAP - express server / analyzer TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Queues - does anyone use them
Last year I was in a biotech company and all the systems (around 8) were communicating with Advanced Queuing. All systems werre on 817 and one in 901. The systems were in fact a pipeline producing data at the beginning , refining it along the way and putting it in a warehouse at the end. I do not recall backup problems, rman was used. --- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] a écrit : Hi, I've sent a couple of questions on queues and got no answers - that's fine and I understand we're all busy. What I'm wondering though is whether anyone is actually using Oracle queues at all? Any feedback would be appreciated. For anyone out there who does use Advanced queues: one of our developers read that Creating a queue table in a tablespace will disable that particular tablespace for point-in-time recovery. - Do you normally put your AQ tables in a separate tablespace (we're currently looking at doing just that)? - Who normally owns the queues and queue tables - system or the application schema. Thanks, Bruce Reardon mailto:bruce.reardon;comalco.riotinto.com.au -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Limitations of table partitioning.
Can you be more precise. --- [EMAIL PROTECTED] a écrit : Hello What are the limitations of partitioning a table in Oracle. Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Adhoc queries and limiting the amount of records queried...
Oracle, DB2 UDB and Sql Server --- Igor Neyman [EMAIL PROTECTED] a écrit : Ruth, Are you in the same boat, dealing with both: Oracle and SQL Server? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 7:48 AM That's a great tip! I never know that. Thanks! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:58 PM Adhoc queries and limiting the amount of records queried...In SQL Server: set rowcount some_number before running the query does the same thing as oracle's ROWNUM in where clause. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: Grabowy, Chris To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 2:29 PM Subject: Adhoc queries and limiting the amount of records queried... I just wanted to ping the list to see what other people have done to control or constrain adhoc query users??? We have a group that is struggling with the adhoc query piece that's in production. Some of the users end up firing off insane queries. The group is trying to find a way to limit the amount of records queried for, so that a wild query doesn't hose the database. Appending a ROWNUM to the WHERE clause is one idea. Using USER PROFILEs is another. Any other thoughts?? Dare I ask.this custom app also runs on SQL Server, so SQL Server ideas would also be appreciated. Many thanks!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Table Design
Have you done a conceptual data model ? Do all transactions have the same properties ? Do you have established any performance requirements ? Do you favor insert or read ? If the 10 transaction type have the same properties I would definitively put them in one table. If your tests show that there is a performance problem you can use the partitionning option (needs the enterprise edition and $$$) then its transparent to your design. Splitting in 10 tables have the following drawback : - what if there is a new transaction type ? - have fun reporting on more than a transaction type ! - what if a transaction was inserted with the wrong transaction type ? (insert/delete) --- [EMAIL PROTECTED] a écrit : Hello We are doing database design for a project. We have 10 distinct transactions types and the total number of records is expected to be around 5,00,000 taking all transactions together.We have normalised the tables and decided to store all of them together in a single table identified by the transaction type and other unique fields. We would like to know which option would be the best so that we can retrieve data most efficiently Option-1. Maintain 10 different tables for each transaction type (i.e 50 records will be split among 10 tables) Option-2 Store all of them together in a single table identified by the transaction type and other unique fields. Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Table Size
The best way to calculate the size of a table is to load it with 1000 production data rows. Then calculate the size of the predicted volume. You should be able to handle the first year of data at day 1. Do not loose time to calculate the table size at the byte level with formulas. For the temp tablespace, it depends on your application needs. You should be able to rebuild all objects successfully. As for the rollback segment tablespace, then again it depends on your application and number of users. Do not forget space for exports, backups, workspace, at least 2 versions of Oracle software, ... I just went to a DB2 fast track for experienced DBA. According to IBM, the total size for the DB environment is 4 times the size of the data in the DB. (DB2 uses a lot of temporary files outside the DB). --- [EMAIL PROTECTED] a écrit : Dear List, I am using Oracle 9i database. I need to identify the space requirements for our database for the production database. Can anybody suggest how to calculate the size of a table. and also additionally how to calculate the size of the whole database.? Regards Prem = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: [Q] what kind of documents shoud contractor provide to me before project end?
The list of documents should have been established before the contract was signed. A professionnal contractor would have told you that. The contractor must follow your methodology and give you the same documents as your internal IT teams. On the DBA side, you should expect : database architecture, logical data model, physical data model, naming convention, backup and recovery guide, security guide, a benchmarking document (if some benchmarking was done). --- dist cash [EMAIL PROTECTED] a écrit : We have a application use ORACLE 8.1.6 and Forms 6i. This project going to finish soon. Can anyone tell me what kind of documents should contractor provide to us before they leave? Thanks. _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: will the Return Order of rows change with time ?
When doing many select you should have the same order but this is not guaranteed by Oracle. The only official guaranty is to use an order by. After an export/import or a move, you have the risk that the rows will not be in the same order. How big is the table ? There is no unique id for the customer ? --- Ratnesh Kumar Singh [EMAIL PROTECTED] a écrit : Hi I have a very large DW table in which there are only inserts and NO updates/deletes. The table grows by around 2-5 % every week due to new inserts. I need to return the rows for each customer in the same order as inserted to table. Due to design/delivery constraints , i cannot modify the table. ques 1 : if i do a 'select * from table' with where clause but no order by clause, will the Order of rows returned be the same whenever this query is executed ? Is this gauranteed by Oracle ? ques 2 : if i export/import this table , then execute the same query, will the Order of rows returned be the same as before the export/import ? ques 3 : if i use the 'move' cmd to rebuild this table , then execute my query, will the Order of rows returned be the same as before the rebuild ? any explanations are most welcome many thanks ratnesh singh - Ratnesh Kumar Singh Sr. Software Engineer Patni Computer Systems Ltd TTC Mahape , Navi Mumbai Work : (91 22) 7611090/110/128/350 Ext. 2107/2106 Home : (91 22) 8662162 http://www.patni.com World-Wide Partnerships. World-Class Solutions. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
OT : Anybody using Silverrun data modelisation tool ?
Hi, We're using Silverrun RDM 2.7.2 There is a conceptual/logical data model for all the entities of the project. I must create the physical data model for the first phase and I will have to create the physical data models for the next phases also. Should I create a brand new model in a separate file or should I create the physical data model in a sub-schema of the conceptual model ? What if we want to keep different images (in time) of a data model ? Thanks. = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: services on windows?????
It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
ETL architecture
Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: ETL architecture
Almost all ETl tool are using odbc for their development environment but once you're running in batch mode they used the native driver of the source/target databases. --- Mandar A. Ghosalkar [EMAIL PROTECTED] a écrit : and how are they going to connect to the database on server B? are they using odbc? millions of inserts using odbc over the network? -Original Message- From: paquette stephane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Subject: ETL architecture Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: ETL architecture
Thanks. According to the proof of concept team, it seems to still be a problem. The product do not seem to handle any return code from the database processes. Still investigating. --- Frank Pettinato [EMAIL PROTECTED] a écrit : Stephane, We used this approach (albiet on Windows) back in 97-98. We processed ETL from about 300 different customers including several large ones with files 50MB weekly. We saw very good performance from the tool. If I had to pick a problem with this tool it would be the ability to detect errors and stop processing or use some type of exception handling. This was a few years ago, so it may have gotten better since then. Hope this helps, Frank -Original Message- stephane Sent: Wednesday, October 16, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Frank Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: ETL architecture
I've never see that approach. Last spring, I've worked at a rich client where there was 23 Oracle consultants and Oracle Warehouse Builder was installed on several servers instead of being installed in a central fashion. I agree that the ETL tool should drive the whole show. As for the network between the servers I think it's 100 megabits. --- [EMAIL PROTECTED] a écrit : This is a common approach. Should be ok if: * transporting the ftp files is part of the ETL process * big fat pipe to the servers. Jared paquette stephane [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ETL architecture Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: SQL Joins vs Sub Queries vs Cursors
Usually sub-queries are not the fastest way to do things. When a developper is talking about doing things using cursors the big red light flashes : ho ho 3gl thinking ahead ! The only way to know for sure is to test them. Do not just check the elapsed time. I've tested 2 scenarios once and they were taking the same time but one was having twice the buffer gets than the other one. --- VIVEK_SHARMA [EMAIL PROTECTED] a écrit : Which is best Joins vs. Sub Queries vs. Cursors if all options are possible in a given situation? from a performance perspective) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: ## Keeping Skills Current
This is quite a challenge. This mailing list is one way to keep up with the pace of technology. Sometimes I'm asking myself how come people have time to post so many messages on the list. Dan Fink has very good answers. Check on the guru's web site. Buy and read a book from times to times. Choose a subject and present it to others. You will learn a lot on that subject (or the others will booo you). I'm reading on this list each day even if I'll be working 90% of my time on DB2 for the next year. I do not want to loose the Oracle stuff I've struggle to learn in so many years. --- Warkentien, Stephen [EMAIL PROTECTED] a écrit : I am looking for suggestions on how to brush up my skills and continue learning on a regular basis. Large blocks of free time are hard to come by, but if I had only 30 minutes (or an hour) a day, what would you recommend? Thanks to all. Stephen Warkentien ...OLE_Obj... Senior Database Administrator Northrop Grumman Information Technology 5500 Canoga Avenue M/S W91 Woodland Hills CA 91367-6698 818-715-2860 voice 818-715-2617 FAX mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Warkentien, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Warehouse design: snowflake vs star schemas
Snowflake is often used because people still want to normalize (and save some disk space !) which is not the way to go to ease query. If you do an hybrid data model, your loading will be easier as you will have less problems to solve. I agrre with you, the complexity comes from the number of sources and their quality. But, from experience, at my last job, the DW has designed an hybrid data model to ease the ETL processes. Let me tell you that the querying and reporting was painful and slow. We have redesign it in a more formal star schema and we had some real challenges to load the DW. On the current project, we have 15 sources (excel, cobol, Oracle, Clipper, DB2/MVS, Nomad,... ) we are doing a prototype with an ETL, we will have fun ! It is feasible just to have a date column in the fact table. That's what they had done at the previous job. I do not recommend that. If you carefully do the analysis, you'll see that the users want to manage all kind of special events like season, national day, F1 racing (in Montreal, a beer company is checking if beer is more sold during the week-end Grand Prix). Also, often the fiscal year do not match the calendar year. So there is plenty stuff you may want to track with the time dimension. Using a generated key or the date value as the key is a good question. On the theoritical side you should use a generated key. I've used a date field without problem. --- Alexandre Gorbatchev [EMAIL PROTECTED] a écrit : Stéphane, Thanks for response. I have always discplined myself to use star schema and never snowflake. Would you mind asking why? The Which one is easier to implement and easier ETL ? is not a good question as your data model should not be design for the ETL procecess but only for the querying. I mean ETL to load data _INTO_ data warehouse. Of course, complexity is mostly determined by sources, but still I'd like to know if there is any general influence by DW's data model. Another question. Is it feasible to make date dimension or just use date column? For example, Oracle Discoverer can work with date columns using hierarchies Y-M-D and similar. What is faster: separate table for date dimension or date column? If I go with date dimension table should I use date column as a foreign key in fact table or use some artificial key? TIA, Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Warehouse design: snowflake vs star schemas
Data modeling in a datawarehouse is there to ease and make querying faster. I have always discplined myself to use star schema and never snowflake. The Which one is easier to implement and easier ETL ? is not a good question as your data model should not be design for the ETL procecess but only for the querying. Oracle star transformation join technique is designed to handle star schema. HTH --- Alexandre Gorbatchev [EMAIL PROTECTED] a écrit : Dear Data Warehouse Experts, Could you please share you experience with snowflake and star data models. How do you choose between them? What problems may arise? Is star schema preferred for Oracle? What is users' experience with those schemas? Which one they like more and why? Which one is easier to implement and easier ETL? Are there other patterns for DW? I would like to check/confirm/change my possibly subjective point of view to more objective perspective. I would appreciate your thoughts or links where I can review practical conclusions. TIA, Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Cost of joins
It depends on what you're doing. The use of a join technique over another depend on how much data you need to access. If you read very few information from both tables then a nested loop is the fastest way to get data. To use a nested join at a cheap cost you need a good index on the outer table. On the other hand, if your query output contained allmost all data from both tables than an hash join or a sort merge is better than a nested loop. If you're in a DW and have data organized with dimension and fact tables than the optimiser should be using star transformation. --- Leonard, George [EMAIL PROTECTED] a écrit : Hi there Can someone please give me in order of preference/cost the relevant costs for the different joins. IE: This join is cheap, This is very expensive, This is bad and always avoid. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
TNS-00510: Internal limit restriction exceeded
HI all We had those messages yesterday in the listener.log file TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Also on the unix side, we had a message about the OS that can not fork a new process. This is on 8172 32bits/AIX 4.3.3 The sga is 1.7G, the server has 8G of ram. There is between 150 and 300 users connected. The init.ora process parameter is set to 425. The unix number of process allowed is set to 500. I've check on metalink, but found nothing that we do not already do. Any ideas ? Thanks = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Restrict certain database access using 3rd party tools.
In homemade applications, by default users have a role with read only, in the applications we change the default role that allows insert, update, delete. I've not tested this scenario but how about if, in a database logon trigger, you check the v$process.program field then depending of that value you may be able to change the user default's role. Should work on 8i using dedicated connection. --- [EMAIL PROTECTED] a écrit : Hi All, We have users that have OPS$ accounts that have full DML privs when they run forms application via citrix. Currently they do not have sqlplus,etc. There is a requirement that some can have sqlplus,toad,etc. I know you can set up security for sqlplus,etc using product_user_profile but is there a way to allow only SELECT when using a 3rd party tool such as TOAD. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Restrict certain database access using 3rd party tools.
Oups ! you're right. --- Kevin Lange [EMAIL PROTECTED] a écrit : Except for the fact that they could always change the program name that they are running to match what you need. Then that security is bypassed. -Original Message- Sent: Thursday, October 03, 2002 11:08 AM To: Multiple recipients of list ORACLE-L In homemade applications, by default users have a role with read only, in the applications we change the default role that allows insert, update, delete. I've not tested this scenario but how about if, in a database logon trigger, you check the v$process.program field then depending of that value you may be able to change the user default's role. Should work on 8i using dedicated connection. --- [EMAIL PROTECTED] a écrit : Hi All, We have users that have OPS$ accounts that have full DML privs when they run forms application via citrix. Currently they do not have sqlplus,etc. There is a requirement that some can have sqlplus,toad,etc. I know you can set up security for sqlplus,etc using product_user_profile but is there a way to allow only SELECT when using a 3rd party tool such as TOAD. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Dark side of the force
Thanks. I do not think so as DB2 was chosen because we'll be implementing Siebel (and Siebel is recommanding DB2). They're should be 2 DB2 databases, one for Siebel and one for the staging area as 8 different data sources will be loaded in Siebel. So I hope RPG won't fit in ;-) --- Farnsworth, Dave [EMAIL PROTECTED] a écrit : Try this one for DB2. So do you have to deal with a bunch of RPG programmers for DB2? www.idug.org Dave -Original Message- Sent: Tuesday, October 01, 2002 10:03 PM To: Multiple recipients of list ORACLE-L Hi all, I'll be seeing the dark side of the force as I'll be the DBA on a DB2 UDB project. Is there a list like this one for DB2 ? Any links to DB2 stuff ? I'd be interested in documents showing the differences/similarities between Oracle and DB2 UDB. Let's see our bargaining power with our Oracle rep once DB2 is in our Oracle shop (over 100 instances) = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: logon trigger
Hi, Use dynamic SQL (execute imediate). Also, consider placing your code into a stored proc called by the trigger. --- George Leonard (ZA) [EMAIL PROTECTED] a écrit : Hi guys I am trying to create the following trigger. The user in question is logging in using siebel application and siebel does not allow multiple SQL statements during login so we through this might solve the problem. My problem now is though, the set rollback works but the alter session statements does not seem to want to work. The server needs to be in RBO since this is the only mode supported by siebel. Help appreciated. create or replace trigger smload.logon after logon on database begin SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01; Alter session enable parallel query; Alter session set SORT_AREA_SIZE = 10485760; Alter session set OPTIMIZER_MODE = choose; end; / George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! *** This message contains information intended solely for the addressee, which is confidential or private in nature and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message or any file attached to this message. Any such unauthorised use is prohibited and may be unlawful. If you have received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the original message from your machine. Furthermore, the information contained in this message, and any attachments thereto, is for information purposes only and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of Dimension Data (South Africa) (Proprietary) Limited or its subsidiaries and associated companies (Dimension Data). Dimension Data therefore does not accept liability for any claims, loss or damages of whatsoever nature, arising as a result of the reliance on such information by anyone. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information transmitted electronically and to preserve the confidentiality thereof, Dimension Data accepts no liability or responsibility whatsoever if information or data is, for whatsoever reason, incorrect, corrupted or does not reach its intended destination. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Data modeling question about reference table
Hi, We're discussing on reference table. One containing everything (using a type) or one per entity. We'll have a lot of entities. This is for a staging area where data will be validate before going in Siebel. In theory, this staging will become a very big staging for a datarehouse and still in theory there is no plan yet that that staging will be available to the users as an ODS. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Dark side of the force
Hi all, I'll be seeing the dark side of the force as I'll be the DBA on a DB2 UDB project. Is there a list like this one for DB2 ? Any links to DB2 stuff ? I'd be interested in documents showing the differences/similarities between Oracle and DB2 UDB. Let's see our bargaining power with our Oracle rep once DB2 is in our Oracle shop (over 100 instances) = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Can I do this in Oracle 8i?
Your update is updating all rows in table1. Is that what you want ? nologging only works with direct path insert, not with update. --- Gurelei [EMAIL PROTECTED] a écrit : Hi. I want to update a table based on data in another table. Something like: update table1 a set f1 = (select f2 from table2 where table2.f3 = table1.f3 and table2.f4 = table1.f4); this seems to work, but generates a lot of redo logs. So I tried to add NOLOGGING. Alas, seems like NOLOGGING and alias don't tolerate each other. I haven't been able to run an Update with both alias and NOLOGGING. Is that something that Oracle restricts or did I not try hard enough? Any suggestions? TIA Gene __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Best Practice - Partitioned object, one partition per tablespace,
That's the way I've done it. It let's you drop a partition and drop the tablespace so nothing is left. --- Freeman, Robert [EMAIL PROTECTED] a écrit : We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Another datafile sizing question
It's late at night maybe that's why I do not understand your answer but I do not see the link between LMT and the number/size of datafiles. One reason of multiple datafiles id to spread IO but since nowadays a majority of sites goes on huge disk box using raid 5 (that's what we have, the unix guys are the IT master here) multiple files is less meaningful. What I liked is a file politics where you restrained the number of file size. Here we have from 15M up to 8.5G file size with all the possibility in between. I'm trying to standardize all that. Another factor to consider is backup and recovery. Restoring a 10G file will take more time than a 2G file. In your case, if file placement is not possible than go for a 800M file and use a second one for the future growth. -- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Darren - My advice would be to read up on Locally Managed Tablespaces (LMT) and uniform extents. This is a new feature that will ease your management work. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 6:43 PM To: Multiple recipients of list ORACLE-L I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application certifications. I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to create a 800mb datafile and move all the data into it, The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile. Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ? Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administratorusing 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?
I'm not sure either as I am rereading a document by Craig Shallamaher where he is saying to change pctused and pctfree in order to reduce data block fragmentation. I have to test that. At my new job, the DBAs are doing massive export/import to reduce fragmentation... (with their dictionnary managed tablespace) --- Jared Still [EMAIL PROTECTED] a écrit : Are you sure about that John? On Tuesday 24 September 2002 04:28, [EMAIL PROTECTED] wrote: No, it is not retrospective. You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?
Jared, So, that means that to remedy a case of data block fragmentation we just need to increase the pctused for the fragmented tables. Of course, things won't change as fast as an export/import but it's certainly less work to do. --- [EMAIL PROTECTED] a écrit : John, Someone asked a question a month or so ago about changing PCTUSED and PCTFREE: When do the blocks go back on the free list, when the 'ALTER TABLE ... PCTFREE N' command was issued, or did the blocks go back on the free list when the next insert was issued. I don't remember what my conclusion was, and IIRC, it wasn't definite. But, testing shows that blocks do go back on the free list when PCTUSED is increased to a a value greater than the amount of data in the block. This was on 8.1.7 on Linux. It's in the archives if you care to look for it. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend that if a table is fully loaded upto its pctfree/pctused limits and there are no available blocks on the freelist then by changing the pctfree/pctused values no additional blocks will suddenly appear on the freelist. I do agree however that if a block is amended by having a row deleted or a row updated then the new values come into play and the blockcould then be available on the freelist. I think I am correct on this but as with anything I am always ready to be proved wrong - it has happened before and wil lhappen may times in the future John -Original Message- Sent: 24 September 2002 15:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Are you sure about that John? On Tuesday 24 September 2002 04:28, [EMAIL PROTECTED] wrote: No, it is not retrospective. You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?
John, You are right, I just find out note 1029850.6 on metalink : A block is relinked to a free list if after DELETE or UPDATE operations, the percentage of the used space falls below PCTUSED. --- [EMAIL PROTECTED] a écrit : Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend that if a table is fully loaded upto its pctfree/pctused limits and there are no available blocks on the freelist then by changing the pctfree/pctused values no additional blocks will suddenly appear on the freelist. I do agree however that if a block is amended by having a row deleted or a row updated then the new values come into play and the blockcould then be available on the freelist. I think I am correct on this but as with anything I am always ready to be proved wrong - it has happened before and wil lhappen may times in the future John -Original Message- Sent: 24 September 2002 15:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Are you sure about that John? On Tuesday 24 September 2002 04:28, [EMAIL PROTECTED] wrote: No, it is not retrospective. You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Using Log Miner across all DB
Hi all, First post since I begin a new job. All my DBA contacts have played with Log Miner but none of them have deployed it in a production environment. We want to set up LogMiner to be used across all production DB (25+ db on Oracle 817). The way I'm seeing this is the following : - All db with a utl_file dir to create the dictionnary - There is a central location (DB and OS repository) to investigate, where we will copy the dictionnary and the redo/archived files (all file names contain the instance name so they're unique) - I've developed a package to simplify the dbms_logmnr procedures for the other DBA I've seen posts on Metalink where people where loding the v$logmnr_contents in a homemade table to speed up queries. Anybody recreating the dictionnary with a cron job ? Any comments ? TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Using Log Miner across all DB : problem with using parameters default
Hi, In a test procedure I'm using successfully the default feature for a parameter : create or replace procedure testp1 (p1 in varchar2 := null) is begin if (p1 is null) then dbms_output.put_line('il est null'); else dbms_output.put_line('il est pas null'); end if; end; / The load_file is defined as procedure load_file (p_file1 in varchar2 default null, p_file2 in varchar2 default null, p_file3 in varchar2 default null) is Now, I'm trying the same thing in a procedure that is in a package and I kept getting PLS-00306: wrong number or types of arguments in call to 'LOAD_FILE' DHMS.WORLD:spaquetteexec upkg_miner.load_file('dhms_log2a.dbf') BEGIN upkg_miner.load_file('dhms_log2a.dbf'); END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'LOAD_FILE' ORA-06550: line 1, column 7: PL/SQL: Statement ignored What am I missing ? ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: ALLOCATION_TYPE USER or SYSTEM for a Locally Managed Tablespace ?
I'm not sure I understand what you exactly want but here is what I do/believe. Since 815 and up to 817, I use LMT with uniform extent size. I kept the number of extents by objects below 100. On a 8K block size, you should not have more than 505 extents for an object because that's the number of extent adresses Oracle can keep in a block (in the segment header). Yes, object fragmentation is as bad with LMT than dictionnary managed tablespaces. You do not want blocks to be half empty, in both cases Oracle will have more worked to do (read more blocks) to read the data. HTH --- VIVEK_SHARMA [EMAIL PROTECTED] a écrit : Missed your Point Can u explain ? NO MIN_EXTENTS Set at Tablespace OR Object Level when migrating from Dict to LMT Does Excessive Fragmentaion of Objects in Locally Managed Tablesspaces have a Performance Overhead OR does it have only a Space overhead ? Thanks -Original Message- Sent: Tuesday, September 24, 2002 1:33 AM To: Multiple recipients of list ORACLE-L Tablespace ? Even though you control the extents with USER, the underlying concept is still usage of bits (typically 5 x blocksize, unless you already had MINIMUM EXTENT set on the tspace before migration from dict=lmt). Thus, probably (assuming you don't want to use uniform), an auto-allocate policy is best to limit the possible damage from fragmenation (ie lost space) hth connor --- VIVEK_SHARMA [EMAIL PROTECTED] wrote: Qs In sys.dba_tablespaces , Which is Better , ALLOCATION_TYPE USER OR SYSTEM with EXTENT_MANAGEMENT being LOCAL for Both Cases ? For Objects Existing in Locally managed Tablespaces having ALLOCATION_TYPE SYSTEM , NEXT_EXTENT has NO Value But EXTENTS has Values . Qs Can Large Numbers of Extents in a Locally Managed Tablespace Cause a Performance Overhead ? We Convert the ALLOCATION_TYPE from SYTEM to USER to Allow us to Control the NEXT_EXTENT Size Manually This is Done by Running the Following 2 Commands on the respective Locally managed Tablespace execute dbms_space_admin.tablespace_migrate_from_local('TBLSPC1'); execute dbms_space_admin.tablespace_migrate_to_local('TBLSPC1'); Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: drop tablespace including contents
I had one experience with an ERP, since then I'm avoiding those contract. Developping a system is so much more interesting in my point of view. Unfortunately there is more and more ERP sold :-( --- Brooks, Russ [EMAIL PROTECTED] a écrit : Yeah, that's what I do too. I just wish it wouldn't clobber the stats on the indices after I've so carefully gathered them. We have the 6.2 sapdba, so I don't think it's using dbastatc as much to control when and how it does the stats. Russ -Original Message- Sent: Wednesday, August 21, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Ironically, analyzing tables is one of the jobs I leave up to SAPDBA. There are a number of tables that shouldn't be analyzed, ( ~150 on my system ) and the system knows which ones they are. Just schedule the job through transaction DB13 and forget about it. Jared paquette stephane [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/20/2002 09:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:drop tablespace including contents At one client, one team was using SAP without a DBA, only the SAP administrator using SAPDBA. They were having poor performance. After 2-3 days they came to see me, after 5 minutes I told them that 4000 tables out of 16 000 were having no statistics at all. They analyzed during the weekend and performance was pretty good --- [EMAIL PROTECTED] a écrit : Dick, There is absolutely *nothing* that SAPDBA does that a reasonably knowledgeable DBA can't do from his of her favorite toolset. ( vi, Perl and sqlplus for me :) SAP types have it drummed into their heads that the only proper way to do anything DBA work is via SAPDBA. I refuse to use it, and it just drives the SAP consultants crazy. There are many cases where a good DBA can do a much better job than SAPDBA. The tablespace reorganization is a good example. Trying to 'drop tablespace including contents' with 3500 tables is not a terribly bright way of going about it. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/20/2002 02:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:drop tablespace including contents Russ, Your high usage of RBS was due to the updates being done to the system data dictionary. Since you were dropping a tablespace and contents the DDL statements for the individual objects (tables and indexes) needs to be done first, but I've a funny idea from practice that Oracle does not do an implicit commit in this case but instead holds on till the end. This makes dropping a tablespace with the including contents caviot very nasty. Thank GOD we never implemented SAP over here. I've heard nothing but bad about SAP and sapdba. Dick Goulet Reply Separator Author: Brooks; Russ [EMAIL PROTECTED] Date: 8/20/2002 11:13 AM Hi, This past weekend we experienced a problem on a production database, and I would like to try to determine what went wrong, how to avoid it in the future, and any better ways of dealing with it should it be encountered again. After moving some large objects out of tablespace to spread I/O, we wanted to reorganize the old tablespace to remove some fragmentation. The tool we were using, sapdba, does not readily permit you to drop the individual tables between the export and the drop tablespace including contents. Since the tablespace had over 3500 tables the drop tablespace was expected to take a long time. We also defined a large rollback segment for use this weekend, although with only maxextents of 100. When Oracle tried to allocate the 101 extent in the RBS, error messages were issued and things came to a grinding halt. sar indicated disk I/O to the new RBS, but not to any of the datafiles. We waited several hours, but the situation did not appear to change. Shutdown immediate did not work. We could alter the datafiles back online, but not the tablespace. Since it was production, the decision was made to restore to a recent backup. 1. Was the rollback activity due solely to storing and restoring DDL for the tables and indices? 2. Once the RBS was unable to extend, was the drop tablespace including contents dead? We tried to alter maxextents on the RBS, but did not get a response from === message truncated === = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED
Re:drop tablespace including contents
At one client, one team was using SAP without a DBA, only the SAP administrator using SAPDBA. They were having poor performance. After 2-3 days they came to see me, after 5 minutes I told them that 4000 tables out of 16 000 were having no statistics at all. They analyzed during the weekend and performance was pretty good --- [EMAIL PROTECTED] a écrit : Dick, There is absolutely *nothing* that SAPDBA does that a reasonably knowledgeable DBA can't do from his of her favorite toolset. ( vi, Perl and sqlplus for me :) SAP types have it drummed into their heads that the only proper way to do anything DBA work is via SAPDBA. I refuse to use it, and it just drives the SAP consultants crazy. There are many cases where a good DBA can do a much better job than SAPDBA. The tablespace reorganization is a good example. Trying to 'drop tablespace including contents' with 3500 tables is not a terribly bright way of going about it. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/20/2002 02:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:drop tablespace including contents Russ, Your high usage of RBS was due to the updates being done to the system data dictionary. Since you were dropping a tablespace and contents the DDL statements for the individual objects (tables and indexes) needs to be done first, but I've a funny idea from practice that Oracle does not do an implicit commit in this case but instead holds on till the end. This makes dropping a tablespace with the including contents caviot very nasty. Thank GOD we never implemented SAP over here. I've heard nothing but bad about SAP and sapdba. Dick Goulet Reply Separator Author: Brooks; Russ [EMAIL PROTECTED] Date: 8/20/2002 11:13 AM Hi, This past weekend we experienced a problem on a production database, and I would like to try to determine what went wrong, how to avoid it in the future, and any better ways of dealing with it should it be encountered again. After moving some large objects out of tablespace to spread I/O, we wanted to reorganize the old tablespace to remove some fragmentation. The tool we were using, sapdba, does not readily permit you to drop the individual tables between the export and the drop tablespace including contents. Since the tablespace had over 3500 tables the drop tablespace was expected to take a long time. We also defined a large rollback segment for use this weekend, although with only maxextents of 100. When Oracle tried to allocate the 101 extent in the RBS, error messages were issued and things came to a grinding halt. sar indicated disk I/O to the new RBS, but not to any of the datafiles. We waited several hours, but the situation did not appear to change. Shutdown immediate did not work. We could alter the datafiles back online, but not the tablespace. Since it was production, the decision was made to restore to a recent backup. 1. Was the rollback activity due solely to storing and restoring DDL for the tables and indices? 2. Once the RBS was unable to extend, was the drop tablespace including contents dead? We tried to alter maxextents on the RBS, but did not get a response from the system. Was that the appropriate reaction to this problem. 3. A join of v$session and v$sql did not indicate any active SQL. How should we have monitored the progress of what we assume was rollback activity? Any way to estimate how much or how long the rollback would take? 4. If the database were shutdown during the rollback I assume the rollback would recommence when Oracle came back up. Would it start where it left off or start from scratch. It was my impression that it is marking the header blocks as it goes, but I would like to check. Thanks, Russ Brooks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4807.2300 name=GENERATOR/HEAD BODY DIVHi, BRThis past weekend we experienced a problem on a production database, and I would like to try to determine what went wrong, how to avoid it in the future, and any better ways of dealing with it should it be encountered again. BRAfter moving some large objects out of tablespace to spread I/O, we wanted to reorganize the old tablespace to remove some fragmentation. The tool we were using, sapdba, does not readily permit you to drop the individual tables between the export and the drop tablespace including contents. Since the tablespace had over 3500 tables the drop tablespace was expected to take a long time. We also defined a large rollback segment for use this
Re: WG: Re: Data Warehouse on Windows
Hi, Sure that Sybase has not all the nice features Oracle has but I'm a bit surprised that you find it way too slow, do you have Sybase 12.5 ? 12.5 has interesting new features compare to 11.9 version. 20 users doing ad hoc queries ... I supposed you have a tool like Business Objects or Cognos and you're hiding the tables behind a user layer. Some typical queries involve joining 2 tables each holding 2 Million rows. Are you using dimensionnal modeling ? You can have a dimension with a million lines but it's very rare. Have you built aggregates ? The only good way to speed up queries in a DW is to pre-calculate the data. Have you investigate to see what is the bottleneck in your application ? Depending on it you may or may not solve it by using Oracle DW features : partitionnning, star join, ,... HTH --- Sackwitz, Antje [EMAIL PROTECTED] a écrit : Hi, Stephane, actually we have the database running on Sybase but there it is way too slow ( as I told everyone here before). The application has about 25 small and about 10 large tables. Data comes in every night about 100-250MB. We have just about 20 users doing 'ad hoc' queries to the database via a commercial tool. At the moment we have a test installation running on an IBM computer having 2 processors a 2Ghz, 2 Gig RAM. Some typical queries involove joing 2 tables each holding 2Million rows. Test situation will represent data warehouse after being 3 years in production. Well, now the query takes about 15-20 Mintues which is too slow for our sales people. I calculated, the machine scans about 80-1Mio rows per second. I thought, there are a lot of tuning possibilites in Oracle that are not available in Sybase. Our system can run on both RDBMS. So as we are buying a new machine for our database test environment I thought I better find out which is best equipment for Oracle as I expect people to learn that Sybase is not your number one when you go for a fdata warehouse. Overall we calculated, that we add new muodules over next couple of years so finally DW will hold 20 Gig data. Windows is chosen as sales folk here says Windows machines are a lot cheaper than UNIX and the commercial tool needs some server processes available not for Linux Any further recommendations? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Cognos-unix???
I've install Cognos tools on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? --- karthikeyan S [EMAIL PROTECTED] a écrit : Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Cognos-unix???
At the time, we didn't get a better performance on unix than on windows because the tool was not able to use more than one cpu. I hope that the current version can take advantage of multiple cpu. --- Vergara, Michael (TEM) [EMAIL PROTECTED] a écrit : We moved away from the Cognos-on-UNIX because of limitations in the tool. Plus, believe it or not, Cognos on Windoze is a LOT faster. Just my 2¢ worth... Mike -Original Message- Sent: Friday, August 16, 2002 9:49 AM To: Multiple recipients of list ORACLE-L I've install Cognos tools on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: OT: Looking for Contacts in GTA
Why leave beautiful Montreal for a place where everything close at 1 o'clock ? ;-) --- David Hill [EMAIL PROTECTED] a écrit : Hi Guys I was just wondering if anybody could help me and send me some contacts or head hunter's in GTA. I'm currently Working in Montreal and am looking to move to Toronto. I'm a DBA with 3 years experience and am in desperate need of a new challenge. Any help would be greatly appreciated. Thanks David Hill DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Data Warehouse on Windows
In a datawarehouse you want to exploit parallelism as much as possible. So you'd better with many processors and independant mount points. As raid 5 is very popular because it's cheaper, you will probably put your data on raid5 but fight to put your redo on non raid 5 disk. Do you have a good idea of the architecture ? Will you load the data daoly, weekly, monthly ? You may end up with a design where the database is non archivelog and allmost all the loads are done in direct path with nologging , then putting the redo on raid5 is less important. --- Sackwitz, Antje [EMAIL PROTECTED] a écrit : Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Rolling sums (?)
He's on 8.0.5, Analytic functions are only available in 8.1.x. --- Connor McDonald [EMAIL PROTECTED] a écrit : Take a look at the windowing functions under 'ana;ytic functions' in the data warehouse guide...They are very very cool.. hth connor --- Jack van Zanen [EMAIL PROTECTED] wrote: Maybe having a bad hairday but following code will give me for every period number the sum of all work in progress for the period plus the previous 12 periods. Basically it takes the period number from the current record and sums a column of that record with the previous 12 periods. year period value 2000 1 1 2000 2 2 2000 3 3 2000 4 4 2000 5 5 2000 6 6 2000 7 7 2000 8 8 2000 9 9 2000 1010 2000 1111 2000 1212 2001 1 13 2001 2 14 2001 3 15 So for period 2001 1 I need the values 1 thru 13 added together (91) Period 2001 2 needs to be the values 2 thru 14 added together (104) etc As you maybe can imagine the explain plan for this baby is 4 full tablescans on quite large tables. (see below) My question is if somebody has a better solution to handle this query? Oracle 8.0.5 !!! AIX 4.3.3 SELECT V1.ENGAGEMENT , V1.YEAR , V1.PERIOD , MAX(V1.NET_FEE_EARNED_PTD) , MAX(V1.EXP_WIP_VAL_PTD) , SUM(V2.TIME_WIP_VAL) , MAX(V1.GNRL_WON) , MAX(V1.GNRL_WOFF) , MAX(V1.TIME_WOFF) , MAX(V1.WIP_PROV) , MAX(V1.EXP_WOFF) , MAX(V1.DB_WOFF) , MAX(V1.DB_PROV) FROM ( selectmax(WSTAT.ENG_NUMB) AS ENGAGEMENT, max(WSTAT.FNANCL_YEAR) AS YEAR, max(WSTAT.PRD_NUMB) AS PERIOD, SUM(NVL(WSTAT.TIME_WIP_VAL_PTD, 0)) + SUM(NVL(WSTAT.GNRL_W_ON_PTD, 0)) - SUM(NVL(WSTAT.GNRL_W_OFF_PTD, 0)) - SUM(NVL(WSTAT.TIME_WIP_VAL_W_OFF_PTD, 0)) - SUM(NVL(WSTAT.WIP_PRVSN_PTD, 0)) - SUM(NVL(WSTAT.EXP_WIP_VAL_W_OFF_PTD, 0)) - SUM(NVL(DSTAT.DBTRS_W_OFF_PTD, 0)) - SUM(NVL(DSTAT.DBTRS_PRVSN_PTD, 0)) NET_FEE_EARNED_PTD, SUM(NVL(WSTAT.EXP_WIP_VAL_PTD,0)) EXP_WIP_VAL_PTD, SUM(NVL(WSTAT.TIME_WIP_VAL_PTD, 0)) TIME_WIP_VAL, SUM(NVL(WSTAT.GNRL_W_ON_PTD, 0)) GNRL_WON, SUM(NVL(WSTAT.GNRL_W_OFF_PTD, 0)) GNRL_WOFF, SUM(NVL(WSTAT.TIME_WIP_VAL_W_OFF_PTD, 0)) TIME_WOFF, SUM(NVL(WSTAT.WIP_PRVSN_PTD, 0)) WIP_PROV, SUM(NVL(WSTAT.EXP_WIP_VAL_W_OFF_PTD, 0)) EXP_WOFF, SUM(NVL(DSTAT.DBTRS_W_OFF_PTD, 0)) DB_WOFF, SUM(NVL(DSTAT.DBTRS_PRVSN_PTD, 0)) DB_PROV FROMENG_WIP_STATS WSTAT, ENG_DBTRS_STATS DSTAT WHERE WSTAT.ENG_NUMB(+)=DSTAT.ENG_NUMB AND WSTAT.FNANCL_YEAR=DSTAT.FNANCL_YEAR AND WSTAT.PRD_NUMB=DSTAT.PRD_NUMB GROUP BYWSTAT.ENG_NUMB, WSTAT.FNANCL_YEAR, WSTAT.PRD_NUMB ) v1, ( selectmax(WSTAT.ENG_NUMB) AS ENGAGEMENT, max(WSTAT.FNANCL_YEAR) AS YEAR, max(WSTAT.PRD_NUMB) AS PERIOD, SUM(NVL(WSTAT.TIME_WIP_VAL_PTD, 0)) + SUM(NVL(WSTAT.GNRL_W_ON_PTD, 0)) - SUM(NVL(WSTAT.GNRL_W_OFF_PTD, 0)) - SUM(NVL(WSTAT.TIME_WIP_VAL_W_OFF_PTD, 0)) - SUM(NVL(WSTAT.WIP_PRVSN_PTD, 0)) - SUM(NVL(WSTAT.EXP_WIP_VAL_W_OFF_PTD, 0)) - SUM(NVL(DSTAT.DBTRS_W_OFF_PTD, 0)) - SUM(NVL(DSTAT.DBTRS_PRVSN_PTD, 0)) NET_FEE_EARNED_PTD, SUM(NVL(WSTAT.EXP_WIP_VAL_PTD,0)) EXP_WIP_VAL_PTD, SUM(NVL(WSTAT.TIME_WIP_VAL_PTD, 0)) TIME_WIP_VAL, SUM(NVL(WSTAT.GNRL_W_ON_PTD, 0)) GNRL_WON, SUM(NVL(WSTAT.GNRL_W_OFF_PTD, 0)) GNRL_WOFF, SUM(NVL(WSTAT.TIME_WIP_VAL_W_OFF_PTD, 0)) TIME_WOFF, SUM(NVL(WSTAT.WIP_PRVSN_PTD, 0)) WIP_PROV, SUM(NVL(WSTAT.EXP_WIP_VAL_W_OFF_PTD, 0)) EXP_WOFF, SUM(NVL(DSTAT.DBTRS_W_OFF_PTD, 0)) DB_WOFF, SUM(NVL(DSTAT.DBTRS_PRVSN_PTD, 0)) DB_PROV FROMENG_WIP_STATS WSTAT, ENG_DBTRS_STATS DSTAT WHERE WSTAT.ENG_NUMB(+)=DSTAT.ENG_NUMB AND WSTAT.FNANCL_YEAR=DSTAT.FNANCL_YEAR AND WSTAT.PRD_NUMB=DSTAT.PRD_NUMB GROUP BYWSTAT.ENG_NUMB, WSTAT.FNANCL_YEAR, WSTAT.PRD_NUMB ) V2 WHERE v1.ENGAGEMENT=V2.ENGAGEMENT(+) AND TO_DATE(V2.YEAR(+)||V2.PERIOD(+),'MM') = ADD_MONTHS(TO_DATE(V1.YEAR||V1.PERIOD,'MM'),-12) AND TO_DATE(V2.YEAR(+)||V2.PERIOD(+),'MM') = TO_DATE(V1.YEAR||V1.PERIOD,'MM') GROUP BY V1.ENGAGEMENT , V1.YEAR , V1.PERIOD Explain plan: ID PID QUERY_PLAN - -
Re: Data Warehouse on Windows
DW are memory hungry... It really depends on the application needs, there will be less than 20 users, if the design is good they won't be hitting raw ultra-detailed data with query using only one dimension ... Depending on the kind of data loads, 4G of ram can be quite enough for a small DW. Before buying the hardware, is there any capacity planning that will be done ? --- [EMAIL PROTECTED] a écrit : Antje, Forgot to mention: The mgrs do know the memory limitations on Windows don't they, as DW are very memory hungry? Jared Sackwitz, Antje [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Transferring data from one table to another
Do you want to copy or move ? If move then partition the target table and do an exchange partition, is the faster way to move data. --- Ji, Richard [EMAIL PROTECTED] a écrit : How about turn off logging and drop indexes on the target table. Do insert with the APPEND hint. Re-create index. -Original Message- Sent: Monday, August 12, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Iam planning to copy 18-40Million rows thru CTAS!! My question is which one is efficient, CTAS or using cursor in pl/sql Procedure!! thanks peter. From: Abdul Aleem [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Transferring data from one table to another Date: Sun, 11 Aug 2002 23:23:19 -0800 Thank you, Amjad, The problem is that then I have to write a procedure for each of the tables. I was looking for something that could be set at database level and would apply to every table. Aleem -Original Message- Sent:Monday, August 12, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Subject: RE: Transferring data from one table to another well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize the counter.. i have written the Pseudo code below: declare cursor c1 is SELECT * from schema2.abc; cntr number := 0; begin for c1_abc in c1 loop insert into schema1.abc values contained in c1_abc; cntr := cntr +1; if (cntr = 1000)then cntr := 0; commit; end if; end loop; /* the following commit is 4 last set of records that might not b commited*/ commit; end; rgds, Ams. www.medicomsoft.com -Original Message- Sent: Monday, August 12, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 million records. The tablespace increases to consume full disk space and yet seems to be demanding more so the operation doesn't complete. Is there a possibility to process commit after every 1,000 records? Is there any other way of doing it? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Amjad Saiyed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
Re: set sql*trace VB/Crystal
You can see the sql generated by the report in Crystal, so take that sql and run it in sqlplus to see the access plan. You can also check in v$sqltext the select run by the report. --- Baker, Barbara [EMAIL PROTECTED] a écrit : List: We have a crystal report performing badly. (No! ,you say. You're shocked!) The report has a visual basic front end. Our developer wants to set sql trace in the VB code. It's not working. When I tkprof her trace file, all that's in there is the ALTER SESSION SET SQL_TRACE TRUE command. Is there some trick here? I don't know VB at all, so I don't know how to advise her. She looked on the Microsoft site, but it was not helpful. Thanks for any help! Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Oracle vs. DB2
For what I've read, globally the 2 databases are equal in performance, reliability and functionnalities. Larryh E as many times said that it's only competition in the database market is DB2. I guess it really depends on your environment. Of course Oracle works on more OS (used to be anyway), but which big organisation only have one DB ? All big companies I've worked have many DB. I would be interested by any non-partial comparison between Oracle and DB2. --- Vergara, Michael (TEM) [EMAIL PROTECTED] a écrit : Hi Everyone! Well, there's been a lot of Oracle vs. Microsoft traffic on the list, but now my Manglement wants a similar comparison to IBM's DB2. Does anyone know of web sites or locations where there are documented objective comparisons between Oracle and DB2? I'm faced with answering buzzwords like 'Future Market Position', 'T.C.O. - Cost Effectiveness', 'Demonstrated Technology', and 'Platform Compatibility'. Any references are appreciated. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Rolling partitions
The fact tables were partitionned with hashing than range. The volumetry was supposed to be huge and there was no data purging in the architecture. The range partitionning was done on a protein batch number or something like that. --- Jack Silvey [EMAIL PROTECTED] a écrit : interesting ... what was the partition key? Phylum? Genus? --- paquette stephane [EMAIL PROTECTED] wrote: We used the date as the key of the time dimension but we were using a time dimension to drive the queries. At my last client, I was surprised to see no time dimension in the datawarehouse but I was even more surprised to that there were no date at all in the fact tables of this datawarehouse. It was in a biotech company and the datawarehouse was developped by Oracle Corp. Time was having no meaning for the users (biologists). --- Jack Silvey [EMAIL PROTECTED] a écrit : Jared / all, Agree, date column in the fact is a bad idea. I have experience with a warehouse that had a fact table partitioned on a date column. This system does not use a date dimension, and queries are directly constrained on the date column in the fact. You are right, in this system, if you use a date dimension, you do not get partition elimination. You can get partition elimination if you use use partition key in the WHERE clause, but this setup has two major problems: 1) no true star execution, and 2) lack of flexibility. No true star execution: In true star schema execution the query visits all the dimension tables first, makes a cartesian join of all of the relevant dimension records, and use this dataset to select records from the fact table. This works since the fact table visit is usually the most expensive, and it is cheaper to do a cartesian join of dimensions rather than use the fact table as part of the regular query. Since the date column is in the fact table, the enduser must directly constrain queries against the fact. Therefore, this system does not use the STAR execution plan, since it must use the fact as part of the normal query and is not able to save it until the last step. This hampers query performance. Poor flexibility: This system is not flexible, since you cannot store date information other than just the date. For instance, since there is no date dimension, queries can't just look in the dimension table and see which dates comprise fiscal third quarter. The query issuer has to hardcode dates into the query, instead of saying where datetab.3qflag = 'Y'. Kimball talks about direct fact constraint on dates with an air of disfavor in his book about data warehousing. I am sure that these two problems are not the only ones, they are just the first two that leap to mind. Jack --- [EMAIL PROTECTED] wrote: This discussion raises an interesting question. Do your fact tables have a date column in them? If so, how do you correlate that with the date/time dimension table? If you use a local date column to control the partitioning rather than a PK from the date/time dimension, user queries based on the date/time dimension won't be able to use partition elimination. Personally, I see no need for a date column in the fact table. Jared paquette stephane [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/06/2002 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Rolling partitions I've done that in a datawarehouse system. The fact tables were partitionned by date. Some fact tables were keeping different number of months : 6o, 12, 15,... This was handle in the metadata tables and was written with PL/SQL (Oracle 8). You can do a lot of things with PS/SQL. So the metadata was containg the table name, the naming convention of the partition, the naming convention for the tablespace, disks name, the number of partition per table, ... Data was moved into retention data tables then the partition were rolling : creation of new tablespaces, creation of new partition, moving data to the retention tables, dropping partition,... HTH --- Tracy Rahmlow [EMAIL PROTECTED] a écrit : I am finally looking to implement partitioning and have some issues with rolling partitions by date. (Ie add partion p0802 and drop p0801) Does anybody have or know of a generic procedure/process that will allow
Re: Shark Tank: Works, shmerks -- how much did it cost?
It's like a cartoon I've seen in a french IT magazine. On the first slide there is the IT director bragging about it's huge mainframe to track the lost luggages across all airlines. In the next slide, you see the fresh new employee just hired from school who says I just develop on my laptop a program to prevent losing the passengers luggage --- [EMAIL PROTECTED] a écrit : Ok, this is kind of off topic, but it does have Oracle in it at least once. I just couldn't resist sending this to the list. How many of us have had an experience similar to this? I've had at least two I can think of. The worst was after a merger, and we went with the other companies more expensive, proprietary system for a data warehouse. (Ours was Oracle on AIX, theirs was TeraData on NCR ) The reason? And I heard this with my own ears coming from the mouth of a VP: It was a business decision. Our system is only 2 million dollars, and theirs is 11 million, so we're going with theirs. This from a business that hadn't made money in 4 years. - Shark Tank: Works, shmerks -- how much did it cost? This sysadmin pilot fish discovers that his company needs to distribute updates to a cluster of Unix servers. Simple enough, says fish. I write some scripts that copy the data out and append it to the files that need it. It all works well and it tests out great. But as the deadline for the rollout approaches, fish learns that the company has spent a six-figure wad of dough on a big commercial software package to distribute the data -- including a full-time engineer to run it. My scripts are ripped out and replaced by a set of four dedicated distribution servers running this giant package, says fish. OK, he can live with that. After all, his scripts are being replaced by four servers and a dedicated engineer. But there are implementation problems, and bugs, and the deadline is missed, and expenses on the project skyrocket. The dedicated engineer is spending all her time on the phone with the vendor's tech support, just trying to get things working. Meanwhile, fish's scripts are still humming along perfectly in the preproduction environment. Say, fish suggests to management, maybe we should forget about giant six-figure, four-server packages and consider implementing this simple, effective solution that actually works. And management turns him down cold. The reason? If we use a home-rolled solution, we won't have tech support, his boss tells him. And, as we have seen, we make heavy use of tech support for this problem. _ Can't get enough Tank? Check out other bite-sized bits of humor, rumors, gossip and fun at The Sharkives: http://www.computerworld.com/departments/opinions/sharktank -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Replication
Hi, Oracle Lite would not be good for us as when I said users are working with a deployable version, I mean a bunch of users go away with their server/database and come back 2-3 months after, then they synchronized the master database. --- Don Jerman [EMAIL PROTECTED] a écrit : Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: Hi, We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, there should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Replication
The application will be developped in ASP, the deployed version would juste be a lighter version of the main application. --- Ramon E. Estevez [EMAIL PROTECTED] a écrit : Don, What are you using for deploy the applications ?? I am interested in this topic too. Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 10:33 AM Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: Hi, We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, there should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Free ware databases: which are worth the money?
We have used MySQL in a small in-house project. It works OK for what we want it to do, but it's far from having Oracle's functionnality. --- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Mark Eweek recently did a head-to-head performance test of major databases and included MySQL. You might look it up to see the strengths and weaknesses of this type of database. Unless the simple memory cache in MySQL works for you, Oracle left all of them in the dust, including SQL Server. Some people here use MySQL for small applications and report that it works fine for their purpose. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 02, 2002 5:33 AM To: Multiple recipients of list ORACLE-L Hi, we are investigating some freeware databases for deployment on systems that dont justify the cost of an oracle license, on linux. What databases out these can cope with a OLTP load, all transaction based, with some reporting? Uncomplicated databases, with mid size volumes of transactions (say low millions) and some reporting queries? I guess reliability is the primary concern, if something can be built as solidly as an oracle instance, with whatever OS protection this would need, then its a starting point for making a non oracle freeware enterprise database. Anyone have any suggestions on what I should download first? Thanks! Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Replication
At a previous job, I've tested the first version of Oracle Lite in 1996 if I remember correctly. The concept of user did not exist, I do not know if it has changed. In my case, several users will connect to the same database. So I guess I'll need the Workgroup version. --- Don Jerman [EMAIL PROTECTED] a écrit : Yes that's how it works, although the volume for 2-3 months might be excessive, if the deltas get large. Light uses Advanced Replication to manage the deltas so the resolution process might take a while. paquette stephane wrote: Hi, Oracle Lite would not be good for us as when I said users are working with a deployable version, I mean a bunch of users go away with their server/database and come back 2-3 months after, then they synchronized the master database. --- Don Jerman [EMAIL PROTECTED] a écrit : Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: Hi, We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, there should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr
Replication
Hi, We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, there should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Replication
Hi, I've never had experiences in replication environments. We will develop a new system that has a central database (817/win2000). From times to times, some users will worked with a deployable version of the application in a region without network connection. When the users are back, they're should be able to synchronize with the centralized database. The data goes from the deployable version to the centralized database only. What strategies can be considered ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: table size.
When using delete , the highwater mark does not change, so the table still use what was allocated. export/import also does noty resize the table. One way to do it, would be to precreate the table with a smaller size then import the data. --- mitchell [EMAIL PROTECTED] a écrit : Sorry : table is 8 million rows and I deleted 5 million rows. - Original Message - To: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 12:20 PM Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same. I thought table size should be taken much less space. the storage clause for both table is the same: pct10,pctused 40. any idea. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Exporting stats for a production server to a dev/test server
I've used 1 month ago on Oracle817 without any problem. --- [EMAIL PROTECTED] a écrit : Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Restore on another machine with RMAN
Luc, I strongly recommend to use a catalog. Without catalog, some recovery scenarios are not available. There are some parameters you have to put in the init.ora file to indicate the new files location. Stéphane --- Luc Demanche [EMAIL PROTECTED] a écrit : Hi gurus, I'm in process of testing our backup strategies. We are using RMAN, but for our prod database we aren't using the recovery catalog. Our backup's files are on disk, so I transfered them on another machine. I recovered the controlfile, I mounted the database, but when RMAN tried to restore it looks for the original location where RMAN created the backup. How can indicate the new location of the backup's files ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Installing Oracle 9i Developper suite
I'm installing Oracle 9i Developper suite on winXP and the doc says : If you use assistive technologies such as screen readers to work with Java-based applications and applets, run access_setup.bat before starting your screen reader. What the hell is assistive technologies such as screen readers = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Need improvement on Oracle Loader
Go at http://www.evdbt.com/papers.htm You'll find a white paper on sql*loader for DW. --- Smith, Ron L. [EMAIL PROTECTED] a écrit : We have an application that calls SQL*Loader to load data warehouse tables every night. We would like to speed up the loads if possible. Does anyone have any tips or papers on improving performance on SQL*Loader? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Data Warehouse design
Yes it is ok to have sequences as the primary keys. The dimension should not use keys from the source systems as their own keys. They must be independant. Also, since the PK of the dimensions are foreign keys in the fact tables, if using a non-generated key you will increase the size of the fact tables for nothing. I've never put relationsips between dimension tables. All the validation is done before the load in the staging area. --- [EMAIL PROTECTED] a écrit : Hi, I am in the process of designing the data warehouse. My Question is can I define the relationship between dimension tables. Like I have country,customer and time zone dimension tables. Can I add relationship between customer,country and time zone just to validate the data before load whether the country and zip code is correct or should I integrate the country and time zone with customer itself. If I integrate this. Is it going to affect the performance. 'cos for every record it is going to validate all these things before load. Can I create sequences for primary keys(fact tables and for some of the dimenasion tables also). Is it OK to have a sequence as primary key. I need your expert views on this. Regards, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Analyze running twice as long after upgrade to 8.1.7.2
As John says, you can check on what Oracle is waiting on . It may not solve your problem, but can make the analyze faster. Since your fact tables are partitioned and since you're migrating from 8.0.4 that means range partitioning. If the tables are partioned by date and you do you allow update/insert in partitions other than the current one then you can analyze only the current one. At a previous client, only the current partition of the fact tables were analyzed after the daily load. --- [EMAIL PROTECTED] a écrit : We just upgraded our data warehouse from version 8.0.4 to version 8.1.7.2 of Oracle. We run on Sun Solaris 2.6 vith Veritas Quick I/O. We do an analyze compute nightly with a 10% estimate of our large, main fact table. Before the upgrade, the analyze ran for 45 minutes. Since the upgrade, it's run three times at a consistent 90 minutes. I am trying to research on Metalink but have not had much success. Why would this analyze suddenly run longer? I wouldn't think that analyze code is being modified much in new releases. All the effort would go into new packages like DBMS_STATS. Is anyone aware of analyze changing in 8i. Our analyze was of a partitioned table and was single-threaded, not parallel. I can see that it is still single-threaded. We really didn't change much during the upgrade. I added another datafile to the SYSTEM tablespace (on the same file system as the previous file). I also changed parallel_threads_per_cpu from 2 to 0. However, since we never did the analyze in parallel, I don't think it was an issue. Any other ideas? I'd like to be able to give our application owners some explanation. Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Any tool available for identifying junk code?
I like the then use coffee-machine information part. --- Stephane Faroult [EMAIL PROTECTED] a écrit : Sandeep Kurliye wrote: Hi Guys, Sorry, if this sounds bit awkward or unrelated to this mailing list. Can any one of you please let me know whether there is any tool available to identify junk code in an application. My applications are written in Oracle Forms and VB. Backend is Oracle. I am in the process of tuning these applications. I can see lots of poorly written SQLs. These can be tuned from backend as well as changing SQLs in forms. But what about poorly written logic? As such, I am going thr' each and every line of code and tuning it wherever necessary, but plenty of time will require to complete this process. If there is any tool available which identify the problem, then I've to directly go to the application/code and modify it. If I've to rewrite whole application, then its massive task. Please help. TIA, Regards, Sandeep. Sandeep, Glad to see somebody worrying about logic. But it's a mountain to climb. IMHO, try to concentrate on 'problem' code - check V$SQLAREA at regular intervals to see the top 'buffer_gets' queries, you do not only have individual queries, you will also see (command_type = 47) stored PL/SQL procedures, and they may point you to bad logic; listen to users to. Fortunately there is a lot of terrible code that nobody really worries about. The first thing I would do in your case would be to put calls to dbms_application_info everywhere, setting 'module' and 'action' to identify 'atomic business processes' (if such a thing exists), then use coffee-machine information and a bit of monitoring to check what really hurts and concentrate on that. Otherwise you risk spending a lot of time on improvements that nobody will ever notice. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: INDEX move
If your index tablespace is on the same physical device than your table tablespace , you will have no gain. Is your bottleneck an IO one ? --- Seema Singh [EMAIL PROTECTED] a écrit : Hi I have few of primary key and unique indexes on main data tablespace.I am thinking that if I moved those indexes into diffrent tablespace then we woudl have some performance gain.If I am not correct let me know please?Is any impact if I move primary key and unique indexes to INDEX tablespace? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: DataWarehouse Design Training
Check the Datawarehouse Institute : http://www.dw-institute.com --- Toepke, Kevin M [EMAIL PROTECTED] a écrit : Hello! Can anyone recommend a good training class on DataWarehouse design/implementation? I have a basic understanding of the concepts,etc from reading books, but would like a hands-on course to get more of a feel for the subject. TIA Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: partition tables
You can use insert select , export/import, create as select to move data from a non-partitionned to a partitionned table. Partitionning helps in the management of large tables more than in speeding the queries. Will you delete data from that table one day ? Choose the partition key carefully. A partition with only 100 000 rows is pretty small. Since you have 10 000 000 rows in your table, you will have 100 partitions of 100 000 rows, it's way too many small partitions. --- BigP [EMAIL PROTECTED] a écrit : Hi All , We are thinking of converting one of huge table in to partition table . What is best way to achieve this ? Is there any alter table clause that can do this or I will have to export ..recreate table with partition option and then import . Also how can I mentiod that partition should have only 10 rows . For example after each 10 rows add another partition ? If I have 1000 rows in the table , should I expect some performance gain out of this Thanks , BigP = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: what is dual?
I remember that a long time ago, with Oracle 6 and Forms 2.3 , the dba, accidentely, add a row in dual. Since, at that time, almost all Forms trigger were relying on dual, absolutely nothing was working in the production environment. I do not have to tell you that the dba spent many hours before finding the problem... --- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Eric - Assuming this isn't end-of-day humor. Dual is an Oracle pseudo-table with one row and one column. It is useful to test SQL functions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 29, 2002 6:01 PM To: Multiple recipients of list ORACLE-L begin hallo what is dual? exit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Limited SORT_AREA_SIZE
Hi, Asked you sys admin to boost the maximum memory allowable for a process. I had that error on a hp box. I do not remember the name of the parameters. Once the sys admin had changed the memory process parameters, processes were able to use way more than 150M of ram. You can increase the sort_area_size for a particular session with alter session instead of bouncing the db. What I've done at a previous client was to change the session parameters using a database logon trigger who was checking in a table what sort/hash values to put for each user. --- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : This weekend I was rebuilding a large table and when it came time to rebuild the indexes, I cranked the SORT_AREA_SIZE up to 1/2 gig. It bombed off with an ORA-04030. I kept reducing the SORT_AREA_SIZE (bouncing the instance to make the change) until I got it down to 150-meg. Then everything ran fine. I discussed this with my Unix system administrator and he felt everything was fine from his end. I ran Oracle's maxmem utility and received: oracle.fin7maxmem Memory starts at: 5369596416 (1400d8a00) Memory ends at: 6399795195 (17d751ffb) Memory available: 1030198779 (3d6795fb) So it seems like I could have SORT_AREA_SIZE much higher than 150-meg. The indexes built fine, but I am curious about the problem. Any ideas? Oracle 8.1.6 (until Oracle gets a good 8.1.7 version) Compaq Tru64 4.0E 4-cpu. 4-gig. of system memory. shared_pool_size = 400-meg This is the only instance on this server. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Multiple ennvironments with Portal and 9iAS
I do not have experience with them either yet ... anyway the client doesn't want to pay for more licences so we'ill install on one server and configure the tools to handle 3 environments. --- Jared Still [EMAIL PROTECTED] a écrit : Stephane, I don't have any experience with the environment you describe, but it would seem good practice to separate the dev, test and maintenance logically, even if they do have to share hardware. Jared On Friday 24 May 2002 13:33, paquette stephane wrote: Hi all, The client has a dev, test, maintenance, QA and prod environments. Each environment consist of a pipeline of several applications. QA and prod have their own independant pipelines with their own servers with Oracle 9i, Oracle 8i, Workflow, Portal and 9iAS Dev, test and maintenance shares 4 servers. We would like to have dev, test and maintenance to have their pipelines with a maximum of independance. Do you suggest to install 1 setup of Portal and 9iAS to serve the 3 environments or to install 3 copies of Portal and 9iAS ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Multiple ennvironments with Portal and 9iAS
Hi all, The client has a dev, test, maintenance, QA and prod environments. Each environment consist of a pipeline of several applications. QA and prod have their own independant pipelines with their own servers with Oracle 9i, Oracle 8i, Workflow, Portal and 9iAS Dev, test and maintenance shares 4 servers. We would like to have dev, test and maintenance to have their pipelines with a maximum of independance. Do you suggest to install 1 setup of Portal and 9iAS to serve the 3 environments or to install 3 copies of Portal and 9iAS ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: How to enable Java
You can installed java with scripts. Check metalink note 156477.1 Use more space (10-20M more )than specified on the note for java_pool_size and shared_pool --- Joe LaCascio [EMAIL PROTECTED] a écrit : Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: oratab file
The oratab is provided by Oracle Corp. We created our own oratab file to handle more parameters. --- Babu Nagarajan [EMAIL PROTECTED] a écrit : All On one of the database servers we have, the oratab file has been changed to include a :parameter after each entry and that parameter is used to determine whether the database is supposed to be shutdown at a certain time. It kind of struck me as a odd way to do this... This created problems for me when I was trying to get OEM discover this database and I had to remove this parameter to get OEM discover the database. So the question is : Have you seen this some where else? Is this (editing of oratab) supported? PS : This is not my database. I had to look into it for some other reason and I discovered this. TIA Babu = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Partition Exchange
The alter table exchange partition lets you transfer data from the partition of a partitioned table to a non partitioned table. It changes the adress in the data dictionnary, no data is moved, that's why it is fast. For example, I'm using it in a system to exchange old data with new data. The new data is loaded in staging tables (non-partitioned). When the data is cleansed and validated, the staging tables are exchanged with the target tables (partitionned). The target tables are partitioned with only one partition to be able to used the alter table exchange partition statement. More in the docs... --- [EMAIL PROTECTED] a écrit : Dear all, What's the meaning of Partition Exchange? tia, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Storing phone info...
As for the adress, you have more flexibility when storing each parts separately. Stephane --- Suzy Vordos [EMAIL PROTECTED] a écrit : Curious how people are storing phone info in their database, eg., separate columns for country code, city code, area code, etc. Any references about this would be appreciated! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re:RE: SQLPlus was Oracle - can you imagine ;-)
It was ODL : Oracle Data Loader . --- paquette stephane [EMAIL PROTECTED] a écrit : Since we're in old stuff. Anybody remember the ancestor of Sql*loader ? Answers in 10 minutes ! --- [EMAIL PROTECTED] a écrit : Stephane, I remember using Pro*C with Lattice C and/or Vax C on Oracle 4. Was a whole lot more efficient than iag/iap. Damn, those were the days when a mouse was an optional item on your desktop that normally outlived the rest of the PC. That is IF you had a PC!! Dick Goulet Reply Separator Author: MacGregor; Ian A. [EMAIL PROTECTED] Date: 5/17/2002 12:18 PM I forgot about the name change fron HLI to OCI, but the core functionality, the ability to embed SQL in a 3GL, was there which was the gist of my claim. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 17, 2002 12:28 PM To: Multiple recipients of list ORACLE-L MacGregor, Ian A. wrote: I believe, fifteen years ago, it had already changed to SQL. Yes. Dates from Oracle5, 17 years ago. I'm also pretty sure that iag/iap had also already been introduced. OCI was definitely there Wrong. OCI came with Oracle6 (1988). Was called 'HLI' then. and probably the Oracle pre-compilers for 3GL's as well. Oracle 5 too. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette
Re: data warehousing desing - to denormalize or not to denormalize -
A DW stores data in a denormalised fashion, that's one point that every body knows but it is also subject oriented. It is also developped one subject at a time. A DW is multi-subjects as a datamart is on one subject. From Bill Inmon From the data warehouse data flows to various departments from their customized DSS usage. These departmental DSS data bases are called data marts. A data mart is a body of DSS data for a department that has an architectural foundation of a data warehouse. The data that resides in the data warehouse is at a very granular level and the data in the data mart is at a refined level. The different data marts contain different combinations and selections of the same detailed data found at the data warehouse. In some cases data warehouse detailed data is added differently across the different data marts. Yet in other cases a data mart will structure detailed data differently from other data marts. But in every case the data warehouse provides the granular foundation for all of the data found in all of the data marts. Because of the singular data warehouse foundation that all data marts have, all of the data marts have a common heritage and are able to be reconciled at the most basic level. --- [EMAIL PROTECTED] a écrit : -- Gurelei [EMAIL PROTECTED] on 05/10/02 12:13:27 -0800 Jared, Thanks for the answer. I must admit my ignorance in terminology as for me data warehouse and data mart a pretty much the same thing except for size. I understand that data mart is smaller. The database I'm referring to could probably be described as data mart as it is going to be rather small - a gig or so maybe. Data Mart == summarized data from a Warehouse used to speed up query times. Main point to a mart is that by pre-aggregating the data the volume (and keyspace) are reduced. Mart's acutally increase total storage becuase they store the data more than once (Warehouse + agg'd into the Mart). Advantage is speed for the 90% of all queries that use agg'd data in the first place. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: How to backup a data warehouse?
Hi, If my memory is good, it was in 1998-99 with Oracle 8, we were using stored proc with dynamic pl/sql. I do not recall that it was taking long. Everything was done with dynamic pl/sql : tablespace creation, partition creation,... Our partitions were not big, between 200M and 800M. Stéphane --- [EMAIL PROTECTED] a écrit : Stephane, So, what process did you use to switch over a non-read-only partition to read-only on a monthly basis? How quickly were you able to make the switch? How large were your partitions? Thanks, Cherie paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: Re: How to backup a data warehouse? [EMAIL PROTECTED] 05/08/02 01:49 PM Please respond to ORACLE-L I've tested a setup like the one Tim is describing. We tested backuping with RMAN using incremental and doing conventional hot backup. We were partitionned by month and each partition was in its own tablespace. Only the current month was active so the rest was in read only mode. Since volume was not too big , we were still able to do a nice clean full backup during the weekends. --- Tim Gorman [EMAIL PROTECTED] a écrit : The short answer is that it becomes important to make use of the features of 1) range-partitioning, 2) read-only tablespaces, and 3) incremental backups with RMAN, and 4) a honking big tape library using media-management software. Range-partitioning allows tables and indexes to be spread across multiple tablespaces, usually by time. As data ages, inserts/updates/deletes tends to cease; it is usually the newest data that has insert/update/delete activity upon it. Therefore, as data ages, you can set the tablespace in which the partitions are located to read-only. As tablespaces are set to read-only, you can remove them from the regular backup list. It is important to take 2-3 additional backups for archival retention after setting to read-only, but the regularly scheduled backups can now ignore those tablespaces. Generally, I recommend partitioning according to your loading scheme (i.e. daily loads, thus daily partitions) and storing those partitions in tablespaces according to your scheme for setting them read-only (i.e. if setting read-only on a quarterly basis after aged 6 months, then create quarterly tablespaces to house all of the partitions from all partitioned objects in that quarter). The advantages of RMAN's incremental backup mechanisms should be obvious, but its usefulness depends on the nature of the application. At the very least, incremental backups will supplement the effects of the partitioning/read-only-tablespace scheme illustrated above. Using RMAN's incremental backup mechanism, at worst you would be getting the equivalent of a level-0 or full backup, if every block was modified during every backup cycle. I hope that would be an unlikely scenario, though... - Original Message - From: Terrian, Tom To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 08, 2002 9:38 AM Subject: How to backup a data warehouse? How do you guys backup your data warehouses? Our warehouse is suppose to top out around 3.5TB. It seems that the traditional hot/cold backup methods will not be able to keep up. How do you guys do it? Thanks, Tom Terrian = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED
Re: Working with Oracle Designer
I've been looking for that in Designer , where it is ? I've used a lot Power*AMC in the past and it has that feature . We're using Oracle Designer 6.5.52.1.0 TIA --- [EMAIL PROTECTED] a écrit : Stephane, We have the same objects, etc. in both dev and prod. We only have a single database defined. When we get to prod, we'll have to edit the tablespace physical storage definition (in just one place) to change the datafile definitions. It is possible to use different methods to generate DDL from the same definition.One method generates DDL that containts storage definitions and one does not. You don't actually need to change the way anything is defined in Designer to switch back and forth between the two methods. Cherie paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: Re: Working with Oracle Designer [EMAIL PROTECTED] 05/08/02 04:03 PM Please respond to ORACLE-L So you're generating specific DDL for each environments. Do you have 1 db in Designer per Oracle database ? Also, we have a requirement to be able to generate the DDL without any tablespaces and storage clause so the developers can do some prototyping in their own space. The way we will handle that is to create a user no_storage for each user and to do table implementation without tablespace. Anybody working like that ? --- [EMAIL PROTECTED] a écrit : Stephane, We are doing exactly that with Designer 6i. We are able to generate all the DDL except for public synonyms. No solution found for that. Otherwise, it is working well in our QA environment. Haven't used it yet to generate prod but that is coming next month. Cherie Machler Oracle DBA Gelco Information Network paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: Working with Oracle Designer [EMAIL PROTECTED] 05/08/02 01:24 PM Please respond to ORACLE-L Hi, We're discussing ways of working with Designer. We convinced developpers to use the check in/check out stuff and each application has its many workareas. Someone here would like to press a button and have all the DDL generetad for at least 2 environments : prod and dev (including datafiles path and sizing). Of course the physical files layout/sizing are different in dev, test, QA, prod and maintenance environments. One way we tought, is for each application, to have a logical DB where we put all the schemas, tables, and tablespaces. For the same application, we created 2 physicals DB , lets called them dev and prod where we created the tablespaces with a storage definition. The storage definition would match the physical caracteristics of the db. So, when generating for dev, we use the dev physical layout and when for prod we use the prod physical layout. Anybody working like that ? Other approach ? TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! === message truncated
Re: Working with Oracle Designer
I've found out how to generate without the storage clause. --- paquette stephane [EMAIL PROTECTED] a écrit : I've been looking for that in Designer , where it is ? I've used a lot Power*AMC in the past and it has that feature . We're using Oracle Designer 6.5.52.1.0 TIA --- [EMAIL PROTECTED] a écrit : Stephane, We have the same objects, etc. in both dev and prod. We only have a single database defined. When we get to prod, we'll have to edit the tablespace physical storage definition (in just one place) to change the datafile definitions. It is possible to use different methods to generate DDL from the same definition.One method generates DDL that containts storage definitions and one does not. You don't actually need to change the way anything is defined in Designer to switch back and forth between the two methods. Cherie paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: Re: Working with Oracle Designer [EMAIL PROTECTED] 05/08/02 04:03 PM Please respond to ORACLE-L So you're generating specific DDL for each environments. Do you have 1 db in Designer per Oracle database ? Also, we have a requirement to be able to generate the DDL without any tablespaces and storage clause so the developers can do some prototyping in their own space. The way we will handle that is to create a user no_storage for each user and to do table implementation without tablespace. Anybody working like that ? --- [EMAIL PROTECTED] a écrit : Stephane, We are doing exactly that with Designer 6i. We are able to generate all the DDL except for public synonyms. No solution found for that. Otherwise, it is working well in our QA environment. Haven't used it yet to generate prod but that is coming next month. Cherie Machler Oracle DBA Gelco Information Network paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: Working with Oracle Designer [EMAIL PROTECTED] 05/08/02 01:24 PM Please respond to ORACLE-L Hi, We're discussing ways of working with Designer. We convinced developpers to use the check in/check out stuff and each application has its many workareas. Someone here would like to press a button and have all the DDL generetad for at least 2 environments : === message truncated === = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send
RE: Datawarehousing help
Rachel, If a DW is built and that users do not have access to a part of it in an ad hoc fashion, you gonna have a lot of political meetings They should have some data marts for their usage and keep most of them off the raw data. Regarding SAS tools, I've used SAS more than 10 years ago in math classes... when it was only a statistical tool. --- [EMAIL PROTECTED] a écrit : Dennis, Forgetting about normalization won't be a problem, I've always been more practical than by the book. As for amounts of data being collected, I can see them wanting data aggregated hourly. I greatly doubt the tech people will allow adhoc queries, they seem to do things right here. What will happen is that they will be contacted by marketing with an I need this new report NOW request, but tech will generate it. But *my* problem is that the data warehouse will supposedly be only a small part of what I'm responsible for, I don't think they understand the scope of what they are asking for, as yet. They will, I'll make sure of it. Right now, as this is a new internal group, I'm still collecting information on which databases I will be responsible for. Then I just have to remember that when I set deadliines, I am prone to underestimation. :) Rachel |+--- || | || | || DWILLIAMS@lif| || etouch.com | || | || 05/03/2002 | || 08:48 PM | || Please | || respond to | || ORACLE-L | || | |+--- | | | | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: Datawarehousing help | | Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis package. A scientist or engineer could load a set of test data into it and perform various arithmetic and statistical analyses. Today most of that can be done with Oracle or MS Excel. My point is that I would expect it to be heavily biased toward mathematical capabilities. Like Data Mining, which is all statistics. Learn what that term means. To learn Data Warehousing, I would encourage you to just do some Googling and find good tutorials. An excellent newslist is dwlist. Instructions: For help with list commands, send a message to mailto:[EMAIL PROTECTED] with the word help in the body of the message. The magazine http://www.intelligententerprise.com/ has some excellent information. I would search for Ralph Kimball. He is one of the leading figures in the DW arena. Look for some of his earliest columns on the magazine site. He also answers questions on dwlist from time to time. The main change you need yourself is to forget normalization. DBAs that can't get past that point don't last long in the DW field. In the early days the DW people would patiently explain the reasons to a DBA, but today there are enough DBAs that have made the leap that a hard-headed normalization bigot just isn't tolerated. It is much easier to just ask for a replacement DBA. The reason normalization isn't adhered to in DW is that users will be creating their own queries and they can't understand 10-table joins with outer joins, etc. A DW is usually loaded and then queried. Our DW is loaded each weekend and then queried all week. So a DW is deliberately denormalized and contains redundant data for ease of use. OLTP databases have no concept of time. A DW is all about time. To reconstruct what the situation is at various points of time, the DW has loads of historical data. For example, marketing people need to be able to reconstruct the amount of business they did with a customer over a period of time last year and compare it with the same period this year. So between denormalization and tons of detailed historical data, DWs are normally BIG! Fortunately they are usually read-only. For Oracle, you want Enterprise Edition with the partitioning option. And study Oracle Materialized Views. In schema, a DW is usually a central fact table and 4-6 dimension tables. Less than 4 dimensions and you don't need a DW. More than 6 and marketing people can't understand the model. Normally the fact table is much larger than the others, but not always. One of Wal-Mart's dimension tables is each person in the U.S. Just size each of those tables, and you've got your
Re: DB Config. Assistant
I assume you're talking about the dbassist tool. If it's working as on unix, you should find the log files in $ORACLE_BASE/admin/$ORACLE_SID/create. I prefer the old way, using scripts, this way I can rerun the scripts for all the different environnements. HTH --- KENNETH JANUSZ [EMAIL PROTECTED] a écrit : 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC. I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
good value for optimizer_index_cost_adj
Hi, Oracle 817/Solaris 8. Users are doing select joining using the PKs of 2 partitionned tables. Partitionned key and the primary key are the same. The access plan is a nested loop with a full table scan on the first table which hold 700 000 rows. The block size is 16K, I assume that's why Oracle is doing FTS. By using optimizer_index_cost_adj, I can make Oracle use the PK of the first table. I've used 50 as a value for optimizer_index_cost_adj. Is that too much ? Where can I get some metrics on that parameter ? TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Clob indexes
I also think that since those indexes are created by Oracle, Oracle knows them. I'll trace the dbms_stats and I'll look for the 'bitand(flag,)' --- Jonathan Lewis [EMAIL PROTECTED] a écrit : It would make sense, I would expect Oracle to take a shortcut with LOB Indexes, simply hard-coding the fact that access to the LOB should always be via the LOB index. Consequently there would be no point in thinking about them You could run SQL_TRACE prior to the dbms_stats call, and see if there is a 'bitand(flag,)' line in the query that identifies indexes that excludes LOB indexes. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 23 April 2002 22:52 I've hit bug 1499329 As a workaround, I'm analysing the tables in the staging environment then I'm doing an exchange partition. I can analyse the tables/indexes without problem in the staging environment. My question is when creating a clob, Oracle creates a sys_...$$ indexes. When analysing the schema, those sys_...$$ indexes do not have any statistics. Is that normal ? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Clob indexes
I've hit bug 1499329 As a workaround, I'm analysing the tables in the staging environment then I'm doing an exchange partition. I can analyse the tables/indexes without problem in the staging environment. My question is when creating a clob, Oracle creates a sys_...$$ indexes. When analysing the schema, those sys_...$$ indexes do not have any statistics. Is that normal ? TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: Exchanging partition takes a lot of times
Thanks for replying. I've seen your post on a similar question on metalink. I've already tested with the constraints enabled novalidate using the default exchange mode (with validation). The exchange is taking 3 seconds. We'll go this way since we're replacing completely the target tables with the staging ones and we're doing all the test on the staging tables before switching. Regards --- Jonathan Lewis [EMAIL PROTECTED] a écrit : See the book - chapter 12, page 250. It's normal behaviour. There is one bizarre SQL run if you do the exchange without validation and another (usually cheaper) if you do it with validation. This relates to checking primary and unique keys, rather than the partitioning constraint. The solution/workaround is to set the constraints to a RELY ENABLE NOVALIDATE. But the last time I checked you still got problems with partitioned tables in involved in parent/child relationships. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 11 April 2002 17:17 I'm testing the exchange partition and it's taking 90 seconds to exchange a table containing 700 000 rows with a partition containing also 700 000 rows. I've noticed that SYS is doing a crazy select to check on the PK of the tables even if I used whitout validation in the exchange statement. I this normal behavior ? = Stéphane Paquette -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: disk subsystem performance question
I just started a couple days ago at this client. They're using Hitachi technology in the QA and prod environment with 181G disk. I asked the SA twice and he confirmed the 181 G disk. I'll ask more details to the SA as soon as I know him better. --- Deshpande, Kirti [EMAIL PROTECTED] a écrit : John, I agree with the 18GB drives implementation and pushing for more 'parity groups'. That's what we did. Now, HDS was back to sell more disk and backup soultions to us. I am not sure what we have agreed to purchase. A cache of 10GB for the 400GB database is nothing. I bet you will have tables larger than the cache size. A single FTS on these tables will flush the whole cache... We have 16GB cache (I think I remember that right, and is the max for 7700E), and that is not enough for several servers that the cabinet supports. - Kirti -Original Message- Sent: Wednesday, April 10, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Thanks for all the replies. We are determined to lay out the data as well as we can across the disks we are about to purchase - with the goal of striping across array groups and smaller, faster drives. The real argument for us is 18GB vs. 73GB disk drives and how we can stripe. The Hitachi is configured into groups of 4 physical disks called parity groups and you can choose RAID 5 or RAID 1+0 for that 4 disk set.If you have 73GB drives in a 4-disk RAID 5 configuration you get roughly 219GB of usable space in each parity group (this is what we are being told is the best option for us).This means our heavily concurrently accessed 400GB production database goes on 2 parity groups (2 sets of 4 disks). To me, this sounds like a nightmare waiting to happen and we are trying to stop it.The 18GB drives are less capacity but we can get ourselves spread over more parity groups for better concurrency. We do have about 10GB of cache but it is being shared across the enterprise with various other applications. We as a DBA group are really trying to sell the 18GB RAID 1+0 drive solution especially after reading the groups' experiences - unfortunately we are fighting a lot of marketing hype. If anyone has additional experiences or feedback with Hitachi or EMC they would like to share or comments (agree/disagree) with my thoughts, I'd love to hear them. I'm open for learning! Thanks, John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Don GranamanTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] granaman@coxcc: .netSubject: Re: disk subsystem performance question Sent by: root@fatcity. com 04/10/2002 01:08 PM Please respond to ORACLE-L Short answer - NO! Nobody's disk subsystem is so fast that no intelligence is required in the layout. This is common vendor blather and one of the most popular myths. I have been hearing it for at least six years - and it still isn't true. Layout still makes a huge difference. RAID levels still make a huge difference. Cache won't solve all your problems (it does help though). I've redone the disk layout on some of the biggest, fastest fully-loaded with cache EMC Syms available that had some don't worry about it layout and seen database throughput go up by as much as 8x. See Gaja's whitepaper on RAID at http://www.quest.com/whitepapers/Raid1.pdf . Don Granaman [certifiable oraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 10:38 AM Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0 and 5. I would like to get the smaller, faster 18GB drives in a RAID 1+0 configuration and stripe our data across the array groups as wide as possible. However, I am running into objections from the Hitachi people that their system is s fast we need not worry about such minor
Exchanging partition takes a lot of times
I'm testing the exchange partition and it's taking 90 seconds to exchange a table containing 700 000 rows with a partition containing also 700 000 rows. I've noticed that SYS is doing a crazy select to check on the PK of the tables even if I used whitout validation in the exchange statement. I this normal behavior ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Re: MetaLink problems
I'm on metallink since 7:30 this morning (3 hours) Stéphane --- Boivin, Patrice J [EMAIL PROTECTED] a écrit : FYI, I just went to MetaLink and clicked on the Login to MetaLink link, and got this: Authorization Required This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required. I hope the problem is at my end... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Insert append generating redo
Hi, I'm trying the following insert /*+ append */ into t1 as select * from t2; t1 is created with nologging attribute. The insert is not using the hint at all. I can select on t1 (before any commit) which I should not be able to do if the append hint was used. Any ways to get the hing used ? (Oracle 817/NT) TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
moving data
Hi all, Back on the list after being away for a while. I'm currently at a new client where things are to done yesterday (as usual). We must move data (1Gig) from a staging area to the final area, tables have integrity constraints and tables contain CLOB datatypes. The 2 areas are in 2 different schemas (but I can change that). Oracle 817/Sun Before testing, I see 4 ways to do it : 1. Exchange partition 2. Disable constraint, truncate/insert, enable constraint 3. Create new partition, insert (append), drop partition 4. CTAS, create constraints, rename tables Been there ? Currently at Caprion Pharmaceuticals = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
moving data
Hi all, Back on the list after being away for a while. I'm currently at a new client where things are to done yesterday (as usual). We must move data (1Gig) from a staging area to the final area, tables have integrity constraints and tables contain CLOB datatypes. The 2 areas are in 2 different schemas (but I can change that). Oracle 817/Sun Before testing, I see 4 ways to do it : 1. Exchange partition 2. Disable constraint, truncate/insert, enable constraint 3. Create new partition, insert (append), drop partition 4. CTAS, create constraints, rename tables Been there ? Currently at Caprion Pharmaceuticals = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
HS between Oracle and Sqlserver
Hi, I'm trying to transfer data from Sql Server 2000 into Oracle 9.0.1/Win2000 . I've set up heterogeneous services on Oracle - run caths.sql - create an ODBC connexion - modify the tnsnames.ora - modify the listener.ora abd restart it - create an ORACLE_HOME\hs\admin\initXXX.ora - create a db link I've got the following error : select count(*) from tbl_ressource@sp_sqlserver * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL State: IM002; SQL Code: 0) ORA-02063: preceding 2 lines from SP_SQLSERVER I can TNSPING the sql server side. Any idea ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Courrier : http://courrier.yahoo.fr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
RE: Data Warehouse Raid-5 Shark Environment
I've not worked with an IBM P660 but do have worked in datawarehouse environments with raid5. Raid5 will slow down your loads. The impact may be not too bad if you're in noarchivelog, using direct path inserts with nologging and loading on a monthly basis. -Original Message- Behalf Of Bellefeuille, Wayne S Sent: 9 novembre, 2001 17:35 To: Multiple recipients of list ORACLE-L Anyone out there have any experience running an Oracle Data Warehouse on an IBM P660 (6M1) over a Shark/RAID-5/SAN environment? Work great? Any horror stories? Any gotchas? My concern in us potentially converting to this environment (from an AIX-SP/mirrored environment) has mostly to do with the RAID-5 aspect of the configuration, (especially for writes). But our loads are mostly during off-hours. Are there other things I should be concerned about? Any input would be appreciated!!! Wayne Bellefeuille -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellefeuille, Wayne S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Courrier : http://courrier.yahoo.fr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
Multiple languages Datawarehouse
Hi, Anybody has built a multi-languages datawarehouse ? The star schema is quite pure so only the data in the dimensions needs to be in french and in english. Up to now the query tool is Oracle Discoverer. Anybody has done this ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Courrier : http://courrier.yahoo.fr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).