DBA opening in San Diego

http://careers.peopleclick.com/jobposts/Client40_HomeDepot2/BU1/External/259-277.htm -- 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--

Re: DROP DEVELOPER not working

Privs obtained via roles (such as DROP TABLE) are NOT transferred (by default) when inside PL/SQL procedures. Rajesh.Rao@jpmcha

PROCESS column in V$SESSION

For folks connecting to the DB server from another Unix box the PROCESS field is the Process ID on the host named in the MACHINE field. For folks connecting to the DB server from a PC the values are in the form of : So what do signify? WENDYC

Re: Difference - Rebuild and Analyze index

At least on my DB's doing ALTER INDEX index_name REBUILD does in fact populate the statistics. I discovered this by accident on one RBO DB which started giving poor performnce after doing some REBUILDs (OPTOMIZER_MODE=CHOOSE).

Re: supplying dblink name to package at runtime

The way I solved this problem is to create a useable dummy DB_LINK so that compiling the code will succeed. The only minor gotcha is that what will result if/when a bogus dblink is passed into the code for real at run time. HTH YMMV HAND!

Re: Installing iAS 9.0.2.0.1

I've been trying off on for about 5 MONTHS to get 9iAS R2 into a useable condition. Either I'm suffering from a bad case of senioritis or this s/w should be classified as User Hostile s/w NOT ready for prime time. I'd like to hear from anybody who has this POS installed in production;

9iAS R2 printing Unix

A week or so ago I posted WRT having problems printing a report directly to a printer from 9iAS R2. I've been battling Oracle ever since to get this BUG resolved. AFAIK, the bug exists for at least Solaris, AIX HP. Since I only have been working with Solaris for the last 6+ years, I might

RE: Oracle 10i features

In addition to 9iAS R2 being a terrible install, it is riddled with bugs and a total beast to get operational! I'll give folks another example. If/when you HOST out from a 9i Form your Unix process environment is populated with about 18 environmental variables. The problem is that NONE of the

db file sequential read

I'm search of perfection in an imperfect world. This problem involves a V7.3.4.5 DB on V2.6 Solaris. As part of our nightwork batch processing, a bunch of reports are run against the DB. I have a DBMS_JOB which reports when processes are waiting for events like db file sequential read. I

Re: Migration Assistant Speeds

I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours. Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. THT YMMV!

List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema

OK, I started out thinking that this would be easy. What is a pure SQL solution which generates a results set containing a list of TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]

Re: OT: Guidelines/Standards for supporting non-oracle databases

Unfortunately, the ACCESS virus has been let loose in my company. The main production Oracle database consumes about 150GB. The total sum of ACCESS files in now at 200+GB growing at a faster rate than the Oracle files. The users spend a LOT of time trying to reconcile differences between various

Re: Methods to get DDL

Again, why NO Oracle version specified? If on 9i DB, then use DBMS_METADATA HTH YMMV HAND! Bob Metelsky

Re: Oracle Portal resources

Oracle 9iAS R2 is massive, overly complex, a royal pain to install configure and riddled with BUGS. For example, on Solaris the Reports Server will NOT print a report directly to a printer after a new installation. I have an open bug with Oracle where I created a simple script which conatined

Re: corrupted database

My main production DB in the past would get EXCURCIATINGLY slow during normal business hours. It would slow down so much that the customer service folks would revert to hand writing orders on paper. We could never identify any pattern or any culprit until I got the book Oracle Performance Tuning

9iAS Release2

Since Oracle has been unable to help and since I'm desparate, I'm hoping that some list member will be able to provide me a much needed clue. We hope/plan to have separate Development, Q/A and Production Forms Reports servers running R2, (not R1). AFAIK, The Forms builtin function

Re: Determine max # of concurrent users at schema level

[EMAIL PROTECTED] desc v$license NameNull?Type --- SESSIONS_MAX NUMBER SESSIONS_WARNING NUMBER SESSIONS_CURRENT NUMBER SESSIONS_HIGHWATER

Who has package open

I realize that a package can't be recompiled while a session has it open. How do I identify which session has a package open? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: OT: HOTSOS Symposium

I'm signed up am looking forward to attending it! Larry Elkins

RE: Calculating new PCTFREE and PCTUSED !!!!!1

What I've done, is I have some PL/SQL code which looks for chained rows. When the number of chained rows exceeds 5% it proceeds to unchain the rows. Upon completion it increases the PCTFREE by 5% decrease PCTUSED by 5%. This process continues until they reach values which don't induce chaining.

RE: Calculating new PCTFREE and PCTUSED !!!!!1

No, I won't post it because I downloaded it from another list member's website (??) years ago. Ask me again on Monday, when I'm back in the office will be able to give a better (more detailed) answer.

Re: question on tkprof

As a test I took a *trc file generated on a V7.3.4.5 DB and copied it to a system where I have a dataless 9i copy of the same DB. I used TKPROF from 9i got all the wait statistics reported along with the relevant EXPLAIN PLAN! HTH YMMV HAND! -- Please see the official ORACLE-L FAQ:

Re: Oracle 9i 32bit and 64bit on the same server

I'm using sudo to accomplish something similar; to allow the operators to startup shutdown Oracle. Joshua Becker

Re: Connexion between 9iAS and Oracle 7.3.4

It works here for both 9iAS R1 R2! Amos KABORE

RE: Re[2]: undo tablespace

AFAIK, in 8i+ tablespaces can be created with theNOLOGGING clause LOGGING | NOLOGGING Specify the default logging attributes of all tables, indexes, and partitions within the tablespace. LOGGING is the default. The tablespace-level logging attribute can be overridden by logging

