RE: kill session privilage
I imagine the reason goes something along the lines of Sometimes developers fire off queries that are going to run for an exceptionally long time, often accidentally If you are only talking about killing sessions on a development machine then I think it's a fairly valid request - I can't imagine why a developer would ever want to kill a production session. The earlier suggestion of writing a procedure and granting execute rights on that procedure is an approach I have heard of before. Goulet, Dick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: kill session privilage [EMAIL PROTECTED] .com 14/01/2004 08:44 Please respond to ORACLE-L First question for the boss, WHY? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:44 AM To: Multiple recipients of list ORACLE-L Subject: kill session privilage My boss want me to give kill session privilage one of the developer here . He doesn't have any dba privilage to see session or anything . Is there any way I can give likited access to him. Thanks, ak Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: kill session privilege
At 01:24 AM 1/14/2004, Mark Richard wrote: I imagine the reason goes something along the lines of Sometimes developers fire off queries that are going to run for an exceptionally long time, often accidentally If you are only talking about killing sessions on a development machine then I think it's a fairly valid request - I can't imagine why a developer would ever want to kill a production session. Well, sometimes developers are asked to generate ad-hoc reports for management. In those cases, it's pretty easy to accidentally generate the query from heck and need to kill it. The earlier suggestion of writing a procedure and granting execute rights on that procedure is an approach I have heard of before. What I've generally seen is a stored procedure that checks to make sure that the session the user is trying to kill is their own, probably logs the kill in some sort of audit table, etc. I don't have much of a problem with a developer killing their own session even in production. Justin Cave Goulet, Dick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: kill session privilage [EMAIL PROTECTED] .com 14/01/2004 08:44 Please respond to ORACLE-L First question for the boss, WHY? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:44 AM To: Multiple recipients of list ORACLE-L Subject: kill session privilage My boss want me to give kill session privilage one of the developer here . He doesn't have any dba privilage to see session or anything . Is there any way I can give likited access to him. Thanks, ak Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Should we stop analyzing?
Dunno how he does it. But I'd settle for my replies from my ISP to make it here... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - How do you know they're nodding if they call you on the phone? Distinct rattling sound? :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Import foibles
I the big motivation for the ol' SQL*Plus COPY command was to improve upon this. Of course COPY is disappearing as well isn't it? Cheers Connor --- Jared Still [EMAIL PROTECTED] wrote: My apologies if there are multiple copies of this. Something funky going on with email from work. First, the basics: System Configuration: Sun Microsystems sun4u SUN Enterprise 420R (2 X UltraSPARC-II 450MHz) System clock frequency: 113 MHz Memory size: 1024 Megabytes = CPUs = Run Ecache CPUCPU Brd CPU Module MHz MBImpl. Mask --- --- --- - -- -- 0 2 2 450 4.0 US-II10.0 0 3 3 450 4.0 US-II10.0 The CPU's are about 95% idle. Not much memory paging activity. The disk is (gasp!) a single RAID 5 volume. As this is a mostly read system, it (usually) doesn't matter. Oracle is 8.1.7.2 Doing an import into the database with the following script: imp userid=$USERNAME/[EMAIL PROTECTED] \ file=/u03/tmp/${OWNER}_dv01.dmp \ buffer=10485760 \ fromuser=$OWNER \ touser=$OWNER \ ignore=y \ commit=y \ constraints=n \ indexes=n \ grants=n \ log=imp_${OWNER}.log Notice that the buffer is 10m and commit=y. This job is running very slowly. Querying v$session_event reveals many and long waits for log file sync. TIMEAVG TOTAL TOTAL WAITED WAIT USERNAME SID EVENT WAITS TIMEOUTS SECONDS 100ths -- -- --- -- JKSTILL12 latch free 63 49 0 1 log buffer space 4818 2 641 13 log file switch completion 9 0 3 37 log file sync 628432 6 212193 34 db file sequential read 27 0 3 10 file open 3 0 0 0 SQL*Net message to client 1257012 0 3 0 SQL*Net message from client 1257012 0 211774 17 SQL*Net more data from client 118572 0 9 0 9 rows selected. Notice that the value for log file sync seems a bit high for a session that has been connected for a little over 2 hours. Even so, it does accumulate rapidly. 10 seconds of activity garners 8 seconds of log file sync waits. This is not a terribly fast system, but it should not be this slow. The following query shows that the average blocks per commit is about 4.5. select blocks_changed, user_commits, blocks_changed / user_commits blocks_per_commit from ( select stat.value blocks_changed from v$sesstat stat, v$statname name, v$session sess where stat.sid = sess.sid and stat.statistic# = name.statistic# and name.name = 'db block changes' and stat.sid = 12 ) r1, ( select stat.value user_commits from v$sesstat stat, v$statname name, v$session sess where stat.sid = sess.sid and stat.statistic# = name.statistic# and name.name = 'user commits' and stat.sid = 12 ) r2 With an 8k block, that is about 36k per commit. Somewhat less than the 10m per commit I expected. Suspecting that the LONG datatype in some of the tables may be the culprit, a quick perusal of TFM reveals the following regarding the use of the LONG datatype with the imp utility: The integer specified for BUFFER is the size, in bytes, of the buffer through which data rows are transferred. BUFFER determines the number of rows in the array inserted by Import. The following formula gives an approximation of the buffer size that inserts a given array of rows: buffer_size = rows_in_array * maximum_row_size For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, or DATE columns, rows are inserted individually. The size of the buffer must be large enough to contain the entire row, except for LOB and LONG columns. If the buffer cannot hold the longest row in a table, Import attempts to allocate a larger buffer. So, the buffer parameter has no effect on tables containing columns of the type long, lob, bfile, ref, rowid, urowid or date. This seems rather limiting for such an important utility. This applies to versions 8.1.7 and 9.2.0 I ran a test to load 90k rows into 2 different tables, the only difference being that one used a long column for text
Re: Read Only TBS Backup Confirmation
Gene, That's the purpose of read-only tablespaces. You make to changes you need in the data, alter it to read only, and back it up to the backups device(disk,tape) and but the backup on the shelf. That way your 500 Gig datbase with 500 Meg active only requires the 500 Meg be backed up. Ron [EMAIL PROTECTED] 01/13/2004 11:24:24 AM ENV: - AIX 4.3.3 - Oracle 8.1.7 I have one tablespace which is read only. Can I just copy the datafiles from a Read Only tablespace for a valid backup? For the rest of the db, I backup hot or cold. Is anyone copying Read Only Tablespace datafiles for backups? I haven't found this method officially supported by Oracle, but have read that is safe to copy Read Only datafiles (makes sense), just wondering if anyone is doing it? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Setting up Windows 2000 for Oracle Parallel Server
Hi all, Id like to ask you about how to prepare windows 2000 environment so I can set Oracle Parallel Server on it, aside from networking problem. As I read the doc, I have to set up raw disk and prepare the OS by installing some options to prepare for the parallel server. The question is I dont know what options or additional software to install on Windows 2000 for OPS. I have 2 servers running on windows 2000 and I plan to set multi clustered environment. Can you help me, please? Thank you all in advance. Regards, Wendry.
RE: Table access
Perhaps you can query dba_tab_privs. -Original Message- Tracy Rahmlow Sent: Tuesday, January 13, 2004 10:19 PM To: Multiple recipients of list ORACLE-L I am looking for a script that I can supply a table name and it returns all users that have access to it (either directly, thru system priveleges or thru roles) and what the access is. Does anybody have something like this that I can use? Thanks American Express made the following annotations on 01/13/2004 08:16:14 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** OCP for 9i requirements -- Instructor Led Class is a
Sure. Read Important Program Announcement: Oracle University Hands-On Course Requirement Oracle customers and business partners are demanding hands-on experience - with all aspects of Oracle's database - from their Oracle Certified Professionals. In order to meet our commitment to our customers and constituents, Oracle University has recently made a significant investment in its Certification Program. Three distinct changes are being rolled out with the goal of increasing the level of quality of our certification skill and ability benchmarks: ·Scenario-based testing in all Oracle9i DBA Certified Professional exams . ·Instructor-led class requirement for candidates starting on the Oracle9i DBA Certified Professional credential exam path. ·A new hands-on Masters Practicum Exam for the Oracle9i Database Administrator Certified Master credential. at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html Instructure-led class is a requirement. You CAN take the Online Training to _prepare_ for the Exams. But you MUST attend at least one Instructor-led class to qualify for the certification. Hemant At 10:34 AM 13-01-04 -0800, you wrote: why dont you just read what is on the oracle website? www.oracle.com do a search for certification. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Subject: Re: ** OCP for 9i requirements Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is at least one Instructor Led Training. Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
9i OEM/tools to monitor 8i instances
LG, Has there been any issue monitoring and administering 8i databases using 9i tools? I am seeing some strange behavior when using 9i OEM tools to monitor 8.1.7.0 database and unfortunately I can not reproduce on a consistent basis. TIA, Nikhil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikhil Khimani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Import foibles
Yes, I once imported a schema [Parametric Windchill] which had a few tables with LONG datatypes. It was one particular table that took ggg to import. Import does import one-row-at-a-time for tables with LONGs . But I couldn't explain why one table took so much longer than the others. I just kept logs of the export and import sessions but didn't follow up as this was a Development environment. Hemant At 06:24 PM 13-01-04 -0800, you wrote: My apologies if there are multiple copies of this. Something funky going on with email from work. First, the basics: System Configuration: Sun Microsystems sun4u SUN Enterprise 420R (2 X UltraSPARC-II 450MHz) System clock frequency: 113 MHz Memory size: 1024 Megabytes = CPUs = Run Ecache CPUCPU Brd CPU Module MHz MBImpl. Mask --- --- --- - -- -- 0 2 2 450 4.0 US-II10.0 0 3 3 450 4.0 US-II10.0 The CPU's are about 95% idle. Not much memory paging activity. The disk is (gasp!) a single RAID 5 volume. As this is a mostly read system, it (usually) doesn't matter. Oracle is 8.1.7.2 Doing an import into the database with the following script: imp userid=$USERNAME/[EMAIL PROTECTED] \ file=/u03/tmp/${OWNER}_dv01.dmp \ buffer=10485760 \ fromuser=$OWNER \ touser=$OWNER \ ignore=y \ commit=y \ constraints=n \ indexes=n \ grants=n \ log=imp_${OWNER}.log Notice that the buffer is 10m and commit=y. This job is running very slowly. Querying v$session_event reveals many and long waits for log file sync. TIMEAVG TOTAL TOTAL WAITED WAIT USERNAME SID EVENT WAITS TIMEOUTS SECONDS 100ths -- -- --- -- JKSTILL12 latch free63 49 0 1 log buffer space4818 2 641 13 log file switch completion 9 0 3 37 log file sync 628432 6 212193 34 db file sequential read 27 0 3 10 file open 3 0 0 0 SQL*Net message to client1257012 0 3 0 SQL*Net message from client 1257012 0 211774 17 SQL*Net more data from client 118572 0 9 0 9 rows selected. Notice that the value for log file sync seems a bit high for a session that has been connected for a little over 2 hours. Even so, it does accumulate rapidly. 10 seconds of activity garners 8 seconds of log file sync waits. This is not a terribly fast system, but it should not be this slow. The following query shows that the average blocks per commit is about 4.5. select blocks_changed, user_commits, blocks_changed / user_commits blocks_per_commit from ( select stat.value blocks_changed from v$sesstat stat, v$statname name, v$session sess where stat.sid = sess.sid and stat.statistic# = name.statistic# and name.name = 'db block changes' and stat.sid = 12 ) r1, ( select stat.value user_commits from v$sesstat stat, v$statname name, v$session sess where stat.sid = sess.sid and stat.statistic# = name.statistic# and name.name = 'user commits' and stat.sid = 12 ) r2 With an 8k block, that is about 36k per commit. Somewhat less than the 10m per commit I expected. Suspecting that the LONG datatype in some of the tables may be the culprit, a quick perusal of TFM reveals the following regarding the use of the LONG datatype with the imp utility: The integer specified for BUFFER is the size, in bytes, of the buffer through which data rows are transferred. BUFFER determines the number of rows in the array inserted by Import. The following formula gives an approximation of the buffer size that inserts a given array of rows: buffer_size = rows_in_array * maximum_row_size For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, or DATE columns, rows are inserted individually. The size of the buffer must be large enough to contain the entire row, except for LOB and LONG columns. If the buffer cannot hold the longest row in a table, Import attempts to allocate a larger buffer. So, the buffer parameter has no effect on tables containing columns of the type long, lob, bfile, ref, rowid, urowid or date. This seems rather limiting for such an important utility. This applies to versions 8.1.7 and 9.2.0 I ran a test to load 90k rows into 2 different tables, the only difference being
where is Sort area size
Hi all , is sort are size a part of PGA ? Rgds. Arslan.
List problems
Folks, It seems that a fair number of emails are not being retransmitted to the list. Some of mine and a few others have not appeared in list traffic sent out to subscribers. Searching by author at fatcity.com reveals that the posts made it there, but either are not being sent out, or getting shanghaied along the way. I'll let you know when I find out. I am of course, assuming that some of you will get this one... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** OCP for 9i requirements -- Instructor Led Class is a
If you go to the Update 9i exam listing - there are no course requirements. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hemant K ChitaleSent: Wednesday, January 14, 2004 9:09 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ** OCP for 9i requirements -- Instructor Led Class is aSure.Read "Important Program Announcement: Oracle University Hands-On Course RequirementOracle customers and business partners are demanding hands-on experience - with all aspects of Oracle's database - from their Oracle Certified Professionals. In order to meet our commitment to our customers and constituents, Oracle University has recently made a significant investment in its Certification Program. Three distinct changes are being rolled out with the goal of increasing the level of quality of our certification skill and ability benchmarks: ·Scenario-based testing in all Oracle9i DBA Certified Professional exams . ·Instructor-led class requirement for candidates starting on the Oracle9i DBA Certified Professional credential exam path. ·A new hands-on Masters Practicum Exam for the Oracle9i Database Administrator Certified Master credential. "at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html"Instructure-led class" is a requirement.You CAN take the Online Training to _prepare_ for the Exams. But you MUST attend at least one Instructor-led classto qualify for the certification.HemantAt 10:34 AM 13-01-04 -0800, you wrote: why dont you just read what is on the oracle website?www.oracle.comdo a search for certification. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Subject: Re: ** OCP for 9i requirements Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is "at least one Instructor Led Training". Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes Hemant K ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). Hemant K ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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
RE: data file permissions --
SyncSort is NOT a data unloader. It's purpose, and it does a damned good job of it, is to sort large text files to improve data loading with tools like SQL*Loader. Your user should have zero access to the datafiles, period. They need to be -rw-r so that an ipc dedicated server process will work. But under NO circumstances should that be changed. Doing so can make for a VERY long night of recovering a database. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 13, 2004 5:14 PM To: Multiple recipients of list ORACLE-L Oracle data files are read BY ORACLE SERVER PROCESSES ONLY! The only unloader that reads files directly is the notorious DUL. I haven't had any experiences with DUL, but according to what I know, I wouldn't even want to have it. Now there is a system call named chmod and oracle takes care that only oracle RDBMS can access files. Nobody but the DBA can even sniff database files. Please, execute that user. On 01/13/2004 04:19:25 PM, [EMAIL PROTECTED] wrote: Hello All, I have a question on data file permissions. When i add a new data file, it gets created as -rw-r- Umask for oracle user is 022. There is a unix user who wants read access to the data files since they are read by fastunload process (syncsort). When i do a touch on any file in that same directory the permission reads as -rw-r--r-- which coincides with the umask set. Could someone please tell me how the data files get -rw-r and NOT -rw-r--r--. Oracle file permission reads -rwsr-s--x Thank You, Sathish. -- http://www.fastmail.fm - Choose from over 50 domains or use your own -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: kill session privilage
Well, I guess I could agree with that. But here if a duhveloper needs a session killed, he calls. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 3:24 AM To: Multiple recipients of list ORACLE-L I imagine the reason goes something along the lines of Sometimes developers fire off queries that are going to run for an exceptionally long time, often accidentally If you are only talking about killing sessions on a development machine then I think it's a fairly valid request - I can't imagine why a developer would ever want to kill a production session. The earlier suggestion of writing a procedure and granting execute rights on that procedure is an approach I have heard of before. Goulet, Dick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: kill session privilage [EMAIL PROTECTED] .com 14/01/2004 08:44 Please respond to ORACLE-L First question for the boss, WHY? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:44 AM To: Multiple recipients of list ORACLE-L Subject: kill session privilage My boss want me to give kill session privilage one of the developer here . He doesn't have any dba privilage to see session or anything . Is there any way I can give likited access to him. Thanks, ak Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
Sorta OT: Uncle Larry's no longer Chairman!
And he apparently got hitched, too. Wondering if Wall Street has any thoughts on this... http://www.eweek.com/article2/0,4149,1435093,00.asp Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
JVM for DBA
Hi all, Does anyone have any good resources on the Oracle JVM from a DBA perspective? (ie. Tuning java parameters, managing storage/validation of java objects, monitoring java pool performance, managing security... etc.) I can find lots of stuff for developers but I don't write too much Java code! Thanks for any info. - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: JVM for DBA
Bill - Will you be administering the server or do you need to talk to the administrator? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 10:15 AM To: Multiple recipients of list ORACLE-L Hi all, Does anyone have any good resources on the Oracle JVM from a DBA perspective? (ie. Tuning java parameters, managing storage/validation of java objects, monitoring java pool performance, managing security... etc.) I can find lots of stuff for developers but I don't write too much Java code! Thanks for any info. - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: where is Sort area size
Yes. Note that when you use MTS, sort area is taken from the SGA, specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not. With a dedicated server, sort area is a part of the process address space. On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote: Hi all , is sort are size a part of PGA ? Rgds. Arslan. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Reset sequence at midnight
Hi, I have a sequence which i want to reset to 0 at midnight everyday. What is the best way to do this? Db version - 9.2.0.1.0 Thanks Imran -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle vs Mysql
Hi, I've been asked by management to explore the pros and cons of Mysqlvs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb.Can someonelet me know the advantages of Oracle over Mysql or the problems we can face usingMysqlfor examplesupport issues or availability/performance issues. Thanks in advance Mujeeb
Re: read-only simple snapshot/materialised view refresh
Leng, You didn't mention the frequency of the refresh. I also don't see mention of which database is generating the ora-1555 errors. Jared Kaing, Leng [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/13/2004 09:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:read-only simple snapshot/materialised view refresh Hello everyone, We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 slave. master and slave are on different servers. Snapshots are refreshed by the FAST method using dbms_refresh.refresh. However, do to the extremely high transaction rates on our database, we're getting ORA-1555 when trying to refresh the snapshots. The mlog$ tables builds up and the slave just keeps on falling behind. From what I can see, snapshots are refreshed as a single large transaction. So if there are 500K rows in the mlog$ table, all 500K will be processed in one go. There are no intermediate commits. So my question is: how do you specify a commit point with snapshots? I'm looking for parameters similar to that of the exp and sqlldr utility where you can specify commit points. I've logged an iTAR with Oracle Support and there answer is that it's not possible. ARGH!! Here's another crazy question is - has anyone updated the dbms_refresh package to add a commit point? Or, have you tried to interogate the mlog$ and write a PL/SQL procedure to process the rows in there, thereby having your own commit points? mlog$ provides the primary keys and the DML type. So surely it's just a matter of going through each one of the row and applying it to the slave? TIA, Leng, -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs Mysql
If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. My $.02, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, January 14, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb. Can someone let me know the advantages of Oracle over Mysql or the problems we can face using Mysql for example support issues or availability/performance issues. Thanks in advance Mujeeb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Reset sequence at midnight
To use program which will supply numbers, possibly as an external routine, and not use an oracle sequence as it wasn't designed for that purpose. On 01/14/2004 12:04:26 PM, Oracle wrote: Hi, I have a sequence which i want to reset to 0 at midnight everyday. What is the best way to do this? Db version - 9.2.0.1.0 Thanks Imran -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: where is Sort area size
It comes out of the total memory of the server - separate from the shared pool - it is allocated per session - if running parallel processes in a DSS environ. can quickly consume memory avail. be wary wary careful. -Original Message- Mladen Gogala Sent: Wednesday, January 14, 2004 11:54 AM To: Multiple recipients of list ORACLE-L Yes. Note that when you use MTS, sort area is taken from the SGA, specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not. With a dedicated server, sort area is a part of the process address space. On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote: Hi all , is sort are size a part of PGA ? Rgds. Arslan. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Reset sequence at midnight
drop sequence create sequence but why do you want to do that? --- Oracle [EMAIL PROTECTED] wrote: Hi, I have a sequence which i want to reset to 0 at midnight everyday. What is the best way to do this? Db version - 9.2.0.1.0 Thanks Imran -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sorta OT: Uncle Larry's no longer Chairman!
Dang ... he now shares my wedding anniversary (not the year) ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, January 14, 2004 10:34 AM To: Multiple recipients of list ORACLE-L And he apparently got hitched, too. Wondering if Wall Street has any thoughts on this... http://www.eweek.com/article2/0,4149,1435093,00.asp Rich ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sorta OT: Uncle Larry's no longer Chairman!
Title: RE: Sorta OT: Uncle Larry's no longer Chairman! Raj, If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED] Dang ... he now shares my wedding anniversary (not the year) ... Raj
Re: Oracle vs Mysql
On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sorta OT: Uncle Larry's no longer Chairman!
Title: RE: Sorta OT: Uncle Larry's no longer Chairman! Very True ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 1:51 PMTo: [EMAIL PROTECTED]Cc: Jamadagni, RajendraSubject: RE: Sorta OT: Uncle Larry's no longer Chairman! Raj, If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED] Dang ... he now shares my wedding anniversary (not the year) ... Raj **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re: Reset sequence at midnight
Interesting, I've actually had to do this before. Be forewarned that this is not a good method to use for a very busy app, as it does introduce some level of serialization. control access to the sequence through a package Within the package use a function that sets a lock via dbms_lock.request and then immediately release the lock. The purpose of this will become clear in a moment. Create a procedure within the package that will be used to reset the sequence to 0. It is not necessary to drop the sequence to do this. eg. drop sequence s; create sequence s start with 100; select s.nextval from dual; declare vs integer; inc integer; junk integer; begin select s.nextval into vs from dual; inc := 0 - vs; execute immediate 'alter sequence s minvalue ' || inc; execute immediate 'alter sequence s increment by '||inc; select s.nextval into junk from dual; execute immediate 'alter sequence s increment by 1'; end; / select s.nextval from dual; The procedure that does this just needs to take the same dbms_lock.request that the function mentioned earlier takes. The difference is that it does not release the lock until the modification of the sequence is completed. This forces any requests for new sequence numbers to wait for the modification to the sequence to complete. Jared Oracle [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/14/2004 09:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Reset sequence at midnight Hi, I have a sequence which i want to reset to 0 at midnight everyday. What is the best way to do this? Db version - 9.2.0.1.0 Thanks Imran -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sorta OT: Uncle Larry's no longer Chairman!
I guess jokes about Preferred Oracle Partners would be in bad taste... Patrice. -Original Message- Sent: January 14, 2004 2:24 PM To: Multiple recipients of list ORACLE-L Dang ... he now shares my wedding anniversary (not the year) ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, January 14, 2004 10:34 AM To: Multiple recipients of list ORACLE-L And he apparently got hitched, too. Wondering if Wall Street has any thoughts on this... http://www.eweek.com/article2/0,4149,1435093,00.asp Rich ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sorta OT: Uncle Larry's no longer Chairman!
Title: RE: Sorta OT: Uncle Larry's no longer Chairman! Why does he quit? I thought he likes to fight... - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 14, 2004 1:59 PM Subject: RE: Sorta OT: Uncle Larry's no longer Chairman! Very True ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 1:51 PMTo: [EMAIL PROTECTED]Cc: Jamadagni, RajendraSubject: RE: Sorta OT: Uncle Larry's no longer Chairman! Raj, If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED] Dang ... he now shares my wedding anniversary (not the year) ... Raj **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re:RE: Re: A STRANGE QUERY
Thanks Brad, Thanks Steve, The problem fixed after our DBA drop and rebuild the primary key. It is so great to have people like you on this list. Thanks again, -- Original Message Date: Tue, 13 Jan 2004 08:59:24 -0800 At first stab...I would guess that there is something foobarred with the primary key index. I would rebuild the primary key and try again. Brad O. -Original Message- Sent: Monday, January 12, 2004 4:45 PM To: Multiple recipients of list ORACLE-L It is not an expensive query.It runs really fast without the primary key in production but we dont have this problem in the test instance. -- Original Message Date: Mon, 12 Jan 2004 14:04:42 -0800 Even stranger is, that you expect us to solve your problem without knowing what exactly the problem is! Does your query consist of a SQL statement? Does it have an execution plan? Very strange, indeed. Tanel. Dear List, I have a very strange query: The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** OCP for 9i requirements -- Instructor Led Class is a
I heard from an Oracle instructor that some idiots were bragging about how they passed the OCP without logging in once. This distressed some important people, so this requirement was added. I asked if this meant each instructor was tasked with ensuring each student logged in, and he just smiled. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 8:09 AM To: Multiple recipients of list ORACLE-L Sure. Read Important Program Announcement: Oracle University Hands-On Course Requirement Oracle customers and business partners are demanding hands-on experience - with all aspects of Oracle's database - from their Oracle Certified Professionals. In order to meet our commitment to our customers and constituents, Oracle University has recently made a significant investment in its Certification Program. Three distinct changes are being rolled out with the goal of increasing the level of quality of our certification skill and ability benchmarks: Scenario-based testing in all Oracle9i DBA Certified Professional exams . Instructor-led class requirement for candidates starting on the Oracle9i DBA Certified Professional credential exam path. A new hands-on Masters Practicum Exam for the Oracle9i Database Administrator Certified Master credential. at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html http://www.oracle.com/education/certification/index.html?dba9i_ocp.html Instructure-led class is a requirement. You CAN take the Online Training to _prepare_ for the Exams. But you MUST attend at least one Instructor-led class to qualify for the certification. Hemant At 10:34 AM 13-01-04 -0800, you wrote: why dont you just read what is on the oracle website? www.oracle.com http://www.oracle.com do a search for certification. - Original Message - To: Multiple recipients of mailto:[EMAIL PROTECTED] list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is at least one Instructor Led Training. Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com http://www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq. html http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq .html Justin Cave - Original Message - To: Multiple recipients of mailto:[EMAIL PROTECTED] list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/mail_footer_email/evt=2 1482/*http://hotjobs.sweepstakes.yahoo.com/signingbonus the Signing Bonus Sweepstakes Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com http://hkchital.tripod.com / {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net/ -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com http://www.fatcity.com/ San Diego, California -- Mailing list and web hosting services - 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com http://hkchital.tripod.com/ {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: Shared Pool fragmentation
John, THANKS A TON!!! I've got a vendor trying to convince my boss that their application needs to be on a separate server with a 1GB shared pool. Now I know these guys are blowing snow better than any SnowKing, but I needed some help proving it. BTW: For you southern, snow unaware, a SnowKing is a snow blower of the highest degree. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 13, 2004 6:34 PM To: Multiple recipients of list ORACLE-L Rick, I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031. John -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Shared Pool fragmentation Rick, I think the best answer is 'know thy application'. And in this, knowledge of bind var vs hardcoded value usage, looking at V$SQL and V$SQLAREA, the ratio (!!) of 'parse count (hard)' to 'parse count (total)', pinning of packages/sequences, etc., can help... You cannot actually 'catch' a 4031 before it occurs, but you can always straighten things out before it occurs. I have found that a combination of pinning Packages/Sequences followed by judicious (once in a while) use of shared pool flush helps. Of course, the shared pool has to be correctly sized - too much and you waste time latching and memory, too little and you _might_ run into 4031. Sizing shared pool is an art that has a little science behind it - science that involves understanding and using values from X$KGLOB and X$KSMSP and your application OTOH, I have seen good results with a flush shared pool during quiet times for non-bind hungry 3rd party apps... See below (script courtersy Steve!) - the number of chunks has dropped dramatically freeing up largish globs of shared pool that would otherwise have to be freed up when a largish object (in this case 15456 bytes) has to load. As well, you will see that the number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down drastically as the system frees up 'freeable' chunks ahead of time, reducing the chance of 4031s My (very limited) understanding is that when a package/cursor has to load and a large-enough chunk of shared pool memory is not free, then the kernel will try and flush out the 'freeable' (not in use) memory and merge adjacent free chunks. If this still does not staisfy the memory requirements, then a 4031 is signalled/ The 'alter system flush shared pool' performs a manual flush instead, ahead of time and could (possibly) prevent a 4031 ... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** 08:35:00 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 01089784 23488 46 76 1 3941364656 84140 2 6812843678 185268 3 315504 875 360524 449019527300 671 1036 561588964099 1502 2060 655465161966 2821 4048 71125720 263 4280 7624 8 989584 101 9797 15456 9 rows selected. 08:35:29 SQL alter system flush shared_pool; System altered. 08:36:32 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 0 14364 330 43 76 1 6528 76 85140 6 3964 1 3964 3964 9 29580 129580 29580 105028636 10348821 65436 11 13860744 15092404 130872 12 32192980 173 186086 261016 13 64490864 172 374946 522764 14 83609184 112 7465101048432 15 79829220 57 14005122068384 16 38149220 14 27249443705320 11 rows selected. -Original Message- Sent: Tuesday, January 13, 2004 9:34 AM To: Multiple recipients of list ORACLE-L Is there a way to catch shared_pool fragmentation before you get the 4031 errors? I have looked at Steve Adams site which has scripts to show the free lists chunks in the shared pool. At what point do I know that it is fragmented too much? I know that I can prevent this by using bind variables, and keeping objects, but until I can modify all the
RE: oaktable people
I'm going to make Mogens clean my garage ... I'm sorry, I meant further team building ... when he visits for the Symposium in March! Gary (817)424-3443 Office (817)296-8000 Cell -Original Message- Mogens Nørgaard Sent: Tuesday, January 13, 2004 10:39 PM To: Multiple recipients of list ORACLE-L Lies, lies and viscious rumors. It was only the loft of the Garage, and the idea was to create a new, exciting space for the Oracle Museum, complete with webcams. I had planned the Miracle Master Class Teambuilding Exercise as follows: 1. On Sunday evening we would (slowly!) move the stuff from the loft downstairs and stack it carefully. 2. On Monday evening we would put in the new flooring. 3. On Tuesday evening we would put the stacked stuff back up on the loft. As it turned out, it ended up a bit different from the original plan: 1. On Sunday it took the Oakies about 42 minutes to remove everything from the loft. Most of it was thrown out, and Peter Gram even had to rent a new trailer for the junk. 2. Lex and Carel-Jan and Gary Goodman and James Morle and Jon (from Miracle Iceland) were un-stopable and made 80% of the flooring on Sunday. 3. On Monday Lex got the bright idea of doing some heavy changes to the whole construction of the Garage. Which he and Carel-Jan and helpers then did. 4. On Tuesday evening nobody did anything except participate in the Gala Dinner and visit the famous hotdog stand Bjarne's Poelser. 5. I don't know when the stuff is going up there again. I'm afraid. Mogens PS: The Oakies rock. Nothing beats having 18 of them in your house. Gudmundur Josepsson wrote: Onkel Mogens wrote: All to stay in my house (except Gaja - don't know what he's up to). Rock'n'roll. And none of them know what I meant when I asked them to bring some old clothes for some unusual teambuilding... You're not having them do construction work on your house again, are you? Gaja is probably the smart one, he knows what you're up to! My guess is that 'teambuilding' is Danish for 'dig me a 12 x 25 m swimming pool in my back yard and paint my house while you're at it.' Gummi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Gary Goodman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs Mysql
what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Shared Pool fragmentation
wa! what kind of application is it? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 3:29 PM John, THANKS A TON!!! I've got a vendor trying to convince my boss that their application needs to be on a separate server with a 1GB shared pool. Now I know these guys are blowing snow better than any SnowKing, but I needed some help proving it. BTW: For you southern, snow unaware, a SnowKing is a snow blower of the highest degree. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 13, 2004 6:34 PM To: Multiple recipients of list ORACLE-L Rick, I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031. John -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Shared Pool fragmentation Rick, I think the best answer is 'know thy application'. And in this, knowledge of bind var vs hardcoded value usage, looking at V$SQL and V$SQLAREA, the ratio (!!) of 'parse count (hard)' to 'parse count (total)', pinning of packages/sequences, etc., can help... You cannot actually 'catch' a 4031 before it occurs, but you can always straighten things out before it occurs. I have found that a combination of pinning Packages/Sequences followed by judicious (once in a while) use of shared pool flush helps. Of course, the shared pool has to be correctly sized - too much and you waste time latching and memory, too little and you _might_ run into 4031. Sizing shared pool is an art that has a little science behind it - science that involves understanding and using values from X$KGLOB and X$KSMSP and your application OTOH, I have seen good results with a flush shared pool during quiet times for non-bind hungry 3rd party apps... See below (script courtersy Steve!) - the number of chunks has dropped dramatically freeing up largish globs of shared pool that would otherwise have to be freed up when a largish object (in this case 15456 bytes) has to load. As well, you will see that the number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down drastically as the system frees up 'freeable' chunks ahead of time, reducing the chance of 4031s My (very limited) understanding is that when a package/cursor has to load and a large-enough chunk of shared pool memory is not free, then the kernel will try and flush out the 'freeable' (not in use) memory and merge adjacent free chunks. If this still does not staisfy the memory requirements, then a 4031 is signalled/ The 'alter system flush shared pool' performs a manual flush instead, ahead of time and could (possibly) prevent a 4031 ... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** 08:35:00 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 01089784 23488 46 76 1 3941364656 84140 2 6812843678 185268 3 315504 875 360524 449019527300 671 1036 561588964099 1502 2060 655465161966 2821 4048 71125720 263 4280 7624 8 989584 101 9797 15456 9 rows selected. 08:35:29 SQL alter system flush shared_pool; System altered. 08:36:32 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 0 14364 330 43 76 1 6528 76 85140 6 3964 1 3964 3964 9 29580 129580 29580 105028636 10348821 65436 11 13860744 15092404 130872 12 32192980 173 186086 261016 13 64490864 172 374946 522764 14 83609184 112 7465101048432 15 79829220 57 14005122068384 16 38149220 14 27249443705320 11 rows selected. -Original Message- Sent: Tuesday, January 13, 2004 9:34 AM To: Multiple recipients of list ORACLE-L Is there a way to catch shared_pool fragmentation before you get the 4031 errors? I have
Re: Oracle vs Mysql
1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs Mysql
DBI is an extension to perl language which can then be used by perl to talk with various databases. DBI stands for database interface. With DBI you also have to load in a specific database driver which is called DBD. For instance for oracle you have to install DBI and DBD::Oracle. Its really cool to use and very fast. I wrote a poor man's replication built on DBI/DBD::Oracle/DBD::Sybase. I like mysql but the sql is just not that rich as it is in oracle. They are fixing some of the shortcomings soon so it will be pretty competitive is basic database usage with Oracle. BTW, I agree that a lot of people only need a simple db and for them mysql/postgres is appropriate. As far as I know, Postgres is free to use, so you don't have to worry about licensing at all. Hope this helps Masroor -Original Message- Ryan Sent: Wednesday, January 14, 2004 12:35 PM To: Multiple recipients of list ORACLE-L what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Masroor Farooqi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Shared Pool fragmentation
Hmm..reminds me of a MetaLink thread where I actually saw an Oracle Support analyst claim that it's not uncommon for large OLTP systems to have 2-4GB shared poolsyes, that's 2-4 Gigabytes. I wasn't actually sure how to respond to that, so, I just sort of let it drop. I mean, what do you say? -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Wednesday, January 14, 2004 4:09 PM To: Multiple recipients of list ORACLE-L wa! what kind of application is it? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 3:29 PM John, THANKS A TON!!! I've got a vendor trying to convince my boss that their application needs to be on a separate server with a 1GB shared pool. Now I know these guys are blowing snow better than any SnowKing, but I needed some help proving it. BTW: For you southern, snow unaware, a SnowKing is a snow blower of the highest degree. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 13, 2004 6:34 PM To: Multiple recipients of list ORACLE-L Rick, I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031. John -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Shared Pool fragmentation Rick, I think the best answer is 'know thy application'. And in this, knowledge of bind var vs hardcoded value usage, looking at V$SQL and V$SQLAREA, the ratio (!!) of 'parse count (hard)' to 'parse count (total)', pinning of packages/sequences, etc., can help... You cannot actually 'catch' a 4031 before it occurs, but you can always straighten things out before it occurs. I have found that a combination of pinning Packages/Sequences followed by judicious (once in a while) use of shared pool flush helps. Of course, the shared pool has to be correctly sized - too much and you waste time latching and memory, too little and you _might_ run into 4031. Sizing shared pool is an art that has a little science behind it - science that involves understanding and using values from X$KGLOB and X$KSMSP and your application OTOH, I have seen good results with a flush shared pool during quiet times for non-bind hungry 3rd party apps... See below (script courtersy Steve!) - the number of chunks has dropped dramatically freeing up largish globs of shared pool that would otherwise have to be freed up when a largish object (in this case 15456 bytes) has to load. As well, you will see that the number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down drastically as the system frees up 'freeable' chunks ahead of time, reducing the chance of 4031s My (very limited) understanding is that when a package/cursor has to load and a large-enough chunk of shared pool memory is not free, then the kernel will try and flush out the 'freeable' (not in use) memory and merge adjacent free chunks. If this still does not staisfy the memory requirements, then a 4031 is signalled/ The 'alter system flush shared pool' performs a manual flush instead, ahead of time and could (possibly) prevent a 4031 ... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** 08:35:00 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 01089784 23488 46 76 1 3941364656 84140 2 6812843678 185268 3 315504 875 360524 449019527300 671 1036 561588964099 1502 2060 655465161966 2821 4048 71125720 263 4280 7624 8 989584 101 9797 15456 9 rows selected. 08:35:29 SQL alter system flush shared_pool; System altered. 08:36:32 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 0 14364 330 43 76 1 6528 76 85140 6 3964 1 3964 3964 9 29580 129580 29580 105028636
Re: Oracle vs Mysql
I don't think MySQL is free for commercial application, for dev and test purpose it is free. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:29 PM DBI is an extension to perl language which can then be used by perl to talk with various databases. DBI stands for database interface. With DBI you also have to load in a specific database driver which is called DBD. For instance for oracle you have to install DBI and DBD::Oracle. Its really cool to use and very fast. I wrote a poor man's replication built on DBI/DBD::Oracle/DBD::Sybase. I like mysql but the sql is just not that rich as it is in oracle. They are fixing some of the shortcomings soon so it will be pretty competitive is basic database usage with Oracle. BTW, I agree that a lot of people only need a simple db and for them mysql/postgres is appropriate. As far as I know, Postgres is free to use, so you don't have to worry about licensing at all. Hope this helps Masroor -Original Message- Ryan Sent: Wednesday, January 14, 2004 12:35 PM To: Multiple recipients of list ORACLE-L what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Masroor Farooqi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: Shared Pool fragmentation
Humm, Missed the middle post here. It's a time labor tracking system. They have what they call a large package (28K from Brian post) that they claim must be loaded multiple times is giving them an intermittent ORA-4031 and/or ORA-4045 on the web server. Problem is that the wall clocks and the PowerBuilder admin tool don't have the problem. What I also need with this app is a good book on MicroSlop Transaction server and Distributed Transaction Coordinator. These folks are using it with the web server they are clueless. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 4:30 PM To: Multiple recipients of list ORACLE-L Hmm..reminds me of a MetaLink thread where I actually saw an Oracle Support analyst claim that it's not uncommon for large OLTP systems to have 2-4GB shared poolsyes, that's 2-4 Gigabytes. I wasn't actually sure how to respond to that, so, I just sort of let it drop. I mean, what do you say? -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Wednesday, January 14, 2004 4:09 PM To: Multiple recipients of list ORACLE-L wa! what kind of application is it? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 3:29 PM John, THANKS A TON!!! I've got a vendor trying to convince my boss that their application needs to be on a separate server with a 1GB shared pool. Now I know these guys are blowing snow better than any SnowKing, but I needed some help proving it. BTW: For you southern, snow unaware, a SnowKing is a snow blower of the highest degree. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 13, 2004 6:34 PM To: Multiple recipients of list ORACLE-L Rick, I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031. John -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Shared Pool fragmentation Rick, I think the best answer is 'know thy application'. And in this, knowledge of bind var vs hardcoded value usage, looking at V$SQL and V$SQLAREA, the ratio (!!) of 'parse count (hard)' to 'parse count (total)', pinning of packages/sequences, etc., can help... You cannot actually 'catch' a 4031 before it occurs, but you can always straighten things out before it occurs. I have found that a combination of pinning Packages/Sequences followed by judicious (once in a while) use of shared pool flush helps. Of course, the shared pool has to be correctly sized - too much and you waste time latching and memory, too little and you _might_ run into 4031. Sizing shared pool is an art that has a little science behind it - science that involves understanding and using values from X$KGLOB and X$KSMSP and your application OTOH, I have seen good results with a flush shared pool during quiet times for non-bind hungry 3rd party apps... See below (script courtersy Steve!) - the number of chunks has dropped dramatically freeing up largish globs of shared pool that would otherwise have to be freed up when a largish object (in this case 15456 bytes) has to load. As well, you will see that the number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down drastically as the system frees up 'freeable' chunks ahead of time, reducing the chance of 4031s My (very limited) understanding is that when a package/cursor has to load and a large-enough chunk of shared pool memory is not free, then the kernel will try and flush out the 'freeable' (not in use) memory and merge adjacent free chunks. If this still does not staisfy the memory requirements, then a 4031 is signalled/ The 'alter system flush shared pool' performs a manual flush instead, ahead of time and could (possibly) prevent a 4031 ... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** 08:35:00 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 01089784 23488 46 76 1 3941364656 84140 2 6812843678 185268 3 315504 875 360524 449019527300 671 1036 561588964099
Re: Oracle vs Mysql
I'm suspicious about using MySQL or Postgres with a database 100 gigabytes in size. (Especially, when their main website appeared to be down when I wanted to check some of their recent references). Anyway, if you have availability requirements which don't allow you to take down your system for backup, then you have to use replication (about which quality I'm suspicious again) in order to take online backups from a clone db. For that you need another 100GB of storage. Anyway, if I was persuaded to go with MySQL or Postgres for large databases, I'd try to split them up somehow (kind of partitioning), if possible, to have separate databases with separate server processes serving them. That way taking down or crashing of one server wouldn't affect other data that much... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 8:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Application Server Caching
I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better.
RE: Application Server Caching
Ryan, He has a point. If you look at 9IAS's architecture there is a cache database at the apps server. The trick is to know when the data your looking for in cache is no longer valid. A certain children's apparel/toys site did that to me back in October. I'm still torqued at them. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Application Server Caching I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better.
Re: Oracle vs Mysql
i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Partitioning question (duplicate?)
Pardon if this is a duplicate, but the original has not shown up on the list after 3 hours... Is it possible in 9.2 to partition on a function? I have a table with a date column and I would like to partition by month, regardless of the year. For example, data from January 2003 or January 2004 would go into the same partition. Any sneaky ideas on how to accomplish this without changing the data structures. Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs Mysql
There is a commercial arm of PostgreSQL (or at least a partner) for businesses that require support. Surf on over to: http://www.pgsql.com Expect to pay about the same for PostgreSQL support as you would for Oracle. I don't know of any support for DBI other than the Perl DBI mailing list (which, like this list, is excellent!). Traffic is about the same as ORACLE-L. To subscribe to the list, send a message to: [EMAIL PROTECTED] Better yet, head to http://www.oreilly.com and find the books, then over to http://www.bookpool.com and order 'em. HTH! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, January 14, 2004 3:20 PM To: Multiple recipients of list ORACLE-L 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 vs Mysql
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ryan Sent: Thursday, 15 January 2004 09:05 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle vs Mysql i thought postgre was a for profit company? how do they generate revenues? Don't confuse the PostgreSQL dev team with PostgreSQL Inc. The latter makes some commercially licenced add-ons for PostgreSQL, but the db itself is released under the Berkeley licence. Completely free for commercial use. Unlike MySQL, where you need to licence the server, AND licence the connectivity for commercial use. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Application Server Caching
Ryan, Our application does a certain amount of application server caching, and infact has a pretty advanced cache mechanism to deal with out of date objects, etc. On a more simple level - Common reference records are loaded at start up and cached, error messages are cached, etc. In a similar fashion we a a sequence providing GUID values (global across our application at least) - Obviously the application chews through these very fast (millions per day). So, to reduce load each time the application gets a new value from the sequence it treats it as a range of 1000 values. If the app crashes we only loose a few thousand sequence numbers (several processes each have their own store of 1000 values) but access to the sequence is reduced by a factor of 1000. After three years of running the sequence is around 10,000,000 instead of 10,000,000,000! It's all a matter of knowing what to cache and how to ensure it's still current. If you were populating a list of State Codes for a drop down list then I would cache that result but something like a StockOnHandQuantity figure probably changes so often that caching is of little use. If you have the same query (ficticious eg: select statename, statecode from states) constantly firing in your database then I guess it's a sign that caching would help. Even sub-second queries can quickly add up in a busy system. Cheers, Mark. Ryan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: Application Server Caching [EMAIL PROTECTED] .com 15/01/2004 09:14 Please respond to ORACLE-L I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
Re: Oracle vs Mysql
One more thing which you can tell your boss: MySQL and Oracle are not comparable, at least not with any trustworthy results. (the same goes with MySQL and DB2 or Access and SQL server...) Tanel. - Original Message - From: Mujeeb Chowdhry To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 14, 2004 7:04 PM Subject: Oracle vs Mysql Hi, I've been asked by management to explore the pros and cons of Mysqlvs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb.Can someonelet me know the advantages of Oracle over Mysql or the problems we can face usingMysqlfor examplesupport issues or availability/performance issues. Thanks in advance Mujeeb
RE: read-only simple snapshot/materialised view refresh
Hi Jared, Frequency is currently 15 minutes. We'll need to reduce it to about 5 I guess. ORA-1555 is from the master. As master tables are being updated, snapshot fails with its read consistent image. Once we get really far behind there's no way we can catch up. It fails with ORA-1555 Ta, Leng. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Thursday, 15 January 2004 4:27 am To: [EMAIL PROTECTED] Cc: Kaing, Leng Subject: Re: read-only simple snapshot/materialised view refresh Importance: High Leng, You didn't mention the frequency of the refresh. I also don't see mention of which database is generating the ora-1555 errors. Jared Kaing, Leng [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/13/2004 09:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:read-only simple snapshot/materialised view refresh Hello everyone, We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 slave. master and slave are on different servers. Snapshots are refreshed by the FAST method using dbms_refresh.refresh. However, do to the extremely high transaction rates on our database, we're getting ORA-1555 when trying to refresh the snapshots. The mlog$ tables builds up and the slave just keeps on falling behind. From what I can see, snapshots are refreshed as a single large transaction. So if there are 500K rows in the mlog$ table, all 500K will be processed in one go. There are no intermediate commits. So my question is: how do you specify a commit point with snapshots? I'm looking for parameters similar to that of the exp and sqlldr utility where you can specify commit points. I've logged an iTAR with Oracle Support and there answer is that it's not possible. ARGH!! Here's another crazy question is - has anyone updated the dbms_refresh package to add a commit point? Or, have you tried to interogate the mlog$ and write a PL/SQL procedure to process the rows in there, thereby having your own commit points? mlog$ provides the primary keys and the DML type. So surely it's just a matter of going through each one of the row and applying it to the slave? TIA, Leng, -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RAC on Win2K using RMAN to Create Standby
Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: jwiegand INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Application Server Caching
Just to elaborate - I did a poor job of explaining the sequence trick. If the sequence returns a value of 12345 then the application knows it has a range from 12345000 to 12345999 to use. The next process will get the sequence value 12346, providing a range from 12346000 to 12346999. The long numbers are used in the database to be unique but having the application do a multiplication by 1000 certainly reduced load on the sequence. Mark Richard [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ban.com.au cc: Sent by: Subject: Re: Application Server Caching [EMAIL PROTECTED] .com 15/01/2004 10:49 Please respond to ORACLE-L Ryan, Our application does a certain amount of application server caching, and infact has a pretty advanced cache mechanism to deal with out of date objects, etc. On a more simple level - Common reference records are loaded at start up and cached, error messages are cached, etc. In a similar fashion we a a sequence providing GUID values (global across our application at least) - Obviously the application chews through these very fast (millions per day). So, to reduce load each time the application gets a new value from the sequence it treats it as a range of 1000 values. If the app crashes we only loose a few thousand sequence numbers (several processes each have their own store of 1000 values) but access to the sequence is reduced by a factor of 1000. After three years of running the sequence is around 10,000,000 instead of 10,000,000,000! It's all a matter of knowing what to cache and how to ensure it's still current. If you were populating a list of State Codes for a drop down list then I would cache that result but something like a StockOnHandQuantity figure probably changes so often that caching is of little use. If you have the same query (ficticious eg: select statename, statecode from states) constantly firing in your database then I guess it's a sign that caching would help. Even sub-second queries can quickly add up in a busy system. Cheers, Mark. Ryan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: Application Server Caching [EMAIL PROTECTED] .com 15/01/2004 09:14 Please respond to ORACLE-L I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver
Re: Partitioning question (duplicate?)
First time I've seen this post. And from the fine Data Warehousing manual: here's an example of range partitioning. Note the to_date in the values clause. I don't see why you couldn't use to_date(date_column,'MONTH') Rachel CREATE TABLE sales (s_productid NUMBER, s_saledate DATE, s_custid NUMBER, s_totalprice NUMBER) PARTITION BY RANGE(s_saledate) (PARTITION sal99q1 VALUES LESS THAN (TO_DATE('01-APR-1999','DD-MON-')), PARTITION sal99q2 VALUES LESS THAN (TO_DATE('01-JUL-1999','DD-MON-')), PARTITION sal99q3 VALUES LESS THAN (TO_DATE('01-OCT-1999', 'DD-MON-')), PARTITION sal99q4 VALUES LESS THAN (TO_DATE('01-JAN-2000', 'DD-MON-')), PARTITION sal00q1 VALUES LESS THAN (TO_DATE('01-APR-2000', 'DD-MON-')), PARTITION sal00q2 VALUES LESS THAN (TO_DATE('01-JUL-2000', 'DD-MON-')), PARTITION sal00q3 VALUES LESS THAN (TO_DATE('01-OCT-2000', 'DD-MON-')), PARTITION sal00q4 VALUES LESS THAN (TO_DATE('01-JAN-2001', 'DD-MON-'))); --- Daniel Fink [EMAIL PROTECTED] wrote: Pardon if this is a duplicate, but the original has not shown up on the list after 3 hours... Is it possible in 9.2 to partition on a function? I have a table with a date column and I would like to partition by month, regardless of the year. For example, data from January 2003 or January 2004 would go into the same partition. Any sneaky ideas on how to accomplish this without changing the data structures. Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Hi!!
Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
Veritas Backup Question
Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: kill session privilage
create procedure kill_your_session (in_sid in sys.v_$session.sid%type, in_serial# in sys.v_$session.serial#%type) as row_count pls_integer ; begin select count (*) into row_count from v$session where username = user and sid = in_sid and serial# = in_serial# ; if row_count 0 then execute immediate 'alter system kill session ''' || to_char (in_sid) || ', ' || to_char (in_serial#) || ; end if ; end ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas Backup Question
OK, Teresita, what is your question? Do you have MLM? Did you put the database in the backup mode? Did you save archives? How about the control files? Did you backup control files? I doubt that this forum is an appropriate place for a backup recovery course, but it seems that you have a good incentive to learn. First advice is to try to restore database and see whether you can actually recover. If you can, well, you're a pro. If you can't get backup and recovery book, one of Rama Velpuri's, if possible. My favorite is V7 book, because it's not too thick, it's very clear and well written and I like the color of copper. The most important thing about backup and recovery is never to allow yourself to run out of coffee. On 2004.01.14 21:14, Teresita Castro wrote: Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He has been working with Veritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my boss make me work with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thru Saturday make another incremental backup, but this one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 34567 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4 -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hi!!
Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
Re: Partitioning question (duplicate?)
Dan, Good question, but unless I'm misinterpreting the results, the answer is no... SQL show release release 902000100 SQL create table test 2 (a date, b number, c number) 3 partition by list (to_char(a, 'MON')) 4 (partition pJAN values ('JAN')), 5 (partition pFEB values ('FEB')) 6 (partition pMAR values ('MAR')) 7 (partition pAPR values ('APR')) 8 (partition pMAY values ('MAY')); partition by list (to_char(a, 'MON')) * ERROR at line 3: ORA-00907: missing right parenthesis ..seems to clearly be interpreting the phrase to_char as a column name... Hope this helps... -Tim on 1/14/04 3:24 PM, Daniel Fink at [EMAIL PROTECTED] wrote: Pardon if this is a duplicate, but the original has not shown up on the list after 3 hours... Is it possible in 9.2 to partition on a function? I have a table with a date column and I would like to partition by month, regardless of the year. For example, data from January 2003 or January 2004 would go into the same partition. Any sneaky ideas on how to accomplish this without changing the data structures. Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Partitioning question (duplicate?)
The only way I see is using a system-maintained ( through a before-insert and if necessary before-update trigger ) field that is set to to_char(date_column,'mm') and then range partition on that. At 03:24 PM 1/14/2004, you wrote: Pardon if this is a duplicate, but the original has not shown up on the list after 3 hours... Is it possible in 9.2 to partition on a function? I have a table with a date column and I would like to partition by month, regardless of the year. For example, data from January 2003 or January 2004 would go into the same partition. Any sneaky ideas on how to accomplish this without changing the data structures. Daniel Fink -- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).