Due apologies for DDLs

Hi With due apologies to Perl fans and shell script fans, I have failed to understand why to obtain these DDLs the import option of show=Y indexfile=ddl_script.sql is NOT used after a export with rows=N Of course, 9i OCPs will swear by dbms_metadata! where will that leave our 'perl

Re: Due apologies for DDLs

show=y gives you a very unreadable, unusable (without major editing) file. --- Cyril Thankappan [EMAIL PROTECTED] wrote: Hi With due apologies to Perl fans and shell script fans, I have failed to understand why to obtain these DDLs the import option of show=Y indexfile=ddl_script.sql

Oracle9i Error within Cursor

Hi all, I wrote a script bellow. If it is run on Oracle 8 it runs fine and gives me all the result but on Oracle 9i it returns the error ORA-06502. Can anybody tell me please why? I have found a workaround - instead of select col||'x' colu from tbl union select col colu from tbl; use

Re: Oracle9i Error within Cursor

Michal Zaschke wrote: Hi all, I wrote a script bellow. If it is run on Oracle 8 it runs fine and gives me all the result but on Oracle 9i it returns the error ORA-06502. Can anybody tell me please why? I have found a workaround - instead of select col||'x' colu from tbl union select

RE: Becoming a DBA questions

Dear Gurus, It is very interesting to read all the different responses to this posting. I thought that I should add some of my observations during the past few months of job hunting. I am a trained accountant and had about 3 years of Oracle Financials (Functional) experience both as an

Fw: analyze a partitioned table

Good morning everyone, Can anyone give me the command to analyze a partitioned tabled? To analyze this table unpartitioned I use: analyze table schema.table_name compute statistics; I am partitioning it into 6 partitions and want to compute statistics on each partition.

[no subject]

Good morning everyone, Can anyone give me the command to analyze a partitioned tabled? To analyze this table unpartitioned I use: analyze table schema.table_name compute statistics; I am partitioning it into 6 partitions and want to compute statistics on each partition. Thanks in advance,

Re: Shared pool wait for library cache pin

Jared, We were seeing from 2 or 3 up to a dozen shared pool waits at a time for about 200 users. We normally haven't been seeing shared pool waits at all on this application. It was an unusual one to investigate. Our developer was extremely concerned about this issue and brought it to our

RE: A DBA's career development

Some people mentioned ERP -- here is a newsletter on ERP, but not limited to Oracle. If you enjoy reading ERPCentral’s Newsletter, please tell a friend or colleague about it. Anyone can sign up for a free subscription on our Web site at http://www.erpcentral.com e.g. of Oracle-related items:

Problem in rollback segment

Title: Problem in rollback segment Dear All, Whenever any insert is made in a particular table, one row exclusive lock attained by Oracle, additionally one of the rollback segment is exclusively getting locked. Also no one can insert into the table till the first transaction is committed

RE: Install 8.1.7 release 3 Enterprise Edition

Another down side of the default database is... the GUI tool that the Oracle Universal Installer invokes doesn't support locally managed tablespaces, if I remember correctly. So you will have to drop most of the tablespaces, then re-create them using DBA Studio if you want to use the GUI tools.

Re: Shared pool wait for library cache pin

George/Arun, Thanks for your helpful replies. This information may help me explain the performance problems that peaked yesterday. I do have timed_statistics set to true and my version is 8.1.5. How do you define whether a version count is high ? Is there some threshould that you cross

moving sys.aud$ in 8i

Is anyone still doing this? I found this in note 72460.1 on MetaLink: Note: Moving the SYS.AUD$ table out of the SYSTEM tablespace is not supported because the Oracle code makes implicit assumptions about the data

Re: Analyzing partitioned tables

Here is what we use which also incorporates usingour own definition ofSTALE with monitoring on. It includes indexes as well as partitioned and non-partitioned tables as well as non-monitored tables. HTH select 'analyze table ' || '${SCHEMA}.' || a.table_name || ' compute statistics;'

Re: Shared pool wait for library cache pin

George, Not particularly based on the number of users that we have. See my other reply to Jared for follow-up. Cherie George

RE:

Hi Ruth, According to the docs, the command is : analyze table {table} partition ({partition}); likewise: analyze index {index} partition ({partition}); HTH Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 03, 2002 8:00 AM To: Multiple

Re: Due apologies for DDLs

