OEM 9i - saving/copying reports between repositories

G'day all, I've create a number of custom reports in one of our OMS and would copy them into another OMS. How does one go about doing this? Where are the reports stored? Is there a file that we can copy around? Or if we look at the problem in another way - OEM itself comes with a number of

Re: 9i OCP Details

It must have been either Scott Gossett or Scott Heisey. But not that Scott. The two other Scott's are still with Oracle Education, I think. Glenn Stauffer wrote: Gudmundur Bjarni Josepsson wrote: If you want real advanced courses go with [...] what Jonathan Lewis or guys at his level provide.

Re: oracle authentication from windows

Thanks reginald, Jared , Mladen,.. I set sqlnet.authentication_services=(nts) made sure that the ntlm service was up and running and created a user by the name \\domain_name\username ( replaced domain_name with the name of the stand alone computer i was testing this on) and I can now log

Re: salary question

Whatever the figure may be, two things are certain if the salary is X: a) I probably don't deserve to get X b) I should be getting more than X :-) --- Helen J Mitchell [EMAIL PROTECTED] wrote: Does anyone have information about salaries in Denver? I looked at salary.com and saw the median

printing out of Pl/SQL

Hi gurus, anyone knows of a possibility to directly send data to :LPT1 ? I am in the need of printing online when something definite happens to the DB... TNX Frank Confidentiality Notes This email and any

RE: redo log maintenance

Title: redo log maintenance Thought so. Thanks Mladen. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 5:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: redo log maintenance Doco is plain wrong. I've been adding,

McAfee NetShield 4.5 and Oracle

I am having an interesting problem with regards to Netshield 4.5.1 and Oracle8.1.7 on Win2K. We have a 3rd party app that generates a trace file due to deadlock issue. When NetShield is enabled with the Oracle drives (data and ORACLE_HOMEs) excluded from the scan, we have a severe performance

Re: SQL*Loader Help -- Multiple rows into single column

No. We are still with 8i. --- [EMAIL PROTECTED] wrote: Are you on 9i? If so, setup the sql_load.txt file as an external table, and you can then use SQL and/ora PL/SQL to load your table the way you would like. Don't think you can do what you're asking directly from sqlldr. Jared

RE: printing out of Pl/SQL

dd if=your file of=/dev/lpt1 Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 8:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, anyone knows of a possibility to directly send data to :LPT1 ? I am in the

RE: salary question

Might be looking for one of those moving calculators If I was making $75K in Richmond and moved to Boston for $100K, I could well be going downhill at that... I remembered when I was making $75k they would offer me $95k to move to DC and I ALWAYS turned them down. I figured DC would require a

RE: salary question

Didn't someone earlier this week post another site besides salary.com? Something with the word pay in it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Whatever

RE: printing out of Pl/SQL

You should be more environmentally conscious and pipe this through compress prior to sending it to lpt1. -Original Message- dd if=your file of=/dev/lpt1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

WHY IT DOES NOT WORK == rman target / as sysdba THANKS

bigtex:oraadm 7% rman target / as sysdba Argument Value Description - target quoted-string connect-string for target database catalog quoted-string connect-string for recovery catalog nocatalog

RE: Register vs. Load of JDBC driver

So the Class.forName call is ten times faster than the DriverManager.registerDriver() call? Is that one tenth of a sec vs a sec thing? Class.forName loads the JDBC driver class, then the static initializer part of the JDBC driver registers itself with DriverManager. DriverManager can manage

RE: printing out of Pl/SQL

Oh, I missed the PL/SQL part. Here it is: create or replace directory dev as '/dev'; grant read on dev to public; fp:=utl_file.fopen('dev','lpt0','w',255); I've never tried it personally, but this should work. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]

Re: WHY IT DOES NOT WORK == rman target / as sysdba THANKS

You do not need as sysdba when connecting in RMAN: d:\oraclerman target / Recovery Manager: Release 9.2.0.3.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: T03B (DBID=2558667088) RMAN shutdown using target database controlfile

RE: printing out of Pl/SQL

The question was, how to do it from PL/SQL. I think, the only way is using external stored procedure. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Gogala, Mladen Sent: Friday, June 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L dd if=your file of=/dev/lpt1

Re: printing out of Pl/SQL

You can dump the stuff in to AQ and then have shell script to dequeue it and print it . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:14 AM The question was, how to do it from PL/SQL. I think, the only way is using

RE: salary question

http://www.payscale.com/research/vid-18563 choose the personal payscale report, to have an idea about what you get and what you should be getting.. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Didn't someone earlier this week post another site besides salary.com? Something with the word pay

