Re: Hotsos Clinic 101 Feedback

Attending a Hotsos Clinic and Hotsos Symposium was very worthwhile. If an employer cannot afford the training time, flexing work hours (or using vacation) may be possible. Note: if you do attend a Hotsos event on your own time, your company name can be removed from your name tag ;) Looks like

Re: Oracle Licences Req on Intel Xeon CPU

http://www.microsoft.com/windows2000/server/evaluation/performance/reports/hyperthread.asp has a link to an article that has the BIOS requirement for logical CPU numbering (and start-up order). Note: since Windows 2000 Server does support up to four CPU's, the task manager does display 4 CPU's on

Re: OT: PLSQL question, JAVA, JDBC

http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:986230504001 Have Fun :) Darrell Landrum wrote: I'd take a look on http://java.sun.com, there are some great forums there. Also try http://devtrends.oracle.com. [EMAIL PROTECTED] 03/27/03 11:03AM Hi list, this is a

RE: Oracle encouraging Linux software developers

IBM is loudly touting how much money they will be spending on Linux. Has anyone seen any sales statistics for DB2 on non-IBM platforms? I feel that IBM has a challenge to convince buyers to consider DB2 on Linux. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]

RE: Which process is taking up so much CPU???

Tim, I think you may be right actually! :) I have a sub directory that contains the scripts that you zipped up on your site, this script seemed to have found it's way in to my main SQL directory, and as it didn't have any notes on author I plain forgot. It was indeed called SessionTopCPU.sql. All

RE: Oracle connection through Crystal Reports

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Juan Antonio Félix Sarabia Sent: Thursday, March 27, 2003 21:49 To: Multiple recipients of list ORACLE-L Subject: Oracle connection through Crystal Reports Hi All. I´m trying to connect to a oracle

AW: Database Modeling- Normalization - Dinosaurs or What?

Title: RE: Database Modeling- Normalization - Dinosaurs or What? Hi What I don't understand is: If your development department want to go with a VSAM like approach, why do they invest in Oracle. Why not just get a zSeries and stick to VSAM or IMS ? PS: Your working environment sounds like

RE: Database Modeling- Normalization - Dinosaurs or What?

Hi Stefan On the Data Warehouse project, the technical lead didn't understand Oracle. She was a mainframe programmer and once, in another job, she used VSAM files. WE don't support VSAM files, but she wanted to use them anyway... take data out of Oracle on Unix, pipe it to the mainframe to do

copying datafile nt4-w2k

hi all We are planning an upgrade from NT4 to W2K. I am considering to create a new instance on another server with W2K installed and copying the datafiles from the server with NT4 on it. Is this possible ? Or do i have to use the exp/imp strategy ? thanks vr.gr. Geo Kor Sr. System Engineer

RE: OT: uuencode adding characters

Thanks. I guess this would be a good time to learn Perl :) -Original Message- Berry Sent: March 27, 2003 4:39 PM To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing,

RE: OT: uuencode adding characters

Chris, Can you give me a hint? So I use Perl to rid the file of these characters and then uuencode it and then use mail utility to send to people? Won't uuencode do the same thing again and add those characters back? Thanks! -Original Message- Berry Sent: March 27, 2003 4:39 PM To:

RE: Which process is taking up so much CPU???

Thank you all for your help. I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs. Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS

RE: index on null column

Title: RE: index on null column Here is an idea ... Create a function that returns NULL if the value is null or any other acceptable value that can be ignored. And the function should return valid values otherwise. Then create a function based index on this and see if that helps you. To

Re: create interMedia index problem

Guang, Is your RESINDEX tablespace a Locally-Managed Tablespace with Uniform Extents of less than 3 database blocks? If so, that's your problem. InterMedia indexes consist of some LOB segments and those require extents of at least 3 database blocks - at least in 8i. If not, I don't know. Jack

Week - Date function!

Hi, Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in

Re: Which process is taking up so much CPU???

Alter system set timed_statistics=true; or/and - init.ora - timed_statistics=true HTH CP [EMAIL PROTECTED] wrote: Thank you all for your help. I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs.

Intermedia tag problem

Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: SYCyane/SYMANPhibro Energy */MAN This

RE: Week - Date function!