For those of us that are still 9i ignorant, you will need to explain your comment about 'dbms_metadata'. As for 'Perl expertise', you obviously don't know much about it. Jared On Wednesday 02 January 2002 23:55, Cyril Thankappan wrote: Hi With due apologies to Perl fans and shell script

RE: Shared pool wait for library cache pin

There are a lot of issues including memory leaks and shared pool problems that forced us to upgrade from 8.1. to 8.1.7.2 It's Oracle on Solaris. Contact Oracle Support. Regards, Waleed -Original Message- Sent: Thursday, January 03, 2002 8:35 AM To: Multiple recipients of list

RE:

Ruth I believe in its most basic form you can do analyze table table_name partition (part_name).. eg analyze table ruth.ruths_part_table partition (part1) compute statistics; Please correct me if I am wide of the mark, still an infant when it comes to partitioning and the like. HTH

Re:Problem in rollback segment

Smells like a software coding problem on the client side. Can you provide additional information on how the DB is getting updated? Some programmers/programs do a 'lock table tablename in exclusive mode' before inserting/deleting/updating which is totally unnecessary can cause your problem.

Re: Shared pool wait for library cache pin

there is a bug with 815 with timed_statistics = true. it will cause your sql not to be reused from the shared pool. search in metalink for more details.. try setting it to false... babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday,

RE:

Sorry - forgot the compute clause: analyze table {table} partition ({partition}) compute statistics; likewise: analyze index {index} partition ({partition}) compute statistics; Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 03, 2002 9:20 AM

Re: Shared pool wait for library cache pin

George, Thanks for this tremendously helpful email. Just what the doctor ordered. Cherie George

RE: analyze a partitioned table

Ruth, Pl check out dbms_stats package and gather_table_stats procedure in particular.. Here is an example from my scripts.. execute dbms_stats.gather_table_stats ('DBM','CAMPAIGNS',NULL, NULL, FALSE,'FOR ALL INDEXED COLUMNS SIZE 150',NULL,'ALL',TRUE,NULL,NULL, NULL); HTH, - Kirti

Re: Fw: analyze a partitioned table

Ruth, Good morning. To analyze a partition use; ANALYZE TABLE table PARTITION (partition name) COMPUTE STATISTICS The same is true for an INDEX and partition. Hope this helps. ROR mª¿ªm [EMAIL PROTECTED] 01/03/02 08:20AM Good morning everyone, Can anyone give me the command to

Pass Oracle 7 to Oracle 9

Title: Pass Oracle 7 to Oracle 9 I'm beginner in the DBA world I want to pass my DB Oracle 7 in Oracle 9. Could someone tell me which big points I need to know to do this passage in Oracle 9i which points i must be careful in ? Benoît NYSSEN Benoît NYSSEN

RE: Due apologies for DDLs

ORA-0666Warning. You have pushed the JaredPERL button. Cause: // You pushed the button. Action: // Stop it. -Original Message- Sent: Thursday, January 03, 2002 10:15 AM To: Multiple recipients of list ORACLE-L For those of us that are still 9i ignorant, you will need to

Re: Shared pool wait for library cache pin

George/Arun, I see that bug

DBA Job Description

I was wondering if anyone has a DBA job description, you know, the type that HR would want to see. I have finally convinced damagement that I am not a PC Programmer(my current title) since I write no code directly for end users. I do nothing but database stuff. I figured someone must have a

Re: Fw: analyze a partitioned table

Ruth, It is : analyze table schema.table_name partition (partition_name) compute statistics; Repeat for each of the six partitions. I always do the delete statistics statement first. I've had problems in the past with bits of old statistics hanging around and wreaking havoc. Cherie Machler

Re: Shared pool wait for library cache pin

George/Arun, Thanks for your helpful replies. This information may help me explain the performance problems that peaked yesterday. I do have timed_statistics set to true and my version is 8.1.5. and sql_trace? There are some workarounds posted in the bug report for the timed statistics

Re:

See http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem8a.htm#2058616 PARTITION | SUBPARTITION Specify the partition or subpartition on which you want statistics to be gathered. You cannot use this clause when analyzing clusters. If you specify PARTITION

upgrade strategy

The documented mechanisms for upgrading a db is to use the migration tool or run the u0xx.sql script on your old version data files. All this implies downtime which I cannot afford. How do 24x7 shops upgrade oracle software? I did the upgrade from 8.1.6 to 8.1.7 with a standby db

Is Same instance name possible on same server?

