RE: OLAP Financial Function Calculators for Oracle 9i.

Hi I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain

OLAP Financial Function Calculators for Oracle 9i.

Hi I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not certain

OLAP Financial Function Calculators for Oracle 9i.

Hello: I would like to know if the Oracle Express feature of Financial Function Calculators are available with Oracle enterprise Edition 9.0.1.0.0. If my memory serves me correctly , I think Oracle has incorporated OLAP services as part of the 9i database enterprise edition. But I am not cer

RE: Instance fails to start

Could you please let me know, what is the significance of NTTACH=0 and why only this one needs to be removed. Srini -Original Message- Sent: Wednesday, April 10, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Bill, Check whether u have any hung shared memory segments by issuing

RE: Long-running SQL

Could you please let me know the Title and Author's complete name. I interested in reviewing this book. Srini -Original Message- Sent: Wednesday, March 27, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Yep, Guy's book is among my fav's. I consider it an indispensable DBA book.

RE: EXPORT FAST?

Also look into the option BUFFER in export. Srini -Original Message- Sent: Tuesday, March 26, 2002 10:59 AM To: Multiple recipients of list ORACLE-L I think you can use direct=y option. Are you taking this export to a file (over disk) or directly to tape? Greeting Diego Cutrone ---

RE: ORACLE TUNING

Thanks, I'll post. -Original Message- Sent: Thursday, March 21, 2002 3:58 AM To: Multiple recipients of list ORACLE-L Why not post the query and the two plans ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html

RE: ORACLE TUNING

Thanks -Original Message- Sent: Wednesday, March 20, 2002 11:23 PM To: Multiple recipients of list ORACLE-L Are the sizes of the tables same on both development and production machines? In our case, we used histograms on indexed columns and that brought execution plans same on both the

RE: ORACLE TUNING

Both have current statistics. Data distribution is smaller on DEV. Both are using CBO. -Original Message- Sent: Tuesday, March 19, 2002 4:53 PM To: Multiple recipients of list ORACLE-L What about current statistics on both DBs? Is the distribution of the data reasonably the same? Are

RE: ORACLE TUNING

Thank you.. Buffer cache is smaller on DEV. What specific parameters are you refering you? Indexes are in the same order. -Original Message- Sent: Tuesday, March 19, 2002 5:52 PM To: Multiple recipients of list ORACLE-L buffer cache size the same ? init.ora parameters the same ? index

RE: ORACLE TUNING

Thank you I will look into this option. Can tell me more on this if have already implemented this feature. Srini -Original Message- Sent: Wednesday, March 20, 2002 1:58 AM To: Multiple recipients of list ORACLE-L hi Srini, Why don;t you use stored outlines. -Original Message

RE: ORACLE TUNING

Yes they both are, only difference being the amount of data in Prod and DEV databases for this query. Prod has more. Srini -Original Message- Sent: Tuesday, March 19, 2002 9:43 PM To: Multiple recipients of list ORACLE-L Are the tables/indexes analyzed the same way, if you use CBO?

RE: ORACLE TUNING

Thank you for the response. The indexes on both sides are regular non-unique indexes. Any other possible reasons.. Srini -Original Message- Sent: Tuesday, March 19, 2002 1:34 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: > > Hello: > > I have an identical query

ORACLE TUNING

Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy mig

RE: Instance Monitoring Tools

How would you rate OEM's Instance Monitor and DBArtisan tools with BMC-Patrol. Thanks Srini -Original Message- Sent: Thursday, February 21, 2002 1:43 PM To: Multiple recipients of list ORACLE-L We use BMC-Patrol. Works great for us.. - Kirti -Original Message- Sent: Thursda

RE: Database Performance Question

Thank you , I will look into the suggestions. Srini -Original Message- Sent: Tuesday, January 29, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Srini, 1. You don't have to feel... go after v$system_event, v$session_event and v$session_wait to find out what events and SQLs are co

RE: Database Performance Question

Thanks -Original Message- Sent: Tuesday, January 29, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Bringing back 20,000 rows is not good in my shop. I recently tuned a SQL (returned 14000 rows, and it is web-based appl) from running 15 minutes to less than 15 seconds. The SQL

RE: Database Performance Question

Typically i bringing back about 20,000 rows and that too after filtering first and joining with bigger tables. Srini -Original Message- Sent: Tuesday, January 29, 2002 12:41 PM To: Multiple recipients of list ORACLE-L How many rows are you bringing back from a typical query, how good is

RE: Database Performance Question

Kirti: Thanks for the insight. Here are my Answers: 1. I feel database is the problem because when only a subset of the total data is used the performance is excellent (with one tenth of the total data). The no. of users are the same. Only amount data that is retrieved is enormous (almost 10 t

Database Performance Question

Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with eac

Oracle Stand by database

Hi all: If anybody has a concise document on setting up stand by databases, please send me a copy or send me the links on the web where I can find one. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Servi

RE: Database Views

Thank you all for your opinions. The tables that I want to consolidate are 15 Million rows each. So five tables put together will constitute 75 million rows in one table. I will have to consider partitioning after that for optimum performance. Also Materialized view would take a long time to r

Database Views

I would like get your opinion on what would be the best way provide access to data across multiple databases on just on Node (database). One way that I have tried is create a view on one database that reads tables across remaining four databases using Dblinks. Let us say there is a table called

RE: Oracle Enterprise Manager

I have tried, but they show a status of pending. I am unable to de-register from OEM against this node. Srini -Original Message- Sent: Friday, January 11, 2002 8:55 PM To: Multiple recipients of list ORACLE-L Have you cleared out all registered events, jobs, and alerts against this no

Oracle Enterprise Manager

Hi: I am running into this problem with OEM while trying to delete a node previously configured. OEM returns an error VNI-4040 Node agent queue file may be corrupted. I have gone through a few postings on Metalink and implemented the suggestions there such as removing .q files in agent director

Database Comparison

Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or

RE: NOLOGGING/LOGGING

thanks -Original Message- Sent: Monday, May 14, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Thanks Rajaram ! Here's the bottom line : NOLOGGING doesn't apply to conventional DML at all ! It applies only to CREATE/ALTER objects and Direct Load Inserts such as using SqlLoader

NOLOGGING/LOGGING

Title: RE: Intermedia I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter.  Specially for huge updates w

DATABASE COMPARE SCRIPT

Title: RE: When to go for ORACLE NAMES Server I am trying to find out the schema differences between two databases.  Differences like Column size,column datatype,column data length, indexes,tables,constraints etc. If anyone has a script or know where I can get one that will accomplish this,

TEMP tablespace segment management

Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (85

RE: CUBES

Thanks. This was helpful Srini -Original Message- Sent: Friday, February 02, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Hi, ROLLUP is similar to break/compute of sql*plus. However it hasn't the same funcionality. With CUBE you receive the information of ROLLUP and the tot

RE: CUBES

thanks -Original Message- Sent: Thursday, February 01, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Just try : SELECT deptno, job, SUM(sal) FROM emp group by cube(deptno, job) / and see the d

CUBES

Hi, Could someone please give me an example for cube. I could understand rollup using the following example. SELECT deptno, job, SUM(sal) FROM emp group by rollup(deptno, job) / Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMA

CUBES

Hi, Could someone please give me an example for cube. I could understand rollup using the following example. SELECT deptno, job, SUM(sal) FROM emp group by rollup(deptno, job) / Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL P