Re: Becoming a DBA questions
I agree also, I've been working with Oracle since version 4 and the rates here in austin,tx are anywhere from $35/hr to $75/hr, and chances are pretty slim finding an company willing to pay $75/hr for an senior person, and usually its an 1099 job when it comes to $75/hr job. dan whatley Randy Kirkpatrick wrote: > > Either he's full of crap, or they're paying him way too much unless he has > some other managerial responsibilities. The only way to make 200K is to be a > sought-after independent consultant (at $100 an hour or so). The going rate > in the Denver area is $40 - $60 an hour (sometimes up to $75, but never > $100!) > > Randy > > -Original Message- > [EMAIL PROTECTED] > Sent: Friday, January 04, 2002 11:16 AM > To: Multiple recipients of list ORACLE-L > > Lemme get this right. > > This guy is a *new* DBA. He's making 150k and he's not > even a senior DBA, where he can make 200k? > > That's all from me. I'm gonna go sulk now. > > Jared > > DENNIS WILLIAMS > list ORACLE-L <[EMAIL PROTECTED]> > TOUCH.COM>cc: > Sent by: Subject: RE: Becoming a DBA > questions > [EMAIL PROTECTED] > m > > 01/04/02 09:05 > AM > Please respond > to ORACLE-L > > The following eweek article might be of interest. If the link gets mangled, > the article is at http://www.eweek.com Following the Data to a DBA Job by > Jeff Moad. > http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Randy Kirkpatrick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Whatley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ANALYZED Questions?
Hi Seema, Those tables are used by the replication services to populate changes to other snapshot/master databases. When you create a primary key snapshot log on a master table, execute an "alter snapshot log add primary key" in addition to MLOG$_, an temporary table by the name "RUPD$_ will also be created. To remove them, you would run this PL/SQL script, and as an rule of thumb, before you try this, be sure to try this out on an test database "BEFORE" running on your production database to verify the end results. dan whatley Sr. Oracle DBA Global Information Systems Motorola, Inc. 7700 W. Parmer Ln. Austin, Tx 78729 [EMAIL PROTECTED] Remove Temporary Updatable Snapshot Logs Determine if you have temporary updatable snapshot logs by issuing the following SQL statement: SELECT owner, table_name FROM dba_tables WHERE temporary='Y' AND table_name LIKE 'RUPD$%'; If any rows are returned, temporary updatable snapshot logs exist in your database. Run the following PL/SQL block to remove them: DECLARE sql_cur BINARY_INTEGER; dummyBINARY_INTEGER; new_flag BINARY_INTEGER; CURSOR mv_logs IS SELECT '"'||mowner||'"."'||temp_log||'"' temp_log, flag, mowner, master FROM mlog$ m WHERE temp_log IS NOT NULL FOR UPDATE; BEGIN sql_cur := dbms_sql.open_cursor; FOR alog IN mv_logs LOOP new_flag := alog.flag; IF dbms_ijob.bit(new_flag, 64) THEN ---KKZLOGTUPS new_flag := new_flag - 64; END IF; BEGIN dbms_sql.parse(sql_cur, 'DROP TABLE ' || alog.temp_log, dbms_sql.v7); dummy := dbms_sql.execute(sql_cur); UPDATE mlog$ m SET flag = new_flag, temp_log = NULL WHERE m.mowner = alog.mowner AND m.master = alog.master; EXCEPTION WHEN others THEN NULL; --- Ignore the error END; END LOOP; dbms_sql.close_cursor(sql_cur); COMMIT; EXCEPTION WHEN others THEN IF dbms_sql.is_open(sql_cur) THEN dbms_sql.close_cursor(sql_cur); END IF; RAISE; END; / Seema Singh wrote: > > Hi > I execute DBMS_UTLITY ANALYSE SCHEMA for one schema .I Found some of tables > like > RUPD$_GT_PRODUCTS > RUPD$_GT_TEL_NUMBER_AFF_MA > RUPD$_GT_USER_EMAIL_ADDRES > RUPD$_GT_USER_PROVIDER_THR > are no analysed. > Any idea What kind of these tables are? > Why they are not analysed? > Thanks > -Seema > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Whatley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Change PCTINCREAE for SYSTEM Tablespace
Hi Ken, If no one has told you yet, all you have to do is to use the "alter tablespace" command, for example: alter tablespace system default storage (pctincrease 0); select tablespace_name, pct_increase from dba_tablespaces where tablespace_name='SYSTEM'; You shouldn't need to rebuild your database, (e.g. your control files) to reset this tablespace storage parameter. Hope this resolves your problem for you there. Dan Whatley Sr. Oracle DBA Motorola, Inc. Global Information Systems 7700 W. Parmer Ln. Austin, Tx 78729 Ken Janusz wrote: > > Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace > without recreating the DB? For some reason the person who created the DB I > am working on set PCTINCREASE to 50 (or didn't did not include this > parameter).I am using this DB for a data conversion so there is no > software connected to it and in turn no users on it. > > Thanks, > Ken Janusz, CPIM > Database Conversion Lead > Sufficient Systems, Inc. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dan Whatley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).