Hi Can I have same instance name on same unix server?If yes then how? Can I restore the database with diffrent name.Suppose I have backup of prod instance on one server.can I create prod1 instance name on diffrent server by having same hotbackup data files,archived log files and control files.?

Re:

Hi, Try ANALYZE TABLE schema.table_name PARTITION partition_name COMPUTE STATISTICS; /Quamrul From: Ruth Gramolini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 Jan 2002 05:00:20 -0800 Good morning everyone, Can

Crystal Report as an ad-hoc tool

Hi all: My users are considering using Crystal reports as an ad-hoc tool to query a DSS. They ran into several issues however using it. I was wondering if someone out there has ehough experience with that tool to shed some light. Issue 1. Whenever Crystal creates a query it only create a

Re: Shared pool wait for library cache pin

Cherie, Sounds like a bug: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=132632.1 1193003 This problem was introduced in Oracle 8.1.5 SQL statements may not be shared when they should be. This can increase

Re: Problem Setting Up User

I beg to differ. A default role is simply one that is automatically enabled (or set) upon login. Any or all of a user's roles may be default (see the definition of user_role_privs). May I suggest, Rachel my friend, that *you* RTFM? :-D --- Rachel Carmichael [EMAIL PROTECTED] wrote:

Re: Shared pool wait for library cache pin

Hi, There are a number of 8.1.5 bugs that can cause these symptoms. There is the null-refresh snapshot bug (1348501), and a number of aditional bugs of whihc may or may not be published (but that are referenced in other notes on metalink), including, but not limited to 1000866: HIGH

Re: Shared pool wait for library cache pin

George, I know that you don't support his scripts but do you happen to know if there is a cat script or something I need to run to get this view?: SQL @whence_invalids sys.x_$kglob o * ERROR at line 33: ORA-00942: table or view does not exist I seem to be missing it. I wonder if

Re: Shared pool wait for library cache pin

Hi Cherie, The version_count should be irrelevant of the number of users you have. I doubt this is a shared memory leak, it sounds like simple latch conetention based on the number of versions you have of certain queries. If flushing your shared pool resets the version count for that query,

RE: DBA Job Description

Maybe you can find something on one of those job websites? -Original Message- Sent: Thursday, January 03, 2002 9:30 AM To: Multiple recipients of list ORACLE-L I was wondering if anyone has a DBA job description, you know, the type that HR would want to see. I have finally convinced

Re: Becoming a DBA questions

Wow, Joe, $1000K for taking the tests? That's what I call an incentive! ;-) PB --- Joe Testa [EMAIL PROTECTED] wrote: Kimberly, I'm with you and like you I only took the 8 test because at the time, my employer paid for the tests and gave me a bonus to pass them(like $250/test and $1000K

Re: Oracle9i Error within Cursor

Good reason to do it right the the first time. Jared - ducking and running :) Michal Zaschke

Re:

Thanks everyone! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 10:00 AM Hi, Try ANALYZE TABLE schema.table_name PARTITION partition_name COMPUTE STATISTICS; /Quamrul From: Ruth Gramolini [EMAIL

Re: Is Same instance name possible on same server?

Hi Q) Can I have same instance name on same unix server?If yes then how? A) No Q) Can I restore the database with diffrent name. A) Yes but this is hard by hand but easy if you use Rman Q) Suppose I have backup of prod instance on one server. can I create prod1 instance name on

RE: Problem Setting Up User

I think there is a command like: alter user ??? default role all -Original Message- Sent: Thursday, January 03, 2002 12:30 PM To: Multiple recipients of list ORACLE-L I beg to differ. A default role is simply one that is automatically enabled (or set) upon login. Any or all of a

RE: upgrade strategy

Title: RE: upgrade strategy Use SharePlex for Oracle. Users can continue to do their activity on the primary machine, while you upgrade and test the secondary. Once the upgrade is complete, shareplex then applies the waiting transactions to the target. It's nice, because it can replicate

Installing Extra Oracle Features After The Initial Install

I have installed Oracle 8.1.6 on a Windows 2000 system. I would like to install the Test database and the Pro C++ wizards which were not installed in the original install. If I do a customized install, is it going to fowl up the stuff that has already been installed? What should I look out

Re:Is Same instance name possible on same server?

Same name on the same server, NO. But for the other review the create controlfile command. Dick Goulet Reply Separator Author: Seema Singh [EMAIL PROTECTED] Date: 1/3/2002 9:05 AM Hi Can I have same instance name on same unix server?If yes then

