Privileges and PL/SQL code
Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C. Didn't use to work, since PL/SQL is not particularly interested in grants received through roles. But I don't really want to grant all privileges directly to B and C (and many more users). Is there a way in 9i that works better ? Any improvements I missed out on ? Thanks in advance, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Privileges and PL/SQL code
Title: RE: Privileges and PL/SQL code If you don't want to do that, create your pl/sql code under schema A and grant execute on those to B and C. Sorry ... that's the only way to go ... 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: Stefan Jahnke [mailto:[EMAIL PROTECTED]] Sent: Monday, July 14, 2003 8:31 AM To: Multiple recipients of list ORACLE-L Subject: Privileges and PL/SQL code Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C. Didn't use to work, since PL/SQL is not particularly interested in grants received through roles. But I don't really want to grant all privileges directly to B and C (and many more users). Is there a way in 9i that works better ? Any improvements I missed out on ? Thanks in advance, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). 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.*2
AW: Privileges and PL/SQL code
Title: RE: Privileges and PL/SQL code
That's what I was afraid of 8-{ ... oh
well.
Since
we have several developer's working on local copies of the code in schemas B, C,
etc.,
I
guess I have to grant privileges to all schemas.
Thanks
for the quick response.
Stefan
Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED]
http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
Kosten senken - strategische IT-Ziele
erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
mailto:[EMAIL PROTECTED].
Wie Sie wissen, koennen ueber das Internet
versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden.
Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und
unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und
Aeusserungen ausschliessen.
As you are probably aware, e-mails sent
via the Internet can easily be copied or manipulated by third parties. For this
reason we would ask for your understanding that, for your own protection and
ours, we must decline all legal responsibility for the validity of the
statements and comments given above.
-Ursprüngliche Nachricht-Von: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Gesendet: Montag, 14. Juli 2003
14:49An: Multiple recipients of list ORACLE-LBetreff:
RE: Privileges and PL/SQL code
If you don't want to do that, create your pl/sql code under
schema A and grant execute on those to B and C.
Sorry ... that's the only way to go ...
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:
Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 14, 2003 8:31 AM To: Multiple recipients of list ORACLE-L Subject: Privileges and PL/SQL code
Hi list
I was wondering if there is any way to get the following to
work:
User A owns all tables, users B,C own PL/SQL code to access
A's tables. To work with A's tables from user B and C,
I would like to create a role to contain all the
object privileges and grant these to B and C.
Didn't use to work, since PL/SQL is not particularly
interested in grants received through roles.
But I don't really want to grant all privileges directly to B
and C (and many more users).
Is there a way in 9i that works better ? Any improvements I
missed out on ?
Thanks in advance, Stefan
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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).
Antw: Privileges and PL/SQL code
Hi Stefan, since 8 (i?): have a look at AUTHID CURRENT USER in the docs. This enables using of database roles. Greetings, Guido [EMAIL PROTECTED] 14.07.2003 14.30 Uhr Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C. Didn't use to work, since PL/SQL is not particularly interested in grants received through roles. But I don't really want to grant all privileges directly to B and C (and many more users). Is there a way in 9i that works better ? Any improvements I missed out on ? Thanks in advance, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Guido Konsolke 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 DBA e-books , must read E-books
1)Expert One-on-One (Thomas Kyte) 2) Oracle doc. performance tuning guide. 3) High Performance tuning with Statpacks. (Don Burleson) 4) Scaling Oracle8i 4) Oracle Internals Locks,latche,waits,memory (Steve Adams). And finally this mail group... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 13, 2003 5:49 PM Dear Friends, I am from India , looking for some good books on Oracle DBA , especially performance oriented. I was trying to get 1. Practical oracle 8i by jonathan 2. Oracle 9i DBA 101 3. Any good oracle Performance books. But I failed to buy in indian market. I have many Oracle Books , Oracle Press books with me , all OCP oracle corp books and STS ,Test KNIG with me. Please reply this mail if you have any of the above mentioned books for exchange. Only for exchange. Pls do not reply If you do not have the above mentioned books. Thanks Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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: Manoj Kumar Jha 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 security question
Don, The users need acces to the data that is in the database or what is the purpose of the database? I would change the privileges of the users to CREATE SESSION only and revoke all others. Then I would use ROLES that have select privileges on the tables that they need acces to. By creating roles and granting the role to a user the user can select from the tables. If different groups need acces to different tables you can create different roles and grant them as needed. Roles are an easy method of controlling acces to table data and if changes are needed then you change the role's privileges and all users of the role are effected. Ron [EMAIL PROTECTED] 07/11/03 03:44PM Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that database. Can somebody tell me what it is necessary steps to do that? Any comments are highly appreciated. Thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: 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).
Estimating User Load on the system
Title: Estimating User Load on the system I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! 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.*2
RE: import from 8i to 9i /IMP-00003:ORA-02298
Just to update you all... I am not having any problems if I setup a db link from 9i to 8i and get the data then enable the constraints. Oracle asked me to create a test case for them. I have sent them all the information they have asked for. Thanks, Surendra -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: import from 8i to 9i /IMP-3:ORA-02298 I did that already. Please see below.. ERROR 1: = IMP-00017: following statement failed with ORACLE error 2298:"ALTER TABLE "TWESAU" ENABLE CONSTRAINT "FK_LC_AU_SYSID""IMP-3: ORACLE error 2298 encounteredORA-02298: cannot validate (CMS.FK_LC_AU_SYSID) - parent keys not found ALTER TABLE CMS.TWESAU ADD CONSTRAINT FK_LC_AU_SYSIDFOREIGN KEY (AU_CASELOAD_SYSID) REFERENCES CMS.TWESLC (LC_CASELOAD_SYSID) ON DELETE CASCADE; Query on source database: select AU_CASELOAD_SYSIDfrom cms.TWESAUwhere AU_CASELOAD_SYSID not in (select LC_CASELOAD_SYSID from cms.TWESLC); No rows ERROR 2: ==IMP-00017: following statement failed with ORACLE error 2298:"ALTER TABLE "TWESCA" ENABLE CONSTRAINT "FK_CO_CA_SYSID""IMP-3: ORACLE error 2298 encounteredORA-02298: cannot validate (CMS.FK_CO_CA_SYSID) - parent keys not found ALTER TABLE CMS.TWESCA ADD CONSTRAINT FK_CO_CA_SYSIDFOREIGN KEY (CA_COMPANY_SYSID) REFERENCES CMS.TWESCO (CO_COMPANY_SYSID) ON DELETE CASCADE; Query on source database: select CA_COMPANY_SYSIDfrom cms.TWESCAwhere CA_COMPANY_SYSID not in (select CO_COMPANY_SYSID from cms.TWESCO ); No rows. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003 10:37 AMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: import from 8i to 9i /IMP-3:ORA-02298 Surendra, Go back to the 8i database and run a query to see if parent records exist for all child records. It sounds like your source database is bad. Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: import from 8i to 9i /IMP-3:ORA-02298 I tried it on my sun box, still same problem. Also I tried with no compressing/uncompressing of dmp file, no luck. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 5:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: import from 8i to 9i /IMP-3:ORA-02298 With all my today's trials(including import into 8i db on Sun)I used different export file than the one I have used other day. I am wondering if the ftp(I did it in bin mode only)from unix box to windows box caused something? Anyway, I got my Sun box ready with 9i and will know soon if the problem is between Unix and Windows. Thanks for your reply. Surendra -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 3:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: import from 8i to 9i /IMP-3:ORA-02298 Could your export file be corrupt. There have been a few alerts on 8.1.7 exports producing bad dump files. One alert is Note:223399.1. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 [EMAIL PROTECTED] 7/8/03 3:34:29 PM What userid is exporting data and importing data? Try exporting and importing as system. 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 08, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: import from 8i to 9i /IMP-3:ORA-02298 I tried importing data first then enabling constraints, same problem. I have disabled(it is not enabled to begin with but reporting 'ENABLED' in USER_CONSTRAINTS) one of those constraints and tried to enable it manually. Same error. And I have
Recreating the Temporary segment in a TEMPORARY Tablespace
In earlier versions of Oracle with the TEMP tablespace being Dictionary-Managed but Contents=TEMPORARY, I could recreate or shrink the temporary segment without an Instance restart by executing an ALTER TABLESPACE TEMP DEFAULT STORAGE (PCTINCREASE 0) -- ie any ALTER command for the storage parameters would result in the temporary segment being dropped [if not in use, immediately, else, after the last session using it exits]. Why would I do it ? So as to be able to resize the datafiles in the TEMP tablespace. This could become necessary after a runaway query [a cartesian product] or some large index builds had extended the tablespace datafiles significantly. I would be able to reclaim the disk space. Now, with the TEMP tablespace a Locally-Managed, I find that I cannot recreate or shrink the temporary segment as the ALTER TABLESPACE TEMP DEFAULT STORAGE command is not valid. What other commands could I use ? Creating another TEMPORARY TABLESPACE, changing user's TEMPORARY_TABLESPACE and then dropping the first tablespace is an option but one that I would not prefer. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- 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).
Performance problems VMS 8i
Oracle 8.1.7.4 OpenVMS 7.2-1 DIGITAL TCP/IP Services for OpenVMS Alpha Ver V5.0A-ECO 3 After an upgrade from Oracle 7.3.4 to 8.1.7.4 on OpenVMS, some (but not all) of our batch jobs are suffering severe performance degradation. One of our critical jobs went from 3 hours to 9 hours elapsed time. The reason is obvious. The solution is not. One of our jobs increased from 45 minutes to 1 hr 30 min. The direct i/o for this job increased from 480 to 1,046,938. (Identical everything. Only difference 7.3.4 versus 8.1.7.4) This direct i/o number is from the parent process the process that is communicating with the detached process actually running the oracle code via a mailbox (using the bequeath adapter). The jobs causing trouble are batch jobs running on the server, and are using bequeath. Oracle has been pretty much useless. They recommended increasing sysgen pql parameters, which did nothing. I've been able to achieve the greatest performance gain for this job by increasing BIOLM (buffered i/o limit) for bequeath listener (using parameters on run/detached in startup_bequeath.com), tnslsnr (increasing lsnrctl.com and tnslsnr.com), and increasing biolm for Oracle acct and user acct running the job. Anyone out there - had similar experiences? - know what in blazes Oracle did to 2-task to shoot up direct i/o? - know how to influence the 2-task communication to use increased buffered i/o and decrease direct i/o? Any ideas greatly appreciated. Thanks! Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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: Estimating User Load on the system
Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! -- 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: Performance problems VMS 8i
I'm going to ask the obvious question: Have statistics been generated for the schemas in question? It's assumed that you're now using CBO, and if stats have not been generated, then CBO is making assumptions about the nature of your data. Jared On Monday 14 July 2003 07:54, Barbara Baker wrote: Oracle 8.1.7.4 OpenVMS 7.2-1 DIGITAL TCP/IP Services for OpenVMS Alpha Ver V5.0A-ECO 3 After an upgrade from Oracle 7.3.4 to 8.1.7.4 on OpenVMS, some (but not all) of our batch jobs are suffering severe performance degradation. One of our critical jobs went from 3 hours to 9 hours elapsed time. The reason is obvious. The solution is not. One of our jobs increased from 45 minutes to 1 hr 30 min. The direct i/o for this job increased from 480 to 1,046,938. (Identical everything. Only difference 7.3.4 versus 8.1.7.4) This direct i/o number is from the parent process the process that is communicating with the detached process actually running the oracle code via a mailbox (using the bequeath adapter). The jobs causing trouble are batch jobs running on the server, and are using bequeath. Oracle has been pretty much useless. They recommended increasing sysgen pql parameters, which did nothing. I've been able to achieve the greatest performance gain for this job by increasing BIOLM (buffered i/o limit) for bequeath listener (using parameters on run/detached in startup_bequeath.com), tnslsnr (increasing lsnrctl.com and tnslsnr.com), and increasing biolm for Oracle acct and user acct running the job. Anyone out there - had similar experiences? - know what in blazes Oracle did to 2-task to shoot up direct i/o? - know how to influence the 2-task communication to use increased buffered i/o and decrease direct i/o? Any ideas greatly appreciated. Thanks! Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- 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: Estimating User Load on the system
Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! -- 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). -- 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: Estimating User Load on the system
I'll add my favourite - and currently overlooked - point. Network. Not the entire network as a whole, but specific server things like NIC performance, protocol stack performance, MTU (see recent excellent post by Matt on jumbo frames), and all that jazz. my 2¢ Ciao Fuzzy ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of DENNIS WILLIAMS Sent: Monday, July 14, 2003 17:49 To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! -- 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). -- 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). -- 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: Estimating User Load on the system
Title: RE: Estimating User Load on the system Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind of computation of possible charge back. So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ... any ideas? 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: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Monday, July 14, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! -- 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). -- 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). *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.*1
MicroSlop DTC
To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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).
Oracle user groups in Bangalore, INDIA
List gurus, Are there any oracle user groups in Bangalore, INDIA? My nephew is an upcoming Oracle DBA. He would like to participate in user meetings relevant to Oracle in Bangalore area. Any help will be greatly appreciated. Thanks, Govind -- 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: Antw: Privileges and PL/SQL code
You will need to grant privileges directly to B and C on A's objects. Since B and C use PL/SQL code, other users only need to have execution permission on B and C's procedures. Using AUTHID CURRENT USER in the creation of the stored programs would require that the stored programs execute under the permissions and privileges of the user currently running the stored program. Otherwise the programs will be executed under the permissions and privileges of the owner of the stored programs. To enable a role with the privileges , grant the necessary privileges to a role, grant the role to the users, and at run time use the package procedure DBMS_SESSION.SET_ROLE. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] nkrupp.com To: [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] cc: Subject: Antw: Privileges and PL/SQL code 07/14/2003 07:54 AM Please respond to ORACLE-L Hi Stefan, since 8 (i?): have a look at AUTHID CURRENT USER in the docs. This enables using of database roles. Greetings, Guido [EMAIL PROTECTED] 14.07.2003 14.30 Uhr Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C. Didn't use to work, since PL/SQL is not particularly interested in grants received through roles. But I don't really want to grant all privileges directly to B and C (and many more users). Is there a way in 9i that works better ? Any improvements I missed out on ? Thanks in advance, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Guido Konsolke 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: 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
Re: MicroSlop DTC
I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: MicroSlop DTC 07/14/2003 11:19 AM Please respond to ORACLE-L To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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: Estimating User Load on the system
Raj, Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT): CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!) physical reads + physical reads (direct, lob, etc.) + db block changes (former is reads, latter is the number of changes that would cause writes on behalf of that process for Log, Undo and DBFile) session pga/uga memory max (Memory usage) SQL*Net roundtrips to/from client and dblink (Network usage) Collect and summarize system wide (via STATSPACK) and for individual users via LOGOFF just to compare. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind of computation of possible charge back. So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ... any ideas? 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- mailto:[EMAIL PROTECTED] ] Sent: Monday, July 14, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Jared Still 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: DENNIS WILLIAMS 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
RE: Estimating User Load on the system
Title: RE: Estimating User Load on the system Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need. 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: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, July 14, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj, Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT): CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!) physical reads + physical reads (direct, lob, etc.) + db block changes (former is reads, latter is the number of changes that would cause writes on behalf of that process for Log, Undo and DBFile) session pga/uga memory max (Memory usage) SQL*Net roundtrips to/from client and dblink (Network usage) Collect and summarize system wide (via STATSPACK) and for individual users via LOGOFF just to compare. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind of computation of possible charge back. So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ... any ideas? 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- mailto:[EMAIL PROTECTED] ] Sent: Monday, July 14, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA 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 ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Jared Still 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
Re: Oracle security question
Hi Don, I wrote a paper for securityfocus.com a while ago that described a simple security scanner for Oracle, there is also a script you can run with the paper. You can get the link on my Oracle security papers page on my site at www.petefinnigan.com/orasec.htm, the paper is near the top and is called a simple Oracle security scanner hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
dbf and cdx files
I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak
Re: dbf and cdx files
clipper/dbase III/foxbase/foxpro? joe AK wrote: I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: MicroSlop DTC
9.2.0.1.0 On Win 2K. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: MicroSlop DTC 07/14/2003 11:19 AM Please respond to ORACLE-L To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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: dbf and cdx files
The dbf are databases of Fox, Clipper or DBase. And the cdx, I am not sure but maybe are index. You can open the dbf's with MicrosoftExcel, DBUor DBASE. In excel select data type DBase. [EMAIL PROTECTED] 07/14/03 12:29PM I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak
RE: MicroSlop DTC
Hum, does tnsping resolve the service correctly? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: RE: MicroSlop DTC 07/14/2003 12:44 PM Please respond to ORACLE-L 9.2.0.1.0 On Win 2K. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: MicroSlop DTC 07/14/2003 11:19 AM Please respond to ORACLE-L To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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
RE: dbf and cdx files
Are the dbf files dbase files? If so, I have something that you might be able to use or adapt to your purposes. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: dbf and cdx files I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak
RE: dbf and cdx files
Toss paradox in too.. YOu might be able to find and old dbf to ascii test converter utility.it might still run in a DOS box on WIndoze... Old excel version from Office 95 might be able to open them. You would need to set up 95 or 98 to install... either wayugly -Original Message- Sent: Monday, July 14, 2003 1:44 PM To: Multiple recipients of list ORACLE-L clipper/dbase III/foxbase/foxpro? joe AK wrote: I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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).
oracle last
hi is there a statement like last in mysql ? last returns a specified number of rows from a select. means if i do a select and i want only the last 3 lines. thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer 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: MicroSlop DTC
Yes, as well as SQL*Plus and ODBCTST. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hum, does tnsping resolve the service correctly? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: RE: MicroSlop DTC 07/14/2003 12:44 PM Please respond to ORACLE-L 9.2.0.1.0 On Win 2K. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: MicroSlop DTC 07/14/2003 11:19 AM Please respond to ORACLE-L To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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:
Re: Oracle security question
Dear Guang Mei: Thanks for your message. Your suggestion is very helpful. After reviewing all possible uesers, I have locked them. Now I have only one concern that if nobody knows my database's sys and system's password, there should be no way to unlock these accounts. Am I complete right? Thanks! Any comments are appreciated! Don Guang Mei wrote: select * from all_users; to get all users, then change their oracle passwords so that no body can log in except you. This way you know you are the only one who can change the data. Next step is see what application can make the data change. Hope this helps. Guang On Fri, 11 Jul 2003, Don Yu wrote: Dennis Thank you very much. My data in that database is changed three times. The first is whole data being delete. The second is over ten thousands records being added. The third is whole data related to a month being deleted. I know my working environment is very complicated. For this report application, I write shell scripts and C/C++ program to parsing Apache web server access log file (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which are associated with the special pattern as ntlinktrack.cgi, which is associated with Library E-Book,E-Journal, and E-database. Then I need to schedule a solaris cron job to process access log daily and load parsed data into database. Also I create some log files for saving intermediate information from my program. Then I create some ColdFusion pages to post these results into website. In my database there are over million records. Oracle DBA is new duty for me since I had found that my data was missing. This is the reason I post my question on Oracle user group. Now I am trying to read as much as I can but I do not have much time. I want to make sure my database is secure as early as I can. So what do you think of my reason? Thank you very much! Don DENNIS WILLIAMS wrote: Don SYS is the owner of the Oracle dictionary tables. It is a username with DBA privilege, so someone who logs in can change data. If you have changed its password, then you are assured that nobody is using that username right now. If you've changed its password, then I wouldn't worry about it right now. Since it sounds as if you are the only person that accesses this database, then you may want to change the username that owns your tables. Hopefully this username is not SYSTEM or SYS. After that, unless you know of other usernames someone might use to access your Oracle database, don't make any more security changes for awhile. Go back to trying to figure out why your data is changing without your changing it. It may well be there is an innocent reason that has nothing to do with someone else. I've had that happen to me when I've started using an unfamiliar system. And don't forget to buy a good Oracle DBA book like the one I suggested. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 11, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Dennis: Thanks for your message. Now I have changed sys password by the following command: alter user sys identified by xxx But when I try to login from sql plus window by using sys, I cannot successfully login. Also I get an error message. The message is something like connection to sys should be as sysdba or sysoper. So my question is what sys for? Thank you very much! Don DENNIS WILLIAMS wrote: Don If only you can make updates to your Oracle database, then you must enter all the data ;-) From the tone of your posting, I'm going to assume that you are pretty new to Oracle. You may want to get a good basic administration book like Oracle9i DBA 101. http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8 -1/ref=sr_8_1/104-2287688-5574335?v=glances=booksn=507846 It is also a good idea to always mention your Oracle version and platform (Unix, NT, etc.) in your posts. First, log in with the SYSTEM username. Then change the password for SYSTEM and SYS with the command: ALTER USER SYSTEM IDENTIFIED BY x; Where x is your new password. You should be able to make these changes without affecting any end users. Next you should identify your groups of users and how they access Oracle. Basically you need to identify what their access requirements are and then audit the usernames they use to ensure the privileges granted are just what is required. This is also a good time to see about changing passwords, but first buy the book and read up on the basics of Oracle security. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-
RE: LISTENER ON LINUX
A simple ps -ef|grep lsnr will work. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, July 11, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: Ball, Terry 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 listener
hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer 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: Performance problems VMS 8i
Hi Barbara After an upgrade from Oracle 7.3.4 to 8.1.7.4 on OpenVMS, some (but not all) of our batch jobs are suffering severe performance degradation. One of our critical jobs went from 3 hours to 9 hours elapsed time. The reason is obvious. The solution is not. One of our jobs increased from 45 minutes to 1 hr 30 min. The direct i/o for this job increased from 480 to 1,046,938. (Identical everything. Only difference 7.3.4 versus 8.1.7.4) This direct i/o number is from the parent process - the process that is communicating with the detached process actually running the oracle code via a mailbox (using the bequeath adapter). The jobs causing trouble are batch jobs running on the server, and are using bequeath. This sounds like a piece of SQL has hit upon a different execution plan. I'd recommend the following course of action 1. get up to date statistics as Jared says (compute them if you can). 2. modify the job so that it does the following alter session set events '10046 trace name context forever, level 12'; your job alter session set events '10046 trace name context off'; 3. run the job. You will get a trace file in the udump directory with waits and elapsed time in it, you can run that thru tkprof. Look for large values of elapsed time. Chances are excellent (better than 90%) there will be 1 (or at an outside 2) statements that take up more than an hour of your hour and a half. Chances are pretty good ( better than 75%) that faced with those statements you can tune them to take less than 20 minutes - a good index, a rewritten statement. If you don't like all this set events stuff connect internal to the db and run @?/rdbms/admin/dbmssupp and replace the trace stuff with exec sys.dbms_support.start_trace(true,true); your job exec dbms_support.stop_trace(); It does the same thing. If in the unlikely event the above does not hold true, well you will see what you spend your time waiting on. If it is network stuff then maybe you can think about raising a tar with more info. I honestly expect it to be the sql. Do feel free to post the results of the above, if only to show how wrong I am. Good luck. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: MicroSlop DTC
If you are using Microsoft Transaction Server, then be aware that there is a crucial patch to 9i that enables it to work correctly. Oracle shipped a wrong dll oramts.dll with 9i that breaks MTS. I tried 3 times with metablink to find out what was wrong before the software supplier pointed this out. At which point a search for oramts.dll on metablink worts you out. Of course this may be entirely irrelevant.. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, Dick Sent: 14 July 2003 18:19 To: Multiple recipients of list ORACLE-L Subject: MicroSlop DTC To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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 security question
Don Well, if you changed the password, then you should have the new password. Don't post them, because everyone on the internet will have them. What is your Oracle version? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Dear Guang Mei: Thanks for your message. Your suggestion is very helpful. After reviewing all possible uesers, I have locked them. Now I have only one concern that if nobody knows my database's sys and system's password, there should be no way to unlock these accounts. Am I complete right? Thanks! Any comments are appreciated! Don Guang Mei wrote: select * from all_users; to get all users, then change their oracle passwords so that no body can log in except you. This way you know you are the only one who can change the data. Next step is see what application can make the data change. Hope this helps. Guang On Fri, 11 Jul 2003, Don Yu wrote: Dennis Thank you very much. My data in that database is changed three times. The first is whole data being delete. The second is over ten thousands records being added. The third is whole data related to a month being deleted. I know my working environment is very complicated. For this report application, I write shell scripts and C/C++ program to parsing Apache web server access log file (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which are associated with the special pattern as ntlinktrack.cgi, which is associated with Library E-Book,E-Journal, and E-database. Then I need to schedule a solaris cron job to process access log daily and load parsed data into database. Also I create some log files for saving intermediate information from my program. Then I create some ColdFusion pages to post these results into website. In my database there are over million records. Oracle DBA is new duty for me since I had found that my data was missing. This is the reason I post my question on Oracle user group. Now I am trying to read as much as I can but I do not have much time. I want to make sure my database is secure as early as I can. So what do you think of my reason? Thank you very much! Don DENNIS WILLIAMS wrote: Don SYS is the owner of the Oracle dictionary tables. It is a username with DBA privilege, so someone who logs in can change data. If you have changed its password, then you are assured that nobody is using that username right now. If you've changed its password, then I wouldn't worry about it right now. Since it sounds as if you are the only person that accesses this database, then you may want to change the username that owns your tables. Hopefully this username is not SYSTEM or SYS. After that, unless you know of other usernames someone might use to access your Oracle database, don't make any more security changes for awhile. Go back to trying to figure out why your data is changing without your changing it. It may well be there is an innocent reason that has nothing to do with someone else. I've had that happen to me when I've started using an unfamiliar system. And don't forget to buy a good Oracle DBA book like the one I suggested. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 11, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Dennis: Thanks for your message. Now I have changed sys password by the following command: alter user sys identified by xxx But when I try to login from sql plus window by using sys, I cannot successfully login. Also I get an error message. The message is something like connection to sys should be as sysdba or sysoper. So my question is what sys for? Thank you very much! Don DENNIS WILLIAMS wrote: Don If only you can make updates to your Oracle database, then you must enter all the data ;-) From the tone of your posting, I'm going to assume that you are pretty new to Oracle. You may want to get a good basic administration book like Oracle9i DBA 101. http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8 -1/ref=sr_8_1/104-2287688-5574335?v=glances=booksn=507846 It is also a good idea to always mention your Oracle version and platform (Unix, NT, etc.) in your posts. First, log in with the SYSTEM username. Then change the password for SYSTEM and SYS with the command: ALTER USER SYSTEM IDENTIFIED BY x; Where x is your new password. You should be able to make these changes without affecting any end users. Next you should identify your groups of users and how they access Oracle. Basically you need to identify what their access requirements are and then
Re: dbf and cdx files
Looks like foxpro files . Trying to open using odbc driver . -ak - Original Message - From: Stephen Lee To: Multiple recipients of list ORACLE-L Sent: Monday, July 14, 2003 11:54 AM Subject: RE: dbf and cdx files Are the dbf files dbase files? If so, I have something that you might be able to use or adapt to your purposes. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: dbf and cdx files I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak
RE: dbf and cdx files
Attached (I hope) is a C prog I slapped together to take the contents of a DBF file and blow it out to a SQL Loader dat file. I got most of the info from asktom.oracle.com. He has apackage posted there to read a DBF file and insert rows into an oracle table. It is a robust, general-purpose package, but because it inserts rows one at a time, it's as slow as Christmas. I use a ksh script to generate a control file (using the print header only option of the C program), start up sql loader and have it suck on a namedpipe,generate sql loader dat info using all of the C program, and have it write to the named pipe. You can compile the C program and see if you get what we would expect to get from the DBF files. The C program works entirely through command line redirection. Example: c_prog [options] dbf_file output_file -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 4:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dbf and cdx files Looks like foxpro files . Trying to open using odbc driver . -ak - Original Message - From: Stephen Lee To: Multiple recipients of list ORACLE-L Sent: Monday, July 14, 2003 11:54 AM Subject: RE: dbf and cdx files Are the dbf files dbase files? If so, I have something that you might be able to use or adapt to your purposes. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: dbf and cdx files I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak dbf_reader.c Description: Binary data
Re: oracle last
Depending upon the version, you may be able to use the analytical functions (8.1.6+) to achieve what you want. I don't have a ready example, but the Oracle docs are pretty good. If you want a less elegant solution, use an inline query, sort by the reverse order (asc or desc depends on your requirements) and take the top 3. You can find examples of the Top-N approach on www.optimaldba.com/library.html. Either the Top-N Row or SQL Scripting Sorcery paper/presentation will have enough info to solve the problem. pfeffer wrote: hi is there a statement like last in mysql ? last returns a specified number of rows from a select. means if i do a select and i want only the last 3 lines. thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer 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).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
Perl Question
I am mucking through my first real perl script. When it is finished it will install statspack on all of the database throughout the company. That's a gob of databases! To run in batch mode statspack requires two define statements: define default_tablespace = tablespace_name define temporary_tablespace = temp_name Does anyone know the syntax to get these two statements to work? If not, I suppose the individual scripts can be called individually after the perfstat user is created. Either that or chicken out of the perl stuff and go back to tried and true shell scripting. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett 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: dbf and cdx files
I looked through the copy of the C program file I sent and spotted the following error: if(i + 1 p_hdr.no_fields) write(out, ::, 1); There should only be one : in the string ... unless you want ::, in which case, change the 1 to 2. This isn't really an error since only one : is going to print; but it looks bad. This is probably the result of me getting distracted while playing around with different scenarios and never getting back to finish whatever idea I had started. Life is like that around here. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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 listener
Hello Martin, You can create a sequence in Oracle and assign it to the table. You don';t have to create trigger on it. Hope this helps Raju. sorry for my english too :) --- pfeffer [EMAIL PROTECTED] wrote: hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer 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!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: raju angani 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: Estimating User Load on the system
Hello folks, Recently, I employed a similar approach in ourtest database to figure out the problematic queries during a certain load test. I used a logon trigger with just 2 statements : alter session set max_dump_file_size = unlimited; alter session set sql_trace = true; The init.ora had to be modified to set _public_trace_files = true to allow the database userid used by the application to be able to write to the user_dump_dest. Regarding the specifics of the test, I coordinated with the testers and created the trigger just before the load test began and dropped it after the test was over. Of course, I had to make sure that this load test was the only application running. There were around 90 trace files generated which gave me much more information that I ever envisioned. It showed that the connection pooling of the application was implemented poorly since 90 files were generated during a 1 hour load test. Also, I consolidated all the trace files into 1 huge trace file using a shell script and ran it through TKPROF. The information obtained was priceless. It not only provided the culprit queries, it also provided the amount was time being spent in the database out of a total load test of 1 hour. Just wanted to share it with you folks. Let me know if you have any questions. Anil "Jamadagni, Rajendra" [EMAIL PROTECTED] wrote: Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need. 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: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, July 14, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj, Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT): CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!) physical reads + physical reads (direct, lob, etc.) + db block changes (former is reads, latter is the number of changes that would cause writes on behalf of that process for Log, Undo and DBFile) session pga/uga memory max (Memory usage) SQL*Net roundtrips to/from client and dblink (Network usage) Collect and summari! ze system wide (via STATSPACK) and for individual users via LOGOFF just to compare. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind of computation of possible charge back. So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ... any ideas? 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- mailto:[EMAIL PROTECTED] ] Sent: Monday, July 14, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place
Re: Perl Question
Pete, Even as a rabid Perl fanatic, I still use KSH to install statspack. I just modified the stock scripts a bit so they will run without user input. You can do it in Perl, but ksh is probably the tool for this job. Jared Peter Barnett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/14/2003 03:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Perl Question I am mucking through my first real perl script. When it is finished it will install statspack on all of the database throughout the company. That's a gob of databases! To run in batch mode statspack requires two define statements: define default_tablespace = tablespace_name define temporary_tablespace = temp_name Does anyone know the syntax to get these two statements to work? If not, I suppose the individual scripts can be called individually after the perfstat user is created. Either that or chicken out of the perl stuff and go back to tried and true shell scripting. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett 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: 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: Estimating User Load on the system
Hello folks, Recently, I employed a similar approach in ourtest database to figure out the problematic queries during a certain load test. I used a logon trigger with just 2 statements : alter session set max_dump_file_size = unlimited; alter session set sql_trace = true; The init.ora had to be modified to set _public_trace_files = true to allow the database userid used by the application to be able to write to the user_dump_dest. Regarding the specifics of the test, I coordinated with the testers and created the trigger just before the load test began and dropped it after the test was over. Of course, I had to make sure that this load test was the only application running. There were around 90 trace files generated which gave me much more information that I ever envisioned. It showed that the connection pooling of the application was implemented poorly since 90 files were generated during a 1 hour load test. Also, I consolidated all the trace files into 1 huge trace file using a shell script and ran it through TKPROF. The information obtained was priceless. It not only provided the culprit queries, it also provided the amount was time being spent in the database out of a total load test of 1 hour. Just wanted to share it with you folks. Let me know if you have any questions. Anil "Jamadagni, Rajendra" [EMAIL PROTECTED] wrote: Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need. 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: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, July 14, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj, Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT): CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!) physical reads + physical reads (direct, lob, etc.) + db block changes (former is reads, latter is the number of changes that would cause writes on behalf of that process for Log, Undo and DBFile) session pga/uga memory max (Memory usage) SQL*Net roundtrips to/from client and dblink (Network usage) Collect and summari! ze system wide (via STATSPACK) and for individual users via LOGOFF just to compare. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind of computation of possible charge back. So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ... any ideas? 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- mailto:[EMAIL PROTECTED] ] Sent: Monday, July 14, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place
How to make SPFILE in sync with INIT.ORA ?
Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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: How to make SPFILE in sync with INIT.ORA ?
USE shortcut like soft link for unix -Original Message- Sent: 15 July 2003 10:59 To: Multiple recipients of list ORACLE-L Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: How to make SPFILE in sync with INIT.ORA ?
make spfile from pfile; something like that. I would suggest just deleting it altogether. :) - Kirti --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: How to make SPFILE in sync with INIT.ORA ?
Try OEM it has a couple of ways to help you do this. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 14, 2003 11:19 PM make spfile from pfile; something like that. I would suggest just deleting it altogether. :) - Kirti --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Jay 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: How to make SPFILE in sync with INIT.ORA ?
As user sys, issue CREATE SPFILE FROM PFILE; This will create the spfile. You must have started the database using the pfile to use this command. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 14, 2003 10:59 PM Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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: Estimating User Load on the system
Thanks, but I am _not_ looking for culprits ... and I will be collecting this data over a week so collecting traces is not an option. I have queries run by research dept that routinely scan millions of rows, multiple times a day... EMC should be happy though ... Thanks again Raj -Original Message-From: Anil Sikri [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Estimating User Load on the system Hello folks, Recently, I employed a similar approach in ourtest database to figure out the problematic queries during a certain load test. I used a logon trigger with just 2 statements : alter session set max_dump_file_size = unlimited; alter session set sql_trace = true; The init.ora had to be modified to set _public_trace_files = true to allow the database userid used by the application to be able to write to the user_dump_dest. Regarding the specifics of the test, I coordinated with the testers and created the trigger just before the load test began and dropped it after the test was over. Of course, I had to make sure that this load test was the only application running. There were around 90 trace files generated which gave me much more information that I ever envisioned. It showed that the connection pooling of the application was implemented poorly since 90 files were generated during a 1 hour load test. Also, I consolidated all the trace files into 1 huge trace file using a shell script and ran it through TKPROF. The information obtained was priceless. It not only provided the culprit queries, it also provided the amount was time being spent in the database out of a total load test of 1 hour. Just wanted to share it with you folks. Let me know if you have any questions. Anil "Jamadagni, Rajendra" [EMAIL PROTECTED] wrote: Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need. 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: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, July 14, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj, Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT): CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!) physical reads + physical reads (direct, lob, etc.) + db block changes (former is reads, latter is the number of changes that would cause writes on behalf of that process for Log, Undo and DBFile) session pga/uga memory max (Memory usage) SQL*Net roundtrips to/from client and dblink (Network usage) Collect and summari! ze system wide (via STATSPACK) and for individual users via LOGOFF just to compare. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, July 14, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind of computation of possible charge back. So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ... any ideas? 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- mailto:[EMAIL PROTECTED] ] Sent: Monday, July 14, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Raj I'll second Jared's idea. Don
Thanx--Re: How to make SPFILE in sync with INIT.ORA ?
Thanx a lot Arup,Kirti,Arun and others. It worked Thanx a lot once again. i accidentally deleted my mails. sorry i couldn't thank everyone in person. Thanx and Regards, Jp. 15-07-2003 13:25:15, Arunkumar [EMAIL PROTECTED] wrote: Fire the following commands . 1) startup pfile='d:\oracle\admin\pe92\pfile\init.ora' 2)Create spfile from pfile ; 3)then shutdown the database. finally 4)startup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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).
OEM Repository Problem
Hi Listers, I had OEM repository on my database installed on my PC. Accidentally I dropped the database. Now I have recreated the database. But an not able to use this database to create New OEM repository as the OEM config assistant says that the database already had a repository installed. If I try to drop the repository it gives me error as the repository is not actually present. Please tell me if anyone of u knows how to solve this problem. Do I have to reinstall the Oracle Software again. Thanks to all in advance Regards Munish Bajaj