SQL l 1 select x.d 2 from (select to_date(rownum, 'DDD') d, 3 to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week 4from all_objects 5where rownum 366) x 6* where x.week = week_num You may have a problem with leap years, but it's basically the idea.

RE: Which process is taking up so much CPU???

Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 6:24 AM To: Multiple recipients of list

RE: Week - Date function!

Stephane There are days when I just feel lucky if I can understand your code, let alone come up with something smarter. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list

RE: Which process is taking up so much CPU???

On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. I would hasten to point out that this parameter can be set dynamically using alter system from at least 8.1.x forward. Thus,

RE: big disks..OFA??

Peter Welcome to the modern DBA's challenge. - Consider RAID - Pay attention to your cache size (battery-backed, of course) - Test - Eternally the System administrator would prefer you to use fewer devices, makes his/her life easier. The DBA wants many devices. Negotiate. Share. - What

RE: Which process is taking up so much CPU???

ALTER SYSTEM SET TIMED_STATISTICS=TRUE; You don't need to bounce the database ;) Best Regards, K Gopalakrishnan -Original Message- WILLIAMS Sent: Friday, March 28, 2003 6:49 AM To: Multiple recipients of list ORACLE-L Fermin Add this line to your init.ora file. timed_statistics

RE: veritas backup via RMAN troubles

Title: veritas backup via RMAN troubles I had a remarkably similar experience a few months ago with Legato NetWorker and performed all of the steps you listed with the same results. The problem turned out to be very simple. The SA installed the 64-bit version of the Legato Networker

OEM 4

Hi all, Is anyone aware of when OEM 4 will be available. I've been looking around on Metalink and can't seem to find anything about it. It was used at the Oracle Tech Day here in Greensboro this week and the web interface looks to have been really improved. TIA, John P Weatherman Oracle

RE: Intermedia tag problem

Hi, You will have to change your input data and replace the with lt;. This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than , greater than or ampersands in your data and if you do replace then with the

Re: index on null column

It means if I do a query with where clause with A=:x its going to go for index . Does oracle go to table if :x is null. It looks like it does . ??? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 6:33 PM AK

RE: Unable to lock file

Rivaldi Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the env command dumps all environment variables. Do that for your interactive session and then add that to the

Re: core dump for tkprof

It's 8.1.6 db . I ran tkprof succesfully on same box with same version 3 days back . But now it's geting core dump . -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE:

Re: oracle job