RE: A DBA's career development

I went the ERP route after having been an Oracle DBA for 3 years in 2001 when I was recruited by SAP to become a Basis consultant even though I had no SAP experience whatsoever (I think there were around 40 of us, many without any previous SAP experience). They put me in boot camp and fully

RE: Problem Setting Up User

Not true. Only one role can be the default role, if specified. If not specified then ALL are default. That is the only time! Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:

RE: Problem Setting Up User

Maybe I'm reading it wrong but with the syntax of alter user xxx default role all except role [,role]... and alter user xxx default role all role [,role]... according to my book then any combination of none, one, n, all would be possible. Iain Nicoll Duhveloper (I won't surprise anyone here if

Re: Problem Setting Up User

I have never said that I know all... and I have admitted to being wrong in the past. The correct solution was already given... but not in your reply --- Paul Baumgartel [EMAIL PROTECTED] wrote: I beg to differ. A default role is simply one that is automatically enabled (or set) upon login.

Loading a Nested table

Okay... I have been trying to help the programmer on our data warehouse project to get a nested table loaded... and we are failing miserably... Oracle 817 AIX unix We are reading a two tables in one schema, and loading result set into a table and a nested table in another schema. We run for

Moving Oracle software

If I copy the oracle software directories from one machine to another, should I run relink allbefore using them? This is an 8.1.6.3 implementation running under Solaris 2.7. The directory names are different on the new box (i.e. ORACLE_BASE is not the same), and the O/S patch level is off

RE: Moving Oracle software

Whenever you move Oracle software, you must relink. Especially with changes in the ORACLE_HOME and OS levels. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com

Re:Crystal Report as an ad-hoc tool

