Re: WHICH TABLE NEED TO INCREASE FREELISTS
Hi Seema, I use this below. SELECT s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.st ate FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND s.header_block=w.p2; - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 11:38 PM > Hi > Is any way which tables need to increase more freelists? > Thx > -Seema > > > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > -- > 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: Bunyamin Karadeniz 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: Help me tuning the log file sync wait event
Hi , You encounter log file sync and log file parallel write events . This can be because of a slow device on which redo log files are on . OR your redo log sizing is bad. Bunyamin Karadeniz Oracle DBA Havelsan A.S. Eskisehir yolu 7.km Ankara / Turkey Tel : +90 535 3357729 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 6:33 AM > hi, dbas: > One of the database i manage face a serious wait event, log file sync. This is a big and busy oltp system, and using disk array of Sun T3 with raid-5. We are using Veritas QuickIO for datafile and redo log files. > The pressure on the database is growing fast, and more and more the redo log becomes the bottleneck of the database. > Here is some data showing the fact: > > > > 2002/05/03 > Top 5 Wait Events > ~ Wait % Total > Event Waits Time (cs) Wt Time > --- > log file sync 82,244 92,442 33.68 > db file sequential read 298,301 80,719 29.41 > log file parallel write81,849 36,989 13.48 > db file parallel write 5,427 33,615 12.25 > control file parallel write 4,6736,104 2.22 > > > 2002/05/07 > Top 5 Wait Events > ~ Wait % Total > Event Waits Time (cs) Wt Time > --- > log file sync 6,352,383 15,785,313 40.09 > db file sequential read26,862,699 12,538,922 31.85 > log file parallel write 5,971,2293,990,066 10.13 > db file parallel write290,4793,164,391 8.04 > db file scattered read 1,749,137 814,981 2.07 > > 2002/05/21 > Top 5 Wait Events > ~ Wait % Total > Event Waits Time (cs) Wt Time > --- > log file sync 2,207,6096,688,751 59.47 > log file parallel write 2,044,9771,385,379 12.32 > db file parallel write103,1551,203,077 10.70 > db file sequential read 8,772,9081,088,922 9.68 > log buffer space3,284 222,604 1.98 > > 2002/05/28 > Top 5 Wait Events > ~ Wait % Total > Event Waits Time (cs) Wt Time > --- > log file sync 2,247,585 20,529,779 63.71 > db file parallel write441,0524,377,899 13.59 > log file parallel write 1,724,0893,806,535 11.81 > db file sequential read 8,854,5252,044,020 6.34 > enqueue78,759 592,411 1.84 > > 2002/07/04 > Top 5 Wait Events > ~ Wait % Total > Event Waits Time (cs) Wt Time > --- > log file sync 3,838,694 13,158,371 63.28 > db file sequential read 2,189,8632,401,275 11.55 > log file parallel write 3,401,0352,098,018 10.09 > db file parallel write 97,0861,503,608 7.23 > enqueue71,251 432,706 2.08 > > 2002/07/11 > Top 5 Wait Events > ~ Wait % Total > Event Waits Time (cs) Wt Time > --- > log file sync 453,8629,679,513 68.11 > db file sequential read 500,1571,660,982 11.69 > db file parallel write 67,2351,137,017 8.00 > log file parallel write 163,1801,075,201 7.57 > log fi
Re: Buffer busy waits are 10.96% of non-idle waits
ost databases that run in exclusive mode see zero waits on this block class because their DBAs do not create objects with free list groups. Otherwise, the reasons and solutions for free list block waits are similar to those of segment header waits. See that section for details. Identifying block waits by file X$KCBFWAIT shows a count of buffer busy waits per file. The indx column represents the file id number - 1. So this view can be queried to determine which file has a high number of buffer busy waits. select indx+1 fileno, count, time from x$kcbfwait where time != 0 or count > 0 order by time; If the file with highest wait time is known, find the objects that belong to that file: select file_id, segment_name, segment_type, freelists, freelist_groups, pctfree, pctused from dba_extents where file_id = ; Bunyamin Karadeniz Oracle DBA Havelsan A.S. Eskisehir yolu 7.km Ankara / Turkey Tel : +90 535 3357729 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 8:48 AM > Guys, > > " Buffer busy waits are 10.96% of non-idle waits " > > TOAD gives this alarm often. what does it mean ? which view will > give me the wait statistics ? > > " it occurs when a session cannot access a block because it is in > use by another session. The two most common causes are > insufficient free lists for a table or insufficient rollback > segments. " --- IS THIS THE REASON ? > > what should be the value of this , i mean , the safe limits ? > > How do i approach and solve this issue ? > kindly enlighten me. > > TIA. > _ > There is always a better job for you at Monsterindia.com. > Go now http://monsterindia.rediff.com/jobs > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: oraora oraora > 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: Bunyamin Karadeniz 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: STATSPACK and sppurge.sql
I changed the sppurge.sql and written a line to use my largest RBS when deleting. And then deleting 500 snaps lasts only 10 minutes in my db. And I also can advise you to replace DELETE with TRUNCATE in sppurge.sql. Bunyamin Karadeniz Oracle DBA Havelsan A.S. Eskisehir yolu 7.km Ankara / Turkey Tel : +90 535 3357729 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 1:34 AM > Jesse - I'm doing this from memory, so I may be off a little. Look at the > table STATS$SNAPSHOT. Records in this table are related to the other tables > that are populated each time a snapshot occurs (the magic of relationships). > If you delete a row from this table, rows in the other tables are > automatically deleted. Since deleting statistics is a low-risk proposition > for most of us, give it a try. Start by deleting 10 rows to start with, > because deleting is SLOOOW!! As I recall, deleting a 100 snapshots may take > 30 minutes. Anyway, this is the best way I've found to delete STATSPACK > statistics. > > Dennis Williams > DBA, 20% OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, July 08, 2002 3:25 PM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > I'm going to (finally!) be implementing STATSPACK on our 8.1.7.2.0 DB. The > thing that kills me is all the junk that "?/rdbms/admin/sppurge.sql" leaves > behind! Is there any harm in deleting the rows from these tables: > > select table_name > from user_tab_columns > where column_name = 'SNAP_ID'; > > ...where the SNAP_ID is in the range I want to delete? > > I've seen a few messages in the archives that dealt with this, but none I > found were comprehensive in their deletes. Or am I just being too > aggressive with this? > > TIA! > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > 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: 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: Bunyamin Karadeniz 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).
How to use these MTS TUning Scripts
How can I use these scripts below to tune MTS ? Bunyamin SQL> select paddr,type,queued,wait,totalq, 2 decode(totalq,0,0,wait/totalq) "AVG WAIT" from v$queue; PADDRTYPE QUEUED WAIT TOTALQ AVG WAIT -- -- -- -- -- 00 COMMON 0 131585196771 ,002531957 140E11EC DISPATCHER 0 136409 548604 ,248647476 140E1514 DISPATCHER 0 178022 977429 ,182132922 140E183C DISPATCHER 0 4381852406714 ,182067749 140E1B64 DISPATCHER 0 2771101054844 ,262702352 140E1E8C DISPATCHER 0 146121 671815 ,217501842 SQL> select name "NAME", paddr,requests, 2 (busy/(busy + idle)) * 100 "%TIME BUSY" from v$shared_server; NAME PADDR REQUESTS %TIME BUSY -- -- S000 140DD2CC2004637 15,3597284 S001 140DD5F41380026 9,76323755 S002 140DD91C 862050 5,642241 S003 140DDC44 532685 2,77508729 S004 140DDF6C 261459 1,34762108 S005 140DE294 107879 ,521803133 S006 140DE5BC 35905 ,227110307 S007 140DE8E4 14320 ,102182328 S008 140DEC0C 4316 ,04232294 S009 140DEF34 1527 ,013207575 S010 140DF25C436 ,006863212 NAME PADDR REQUESTS %TIME BUSY -- -- S011 140DF584 40 ,006196229 S012 140DF8AC 9 ,004030979 S013 140DFBD4 8 ,003254756 S014 140DFEFC 5 ,001988269 S015 140E0224 9 ,00106223 S016 140E054C 5 ,68091 S017 140E0874 5 ,000136184 S018 140E0B9C 5 ,27237 S019 140E0EC4 7 ,68092 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz 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: Count rows in textfile
You can do it easily with AWK
awk -f myawk1 /dir1/masters.txt
source of myawk1 is :
BEGIN { } END {print "there are ",NR," lines" }
Bunyamin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 9:03 PM
My wife recently bought a book called "Unix for Dummies". I'm sure it
documents the command you need if you are using any flavor of Unix. For
Micromonopoly operating systems, either get a Unix shell emulator such as
cygwin or find a Microsoft Press book and see what it says.
Of course, any command that counts rows in a text file will need to open the
file -- there is no alternative.
Kevin Kennedy
First Point Energy Corporation
-Original Message-
Sent: Wednesday, July 03, 2002 1:43 AM
To: Multiple recipients of list ORACLE-L
Anyone whom has a good example on how to check "how many rows (without
opening the file) does a text file consists of?
What is the command?
Thanks in advance
Roland
--
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: kkennedy
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: Bunyamin Karadeniz
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: Unable to connect to an Oracle Instance
I have experienced this error with MTS. And the solution is either entering IP dbmachinename.domainname to the host file in system32/drivers/etc/ to client . OR to the DNS of domain. Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 03, 2002 2:28 PM Hi, I am not able to connect from my oracle client to an oracle db server (NT) When i try to configure and test for the ora service(from my work station) it says "Connecting...ORA-12545: Connect failed because target host or object does not exist The test did not succeed.(this particular ora instance is not connectable from any workstation) " Thanks in Advance K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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: Bunyamin Karadeniz 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: exp full=y
I import with show=y first with a log file ,
then analyze the log file . And change the create tablespace statements to
the disks I want to create my datafiles and then create tablespaces ..
Then import with ignore=y so that create tablespace statements give error
stating that tablespace is already exist.
But I check and see that every other thing is okay.
I use full import and I have not seen any problems yet.
Be careful that it will import public synonyms too.
Bunyamin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 6:53 PM
> On Wed, Jul 03, 2002 at 09:02:34AM -0400, Ray Stell wrote:
> >
> > I want to move a db to a different machine with a different disk
> > layout. If I create the db and tablespaces on the new machine, can I
> > use a dmp file created by exp full=y to move all the data? The dmp
> > tries to create the tablespaces under the old structure, and these
> > commands will fail, because the names are already there. Are there
> > other things in the dmp that will shoot me in the foot?
> --
>
> Pressing on, I was able to hit a few toes. I get the following
> errors. I neglected to mention I am moving from 8.1.7.2 to 8.1.7.4.
>
> IMP-00017: following statement failed with ORACLE error 4042:
> "BEGIN "
> "SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_DEFER_QUERY
TO D"
> "BA');"
> "COMMIT; END;"
> IMP-3: ORACLE error 4042 encountered
> ORA-04042: procedure, function, package, or package body does not exist
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "SYS.DBMS_UTILITY", line 409
> ORA-06512: at line 2
>
> All of the subsequent calls to DBMS_UTILITY get the same errors.
> So, what did I miss? Where is this utility supposed to be created?
> ===
> Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
> 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: Bunyamin Karadeniz
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: Oracle 8.1 and 8.0.5 compatibility
I had experienced a similar thing too. But I had opened the database with the compatible parameter database needed to startup.. Try to change the compatible parameter in my opinion to open the database. , Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 12:03 PM > I had a problem. > Trying to drop a column from a Oracle 8i Table (personal edition on a > w2kPro) i got the following message (or similar) " you can't drop a table > with 8.0.5 compatibility, you need at least 8.1.0. ! > Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba studio) > and all seems to be right. > The first time i've restarted the dba machine Oracle did not come up any > more (the db was mounted but not opened). > Other way i cant go back to 8.0.5 compatibility because the dropped column ! > what can i do ? > Any help will be appreciated. > Marcello > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Marcello Savino > 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: Bunyamin Karadeniz 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: Oracle client won't install on Windows 2000
Check if the processor is P4. If so , you must replace the symcjit.dll and jvm.dll with the ones in 9i CD. Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 12:03 AM > One of our developers is having a problem installing Oracle Client > (8.1.7). When he inserts the CD the initial screen comes up with the > options to Install/Deinstall products, Explore CD, Browse Documentation. > When he clicks on Install/Deinstall, however the Oracle Installer never > comes > up. > > Any ideas what might be wrong? > > Thanks > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > 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: Bunyamin Karadeniz 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: system event waits
It was talked on the list and had been said that 1% of performance it affects nearly as I remember. Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 4:23 AM > Do you guys think making times statistic =true has any performance impact . > Are there any other considerations ? > > -Bp > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 12:53 PM > > > > > Depending on the version of the database, timed_statistics > > > may be dynamic > > > and > > > not require a database bounce. > > > > True - but the timing values are meaningless unless the counters > > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the > > counters and switches on timing at the same time I wouldn't recommend > > using the time values otherwise. > > > > John Kanagaraj > > Oracle Applications DBA > > DBSoft Inc > > (W): 408-970-7002 > > > > Want to know about a carpenter who built a bridge with two sticks and > three > > nails? Write me for details! > > > > ** The opinions and statements above are entirely my own and not those of > my > > employer or clients ** > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Kanagaraj > > 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: BigP > 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: Bunyamin Karadeniz 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: Re: Re:MTS performance is too bad.
t; > > > you > > > are running into ora-4030s or other memory problems. > > > > > > > > When you say performance is a problem, have you check OS swapping of > > > memory to disk? Your SGA might be too big (with AS and the 3GB switch no > > > bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping > > > out to disk. > > > > > > > > You also need to make sure that only OLTP users (users with short > > > > txns, > > > NOT long running batch jobs, big updates, etc) are connecting via MTS. > > > All batch/DSS type users should be connecting via dedicated server. You > > > can have them specify this in their tnsnames.ora. > > > > > > > > That said, your MTS config is WAY out of whack given the number of > > > concurrent users: > > > > > > > > You only need ONE dispatcher to start with. Change dispatchers to 1 > > > > unless > > > you have multiple NICs you are working off of for a particular > > > segmentation of users. (50 dispatchers would be appropriate for about > > > 12,000 Concurrent > > > users) > > > > > > > > If your total number of concurrent OLTP users is truly 50 set your min > > > servers to 60. Max servers is fine. > > > > > > > > You should also set your large pool instead of a massive shared pool, > > > > all > > > kinds of reason for doing this!! > > > > > > > > If you have a chance go to borders or barnes and noble, sit down and > > > > read > > > chapter 7 (Oracle Connectivity) of my book "Oracle9i for Windows 2000 > > > Tips & Techniques". It covers the setup, monitoring and basic tuning of > > > MTS. > > > > > > > > I hope this helps, > > > > > > > > Mike Sale > > > > > > > > > > > > > > > > > > > > > > mts_max_servers=750 > > > > > mts_min_servers=100 > > > > > dispatchers=50 > > > > > users total 750 > > > > > users concurrent at most 50 > > > > > > > > > > > > > > > - Original Message - > > > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > > > Sent: Wednesday, June 26, 2002 9:58 PM > > > > > > > > > > > > > > >> Bunyamin, > > > > >> > > > > >> What is MTS_MAX_SERVERS & MTS_MIN_SERVERS set to? Also what is > > > > >> the total > > > > >> number of users connecting to the database? > > > > >> > > > > >> Dick Goulet > > > > >> > > > > >> Reply Separator > > > > >> Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> > > > > >> Date: 6/26/2002 8:49 AM > > > > >> > > > > >> I have changed my 8.1.7.3.2 database to MTS on win2000. But > > > > >> performance is too bad. > > > > >> I have 800 MB of shared pool and not setted large_pool_size. > > > > >> 50 dispathers, 100 processes and 750 max processes. > > > > >> > > > > >> What can I do ? Have you got an idea. How can I check the mts > > > > > performance? > > > > >> > > > > >> Bunyamin > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> I have changed my 8.1.7.3.2 database to MTS > > > > > on > > > > >> win2000. But performance is too bad. > > > > >> I have 800 MB of shared pool and not setted large_pool_size. > > > > >> 50 dispathers, 100 processes and 750 max > > > > > processes. > > > > >> > > > > >> > > > > >> > > > > >> What can I do ? Have you got an idea. > > > > > How can > > > > >> > > > > >> I check the mts performance? > > > > >> > > > > >> Bunyamin > > > > >> > > > > >> -- > > > > >> Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > >
Re: Re: Re:MTS performance is too bad.
gt; > > > If you have a chance go to borders or barnes and noble, sit down and > > read > chapter 7 (Oracle Connectivity) of my book "Oracle9i for Windows 2000 > Tips & Techniques". It covers the setup, monitoring and basic tuning of > MTS. > > > > I hope this helps, > > > > Mike Sale > > > > > > > > > > > > mts_max_servers=750 > > > mts_min_servers=100 > > > dispatchers=50 > > > users total 750 > > > users concurrent at most 50 > > > > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Wednesday, June 26, 2002 9:58 PM > > > > > > > > >> Bunyamin, > > >> > > >> What is MTS_MAX_SERVERS & MTS_MIN_SERVERS set to? Also what is > > >> the total > > >> number of users connecting to the database? > > >> > > >> Dick Goulet > > >> > > >> Reply Separator > > >> Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> > > >> Date: 6/26/2002 8:49 AM > > >> > > >> I have changed my 8.1.7.3.2 database to MTS on win2000. But > > >> performance is too bad. > > >> I have 800 MB of shared pool and not setted large_pool_size. > > >> 50 dispathers, 100 processes and 750 max processes. > > >> > > >> What can I do ? Have you got an idea. How can I check the mts > > > performance? > > >> > > >> Bunyamin > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> I have changed my 8.1.7.3.2 database to MTS > > > on > > >> win2000. But performance is too bad. > > >> I have 800 MB of shared pool and not setted large_pool_size. > > >> 50 dispathers, 100 processes and 750 max > > > processes. > > >> > > >> > > >> > > >> What can I do ? Have you got an idea. > > > How can > > >> > > >> I check the mts performance? > > >> > > >> Bunyamin > > >> > > >> -- > > >> 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: Bunyamin Karadeniz > > > 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: MICHAEL.SALE > > 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 containi
Re: Re: Re:MTS performance is too bad.
Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedicated connections even not approached. Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 4:53 PM > You really don't need MTS with no more than 50 concurrent users unless you are running into ora-4030s or other memory problems. > > When you say performance is a problem, have you check OS swapping of memory to disk? Your SGA might be too big (with AS and the 3GB switch no bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out to disk. > > You also need to make sure that only OLTP users (users with short txns, NOT long running batch jobs, big updates, etc) are connecting via MTS. All batch/DSS type users should be connecting via dedicated server. You can have them specify this in their tnsnames.ora. > > That said, your MTS config is WAY out of whack given the number of concurrent users: > > You only need ONE dispatcher to start with. Change dispatchers to 1 unless you have multiple NICs you are working off of for a particular segmentation of users. (50 dispatchers would be appropriate for about 12,000 Concurrent users) > > If your total number of concurrent OLTP users is truly 50 set your min servers to 60. Max servers is fine. > > You should also set your large pool instead of a massive shared pool, all kinds of reason for doing this!! > > If you have a chance go to borders or barnes and noble, sit down and read chapter 7 (Oracle Connectivity) of my book "Oracle9i for Windows 2000 Tips & Techniques". It covers the setup, monitoring and basic tuning of MTS. > > I hope this helps, > > Mike Sale > > > > > > > mts_max_servers=750 > > mts_min_servers=100 > > dispatchers=50 > > users total 750 > > users concurrent at most 50 > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, June 26, 2002 9:58 PM > > > > > >> Bunyamin, > >> > >> What is MTS_MAX_SERVERS & MTS_MIN_SERVERS set to? Also what is > >> the total > >> number of users connecting to the database? > >> > >> Dick Goulet > >> > >> Reply Separator > >> Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> > >> Date: 6/26/2002 8:49 AM > >> > >> I have changed my 8.1.7.3.2 database to MTS on win2000. But > >> performance is too > >> bad. > >> I have 800 MB of shared pool and not setted large_pool_size. > >> 50 dispathers, 100 processes and 750 max processes. > >> > >> What can I do ? Have you got an idea. How can I check the mts > > performance? > >> > >> Bunyamin > >> > >> > >> > >> > >> > >> > >> > >> > >> I have changed my 8.1.7.3.2 database to MTS > > on > >> win2000. But performance is too bad. > >> I have 800 MB of shared pool and not setted > >> large_pool_size. > >> 50 dispathers, 100 processes and 750 max > > processes. > >> > >> > >> > >> What can I do ? Have you got an idea. > > How can > >> > >> I check the mts performance? > >> > >> Bunyamin > >> > >> -- > >> 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: Bunyamin Karadeniz > > INET: [EMAIL PROTECTED] > > > > Fat City Network Service
Re: Re:MTS performance is too bad.
I agree with you but that will not help me in performance ... Bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 12:28 PM > Bunyamin, > > You probably only need about 2 dispatchers. I think Oracle suggest 1 > dispatcher for every 1000 users but that figure seems a little low to me, > I'd work on the basis of 1 dispatcher for every 500. > > As for shared servers, work on the basis of 1 for every 10 users. > > Try this > > mts_servers = 5 > mts_max_servers = 10 (increase if needed) > dispatchers = 2 > > Ade > > -Original Message- > Sent: 27 June 2002 09:18 > To: Multiple recipients of list ORACLE-L > > > mts_max_servers=750 > mts_min_servers=100 > dispatchers=50 > users total 750 > users concurrent at most 50 > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, June 26, 2002 9:58 PM > > > > Bunyamin, > > > > What is MTS_MAX_SERVERS & MTS_MIN_SERVERS set to? Also what is the > total > > number of users connecting to the database? > > > > Dick Goulet > > > > Reply Separator > > Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> > > Date: 6/26/2002 8:49 AM > > > > I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is > too > > bad. > > I have 800 MB of shared pool and not setted large_pool_size. > > 50 dispathers, 100 processes and 750 max processes. > > > > What can I do ? Have you got an idea. How can I check the mts > performance? > > > > Bunyamin > > > > > > > > > > > > > > > > > > I have changed my 8.1.7.3.2 database to MTS > on > > win2000. But performance is too bad. > > I have 800 MB of shared pool and not setted > > large_pool_size. > > 50 dispathers, 100 processes and 750 max > processes. > > > > > > > > What can I do ? Have you got an idea. > How can > > > > I check the mts performance? > > > > Bunyamin > > > > -- > > 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: Bunyamin Karadeniz > 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). > > -- > Live Life in Broadband > www.telewest.co.uk > > > The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. > Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. > > > == > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Adrian Roe > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Publ
Re: Re:MTS performance is too bad.
mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 9:58 PM > Bunyamin, > > What is MTS_MAX_SERVERS & MTS_MIN_SERVERS set to? Also what is the total > number of users connecting to the database? > > Dick Goulet > > Reply Separator____ > Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> > Date: 6/26/2002 8:49 AM > > I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too > bad. > I have 800 MB of shared pool and not setted large_pool_size. > 50 dispathers, 100 processes and 750 max processes. > > What can I do ? Have you got an idea. How can I check the mts performance? > > Bunyamin > > > > > > > > > I have changed my 8.1.7.3.2 database to MTS on > win2000. But performance is too bad. > I have 800 MB of shared pool and not setted > large_pool_size. > 50 dispathers, 100 processes and 750 max processes. > > > > What can I do ? Have you got an idea. How can > > I check the mts performance? > > Bunyamin > > -- > 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: Bunyamin Karadeniz 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).
MTS performance is too bad.
I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin
Re: How do YOU use Java in the DB?
I use it for emails with attachments and running OS commands within database; Look at akadia.com for javamail and here it explains how it is used. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 07, 2002 5:03 AM > > I use it for email. > > Jared > > On Thursday 06 June 2002 14:07, Jesse, Rich wrote: > > So, we've finally taken the jump and are using JSPs (erm..."Java Stored > > Procedures", not "Java Server Pages") on 8.1.7.2.0. > > > > Informal Poll: How do you use Java Stored Procedures? > > > > 1) Easy interface from PL/SQL to "lp" and other OS commands. > > 2) > > 3) > > 4) > > ... > > > > Rich Jesse System/Database Administrator > > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI > > USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > 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: Bunyamin Karadeniz 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: Jr.DBA, Mid level DBA, Sr.DBA
That is my opinion .. Jr. learns the methods. Mid. knows the methods and predicts the results of some. Sr. had used all of them and knows the results. Guru seems to know the database internal code. Bunyamin Karadeniz - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 11:50 PM > The Jr knows the passwords and where to find the databases. (Data) > The Mid knows the answers to the exam questions. (Information) > The Sr knows how the systems integrate and where to find things out. > (Knowledge) > The Guru knows the engine internals but also knows to test for 'features'. > (Wisdom) > > -Original Message- > Sent: Friday, May 31, 2002 1:11 PM > To: Multiple recipients of list ORACLE-L > > > The jr thinks that she knows. > The mid knows that she knows. > The sr knows that she knows not. > > Awareness of ignorance is the mark of true knowledge. > > I like cake. > > jack silvey > > > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > I agree, the Jr. DBA must focus on learning. > > Mid DBA...is still learning. Many Mid still view > > tuning/troubleshooting as > > an art (with a little magic thrown in) > > Sr. DBA...is still learning. Realizes that database > > management is a science, > > requiring research, expirementation and a very > > healthy dose of skepticism. > > > > The best Sr. DBAs that I know are the first ones to > > say 'I don't know'. That > > is the only true path to learning. No one can know > > everything. Often times > > the Jr. DBA will be a great source of knowledge > > since they don't know what > > NOT to ask. > > > > Reaction to reading Books/Documentation > > Junior - I did not know that > > Mid - I know that > > Senior - Perhaps...let's prove it > > > > When a developer/user asks for a change to the > > database > > Junior - I'll look it up and change it > > Mid - I have a script to do that, I'll let you know > > when I am done > > Senior - Why are you needing this change? Did you > > realize that x will cause > > y? Let's figure out the best way to accomplish the > > result. > > > > When faced with an undocumented condition/unknown > > error > > Junior - Log a TAR, get frustrated with 'We need a > > trace file. We need more > > information. '. Calls more > > senior help. > > Mid - Remembers a passage in a book, tries out the > > command. Fixes the > > symptom. > > Senior - Knows that x can cause y, if z is present. > > Tracks condition from > > symptom through to actual problem. > > > > Attends sessions at IOUG > > Junior - Assumes that all speakers know exactly what > > they are talking about > > and all vendor tools work as advertised. > > Mid - Listens to and believes Tim, Cary, Craig, > > Rich, Rachel, Gaja and all > > other High Holy Oracle Gurus preach > > Senior - Listens to, questions and tests (on non > > production systems) what > > Tim, Cary, Craig, Rich, Rachel, Gaja and all other > > High Holy Oracle Gurus > > preach > > > > Knowledge level > > Junior - Has no clue what they know and don't know > > Mid - Knows what they know > > Senior - Knows what they don't know > > > > Every Senior DBA is a mix of Jr. and Mid. They may > > know a great deal about > > one subsystem of Oracle, but lack knowledge in > > another area. > > > > > > Daniel W. Fink > > Sr. Oracle DBA > > MICROMEDEX > > 303.486.6456 > > > > > > -Original Message- > > Sent: Friday, May 31, 2002 2:43 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Junior DBA's job is a learning. > > Mid DBA's job is a science. > > Sr. DBA's job is the Art. > > > > Srs feel database, users, developers and everything > > else. > > They feel what, where, how, when and why should by > > done. > > Their intuition is of high degree. > > ... and everybody is sure - the Sr DBA knows > > everything. (so one of the > > priority of Sr DBA is to make this impression) > > > > -- > > Alexandre > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Alexandre Gorbatchev > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 &
online backup question .
I must write an online backup script for the database 8.1.7 . Are my steps below true ? 1) Alter system archive log current ; 2) Alter tablespace begin backup; copy datafiles Alter tablespace end backup; FOR ALL TABLESPACES EXCEPT TEMPORARY ONES. 3) alter database backup controlfile to trace; 4) alter database backup controlfile to :\bunyamin\yedek\controlfiles\controlxxx.ctl' 5) alter system archive log current; 6) alter system switch logfile; 7) copy e:\orafiles\archivefiles\uybs\archive\*.* E:\bunyamin\yedek\archivefiles del e:\orafiles\archivefiles\uybs\archive\*.* /q 8) copy G:\orafiles\redologfiles\UYBS\*.* E:\bunyamin\yedek\redologfiles What is the differnce between "ALTER SYSTEM SWITCH LOGFILE , ALTER SYSTEM ARCHIVE LOG CURRENT, ALTER SYSTEM ARCHIVE LOG ALL" Thank you ... Bunyamin
Re: Data Auditing
I do it with triggers for each table . I capture the old and new values and construct the sql , user, sysdate,table_name and rowid and insert them to a table . if you want i can send you one example . bunyamin - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 8:38 PM > > > Does anyone have any recommendations on auditing data changes on several > tables? I want to keep before and after data along with username/timestamp. > > I'm thinking of a DML trigger on each table and each with its own audit > table? Or what about a single audit table (using TO_CHAR to convert all > non-character data into the BEFORE and AFTER columns; only CHAR, VARCHAR2, > DATE and NUMBER datatypes are used). That should be slightly more generic. > > Either way it seems a bit messy. Anybody got a better idea? (This audit > trail has to be readily visible to the users - ie. a table - Log Miner > isn't really practical). > > Many thanks for any suggestions. > - Bill. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bill Buchan > 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: bunyamin karadeniz 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).