8.1.6 -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: oracle job Which version "rubs" the job? -Original Message-From: AK [mailto:[EMAIL

RE: Which process is taking up so much CPU???

Thanks Jeremiah. My bad. T early on Friday. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 9:19 AM To: Multiple recipients of list ORACLE-L On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this

RE: Configuring Oracle with RAID and OFA

I *knew* I should have explained that more. I had some verbage that I just deleted for the sake of simplicity. And it sounded much more impressive by leaving things hanging... :) After talking with the contractor that I worked with in setting this up, I was wrong about our physical layout. I

RE: Intermedia tag problem

Thank you Peter and Jan. Luc --- Hitchman, Peter [EMAIL PROTECTED] wrote: Hi, You will have to change your input data and replace the with lt;. This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than ,

RE: oracle job

if you compile package spec, then all dependent objects will be invalid, if you compile package body, then there will be no invalids. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal.

Re: utl_smtp error

Chris, Thanks for explantion. I asked the smtp mail admin. He said The relays are running Exim-4.10. Is that help? Joan Chris Berry wrote: From: Joan Hsieh [EMAIL PROTECTED] Chris, you got me, what MTA stand for? Mail Transfer Agent, its the program that uses SMTP to send or recieve

Oracle Jobs not restarting after upgrade

Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the

Re: oracle job

I don't think, that job calling stored procedure from the package gets invalidated (at leastaccording tomy experience: I was recompiling packages and didn't have anything to do with the jobs calling stored procedures from recompiled packages, unless call to the stored procedure changed,

RE: Oracle Jobs not restarting after upgrade

Title: RE: Oracle Jobs not restarting after upgrade Run them manually for the first time, or try dropping and recreating them. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any

RE: Oracle Jobs not restarting after upgrade

dbms_job.run ? -Original Message- Sent: 28 March 2003 17:09 To: Multiple recipients of list ORACLE-L Solaris 5.8 Oracle 8.1.6 upgrade to 9.2 We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all

Re: utl_smtp error

From: Joan Hsieh [EMAIL PROTECTED] Thanks for explantion. I asked the smtp mail admin. He said The relays are running Exim-4.10. Is that help? What is it you're trying to mail from the database? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps

RE: may not be necessary -- was RE: Oracle DB Backups on SAN with

We use the 'shadow mirror' process on a Hitachi SAN (with Oracle 8.1.7 on Solaris 8 and Veritas VxFS) successfully to refresh our development db without a suspend, or even hot backup mode. After the hair that I didn't pull out turned gray (though I am not willing to detail the incompetence on a

RE: Oracle Jobs not restarting after upgrade

Check you have the init.ora parameters set up in your new DB Brian -Original Message- Sent: Friday, March 28, 2003 12:35 PM To: Multiple recipients of list ORACLE-L dbms_job.run ? -Original Message- Sent: 28 March 2003 17:09 To: Multiple recipients of list ORACLE-L Solaris

snapshot too old

why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query . what is fix for this ? -ak

Re: Configuring Oracle with RAID and OFA

We back this up daily, with an additional archive log backup. The amount of space dedicated to redo is due to the size of the disks, 36 gig. Not much I can do about that. Now that I think of it, might be a good idea to setup so that archive logs will go to redo disks should the archive disk

RE: snapshot too old

AK Take a look at this. It explains it better than I could. http://home.clara.net/dwotton/dba/snapshot2.htm http://home.clara.net/dwotton/dba/snapshot2.htm Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003

RE: OT: uuencode adding characters

From: Saira Somani [EMAIL PROTECTED] Can you give me a hint? So I use Perl to rid the file of these characters and then uuencode it and then use mail utility to send to people? Won't uuencode do the same thing again and add those characters back? I haven't used uuencode, but basically what you

Re: copying datafile nt4-w2k

Certainly possible. I'm currently copying 8.0 files on NT to Win2k servers with 8.1.7 installed. Rebuild the controlfile, open the database and upgrade. Works great. Jared On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote: hi all We are planning an upgrade from NT4 to W2K. I am

Followup to jobs not running

I changed the job_queue_processes (thanks Barbara), and the jobs all started running, but they are not successful from within the job_queue. They are jobs to gather schema stats using dbs_stats and are run as the system user. I can run the what of the jobs within sqlplus successfully, but

Re: copying datafile nt4-w2k

Presuming this is a coldbackup.I recall trying it about a year or so ago with a hot backup and had a problem with recovery not knowing when to stop - it kept wanting more log files. [EMAIL PROTECTED] 3/28/03 1:43:41 PM Certainly possible.I'm currently copying 8.0 files on NT to Win2k

Re: snapshot too old

AK... this happens with LONG queries too... this means that you do not have enough rollback segments... or... that they are very small... HTH JL --- AK [EMAIL PROTECTED] wrote: why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query

Re: create interMedia index problem

Hi: The problem has been fixed. It turned out that we have very big storage clause for isistore. All these Intermedia tables will be created when InterMedia index gets created. So it would try to allocate six 1000M initial extents. And we don't have that many empty block in RESINDEX tablespace.

*Oracle DBA with 8i, OPS, and some SQL Server exp. needed-Los

Los Angeles area company (Torrance) needs an Oracle / SQL DBA to join their IT staff. This person will be the Oracle DBA and will be a backup for the SQL Server DBA. *Candidates in the Greater Los Angeles area will be given first priority. There are no relocation expenses provided, however if a

Re: Followup to jobs not running

Privileges should be granted to the user, who created the job. Was it system? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:13 PM I changed the job_queue_processes (thanks

Re: index on null column

AK, I'd still do some testing with a bitmap index on that column. You have 1,000,000 records. 500 records have value in that column. That means the absolute most distinct values in that column is 501. This is at least one criteria for bitmap candidacy. What I see in testing is select * from

SCN scheme 3

List, does anybody know what this means: SCN scheme 3 It occurs it the alert log upon startup. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: import problem - newbie question

LeRoy, Even though you start your import as system, when the process starts to import tables owned by (for example) 'appuser' it will switch to that user. What I'm thinking is that you should create the user in advance of starting the import and give the user adequate tablespace quota. I may be

RE: Followup to jobs not running

Yes. System is the job owner/creator. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Privileges should be granted to the user, who created the job. Was it system?

RE: Followup to jobs not running

That did not help. It takes longer to error out, but it is still failing. I can set the same jobs up for the sys user and they run without problems. I am not sure why the system user is the owner of the jobs and since I am the only DBA here this afternoon, I will have to wait until next week

RE: Unable to lock file

Dennis, I had set user profile prior to submit the job. It works fine for other databases. Is there any unix command to know the number of files locks currently used ? I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available. Thanks Rivaldi

RE: Followup to jobs not running

Title: RE: Followup to jobs not running login as sys and grant analyze any table to system. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an

RE: Unable to lock file

Another question, After change the kernel parameter (thru kmtune), to make the change take effect, do we need to relink the unix or just shutdown / reboot the machine ? Thanks. -Original Message- Sent: Friday, March 28, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Dennis, I

RE: Unable to lock file

The error is not specific to that database. At other time, the same error occured when starting other database. (I shutdown some small databases for daily cold backup). That's my question too, so far, why I'm able to start manually at daytime. May be less number of locks ? Thanks.

Oracle Grid,Streams

Hi List What are the Pros and Cons of the above?. Has anyone in the industry implemented the above successfully?. Are there any pitfalls / restrictions to using the above technology? TIA GovindanK -- * *YOU SHOULD TREAT

RE: Unable to lock file

You get this when another process has a lock on the file. Are you sure your shutdown was clean? Allan -Original Message- Sent: Friday, March 28, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Hi Listers, Oracle 8174, HP 11.00 I got the following error when starting up the

RE: Unable to lock file

On HP you must rebuild the kernel for the change to take effect. Allan -Original Message- Sent: Friday, March 28, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Rivaldi That requires way more Unix knowledge than I have and we don't run HP anyway. If it was simply the

Re: copying datafile nt4-w2k

Yes, the database is down while doing this. Opening the database and creating a controlfile works, but I really didn't expect recovery on an 8.0 database to work with 8i executables. Jared On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote: Presuming this is a cold backup. I recall

optimal set up of tablespaces on disks??

Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas

Re: Week - Date function!

Maybe a slight improvement. I borrowed heavily from Jonathan Gennicks pivot table article for this. :) http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html select x.d from ( select to_date(rownum, 'DDD') d, to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week from

RE: Oracle Grid,Streams

I think you're confusing something here, or maybe that's just the way the title of your email reads. Oracle has technology that fits in the grid computing paradigm, and Streams is obviously part of that. But there is no Oracle Grid product that you can buy that I'm aware of. Have you looked at

Re: Followup to jobs not running

You may have already got the answer, but if your job is selecting candidate tables or schemas from dba_tables or dba_???, then you have to grant select on them to system specifically. System gets the select privilege from the role DBA and not directly. I have a similar job that runs under a

Re: OEM 4

John, EM 4.0 is currently in beta and is available only to customers who are part of the beta program. Cheers, Gaja --- John Weatherman [EMAIL PROTECTED] wrote: Hi all, Is anyone aware of when OEM 4 will be available. I've been looking around on Metalink and can't seem to find anything

RE: Unable to lock file

I strongly suspect the problem involves environmental variables. One way to test this is from your interactive session do - env | sort -o /tmp/int.env Within your cron script do env | sort -o /tmp/cron.env Next do cd /tmp diff int.env cron.env Then make you cron environment match your interactive

Re: optimal set up of tablespaces on disks??

It depends: for maximum IO on redo, with mirrored redo logs: 4 2 x 36 RAID 1 for redo 1 2 x 36 for archive logs 1 2 x 36 for executables 2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable ) If you choose not to let oracle mirror the redo logs, you could take four of those drives and

RE: Urgent: restore from hot backup w/o archivelogs

Well If you don't mind possibly destroying the database you are trying to restore, you can use: alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1'; We had a strange failure / recovery situation and I was given this command. The description posted in the TAR was: A data

Re: Week - Date function!

Hello! Sesi Odury wrote: Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in SQL??? Using the simple statement below you can get the first date of the week (according to ISO standard). Then you can either add 6 to get