Gene, Don't go there, a MAJOR pain performance breaker. A good tool for simple reports, but NOT industrial strength. Been there, done that, damn it still hurts. I'd recommend a product called Brio instead (http://www.brio.com/products/overview.html). Otherwise see inline. Dick Goulet

Re: Moving Oracle software

i dont think you need a relink all. the path is always taken from your env variables so it does not need a relink... may be on some patch levels you might need a relink. try it w/o relinking and it it works its fine i have tried it w/o relinking and it works fine... babu - Original

Re: Shared pool wait for library cache pin

George, Just checked again right now.Following is the result that I got: SQL select version_count, count(*) from v$sqlarea group by version_count; VERSION_COUNT COUNT(*) - -- 1 48241 2 9 4 2

insert privilege across db link

database is 8.1.7 how do I grant insert privilege to a user in a different database? Note: the database link in place in both database and I can describe tables in each just fine. In the trigger I already have the insert into b.address@bschema. When I try to execute the trigger I get

root.sh wasn't run, help!

Well, I opened a TAR with Oracle but they still haven't gotten back to me and I need to know before I leave tonight (as I might not be leaving tonight). I was installing 8.1.7 on a server prior to doing an upgrade this weekend. Over an hour had passed after asking my SA to run root.sh for me and

RE: Problem Setting Up User

I don't know about default roles, but if you have none set as default, all are active. At 10:00 AM 1/3/02 -0800, you wrote: I think there is a command like: alter user ??? default role all -Original Message- Sent: Thursday, January 03, 2002 12:30 PM To: Multiple recipients of list

Re: insert privilege across db link

in the db link are you using the same user as the table owner in the remote db. in your case are you using the user b in your dblink? babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 3:35 PM database is 8.1.7 how

Re: Moving Oracle software

Just moving it is definitely not OK if the directory structures are not identical. Here's just one example, $ORACLE_HOME/bin/loadjava --- #!/bin/sh # # %W% %E% # unset JAVA_HOME JAVA_HOME=/www/OraHome1/JRE export JAVA_HOME

Re: root.sh wasn't run, help!

root.sh will update your oratab file. this is needed by many of the oracle tools. actually the root user can edit the file thru vi and update it/add the details to it. also it initializes some other directories - one of which could be your orainventory directory (i am making a guess here. pl

RE: insert privilege across db link

the db link is a public one owned by system. User B is only in Bshema. User A with the trigger is only is Aschema. Kathy -Original Message- Sent: Thursday, January 03, 2002 1:16 PM To: Multiple recipients of list ORACLE-L in the db link are you using the same user as the table owner

RE: root.sh wasn't run, help!

Thanks! Oracle finally got back to me and said I should be all right. They suggested just running root.sh and continuing with the remainder of the install steps. They're looking at the errors in the log file for me now. Jay Miller -Original Message- Sent: Thursday, January 03, 2002

Re: Due apologies for DDLs

dbms_metadata, a package that will let you pull ddl for objects out of the database in a readable format. joe Jared Still wrote: For those of us that are still 9i ignorant, you will need to explain your comment about 'dbms_metadata'. As for 'Perl expertise', you obviously don't know

Re: insert privilege across db link

what is the user in the db link. it it b or some other user? babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 4:30 PM the db link is a public one owned by system. User B is only in Bshema. User A with the trigger

RE: Problem Setting Up User

That's not quite the way it works. When a role is granted to a user, it automatically becomes a default role for that user. A role is made non-default via an alter user...set default role... statement. If such a statement is never executed for a user, then all of the user's granted roles

Re: Installing Extra Oracle Features After The Initial Install

Hi Rod, You should be able to create a test database by running the Database Configuration Assistant. Not sure about Pro*C but I believe adding them shouldn't affect anything else. John [EMAIL PROTECTED] wrote: I have installed Oracle 8.1.6 on a Windows 2000 system. I would like to

RE: Default roles (was: Problem Setting Up User)

Again, I beg to differ (with you and the others who questioned my reponse), and I stand by my earlier post. Oracle's alter user syntax allows for zero, one, or any number of the user's granted roles to be designated as default; from the manual: DEFAULT ROLE Specify the roles granted by default

Re: Becoming a DBA questions

Paul, just goes to show how many people on the listserv have me in their killfile, since you're the only one that caught it. joe Paul Baumgartel wrote: Wow, Joe, $1000K for taking the tests? That's what I call an incentive! ;-) PB --- Joe Testa [EMAIL PROTECTED] wrote: Kimberly,

re: utllockt under sqlplus

Patrice, If you want to be able to run under sqlplus you can edit the utllockt.sql script: search for the set charwidth line and comment it out and add a column line as below: --set charwidth 17; COLUMN waiting_session FORMAT A17 Note that the modified script won't work under svrmgrl - I

OTN Download Software Site

I have downloaded two of the 9i zip files from the OTN software site. I have one more to go and have not been able to get connected all day. Anyone know if there is a problem with the OTN site? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz

Re: Becoming a DBA questions

Actually, I passed it on to my supervisor with a brief (cynical) comment. evil grin Stephen [EMAIL PROTECTED] 01/03/02 03:35PM Paul, just goes to show how many people on the listserv have me in theirkillfile, since you're the only one that caught it.joePaul Baumgartel wrote: Wow, Joe,

FW: insert privilege across db link

Ok let's start over.hopefully this will be clearer. I created a public database link owned by system, system is the user I created the database link under. created in my Production database: create public database link ARCHIVE connect to system

Oracle 8.1.7 on Solaris 2.8?

Dear Gurus, I have a Sun machine with Solaris 2.8. As per Oracle 8.1.7 installation documentation, the compatible solaris versions are either 2.6 or 2.7. It did mention 2.8. Will there be any problem, if I install Oracle8.1.7 in this machine having Solaris 2.8? Thanks for

Re: Due apologies for DDLs

Ha! Too little too late. Jared Joe Testa

Export via pipe ksh script

Title: Export via pipe ksh script Could someone please send me a ksh script for doing imp/exp via a pipe. We're running AIX 4.3.3. Thanks! Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA

Re: FW: insert privilege across db link

Kathy, It's been awhile since I've dealt with distributed databases, so I can't recall some of the details clearly. This is just a prelude to telling you there's more than one way to do it, but the only one I can recall at the moment is the easiest one. :) Recreate your database link to

RE: Becoming a DBA questions

I went from fertilizer industry to oracle and things worked out ok. from what I've seen, going from networking to theatre seems like a similar natural progression. Date sent: Thu, 03 Jan 2002 01:05:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL

Re: Is Same instance name possible on same server?

Yes Virginia, you can have two instances with the same name on the same Unix server. We use them to upgrade database versions. The old one remains intact until the users accept the new one. All we change is the listener parameters for the ORACLE_HOME. An that's the trick; the ORACLE_HOMEs

Re: Export via pipe ksh script

Title: Export via pipe ksh script From http://www.orafaq.com(in the sig for this list): begin Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files

Re: XP Professional 9i (YES IT IS A CERTIFIED COMBO ACCORDING TO FETIDSTINK)

