RE: Bind variables v. cursor_sharing = FORCE
Hi Greg and list, I'm not convinced of John's conclusion that 'cursor_sharing' = FORCE outperforms bind variables. Some months ago I tried to reproduce John's results and was not able to, despite trying several different variations on the tests. Tom Kyte claims that 'cursor_sharing' is about 10% more expensive. My results were between 10% and 30%. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message- Sent: Saturday, 20 October 2001 7:21 To: Multiple recipients of list ORACLE-L An excerpt from PIRANHAS IN THE POOL, SQL PERFORMANCE KILLERS Investigating the effects of literal SQL on Oracle performance John Beresniewicz Precise Software Solutio -- Effect of CURSOR_SHARING A primary purpose of the 8.1.6 testing was to assess the impact the new CURSOR_SHARING system parameter and its potential for helping DBAs manage ill-behaved applications with high parse rates of literal SQL. Comparing Test 1 to Test 3 and also Test 0 to Test 4 serves this goal. Comparing these Test results, CURSOR_SHARING exhibits advantages similar to those obtained using bind variables in Test 2: -- Reduced library cache impact. -- Negligible shared pool activity. -- Reduced CPU demands. In fact, Test 3 produced the best elapsed time of all tests in spite of the fact that all the SQL was literal. Thus, it is clear that CURSOR_SHARING can be used to greatly enhance performance of applications that produce high volume literal SQL and thus is a great advantage for the DBA saddled with such applications. CURSOR_SHARING vs. Bind Variables Comparing Test 2 and Test 3 reveals that CURSOR_SHARING = FORCE showed significantly better performance than bind variables in both elapsed time and reduced library cache latching impact. This surprising result deserves further investigation to produce an adequate explanation. Library cache latch impact was significantly reduced as well as shared pool pins and releases. Parsing CPU time increased some but overall CPU was reduced. Perhaps the additional parsing involved in forced cursor sharing also enables increased sharing of shared pool memory heaps. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: event= to capture deadlock debug info
Hi All, I think Jim is using the term deadlock loosely. He appears to be speaking of a hang. The normal recommendation for diagnosing the cause of a hang is to take two 'systemstate' dumps from different sessions in quick succession. However, from 8.1.6 there is a 'hanganalyze' dump that can also be used, and is somewhat more useful. Be warned, however, that I've seen it crash an instance once. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message- Sent: Saturday, 20 October 2001 4:03 To: Multiple recipients of list ORACLE-L Hi James, setting an event at init/session level would basically dump the error state into an trc file. ora-60 or deadlock by defualt writes a message in alert file and also dumps a large trace in udump. so why do you want to explicitly set this event? The default behaviour mimicks the same anyways. hth Deepak --- James Howerton [EMAIL PROTECTED] wrote: DBA's Does anyone know of an event= to set to capture a deadlock condition? On two occasions now a user's session has locked up due to a network problem or three finger salute or who knows what(???) blocking other users from adding records to the system. I have to get it fixed quickly to get them working again so I don't have time to study everything in the locked state before killing the offending users session. It has only happened twice, once at night and once on a holliday. I don't have all of my toys at home to get a quick look. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Droping System User
Title: RE: Droping System User hi I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, the same steps i repeated in mine, all are fine, until before. Now i shutdown my database and startup again, here the problem arises. Oracle mount the database but while opening the database, the instance has been terminated by PMON. Sat Oct 20 10:57:45 2001 PMON: terminating instance due to error 470 Instance terminated by PMON, pid = 316 Oracle posted the following error continuosly in the alert log: SMON: following errors trapped and ignored: ORA-00376: file 1 cannot be read at this time ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF' Am crusious, come to know what type of problem you have faced? Regards, Nirmal -Original Message- From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Droping System User -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Dropping the SYSTEM user is not really all that traumatic. In most cases it's just a DBA account that may own some pieces you'd rather not lose, but dropping SYSTEM will not be noticed by the users of the database. That's the impression I get. When I looked at the objects owned by SYSTEM in my test database before the drop, none of them seemed vital. On the other hand, dropping sys would probably be bad, but I wasn't able to do that (insufficient privileges.) Trying to drop sys tables like sys.user$ caused an ORA-00701. So since I'm on a quest to wound this database, I tried this: SQL delete from sys.user$ where name = 'SYS' ; 1 ligne supprimée. SQL commit ; Validation effectuée. So far no ill effects!
Problem - V$BUFFER_POOL_STATISTICS
Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED]Contact : saurabh00pc @ MSN / Yahoo
RE: Problem - V$BUFFER_POOL_STATISTICS
Hi Saurabh, Try running $ORACLE_HOME/rdbms/admin/catperf.sql first. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message- Sent: Saturday, 20 October 2001 21:05 To: Multiple recipients of list ORACLE-L Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED] Contact : saurabh00pc @ MSN / Yahoo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem - V$BUFFER_POOL_STATISTICS
Hi Saurabh, have a look at $ORACLE_HOME/rdbms/admin/catperf.sql It seems you didn't run it Regards, Ed - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Saturday, October 20, 2001 3:05 PM Subject: Problem - V$BUFFER_POOL_STATISTICS Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED]Contact : saurabh00pc @ MSN / Yahoo
RE: Problem - V$BUFFER_POOL_STATISTICS
Wasnt statspack started with 8.1.6? Check the docs.. Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh Sharma Sent: Saturday, October 20, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Problem - V$BUFFER_POOL_STATISTICS Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED] Contact : saurabh00pc @ MSN / Yahoo
RE: Problem - V$BUFFER_POOL_STATISTICS
Statspack was created in v.8.1.6, but it is supposed to be compatible with v.8.0.x and above. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rajesh DayalSent: Saturday, October 20, 2001 7:10 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Problem - V$BUFFER_POOL_STATISTICS Wasnt statspack started with 8.1.6? Check the docs .. Rajesh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh SharmaSent: Saturday, October 20, 2001 3:05 PMTo: Multiple recipients of list ORACLE-LSubject: Problem - V$BUFFER_POOL_STATISTICS Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED]Contact : saurabh00pc @ MSN / Yahoo
RE: Problem - V$BUFFER_POOL_STATISTICS
Saurabh, Also note that you want to DROP this before you upgrade to 8.1.6 (I think?) where this becomes a fixed view. If you don't, you can end up with a view that is invalid and cannot be dropped. Also, in 8.1.7(?), there is a bug in the view where some of the fields are incorrectly zero - its fixed in a patch set. hth connor --- Steve Adams [EMAIL PROTECTED] wrote: Hi Saurabh, Try running $ORACLE_HOME/rdbms/admin/catperf.sql first. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message- Sent: Saturday, 20 October 2001 21:05 To: Multiple recipients of list ORACLE-L Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED] Contact : saurabh00pc @ MSN / Yahoo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: when user changed password?
u couldnt find that in logminer anyways. what is the db version? -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bind Variables
I have always used the CBO and statistics are generated fairly regularly. I use the analyze table estimate statistics which should not generate histogram information. I have even used the INDEX, FIRST_ROWS, and ALL_ROWS hints. None made a difference. I regenerated the statistics on all tables of a particular slow query with bind variables and it didn't make a difference either. Our platform is red hat linux 6.2 and oracle 8.1.7. [EMAIL PROTECTED] 10/19/01 18:58 PM I have heard of it. Its a concern. However, with hints you can solve some of your problems. And then you could use Stored Outlines and get it stable. And then life will be groovy. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Danny, It sounds like when you ...moved to bind variables... you did two things: 1. Switched to using CBO 2. Changed your application to take advantage of the bind variables. I have never heard of switching to bind variables making things slower (and can not imagine when it would make it so -- the CBO vs. RBO is irrelevant in this case). Thus the question: did you collect the statistics on all your application tables prior to switching to CBO? If you did not have any statistics collected or had some tables that did not have statistics collected then Oracle may had been choosing wrong execution path. Thanks, Val Gamerman. [EMAIL PROTECTED] on 10/19/2001 03:07:56 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Val Gamerman/Victoria Financial) Danny, Were you using histograms? Histograms do not work on bind variables, they only work on literals. I'm sure others will have more to say on the topic but that is one tidbit that I do have experience with on bind variables. Cherie Machler Oracle DBA Gelco Information Network Danny Hughes[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DHUGHES cc: Sent by: [EMAIL PROTECTED]Subject: Bind Variables 10/19/01 01:30 PM Please respond to ORACLE-L --CIVUFTDKZVQDOGJWYCGU Content-Type: multipart/alternative; boundary= HALPYZPZYFFYCGAKLKOY --HALPYZPZYFFYCGAKLKOY Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I have a question about using bind variables. It is my understanding that = bind variables are to be used to keep the same SQL from being reparsed and = keeping multiple copies in the SGA, thus *speeding* things up. I also = understand that by using bind variables that the CBO will not be able to = optimally use the statistics to determine the most effective path to = retrieve data. Some documentation states to use hints when you are using = bind variables to tell the CBO which path to take. Other documentation = states that bind variables don't like the CBO and to use the RBO. After we looked at the library cache and saw thousands of copies of the = same sql, and hundreds of different sql, we decided to look into converting = certain web pages to bind variables. After we converted to using bind = variables, the pages that once took 5 seconds to load all of the sudden = took 2 minutes to load. The db server was pegged at 100% from 8-5 every = day while this application was being used. We have converted back to = literals and the pages are loading quickly again. While on bind variables, = we used every possible hint except RULE and had no luck. We didn't want = to resort to using the RULE hint because oracle claims not to use the RBO = (because of no further enhancements and possibly phasing it out), and to = start using the CBO for everything. There are so many confusing documents regarding the use of bind variables. = I wanted to see what the oracle community is doing in regards to using = bind variables and what their experiences are. TIA Danny Hughes DBA Knobias.com [EMAIL PROTECTED] www.knobias.com --HALPYZPZYFFYCGAKLKOY Content-Type: multipart/related; boundary=KMQGUMGTJRAMPYVFBAEF --KMQGUMGTJRAMPYVFBAEF Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable I have a question about using bind variables. It is my understanding that = bind variables are to be used to keep the same SQL from being reparsed and = keeping multiple copies in the SGA, thus *speeding* things up. I also = understand that by using bind variables that the CBO will not be able to = optimally use the statistics to determine the most effective path to = retrieve data. Some documentation states to use hints when you are using = bind variables to tell the CBO which path to take. Other documentation = states that bind variables don't like the CBO and to use the RBO. br brAfter we looked
9i upgrade problems
I am/was trying to upgrade an 8.1.7 to 9i. The odma wizard process seemed to have completed without errors. However when I try to start the instance I get the message below. It appears ODMA created its own Roll Back Segment, but did not completely clean up after itself. Any suggestions WRT how I can get the instance up? [EMAIL PROTECTED] ORA-01116: error in opening database file 52 ORA-01110: data file 52: '/u01/app/oracle/product/9.0.1/assistants/dbma/log/EDWDEV/ODMA_RBS.dbf' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3 [EMAIL PROTECTED] Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: when user changed password?
Sharon, Historically, I don't know how you could do this... but if you have a future need to track this event, you may want to look into auditing options... beware of resource consumption if you track too many events. -Ron- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sharon Yang Sent: Saturday, October 20, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: when user changed password? Hi, Is it possible to find out when a user changed the password? Log miner is impossible. Thanks, Sharon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i upgrade problems
Charlie, The error indicates that the OS does no believe that the file exists. Have you verified its existence from the OS? If it exists make sure permissions are set correctly so that it can be opened by 'oracle'. I have not tried the migration to 9i, so I am not sure if this a known issue on your platform. You may want to try Metalink if that is an option. My guess, would be that after performing the necessary transactions, the migration script attempted to drop the tablespace and something went wrong. Since the tablespace was only used for migration... can you drop it? Try startup mount, alter database datafile datafile name offline drop... then try dropping the tablespace including contents. If you cannot drop the tablespace, then check the status of the data file in dba_data_files. If it still shows as available, you can trick oracle be telling it to create the data file again with the alter database create datafile and then drop the tablespace. HTH -Ron- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Charlie Mengler Sent: Saturday, October 20, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject: 9i upgrade problems I am/was trying to upgrade an 8.1.7 to 9i. The odma wizard process seemed to have completed without errors. However when I try to start the instance I get the message below. It appears ODMA created its own Roll Back Segment, but did not completely clean up after itself. Any suggestions WRT how I can get the instance up? [EMAIL PROTECTED] ORA-01116: error in opening database file 52 ORA-01110: data file 52: '/u01/app/oracle/product/9.0.1/assistants/dbma/log/EDWDEV/ODMA_RBS.dbf' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3 [EMAIL PROTECTED] Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: when user changed password?
Sharon, It is not possible to get that information without some setup already in place. What version of the database are you using? If 8i, you may want to consider enabling password management features by setting password resource limits. Pl review $ORACLE_HOME/rdbms/admin/utlpwdmg.sql script for some ideas... HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Saturday, October 20, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: when user changed password? Hi, Is it possible to find out when a user changed the password? Log miner is impossible. Thanks, Sharon File: body.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).