RE: Take Care of your DBAs

Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND!

Re: 2k and 8k block size

There was a presentation at the recent HOTSOS conference which showed a performance gain by placing indexes in tablespaces with a LARGE blocksize. HTH YMMV HAND!

Perl for Oracle DBA

I want to strongly recommend the book Perl for Oracle DBA authored by Andy Duncan (this list's manager) Jared Still. I've been a DBA for around 7 years have been doing Perl for longer than that. The code and examples in this book will be put to good use here; as soon as I get some time to put

Re: metadata repository

YES! Buy the book Perl for Oracle DBA install execute the copy-lefted code described in this GREAT tome! Tracy Rahmlow

Oracle events - #s names

From V9.2.0 ORA-1: controlfile debug event, name 'control_file' ORA-10001: controlfile crash event1 ORA-10002: controlfile crash event2 ORA-10003: controlfile crash event3 ORA-10004: controlfile crash event4 ORA-10005: trace latch operations for debugging ORA-10006: testing - block recovery

Oracle Tech Support

Today I opened yet another iTar on the VERY buggy 9iAS R2 Reports Server. Below is a CLASSIC response to my report of errors being generated. There is a Unix generic solution that you can try . Use the command like this : + rwclient.sh userid=mwh/***@prod authid=orcladmin/**

Re: Autoextend on Oracle 7.3.4.5.0

select * from filext$; AFAIK an entry here means this file is now in auto-extend mode. HTH YMMV HAND! Sam Bootsma

V7.3.4.5

[EMAIL PROTECTED] / FILE# PHYRDSPHYWRTS PHYBLKRD PHYBLKWRTREADTIM WRITETIM -- -- -- -- -- -- -- 73340334 309044567713 30904 362219 1476572 111157340 39121270225

Re: Script to Turn Off All Oracle Auditing Options?

I see yet another poor soul still supporting V7.3.4.5 as I am doing on V2.6 Solaris. You should be warned that on a couple of different occasions (I'm a slow learner) when I launched a SQL script which changed AUDITing on hundreds of objects, Oracle went bonkers. It appearded as though the

AUDITs

Solaris V2.6 Oracle V7.3.4.5 For the last hour or more I've tried to RTFM, but I have been unable to find anything which gives me a clue. Below are some AUDIT_ACTIONS their counts from the AUD$ view. 100 LOGON 3279 102 LOGOFF BY CLEANUP

Re: Hot backups

Yes, I believe there is a better way. 1) Get the current SCN 2) Update a record in the DB with SCN# COMMIT; 3) Get the current SCN; 4) While #1 SCN #3 SCN go to #1 5) switch logfile 6) Write #3 SCN out to a file which can be used to decide when to stop applying redo logfiles. 7) After the DB

v$sqlarea v$session

I'm suffering from a senior moment. The question is at the every bottom. SQL select sql_text from v$sqlarea sa where buffer_gets 1 SQL_TEXT SELECT RP.RELPART FROM OERELPART RP, PARTOFFERING PO, PART P

RE: v$sqlarea v$session

From Window A SQL / SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES CONSISTENT_CHANGES -- -- --- -- - -- 169838526512700725 22864266596 18526 173 182492

Re: v$sqlarea v$session

THANKS AK! 1 select oc.sid, ss.serial#, user_name, osuser, sa.sql_text 2 from v$open_cursor oc, v$session ss, v$sqlarea sa 3 where oc.sid = ss.sid 4 and oc.address = sa.address 5 and oc.hash_value = sa.hash_value 6* and buffer_gets 1 SQL / SIDSERIAL#

v$sql ?

Just moments ago I ran the query below got 40 rows returned. I'm at a loss to explain how an SQL statement can have ZERO parse_calls and ZERO executions while recording actual work against the DB select FIRST_LOAD_TIME, DISK_READS , BUFFER_GETS , ROWS_PROCESSED, sql_text from v$sql where

V$LOCK and V$LOCKED_OBJECTS

I'd like to join V$LOCK V$LOCKED_OBJECTS, but I've been spectacularly unsuccessful. So I'm asking for assistance. I suspect that I need to use a 3rd table or view, but I haven't found any common fields to link associated records together. TIA! -- Please see the official ORACLE-L FAQ:

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: Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl?

A V9.2 DB can't/won't talk to a V7 DB, and vice versa. So we were forced into using a V8.1.7 DB as the middle man. It works for low volume transactions.

RE: Oracle Performance Tuning 101 Book now Available!

I refuse to do business with spammers; regardless of what their product may be. Johnson, Michael

9iAS R2 V9.0.2.0.1 Solaris 9

Has anyone successfully installed 9iAS R2 V9.0.2.0.1 on Solaris 9? I'm asking because I've tried failed numerous times. I opened a TAR with Oracle on the 10th and am still waiting for an answer from them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET:

Re: getting estimate of result set from v$sql_plan

DBMS_XPLAN Stephane Faroult

Re: recreate constraints script - URGENT

For 9i DBs, DBMS_METADATA will (re)create DDL for every (at least most) object in the DB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

Re: Startup Migrate

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_15a.htm#2110144 MIGRATE Use the MIGRATE clause only if you are upgrading from Oracle release 7.3.4 to the current release. This clause instructs Oracle to modify system parameters dynamically as required for the

measuring TPM

I've been asked to provide value for the Transactions Per Minute going through our primary OLTP production database. I believe I can use deltas in SCN values to measure transactions which do INSERT/UPDATE/DELETE and then COMMIT; Is there any way to measure/count the number of SELECTs which