(Sorry to spoil everyone's fun) I'll probably have to know this fairly soon, so I looked it up. Oracle has certified the 9i client and 9i server for WindowsXP Pro (but not the Windows XP Home version). From MetaStink: ---excerpt--- General Notes For Oracle Server - Client On Microsoft

Re: Export via pipe ksh script

Is this what you are looking for? #!/bin/ksh mknod /tmp/exp_pipe p compress /tmp/exp_pipe export.dmp.Z exp file=/tmp/exp_pipe userid... log. Rob Pegram Oracle Certified DBA --- Thomas Jeff [EMAIL PROTECTED] wrote: Could someone please send me a ksh script for doing imp/exp via a

Re: Export via pipe ksh script

Title: Export via pipe ksh script Here's one: #!/bin/ksh # # ** # /etc/mknod /u14/ORA_DUMP/arc_tadrcv.dmp p compress /u14/ORA_DUMP/arc_tadrcv.dmp /u14/ORA_DUMP/arc_tadrcv.dmp.Z exp parfile=$HOME/exp_arc_tadrcv.par

Re: ORACLE-L Digest -- Volume 2001, Number 363

Well, if performance is all that important, I guess there is always Viagra? (signed) el fundamento viejo ORACLE-L Digest -- Volume 2001, Number 363 -- From: Mohan, Ross [EMAIL PROTECTED] Date: Fri, 28 Dec 2001 15:55:32 -0500 Subject: RE:

Why metastink {or fetidstink !} ??

Why do a large number of postings refer to MetaLink as MetaStink (or fetidstink) ? The only problem I have with MetaLink is that patch downloads fail mid-way [yes, this is a stink problem particularly when I have downtime on the server but don't have a patch ready !]. Let's be gracious and

RE: Becoming a DBA questions

I received the same bonus with my company. Not offered anymore though. That was back when companies where flashing around the big bucks. -Original Message- Baumgartel Sent: Thursday, January 03, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Wow, Joe, $1000K for taking the

using hints on views

i find the ordered hint extremely helpful... so i usually find myself using this hint... what is your opinion on using hints inside views? thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ:

RE: Becoming a DBA questions

Ok I guess I deserve any comments that come out of this. Take the K out of that. -Original Message- Smith Sent: Thursday, January 03, 2002 6:50 PM To: Multiple recipients of list ORACLE-L I received the same bonus with my company. Not offered anymore though. That was back when

RE: Why metastink {or fetidstink !} ??

Just think of it as a term of endearment -Original Message- [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 6:50 PM To: Multiple recipients of list ORACLE-L Why do a large number of postings refer to MetaLink as MetaStink (or fetidstink) ? The only problem I have with MetaLink is

Re: Installing Extra Oracle Features After The Initial Install

[EMAIL PROTECTED] 4/1/2002 5:05:29 If I do a customized install, is it going to fowl up the stuff that has already been installed? Only if you're chicken. Or act like a turkey. (Sorry for this poultry contribution :-)

Re: Why metastink {or fetidstink !} ??

feel free to use the correct term, and i'll feel free to use metalstink :) joe [EMAIL PROTECTED] wrote: Why do a large number of postings refer to MetaLink as MetaStink (or fetidstink) ? The only problem I have with MetaLink is that patch downloads fail mid-way [yes, this is a stink

Re: Why metastink {or fetidstink !} ??

Why do a large number of postings refer to MetaLink as MetaStink (or fetidstink) ? The only problem I have with MetaLink is that patch downloads fail mid-way [yes, this is a stink problem particularly when I have downtime on the server but don't have a patch ready !]. Two reasons I've

RE: [oracle-l-OT] Re: ORACLE-L Digest -- Volume 2001, Number 363

I am sorry, this is dangerously close to offtopic humor, and you'll have to move your old ass to the off topic list, where we can pump you up with Viagra, and return your sense of youth, humor, and satisfaction to you. -Original Message- To: [EMAIL PROTECTED] Sent: 1/3/2002 9:13 PM

not using indexes

Dear All, I have been entrusted to tune a web based application. This product is at development stage. I generated the trace file and found out the indexes on the table. So I specified hints in all the queries and tested the application. There was a remarkable increase in performance. Can any

Re Re: Due apologies for DDLs

U r right ..I still dunno 'much' about perl.. as for dbms_metadata it is a built in pl/sql package saying 'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual; gives the entire ddl creation script. However, 'interestingly' execute

  1   2   >