process in oracle

Hi Guys, I am in process of designing a event handler for one of the app over here . So some where in app code it will have one line code with event_code and some other param. Now in order to keep users unaffected ( due to processing of event) that event is put in queue (AQ) . Some other

Re: High-availability database question !!!!

Yup. I work for Chartered Semiconductor Manufacturing and we use Promis in the manufacturing floor in all the current fabs. CIM uses a number of custom-built Oracle databases. And Corporate systems are all on Oracle. The newest fab, coming up soon, may not be using Promis [information

AW: printing out of Pl/SQL

sounds like some Unix/Linux I am on NT / Oracle 8.0.6 Frank -Ursprüngliche Nachricht- Von: Gogala, Mladen [mailto:[EMAIL PROTECTED] Gesendet am: Freitag, 27. Juni 2003 16:14 An: Multiple recipients of list ORACLE-L Betreff: RE: printing out of Pl/SQL dd if=your file of=/dev/lpt1

RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS

You always connect as a sysdba privileged user when using RMAN ... so just issue rman target / (or rman target / nocatalog if you're not using a catalog) (Wow! I answered an RMAN question ... and I knew nothing about it 12 months ago) Ciao Fuzzy :-) -Original Message-

RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS

Title: RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS Try rman target / (No quotes and no as sysdba) -Original Message- From: Roger Xu [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Subject: WHY IT DOES NOT WORK

Intresting Statistics -- DB FILE SEQUENTIAL READ waits

We were running a serial update on a fact table (45 mill rows) using the old tech of declare cursor ...table a begin for c1rec in c1 loop update fact where period_key = c1rec.period_key and loan_key = c1rec.loan_key commit every 10,000 rows end loop; end; fACT table

Intresting Statistics -- DB FILE SEQUENTIAL READ waits

-- Sorry the earlier post was incomplete. We were running a serial update on a fact table (45 mill rows) using the old tech of declare cursor ...table temp begin for c1rec in c1 loop update fact where period_key = c1rec.period_key and loan_key = c1rec.loan_key commit every

Re: Intresting Statistics -- DB FILE SEQUENTIAL READ waits

has anyone ever really benchmarked a case where this kind of update through a cursor is EVER faster than doing it in straight sql? It seems to take twice as long if not longer on large batch jobs. ive seen somethings in books that claim it can be faster, but i have tested this every way i can

RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS

(Wow! I answered an RMAN question ... and I knew nothing about it 12 months ago) That is awsome, isn't it!! Congrats! BTW, if you are using 9i and RMAN there is no need for the nocatalog command. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert -

RE: Index question

Hi Michael!!! This is the result of the query: SQL select value from v$parameter where name like 'optimizer%' or name = 'timed_statistics'; Results: TRUE 9.2.0 CHOOSE 2000 100 0 1 7 rows selected. About your travel plans: Te recomiendo en otra ocacion planear vacaciones a Guanajuato,

Connection Problem

I access a database from 2 different sites, having a PC at each site. At one site I use NT and have no problems. At the other site I use Win 2000 and usually get an error message when trying to log on ORA-12545 Connect failed because target host or object does not exist Occasionally it

RE: Index question

I Installed some CD's on my computer that said: Oracle9i Database Realease(9.2.0.1.0) for Microsoft Windows 98/NT/2000/XP CD 1 of 3 Well I installed only the Client. But if is better I can uninstall it and install the CD that said Oracle9i Client Realease(9.2.0.1.0) for Microsoft Windows

RE: printing out of Pl/SQL

Unless I'm totally mistaken '/dev' also has to be in the UTL_FILE_DIR init parameter. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 27, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Interesting... I should try it sometime. Igor

RE: Connection Problem

A name resolution problem? Symptoms for the site with problems are consistent with not getting consistently consistent service from your name server. Look are your tnsnames.ora and see if it has the name of host there. If so, try putting in the IP address instead. -Original Message-

opinion of listers on product(s)

hey guys- Looking at a couple of products for some data replication as part of a continuous availability effort. Just curious, looking for some "reactions", do's and dont's,plus and minus to those who have used the following "software data replication tool(s)" : Quest SharePlex Data

Re: printing out of Pl/SQL

in case of pipe you loose items in pipe if system gets down . Careful !!! -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:04 AM Or DBMS_PIPE - a little easier. - Original Message - To: Multiple recipients

RE: printing out of Pl/SQL

Title: RE: printing out of Pl/SQL Dick, this is 9i ... in 9ir2, oracle recommends that UFD parameter is going away, so use CREATE_DIR ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed

RE: printing out of Pl/SQL

Dick, it used to be so before 9.2. In 9.2 you have a parameter location to utl_file.fopen, which is specified by using the create directory command. I didn't see a version in his post so I assumed he's talking about 9.2. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]

ORA-04031

One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7 on AIX 4.3.2 The output from select * from v$sgastat showed about 3 mb free out of a total of 40 mb of shared pool. I increased the size of

RE: printing out of Pl/SQL

Mladen, Thanks, I was talking about 8.1 and earlier. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 27, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Dick, it used to be so before 9.2. In 9.2 you have a parameter location

Re: printing out of Pl/SQL

When the system gets down, does it get funky, too? ;-) --- AK [EMAIL PROTECTED] wrote: in case of pipe you loose items in pipe if system gets down . Careful !!! -ak __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --

Question On Statistics Gathering

Hi All, Currently we have a very large database ( 8.1.7.4 ) on Tru64 that is having query optimization problems. Lacking good, up-to-date statistics is the main cause of it. Because of the size and availability window we can't afford to analyze the whole schema. Now 8i has a new feature that

RE: printing out of Pl/SQL

Title: RE: printing out of Pl/SQL Are you using sqlplus? spool on ... do some work spoo out will that work for you? Just a guess ... it might Raj Rajendra dot Jamadagni at nospamespn dot com All Views

RE: Question On Statistics Gathering

Dennis, There has been a substantial amount of discussion on this subject in the past, you might want to go look at the archives. But to directly answer your questions: 1) I'm not having a problem with it (8.1.7.4) 2) NO. Dick Goulet Senior Oracle DBA Oracle Certified

RE: printing out of Pl/SQL

Title: RE: printing out of Pl/SQL oops ... it should be "spool out" Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts,

RE: Question On Statistics Gathering

Title: RE: Question On Statistics Gathering 1. not much experience 2. yes it will, but in 8i the rate at which the stats were updated in the DD was *slow*, in 9i it is on demand or 5 minutes I think. Raj

Performance

Hi list, SCENARIO LAB DB = Oracle 8.1.7.4.0 on Suse Linux 7.2 PRODUCTION DB = Oracle 8.1.7.4.0 on HP-UX B.11.00 I have this strange case, I have this query that generate a text file and in the PRODUCTION environment ran for about 30 minutes. When running the same query in LAB ran in about 2

RE: printing out of Pl/SQL

Title: RE: printing out of Pl/SQL Isnt it: spool off? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra Sent: Friday, June 27, 2003 4:15 PM To: Multiple recipients of list

sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session?

Hi, How do I retrieve the last commands I ran in a sqlplus session? I remembe in the training class, I were able to use arrow keys in Windows platform. But in Solaris 9/UNIX platform, it does NOT work. Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337

Re: ORA-04031

Peter: this error usually tells you that you do not have enough memory... you should increase your shared_pool_size parameter in your init.ora ... If you need to determine a shared pool size for avoiding this error, I can send you a script that helps you to 'size' your sga... If you are

RE: Index question

Terrista, Did you run the UTLXPLAN.sql file so you can get a explain plan output ? Check Metalink for an explanation of all of this here is one link http://metalink.oracle.com/metalink/plsql/ml2_gui.startup Then . SQL Set Autotrace on Then run those queries and report

port 2030

I am installing 9i clients on my user's pcs. The client defaults to using port 2030 for the MTS. We were attacked by hackers through this port last week. I don't use MTS at all. Does anyone know more about this setup to know if I turned off this port, what it would affect? If anything that

RE: printing out of Pl/SQL

Title: RE: printing out of Pl/SQL spool off will close the file ... spool out will _print_ it. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD:

Re: Question On Statistics Gathering

Dennis, First, #2 since it is a shorter answer... I don't know, but I just saw another resonder say it did not. That's good to know, I haven't previously taken that into account. Personally, I like the monitor/gather stale feature. I have heard, some on this list, some on metalink of bugs where

RE: ORA-04031

What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7 on AIX 4.3.2 The output from

RE: ORA-04031

Peter You might take a look at Note 146599.1 on Metalink, Diagnosing and Resolving Error ORA-04031. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 2:30 PM To: Multiple recipients of list ORACLE-L One of our

RE: opinion of listers on product(s)

Greg - The following note was posted to this list awhile back. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Check on Oracle streams in 9iR2. It is the

RE: printing out of Pl/SQL

Title: RE: printing out of Pl/SQL Nope. The "spool out" command goes directly to the default printer, while "spool off" only stops spooling. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Igor Neyman [mailto:[EMAIL

RE: sqlplus newbie: How do I retrieve the last command I ran in a

Title: RE: sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session? You can either use the / key to re-run the last command, or you can type ed and enter to edit the last command. Then when you are finished editing, save the changes, and when you return to the SQL

RE: Performance

Have you set event 10046, lev 8 for the session? If not, try setting it and then use 9.2 tkprof to see what is the instance waiting for as well to analyze the execution plans and see how they differ. Also, during the execution, you can watch v$session_wait and see what the session is waiting for.

Re: Performance

Ramon, This is not a strange case at all; I find quite customary to see dazzling fast queries in a development environment crawl pathetically in production. My Spanish being reduced to some vague remnants of Latin (and just enough to understand the promotion of Mexican holiday resorts) I

Update and Join

I am trying to make and update that have a Join. UPDATE ITEMLOC INNER JOIN ITEMMAST ON ITEMLOC.ITEM = ITEMMAST.ITEM SET ITEMLOC.PREFER_BIN='PATEN-A' WHERE (ITEMMAST.INVEN_MAJCL = 'A' AND ITEMLOC.PREFER_BIN='FICTICI') But I don't have the right sintaxis, did some one knows how to do this

RE: Question On Statistics Gathering

1) Oracle is bug free. If not bug free, it is, at least, unbreakable. That means that nothing wrong will happen to you as long as you don't have users or data. They are the problem. 2) Direct load doesn't generate statistics, even if monitoring attribute is set. Direct load is built for

Re: Connection Problem

Try turning on SQL Net tracing to discover the problem. Turn on tracing on the client PC by adding the appropriate trace parameters to the sqlnet.ora file. This will produce a trace file upon your next connection attempt and you will be able to (hopefully) see what is causing the problem. It is

RE: sqlplus newbie: How do I retrieve the last command I ran in a

Title: RE: sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session? How about a history of commands? Thanks. -Original Message-From: Stefick Ronald S Civ ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 5:10 PMTo: Multiple recipients of list

Friday Humor - RMAN

Excerpt from the 9i RMAN Guide : If you specify DEVICE TYPE DISK, then you must back up to random access disks. You can make a backup on any device that can store an Oracle datafile: in other words, if the statement CREATE TABLESPACE tablespace_name DATAFILE 'filename' works, then 'filename' is

Re: Intresting Statistics -- DB FILE SEQUENTIAL READ waits

The ordering of the temp (driving) table to line up with the fact table index-key order is a very powerful technique indeed. If the driving table is random wrt to the index ordering, it would have to look up an index block for each row, pin the block, do the update for just a key or two, and

Re: Question On Statistics Gathering

Statistics management is probably a topic all by itself for large systems. The larger the system, the more critical the statistics, but the smaller a window you have. Enter monitoring. This is my approach - I wrote a PL/SQL package to manage this: - switch all objects of interest to monitoring

RE: 10046 Trace file questions

Dan, 4) A subsequent statement has several space management (activity on fet$ and uet$) activities. The tablespace/file that is passed in as a bind variable are associated with a 'temp' tablespace. However, the tablespace is set up as dictionary managed. This indicates that sorting

RE: sqlplus newbie: How do I retrieve the last command I ran in a

If you are on a Windows 2000/NT client, then start the command line version of SQL Plus by entering start %ORACLE_HOME%/bin/sqlplus [EMAIL PROTECTED]. Then in your SQL session you should be able to recall SQL commands the same way you do in Windows 2000/NT: use the cursor arrow keys to recall

RE: Performance

Mladen, As one of the authors of DBA 101, I appreciate your plugging my book for me. But Gaja Vaidyanatha (correct spelling) and Kirtikumar Deshpande (both on this list) are the authors of the book I think you meant to talk about: Performance Tuning 101. Marlene (has she now moved onto single

RE: Performance

Surely not? I was told just last week by the inestimable Mr. Mogens Norgaard (who we all know as the source of truth) that Gaja's real name is Gaja Vaidyanathanathanatha, and he's about to take on a top-secret new career (details to be revealed at the DB Forum in Denmark in October) ... :) Pete

Re: OEM 9i - saving/copying reports between repositories

the files are stored in oem_webstage directory you will have to copy these files to the other location and give the path. As you must be knowing the oem reporting server should have the management server running on the same machine. when you remove default reporting from the console it doesnt

RE: Intresting Statistics -- DB FILE SEQUENTIAL READ waits

Two features already exist that will preserve table physical order even through various DML-motivated data transformations: - Clusters - Index-organized tables Heap-ordered tables (that is, regular old tables) are designed not to carry any guarantees about physical order. Cary Millsap Hotsos