ORA-01578 data block corrupted
Title: ORA-01578 data block corrupted I got ORA-01578 error while querrying info for below table. How do I fix this error? SQLSelect count(*) from GATEWAYCALLSTATS; * ERROR at line 2: ORA-01578: ORACLE data block corrupted (file # 3, block # 2683299) ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf' Thanks, David
Delete vs. truncate to free up spaces.
Title: Delete vs. truncate to free up spaces. I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I need to keep one month old of records in table. Please advise a better method I can use to free up spaces. Thanks, David
RE: Delete vs. truncate to free up spaces.
It's Oracle8i Enterprise Edition. -Original Message- Jacques Kilchoer Sent: Monday, December 22, 2003 4:44 PM To: Multiple recipients of list ORACLE-L This is one of the cases where a partitioned table can be of great use. What version of Oracle? Standard or Enterprise Edition? With a partitioned table you can say alter table ... drop partition ... ; to easily get rid of a large chunk of data and release the space. See Oracle9i Database Concepts Release 2 (9.2) Part Number A96524-01 Chapter 11 Partitioned Tables and Indexes http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12p arti.htm#464767 or http://tinyurl.com/362ba -Original Message- Nguyen, David M I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I need to keep one month old of records in table. Please advise a better method I can use to free up spaces. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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: Unreadable time_stamp format
Jared,
It is epochtime. When I run your
given SQL I got TO_DATE output is 24-NOV-03. Is it
actual date translated from epochtime 1069716948959 ?
How do I query to select only 100 records?
SQL select to_date('01/01/1970','mm/dd/')
+ ( 1069716948959 / (24*60*60*100
0) ) from dual ;
TO_DATE('
-
24-NOV-03
Thanks,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday,
December 16, 2003 7:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unreadable time_stamp
format
Try milliseconds from the epoch - 1/1/1970
select
to_date('01/01/1970','mm/dd/') + ( 1069716948959 / (24*60*60*1000) ) from
dual
You
really need to know how the timestamp column is defined by your app.
Jared
Nguyen, David M
[EMAIL PROTECTED]
Sent
by: [EMAIL PROTECTED]
12/16/2003 02:09 PM
Please
respond to ORACLE-L
To:Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Unreadable
time_stamp format
Now I got.
USER_NAME TIME
STAMP
--
eholley
1069716948959
jmdavis
1069715246467
jmdavis
1069715324466
-Original
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark
Sent: Tuesday, December 16, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unreadable time_stamp format
Since it's a NUMBER datatype, try:
SQL column time_stamp format
SQL select user_name, time_stamp from
USER_ACTIVITY_LOG;
-Original
Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Unreadable time_stamp format
I need to view time_stamp column in
USER_ACTIVITY_LOG table but it displays unreadable format as shown below.
Is there a way to decode it to be readable?
SQL desc USER_ACTIVITY_LOG
Name
Null? Type
-
TIME_STAMP
NOT NULL NUMBER(20)
NODE_NAME
NOT NULL
VARCHAR2(20)
USER_NAME
NOT
NULL VARCHAR2(20)
CLIENT_IP
NOT NULL VARCHAR2(15)
DESCRIPTION
NOT NULL
VARCHAR2(2048)
SQLselect user_name, time_stamp from USER_ACTIVITY_LOG;
edscott 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
jmdavis 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
Thanks,
David
RE: Unreadable time_stamp format
Jared,
Sure I will. Thanks for you help.
Regards,
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003
11:10 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unreadable time_stamp
format
David,
SOAPBOX
Not
trying to sound condescending or disrespectful, but I think you need
some
serious practice time with SQL. Break out the SQL manual, and find
out
how to join various tables. A good place to start would be the demo
account
scott/tiger, with the demo tables in $ORACLE_HOME/sqlplus/demo.
Knock
yourself out playing with joins, experimenting with different SQL functions.
Create
foreign keys, find out why FK's should have an index, what the requirements
are
for the index, etc. Become *fluent* in PL/SQL as well, and learn when to
use
it and when not to use it.
/SOAPBOX
Try
this:
select
user_name
, to_date('01/01/1970','mm/dd/') + (
time_stamp / (24*60*60*1000))
from user_activity_log
where rownum = 100
HTH
Jared
Nguyen, David M
[EMAIL PROTECTED]
Sent
by: [EMAIL PROTECTED]
12/17/2003 07:54 AM
Please
respond to ORACLE-L
To:Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Unreadable
time_stamp format
Jared,
It is epochtime. When I run your given SQL I got
TO_DATE output is 24-NOV-03. Is it actual date translated
from epochtime 1069716948959 ?
How do I query to select only 100 records?
SQL select to_date('01/01/1970','mm/dd/') + (
1069716948959 / (24*60*60*100
0) ) from dual ;
TO_DATE('
-
24-NOV-03
Thanks,
David
-Original
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unreadable time_stamp format
Try milliseconds from the epoch - 1/1/1970
select to_date('01/01/1970','mm/dd/') + ( 1069716948959 / (24*60*60*1000) )
from dual
You really need to know how the timestamp column is defined by your app.
Jared
Nguyen, David M
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/16/2003 02:09 PM
Please respond to ORACLE-L
To:Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Unreadable
time_stamp format
Now I got.
USER_NAME TIME STAMP
--
eholley
1069716948959
jmdavis
1069715246467
jmdavis
1069715324466
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark
Sent: Tuesday, December 16, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unreadable time_stamp format
Since it's a NUMBER datatype, try:
SQL column time_stamp format
SQL select user_name, time_stamp from USER_ACTIVITY_LOG;
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Unreadable time_stamp format
I need to view time_stamp column in
USER_ACTIVITY_LOG table but it displays unreadable format as shown below.
Is there a way to decode it to be readable?
SQL desc USER_ACTIVITY_LOG
Name
Null? Type
-
TIME_STAMP
NOT NULL NUMBER(20)
NODE_NAME
NOT NULL
VARCHAR2(20)
USER_NAME
NOT
NULL VARCHAR2(20)
CLIENT_IP
NOT NULL VARCHAR2(15)
DESCRIPTION
NOT NULL
VARCHAR2(2048)
SQLselect user_name, time_stamp from USER_ACTIVITY_LOG;
edscott 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
jmdavis 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
Thanks,
David
Unreadable time_stamp format
Title: Unreadable time_stamp format I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below. Is there a way to decode it to be readable? SQL desc USER_ACTIVITY_LOG Name Null? Type - TIME_STAMP NOT NULL NUMBER(20) NODE_NAME NOT NULL VARCHAR2(20) USER_NAME NOT NULL VARCHAR2(20) CLIENT_IP NOT NULL VARCHAR2(15) DESCRIPTION NOT NULL VARCHAR2(2048) SQLselect user_name, time_stamp from USER_ACTIVITY_LOG; edscott 1.0693E+12 edscott 1.0693E+12 edscott 1.0693E+12 edscott 1.0693E+12 jmdavis 1.0693E+12 edscott 1.0693E+12 edscott 1.0693E+12 Thanks, David
RE: Unreadable time_stamp format
Title: Unreadable time_stamp format Now I got. USER_NAME TIME STAMP -- eholley 1069716948959 jmdavis 1069715246467 jmdavis 1069715324466 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark Sent: Tuesday, December 16, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unreadable time_stamp format Since it's a NUMBER datatype, try: SQL column time_stamp format SQL select user_name, time_stamp from USER_ACTIVITY_LOG; -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Unreadable time_stamp format I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below. Is there a way to decode it to be readable? SQL desc USER_ACTIVITY_LOG Name Null? Type - TIME_STAMP NOT NULL NUMBER(20) NODE_NAME NOT NULL VARCHAR2(20) USER_NAME NOT NULL VARCHAR2(20) CLIENT_IP NOT NULL VARCHAR2(15) DESCRIPTION NOT NULL VARCHAR2(2048) SQLselect user_name, time_stamp from USER_ACTIVITY_LOG; edscott 1.0693E+12 edscott 1.0693E+12 edscott 1.0693E+12 edscott 1.0693E+12 jmdavis 1.0693E+12 edscott 1.0693E+12 edscott 1.0693E+12 Thanks, David
Could not run export utility from cron job
Title: Could not run export utility from cron job I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. $exp user/password tables.dmp Thanks, David
Who is querying database info using dblink
How do I check who is querying database information via database link? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
Location of trace files and alert log
Title: Location of trace files and alert log How do I locate where all trace files and alert log are saved? There is no parameter setup in init.ora file. Thanks, David
RE: Perl Book
Programming the Perl DBI from Oreilly is really good for your need. -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Perl Book http://www.oreilly.com/catalog/oracleperl/ Play your cards right and you may even get an autographed copy. ;o) Dave -Original Message- From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Subject: OTC: Perl Book Looks like I have a need write a Perl program to access a database. Any suggestions on a good book. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204
RE: Date format is unreadable
Title: RE: Date format is unreadable
It works better but it still does give correct output. I'd like to see hour,min,sec as well.
1 select user_name,node_name,to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400 from user_activity_log
2 from user_activity_log
3 where user_name = 'admin'
4* order by time_stamp
SQL /
USER_NAME NODE_NAME TO_DATE('
-
admin Insight Server 01-MAY-19
admin Insight Server 11-MAY-03
admin Insight Server 11-NOV-01
admin Insight Server 24-DEC-13
Thanks,
David
-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 05, 2003 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Date format is unreadable
Ooops. Should have written
to_date('01/01/1970', 'MM/DD/') + TIME_STAMP / 86400
The timestamp is in seconds since 1/1/1970, while Oracle date arithmetic
is in days.
Sorry.
Nguyen, David M wrote:
Yes, it is a Unix timestamp. I use your syntax and I got following error.
1 select
user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/')+tig
2 where user_name = 'admin'
3* order by time_stamp
SQL /
select user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/') +
time_stamp from user_activity_log
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +, and not be 0
-Original Message-
Sent: Wednesday, March 05, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L
David,
I presume that your date is a Unix timestamp.
Try to see whether
to_date('01/01/1970', 'MM/DD/') + TIME_STAMP
yields something more meaningful to you ...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
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).
Date format is unreadable
I try to query a report to check user activity but I could not read date column. Is there a way to reformat the column to be readable? Date colum calls "time_stamp" as shown below. SQL desc user_activity_log Name Null? Type - -- TIME_STAMP NOT NULL NUMBER(20) NODE_NAME NOT NULL VARCHAR2(20) USER_NAME NOT NULL VARCHAR2(20) CLIENT_IP NOT NULL VARCHAR2(15) DESCRIPTION NOT NULL VARCHAR2(2048) SQL select user_name,client_ip,node_name,time_stamp from user_activity_log where user_name = 'admin' order by time_stamp; USER_NAME CLIENT_IP NODE_NAME TIME_STAMP --- -- admin NA Insight Server 1.0397E+12 admin NA Insight Server 1.0402E+12 admin NA Insight Server 1.0433E+12
How to improve queries remotely
What is a guideline to improve remotely query using database link? Regards, David
RE: Date format is unreadable
Yes, it is a Unix timestamp. I use your syntax and I got following error.
1 select
user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/')+tig
2 where user_name = 'admin'
3* order by time_stamp
SQL /
select user_name,client_ip,node_name,to_date('01/01/1970','MM/DD/') +
time_stamp from user_activity_log
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +, and not be 0
-Original Message-
Sent: Wednesday, March 05, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L
David,
I presume that your date is a Unix timestamp.
Try to see whether
to_date('01/01/1970', 'MM/DD/') + TIME_STAMP
yields something more meaningful to you ...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
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: Nguyen, David M
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: Snapshot refreshes are failing
: [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: Nguyen, David M 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: What to check?
Title: RE: What to check? All three machines having the same amount of CPUs and memory, and he uses the same script to run on three machines, some of tables containing hundred thousands of records. Below is a portion of his script. Is there a way to improve his SQL command? @Dumptables.sql spool lata.csv select * from lata; spool off spool subscriber.csv select * from subscriber; spool off spool non_subscriber.csv select * from non_subscriber; spool off spool numbering_plan.csv select * from numbering_plan; spool off; spool service_area.csv select * from service_area; spool off spool carrier.csv select * from carrier; spool off spool escaped_number.csv select * from escaped_number; spool off exit; Regards, David -Original Message- From: Mark Richard [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 02, 2003 8:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: What to check? David, Have you checked the most obvious... The number of rows in the table? Also, you say three different Solaris8 machines... How different are they? Are the disk subsystems the same on all three? How identical are their configurations? How similar are the init.ora files on all three machines (perhaps sort_area_size or something similar depending on the query to dump the table)? Unfortunately there's a lot of possibilities about what might cause the slow down. The other suggestions of wait events and execution plans are valid ideas. Hopefully one of these will give a hint about where to look for the cause. Regards, Mark. Nguyen, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguye cc: [EMAIL PROTECTED] Subject: What to check? Sent by: [EMAIL PROTECTED] om 01/03/2003 08:09 Please respond to ORACLE-L Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while other two's only take one hour. He asks me to investigate why. I log into the machine in question to check I/O statistic, memory, CPU usage and found no problem. What else should I check here? Regards, David Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What to check?
Title: What to check? Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while other two's only take one hour. He asks me to investigate why. I log into the machine in question to check I/O statistic, memory, CPU usage and found no problem. What else should I check here? Regards, David
RE: Oracle Performance Tuning Exam
Title: RE: Oracle Performance Tuning Exam There are totally five exams we have to pass to get certified, I'd like to know which exam should I take first and what next in order? Thanks, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Performance Tuning Exam BTW, That is why I didn't spend more than a few hours preparing for that exam. I already sensed that it would be a waste of time in the long-run. -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003 11:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Performance Tuning Exam Good posting. Thank you. This week Morten Egan from Miracle A/S (who's on this list as well, I think) is teaching the Tuning Class for Oracle Denmark, and he's had a few comments as well about the materials. Morten, would you care to comment (in your usually nice and easy manner?) If was, after all, you who came with the unlearn quote below. Best regards, Mogens DENNIS WILLIAMS wrote: Mogens - I posted this note back in October. -Original Message- Sent: Saturday, October 05, 2002 4:08 PM To: '[EMAIL PROTECTED]' List I spent last week at an official Oracle Education Oracle9i Performance Tuning Class, and here is some of the non-technical stuff I learned. - Oracle is teaching the wait interface more and more. In fact, they are updating the curriculum next month to emphasize the wait interface even more (lucky me). - Just how the wait interface is emphasized may depend quite a bit on the instructor, despite what the materials say. My observation is that our opinions are based on what we have experienced and our interpretations of those experiences. So we will probably still have some instructors that will still feel that the wait interface is a passing fad and if you really want to straighten out a database, you need to get in there and improve the BHR (Buffer Hit Ratio). - My instructor was John Hibbard. He is excellent, and I would highly recommend him. He went well beyond the class materials to providing papers he has researched and presented himself, as well as other sources, including papers from Cary Milsap and Jonathan Gennick who participate on this list. When you get through his class, you really feel you have been taken to a whole new level of Oracle knowledge. He is also heavily involved in selecting and preparing the official Oracle training materials for the courses he teaches. Besides Performance Tuning, he teaches several other Oracle classes. Most of the people in my class happened to be more experienced with Oracle, and John did a good job of answering advanced questions with some depth, but not leaving the newbies in the dust. - A funny observation on buffer hit ratio vs. wait interface. The last day of class is an opportunity to take a really screwed-up database and apply a little of what you have learned. The first scenario is titled Buffer Cache. So you run the workload assignment and STATSPACK and look at the BHR and say wow, that is bad, increase the buffer pool, and rerun the workload and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly bump the buffer pool even more and go again. Then you look down at the top 5 waits section just below on the first page of the STATSPACK report and see that the big wait item is Scattered Read. Then you go dope slap and realize this schema is missing some critical indexes and table scanning it's little heart out. I just found it ironic that some people have reported that some of the Oracle instructors emphasize the BHR too much when the first Workshop Scenario has a great example of why focusing on BHR can't solve many problems. But again, we have experience vs. interpretation of experience. A real died-in-the wool BHR fanatic would probably claim that BHR had solved the problem because the first indication that something was wrong was spotting the bad BHR, which led to other investigations. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 10:24 PM To: Multiple recipients of list ORACLE-L Yeah, if you've taken the performance exam, you must now unlearn what you have learnt, to quote from Starwars. I've considered creating a one- or two-day class that would put people into the right track of thinking after having studied and passed that exam. The other exams are more or less fine. The tuning one really - ahm - could be improved... Mogens [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Guys, I took this exam after 12 hours studying and missed 4 questions. I studied using the self-test software (few practice exams) some memorization and the student guides from the
RE: Embeded password in script
Title: RE: Embeded password in script
Thank you, Jared. I have the book you wrote and will look into it.
Regards,
David
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 4:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Embeded password in script
The 'hide.c' program can be implemented and compiled to prevent
parameters from appearing to ps. I believe it still works properly on
most flavors of unix.
For the Perl for Oracle DBA's book we wrote one utililty that I had
wanted for some time, a password database.
For jobs that I plan to run regularly from cron, I use the password
daemon pwd.pl and retrieve the passwords across the network
( encrypted with MD5 ).
If the job is a Perl script ( fairly likely around here ) the password
can't appear to PS, as no password is ever used on the command
line.
It's handy for command line stuff as well, as I only need rights to
access the password database via the password daemon. I don't
have to know the database passwords to login to the account.
e.g. sqlplus system/$(pwc.pl -instance dv01 -username jkstill)@dv01
This is the single most useful utility we put in that book IMO.
Jared
On Monday 24 February 2003 14:02, STEVE OLLIG wrote:
i'll take the first one...
on UNIX you could use a secret hidden file with appropriate permissions
where each line has the format ORACLE_SID:USER:password
then use awk to parse the file for the line with the correct $ORACLE_SID
and $USER, and set an environment variable to the password string. Then
your scripts could use that variable with sqlplus instead of the hardcoded
password.
in ksh it could look something like this:
export password=\
`awk -F: '$1 == sid $2 == dbimpl {print $3}' mySecretHiddenFile`
be warned that if you call sqlplus like this in your scripts:
sqlplus dbimpl/${password} @SQLscript.sql
someone could still see the Oracle password with a sneaky ps command while
your script is running.
a very similar approach could be taken with perl if awk isn't your cup of
tea.
-Original Message-
Sent: Monday, February 24, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have
a better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from command line we go through following steps to shutdown database,
how do I code these steps in the script?
$svrmgrl
SVRMGRLconnect internal
SVRMGRLshutdown
Thanks in advance,
David
--
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: Sun admininstrator
What's requirements? David -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: Sun admininstrator I normally wouldn't post this kind of thing on this forum - but since the job market stinks ya'all might know someone who's looking. Mycompany has an opening for a experienced Solaris admin. We are installing a F 12k (32processor) and they want somebody with experience on it and haven't found anyone locally yet. Also have a Hitachi SAN (99000 lightning 2 T) so SAN experience is also wanted. Unfortunately (please no flames - it's not me ) we don't have relo or can we accept H1-b's. We are a private prison management companyheadquartered in Nashville, Tn. We are putting severalgood sizedOracle databases on it (there's my Oracle connection). If you know anyone looking send them my email. Thanks [EMAIL PROTECTED]
It takes too long to shutdown database
Title: It takes too long to shutdown database I try to bounce database by shutting it down and starting it back up but it just hang in there for almost 45 minutes trying to shut down. It is running on Solaris8, I can press Ctrl+C to interrupt it or issue a kill command to kill it but I hesitate to do so. Do you have any advices and why it takes too long to shutdown database? It usually only takes me about 3 minutes to bounce database. Thanks, David
Upgrading from 8.1.5 to 8.1.6
After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is created to store new version's files and the old directory of old version 8.1.5 is still there. Is is safe to remove the old directory to save disk spaces on the disk? Is there any files being linked to the old version after upgrading? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
Export generates ORA-04031 error
I received following errors during export. I had increased shared_pool_size in configuration file several times, it just fixed the problem for couple weeks then now I received the same problem. Is there a better way to fix this issue permanently? And what is the maximum limit size can I increase shared_pool_size? Currenlty it is increased from 500 to 900. EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam Buffer) EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_expacle Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
Embeded password in script
I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in my script. Sqlplus dbimpl/password @SQLscript.sql Also, from command line we go through following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown Thanks in advance, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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: Embeded password in script
O/S is solaris8 Oracel V8.0.5 Thanks, David -Original Message- Sent: Monday, February 24, 2003 3:25 PM To: [EMAIL PROTECTED] Since you didn't include the OS you have, I won't guess what the answer should be. Please consider that the answer is dependent upon which OS in underneath Oracle. Nguyen, David M [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Embeded password in script [EMAIL PROTECTED] 02/24/2003 12:54 PM Please respond to ORACLE-L I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in my script. Sqlplus dbimpl/password @SQLscript.sql Also, from command line we go through following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown Thanks in advance, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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: Nguyen, David M 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: Upgrading from 8.1.5 to 8.1.6
Title: RE: Upgrading from 8.1.5 to 8.1.6 I think that's a good idea. Thanks, David -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Upgrading from 8.1.5 to 8.1.6 What we do is rename the 8.1.5 directory to indicate it is the old directory (i.e, 8.1.5_old). If nothing breaks after a week or two, then the directory and its contents are removed. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Monday, February 24, 2003 9:34 AM To: Multiple recipients of list ORACLE-L After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is created to store new version's files and the old directory of old version 8.1.5 is still there. Is is safe to remove the old directory to save disk spaces on the disk? Is there any files being linked to the old version after upgrading? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
Updating error
I attempt to update a record and receive following error. How do I fix it? update trunkgroup set originating_carrier = 0110,trunkgroup_id2 = 606,' where trunkgroup_id = '0TWPAAEDS0' and gateway_id = 'GAAA0'; ERROR at line 1: ORA-02291: integrity constraint (DBIMPL.CARRIER_FK9) violated - parent key not found Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
Which rollback segment is currently active?
Title: Which rollback segment is currently active? I have three rollback segments which all show ONLINE. I want to drop one of them but I need to know which one should I drop. How do I find out which one is good to drop? SVRMGR select segment_name,owner,tablespace_name,status from dba_rollback_segs; SEGMENT_NAME OWNER TABLESPACE_NAME STATUS -- -- -- --- RBS01 PUBLIC RBS ONLINE RBS02 PUBLIC RBS ONLINE RBS04 PUBLIC RBS ONLINE Thanks, David
RE: Replication question
Title: RE: Replication question We don't update data on slaves, we update data from master then slave pull data from the master every 5 minutes. David -Original Message- From: BigP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 7:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Replication question it depends on how you are updating slave databases . -bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 3:39 PM We have four machines setup as slave databases which get updated data from one Master database every 5 minutes. The question is how do I know all slave machines get updated data completely from the master database, another word is how do I know there is no missing data when slave machines replicate from the master database? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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: BigP 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).
Replication question
We have four machines setup as slave databases which get updated data from one Master database every 5 minutes. The question is how do I know all slave machines get updated data completely from the master database, another word is how do I know there is no missing data when slave machines replicate from the master database? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
Comparing between two tables
Is it a way to compare two tables to see the differences? We have problem with our database, someone input new data into database that causes problem, we want to find and remove those entries from that table. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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).
ORA-04031
I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural objects and actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam Buffer) EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp . exporting statistics Export terminated successfully with warnings. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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: Increase size of data files and rollback segments
Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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.com -- Author: Nguyen, David M 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: Increase size of data files and rollback segments
Alright guys, just because you know Jeremiah better than me so you can take his joke. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. If you were in my situation, you would understand. -Original Message- Sent: Tuesday, December 10, 2002 1:26 PM To: Multiple recipients of list ORACLE-L Thanks, I had to drop off the Lazy DBA list because of all the sniping. I would hate to have to drop off Jared's list too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:20 PM 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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.com -- Author: Nguyen, David M 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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
Increase size of data files and rollback segments
How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks,David
Changing column format
I create a table to store user account information and set userid column to be primary key. I now want to set username to be primary key instead of userid, how do I change it? There are couple hundreds of records in table. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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).
Monitor replication via OEM
Title: RE: Experience with Quest Shareplex I install oracle enterprise manager on windows NT, create an event to monitor replication then stop replication on slave database, check alarm from OEM but I don't see any alarms. Does anyone use OEM to monitor replication? If so, please advise how to set it up. Thanks,David
RE: How to fix ORA-03113 error
I have oracle8.0.5 running on Solaris8. Here's trace file. I don't think there is problem with I/O. How do I recover this error? $more ssdb_lgwr_272.trc Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_lgwr_272.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: plab1 Release:5.8 Version:Generic_108528-03 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 4 Unix process pid: 272, image: ora_lgwr_SSDB *** SESSION ID:(3.1) 2002.10.13.02.19.02.000 error 204 detected in background process -Original Message- Sent: Monday, October 14, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Your instance crashed because the lgwr died... There should be a trace file for lgwr in the bdump directory... What does it say in the trace file? Are you having any filesystem issues? The LGWR: terminating instance due to error 204 means that there is an I/O error when accessing the controlfile... What version is your database... What O/S are you on... etc... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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.com -- Author: Johnston, Tim 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.com -- Author: Nguyen, David M 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).
How to fix ORA-03113 error
I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: stupid RMAN question
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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).
Password is not case sensity and uncrypted
Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Tool to load data
How do I get it for a trial? David -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tool to load data TOAD has a GUI SQL Loader interface. It lets you use a wizard to create the CTL file, then you can later just re-load that file and execute the load. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: Tool to load data Hi all, I'd like to know if there is some tool we can use to automate loading data into database using SQLLDR either via GUI or scripts. I need to allow someone to loginthe system to bulk load data without worrying he destroys database. Any advices will be appreciated. Regards,David
table_changes
I heard people said we can check table_changes to make sure data is actually loaded into table using sqlldr. If this is true, how do I verify data is loaded by looking table_changes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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).
Data file size growing causing high disk space.
I have data files save under /export/home/oradata directory and this directory shows 100% full disk space because of the growth of these files. What should I do? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: Data file size growing causing high disk space.
Yes, I have autoextend turned on for some of them. If I move them to a different directory, how does oracle database recognize its new directory? Is it something I need to setup in init.ora file? Thanks, David -Original Message- Sent: Monday, September 23, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Sent: Monday, September 23, 2002 11:05 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' David - Do you have autoextend turned on for any of your datafiles? It is pretty simple to relocate some of your datafiles to another disk drive if that is your question. That datafile will be unavailable to your users for a few moments while you move them. You definitely want to take care of this issue immediately. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 11:24 AM To: Multiple recipients of list ORACLE-L I have data files save under /export/home/oradata directory and this directory shows 100% full disk space because of the growth of these files. What should I do? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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.com -- 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.com -- Author: Nguyen, David M 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).
How to load text file into database table
I have a text file and need to load it into database table using sqlldr utility. Is there a way to load a text file? I know how to load csv file but not text file. *** Below is text file format. Date: Wed Aug 29 10:43:53 CDT 2001 Name: Paris By Night Email: [EMAIL PROTECTED] Phone: 202-333- Location: Washington, DC Equipment needing to access: EMS, , , , , Reason: Not working I want to above data into useraccount table which has following columns. date username email phone location equipment reason Thanks in advance, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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).
Copy one user's table to another user's table
How do I copy all data in one user's table to another user's table? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to speed up import
I do backup database nightly using export utility. When I restore database using import, it takes more than 6 hours to finish. Is there a way to speed up import process? Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Disadvantages/advantages of user_ind_columns
I found a column_name "NPA_XXX"created in many many places in user_ind_columns. Does this have any disadvantages or advantages to oracle database such as slowing down SQL query or update table? Thanks,David
RE: It took more than an hour to update 10,000 records
I am not testing your guys' skills I am honestly asking for help as I don't have much experience about database. I have a lots on my plate at work to take care of that's why I don't have much time to check email or to response. Here are some stupid questions I need to ask...how do I turn trace on? Regarding bulkload, I have no problem with bulkloading NEW records, it runs fast for me but in this case I just want to UPDATE 10,000 records, can I use bulkload to update records? Regards, David -Original Message- Sent: Wednesday, August 14, 2002 10:59 AM To: Multiple recipients of list ORACLE-L I think the original poster was testing our skills since he posted his problem and disappeared. Also he asked for some init.ora parameter to make it faster:) Regards, Waleed -Original Message- To: [EMAIL PROTECTED]; Khedr, Waleed Sent: 8/14/02 10:42 AM It wasn't 20 seconds it was 15 seconds. The same lessons apply. Without knowing what else is going on in the database, it's not possible to say why it's taking an hour to insert 10k rows. Using bind variables will drastically reduce the resources consumed by the insert job. Using SQL*loader with a generous bindsize argument would be even better. Running the queries on the wait interface is a start to learning what the problem is. But then, I'm sure you're already aware of all this, and I'm no doubt preaching to the choir. Jared On Tuesday 13 August 2002 18:43, Khedr, Waleed wrote: His problem is not reducing 60 sec to 20 seconds but why an hour or more was taken to update 10,000 rows. It's obvious there are other things (which I indicated in my email) that need to be sorted out to reduce the hour to few minutes. Regards, Waleed -Original Message- Sent: Tuesday, August 13, 2002 9:08 PM To: Multiple recipients of list ORACLE-L David, You don't yet know why it's slow. Why not turn tracing on for the session doing the inserts and then run tkprof on the trace file? Since the inserts seem to be taking so long, you should also be able to join v$session_wait with v$session to catch the waits in action and determine exactly what they are. You should also join v$session and v$session_event while the insert job is running. Actually, using bind variables will probably help. The insert statements will be less resource intensive and run much faster, and this will result in less contention for other sessions. My tests of insert statements with and without bind variables show that using bind variables resulted in an insert job of 27k rows running in 15 seconds and 1/100 sec of parse time. Not using bind variables required 60 seconds, 20 of which were CPU parse time. The increased run time also resulted in 3x as many buffer busy waits for other sessions trying to hit the same table. HTH Jared Nguyen, David M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/13/2002 01:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: It took more than an hour to update 10,000 records Is there a parameter that I can tune in init.ora file to improve this process? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Bind variables will not buy you anything. The time taken is mainly dependent on the execution plan and the cardinality of the indexes being used. Also any overhead like updating a column that's part of an index, triggers, referential constraints, etc. Waleed -Original Message- Sent: Tuesday, August 13, 2002 2:35 PM To: Multiple recipients of list ORACLE-L I run it on the server. How do I use bind variables? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 1:13 PM To: Multiple recipients of list ORACLE-L From the look of your sql statements it seems that each statement will be hard parsed because the values are different. If you will use bind variables you can save a lot of time. Is the script runs on the server or from another computer? If you run the script from another computer you also have the network time added. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 6:24 PM Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is the time too long to update 10,000 records? Is it a way to improve the update task to run faster. Please advise. *** A portion of my update script is shown below: update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = 201 and lata_id = 224; update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = 201 and lata_id
It took more than an hour to update 10,000 records
Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is the time too long to update 10,000 records? Is it a way to improve the update task to run faster. Please advise. *** A portion of my update script is shown below: update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = 201 and lata_id = 224; update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = 201 and lata_id = 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: It took more than an hour to update 10,000 records
I run it on the server. How do I use bind variables? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 1:13 PM To: Multiple recipients of list ORACLE-L From the look of your sql statements it seems that each statement will be hard parsed because the values are different. If you will use bind variables you can save a lot of time. Is the script runs on the server or from another computer? If you run the script from another computer you also have the network time added. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 6:24 PM Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is the time too long to update 10,000 records? Is it a way to improve the update task to run faster. Please advise. *** A portion of my update script is shown below: update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = 201 and lata_id = 224; update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = 201 and lata_id = 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: It took more than an hour to update 10,000 records
Is there a parameter that I can tune in init.ora file to improve this process? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Bind variables will not buy you anything. The time taken is mainly dependent on the execution plan and the cardinality of the indexes being used. Also any overhead like updating a column that's part of an index, triggers, referential constraints, etc. Waleed -Original Message- Sent: Tuesday, August 13, 2002 2:35 PM To: Multiple recipients of list ORACLE-L I run it on the server. How do I use bind variables? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 1:13 PM To: Multiple recipients of list ORACLE-L From the look of your sql statements it seems that each statement will be hard parsed because the values are different. If you will use bind variables you can save a lot of time. Is the script runs on the server or from another computer? If you run the script from another computer you also have the network time added. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 6:24 PM Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is the time too long to update 10,000 records? Is it a way to improve the update task to run faster. Please advise. *** A portion of my update script is shown below: update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = 201 and lata_id = 224; update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = 201 and lata_id = 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
Times_tamp column unreadable format
I try to read date/time from times_tamp column in my oracle database but I could not read it using SQL query. Is it a way to resolve it? SQL select time_stamp from user_activity_log; TIME_STAMP -- 1.0220E+12 1.0220E+12 1.0220E+12 1.0220E+12 1.0220E+12 1.0220E+12 1.0220E+12 1.0220E+12 Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Display all privilleges belong to user
How do I display all privilleges belong to an user? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to?
Using LogMiner to read redo log, how do I tell a transaction is modified by which user and where user logins from like what columns in LogMiner should tell me this kind of information? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to?
Ramon,
I know how to setup LogMiner to run. My question is if LogMiner can tell me
where an user is logging in from what computer?
Thanks,
David
-Original Message-
Sent: Thursday, July 11, 2002 4:15 PM
To: Multiple recipients of list ORACLE-L
Nguyen,
1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio'
2) Create the dictonary file
Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio');
3) Reset the list and create a new one
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.new);
4) Add more redos to analyze
Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
dbms_logmnr.addfile);
5) Perform the analysis
Execute
DBMS_LOGMNR.START_LOGMNR(dictionary='d:\directorio\dictionary');
6) Do a select from the V$LOGMNR_CONTENTS
HTH
Ramon
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 12:48 PM
Using LogMiner to read redo log, how do I tell a transaction is modified
by
which user and where user logins from like what columns in LogMiner should
tell me this kind of information?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ramon E. Estevez
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Increase size of REDO log
How do I increase size of redo logs and how do I create additional redo logs? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of REDO log
How about if I use LogMiner to read redo log to check which transaction had been modified in 5 days ago, how do I know which redo log to look at? Thanks, David -Original Message- Sent: Monday, July 08, 2002 1:04 PM To: Multiple recipients of list ORACLE-L First, Check for the one that is not the current one. Select * from V$log; ALTER DATABASE DROP LOGFILE '/u01/oradata/orcl/redo01.log'; delete the file manually ALTER DATABASE ADD LOGFILE '/u01/oradata/orcl/redo01.log' size 30M; Change your size to your desire one. For the other ones do the same. To change the active one. ALTER SYSTEM SWITCH LOGFILE; hth Ramon - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:33 AM How do I increase size of redo logs and how do I create additional redo logs? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LogMiner errors
I got the errors fixed. The reason the errors were generated because it
could not find time interval between July 1 and July 2. I was able read
redo log with LogMiner but now I come with another question why report
display output in HEX data and why it only shows username is SYS only? I
want to look at some transactions which were made by DBIMPL user that is
not there.
==
**Redo log report:
USERNAME LOG_ID TIMESTAMPSQL_REDO
-- -- -
CAAACtAAAT';
SYS 24036 02-JUL-02insert into UNKNOWN.Objn:
12(Col[1],Col[2],Col[3])
values (HEXTORAW('c108'),
HEXTORAW('c23b20'),HEXTOR
AW('c106'));
SYS 24036 02-JUL-02delete from UNKNOWN.Objn:
13 where Col[1] = HEXTORA
W('c20c42') and Col[2] =
===
In addition, my database is running in NOARCHIVE mode does it mean I can not
go back to check what happened yesterday or couple days ago?
Is there a really good book about LogMiner that I can purchase or a website?
Thanks,
David
-Original Message-
Sent: Wednesday, July 03, 2002 6:13 AM
To: Multiple recipients of list ORACLE-L
I believe also that you can't actually run LogMiner against an 8.0
database but have to generate the dictionary file (which you can do)
and then run the mining procedure with the dictionary file against an
8.1.x database
--- [EMAIL PROTECTED] wrote:
David,
I recall that there is a limit (42 characters?) on the name of the
dictionary file.
2 ways round it. Create the file in the top level ie /export/dict.ora
or
create a symbolic link with a shorter name.
I have a page on my web site which mentions this problem
(www.hcresources.co.uk).
Unfortunately I do not (yet) have internet access at my new site and
cannot
recall what exactly is on the page (I do recall it is not yet
finished)
HTH
John
-Original Message-
Sent: 02 July 2002 19:19
To: Multiple recipients of list ORACLE-L
I tried to run LogMiner to view transactions on Oracle8.0 using
LogMiner and
received following errors. Can someone please help me to fix errors.
This
is HIGH priority that I am working to try to find out who messed up
our
database per my Manager.
SQL begin
2 sys.dbms_logmnr.start_logmnr(
3 DictFileName = '/export/home/oracle/LogMiner/dictionary.ora',
4 StartTime = to_date('01-Jul-2002 08:00:00AM','DD-MON-
HH:MI:SSAM'),
5 EndTime = to_date('02-Jul-2002 12:00:00AM','DD-MON-
HH:MI:SSAM'));
6 end;
7 /
begin
*
ERROR at line 1:
ORA-01280: Fatal LogMiner Error.
ORA-06512: at SYS.DBMS_LOGMNR, line 42
ORA-06512: at line 2
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE
Redo log
I found couple redo logs in my Oracle8.0.5 database, as shown they are switched every 5 minutes. I'd like to have only two or three logs out there and don't want them to be switched until every 4 hours. Is there a way to control it that way? Secondly, if redo log switchs every 5 minutes, does LogMiner have capability to view transaction history from two days ago? Please advise. $ ls -l redo* -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo01.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo02.log -rw-r- 1 oracle dba 512512 Jul 2 11:15 redo03.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo03_1.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo03_2.log -rw-r- 1 oracle dba 512512 Jul 2 11:15 redo04.log Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LogMiner errors
I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and
received following errors. Can someone please help me to fix errors. This
is HIGH priority that I am working to try to find out who messed up our
database per my Manager.
SQL begin
2 sys.dbms_logmnr.start_logmnr(
3 DictFileName = '/export/home/oracle/LogMiner/dictionary.ora',
4 StartTime = to_date('01-Jul-2002 08:00:00AM','DD-MON-
HH:MI:SSAM'),
5 EndTime = to_date('02-Jul-2002 12:00:00AM','DD-MON- HH:MI:SSAM'));
6 end;
7 /
begin
*
ERROR at line 1:
ORA-01280: Fatal LogMiner Error.
ORA-06512: at SYS.DBMS_LOGMNR, line 42
ORA-06512: at line 2
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
How to read REDO log
Title: RE: ORA-27101 Error Can I setup LogMiner to read REDO log of Oracle8.0.5? Someone tells me LogMiner only works for Oracle8.1 or above, is it correct?Is there another tool to read REDO log besides LogMiner? Thanks,David
How to make SQLLDR to run faster?
I try to insert 14,000 rows into oracle database using SQLLDR and it takes too long to finish (around an hour). Is there a way to improve SQLLDR to make it run faster? For example, if modify parameter file will help? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL question
How do I list all user accounts created in a database? And how do I list all user table indexes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Errors with web forms using DBI
I am creating web forms for user to query, insert, update data using DBI to access oracle database. The question is why all blank lines don't shown as they insert into the form, and whenever single quote ' or double-quote is used, web server generates errors and not accepted their submittion. Is there a way to fix these problems? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication errors
I have problem with our database replication between Master and Slaves. Looked at alert.log, I found following errors. Can someone please explain to me what following errors mean and how do I fix them? ORA-01001: invalid cursor ORA-06512: at SYS.DBMS_SNAPSHOT, line 386 ORA-06512: at SYS.DBMS_IREFRESH, line 450 ORA-06512: at SYS.DBMS_REFRESH, line 182 Thanks, David Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris 2.8
I have Oracle8 running on solaris8 for more than a year and don't see any problem. David -Original Message- Sent: Friday, April 12, 2002 10:26 AM To: Multiple recipients of list ORACLE-L Hi friends and gurus, Anybody has had (or has heard from friends of) any bad experience with Oracle 8 running on Solaris 8. I know that the first supported version on Solaris 8 is 8.0.5. If you know of some I would appreciate f you could share it, and specify which version and patch release. Thanks a lot. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Currently log-in users
How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM Error On Unix
Try oemctrl start oms -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Currently log-in users
Thanks for the script. It is useful for me. David -Original Message- Sent: Thursday, April 11, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_USER FORMAT A8 COL PROGRAM FORMAT A25 COL PROCESS_NR FORMAT A8 col uur format A5 select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME, to_char(round(c.seconds_in_wait/3600,0))||'.'|| to_char(round(mod(c.seconds_in_wait,3600)/60,0)) HOUR, a.osuser OS_USER, a.username ORACLE_USER, b.program PROGRAM, b.spid PROCESS_NR, a.sid SID, a.serial# SERIAL# from v$session a, v$process b, v$session_wait c where a.paddr=b.addr and a.sid=c.sid / 2- set linesize 120 select SADDR, SID, SERIAL#, PADDR, substr(USERNAME,1,8) USER, STATUS STATUS_, SCHEMA#, OSUSER, PROCESS, LOGON_TIME, LAST_CALL_ET from v$session order by osuser / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 11 Apr 2002 07:53:26 -0800 How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM Error On Unix
Try to do $which oemctrl or $find / -name *oem* -print Someone on the distro might add in comments David -Original Message- Sent: Thursday, April 11, 2002 1:04 PM To: Multiple recipients of list ORACLE-L I could not see this on HP-UNIX client ( $OH/bin ) where I have installed all the Oracle Client ( Administration ), Would you let me know the location , where I can find this on UNIX --Madhu -Original Message- Sent: Thursday, April 11, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Try oemctrl start oms -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export taking to long
Does it happen everytime you do export or just once awhile? David -Original Message- Sent: Tuesday, April 09, 2002 9:28 AM To: Multiple recipients of list ORACLE-L I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE=/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z LOGFILE=/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log # # Begin compress job and export to pipe with userid and password hidden # compress /oracle_dba/expimp/adprod/exp_pipe_adprod $OUTFILE exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to tune SQL and CPU usage
Someone uses SQL to query data, he complains it takes too long to get results back from oracle database. He also notices there are many oracle processes running on system that uses much CPU and causing system slow down. Is there a way to tune SQL to improve query and to set maximum number of running oracle processes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ticket tracking system
I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ticket tracking system
Thank you all very much for different advices. I will give it a try. Regards, David -Original Message- Sent: Tuesday, April 02, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Don't delete the row(s) you'll need later. Perhaps add a column called ticket_status char(1), that gets a default value of 'O' (open). When you close the ticket change the value to 'C' (closed). To reopen change it back to 'O'. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 11:38 AM I develope a ticket database for people to open, close, re-open ticket to update using oracle database. My question is how do I use SQL command to let people re-open a close ticket for updates? When someone close a ticket, delete command is executed and data is gone. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to calculate time using SQL
Jack, How about substracting a system date with a database replication date to get difference of time? Can you please give me a specific command? SQL select to_char(sysdate, 'Dy Mon Dd HH24:MI:SS ') from dual; TO_CHAR(SYSDATE,'DYMONDD Mon Apr 01 11:08:00 2002== System Time. SQL select next_date from user_refresh; NEXT_DATE Mon Apr 01 11:11:01 2002 == Replication time. Thanks, David -Original Message- Sent: Monday, April 01, 2002 10:38 AM To: Multiple recipients of list ORACLE-L David, Select (DateTime1 - DateTime2) * 24 * 60 * 60 From Dual ; Oracle date arithmetic results are in fractional days, so the above gets you the number of seconds between two Date datatype arguments. Of course you can go ahead and multiply 24*60*60 to get Seconds/Day, but I prefer to leave it that way so it's more obvious what my intent is. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- David M Sent: Monday, April 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Is it possible to calculate seconds using SQL? For example, I'd like to subtract these two time to get difference in seconds: 10:20:32 - 10:25:29 Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to calculate time using SQL
It works. Thank you so much, Jack. David -Original Message- Sent: Monday, April 01, 2002 10:38 AM To: Multiple recipients of list ORACLE-L David, Select (DateTime1 - DateTime2) * 24 * 60 * 60 From Dual ; Oracle date arithmetic results are in fractional days, so the above gets you the number of seconds between two Date datatype arguments. Of course you can go ahead and multiply 24*60*60 to get Seconds/Day, but I prefer to leave it that way so it's more obvious what my intent is. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- David M Sent: Monday, April 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Is it possible to calculate seconds using SQL? For example, I'd like to subtract these two time to get difference in seconds: 10:20:32 - 10:25:29 Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to calculate time using SQL
Thanks for your advices, Stephane. David -Original Message- Sent: Monday, April 01, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Nguyen, David M wrote: Jack, How about substracting a system date with a database replication date to get difference of time? Can you please give me a specific command? SQL select to_char(sysdate, 'Dy Mon Dd HH24:MI:SS ') from dual; TO_CHAR(SYSDATE,'DYMONDD Mon Apr 01 11:08:00 2002== System Time. SQL select next_date from user_refresh; NEXT_DATE Mon Apr 01 11:11:01 2002 == Replication time. Thanks, David David, If what you are after is measuring the lag between two replicated databases, you may have to do something slightly more complicated. For one thing, do not forget that system time is, most often that note, time read by the system-engineer on his wrist-watch the last time he set the date. If your machines do not take the time from a common source, you may get a pessimistic or optimistic view, depending on the machine you are looking at. I think that it's better to look how long it takes to replicate from A to B and back - it will allow you to compare a A timestamp to another A timestamp. Dividing by 2 will give you a fair if not absolutely correct assessment of how long it takes to go from A to B or B to A. Also, a good way to check how replication goes is to create a dummy table with three columns, A_TIME_START, B_TIME and A_TIME_FINISH, to store (on A) SYSDATE into A_TIME_START, to let replicate and have triggers inserting SYSDATE into the ad hoc column everytime it reaches a node. HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Displaying time zone
How do I display time zone in date format using SQL? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Free scripts
I try to find some scripts (PL/SQL package) to monitor my oracle database such as tablespace, rollback segment, etc. Does someone know a website that has this? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re-open a ticket that is closed using SQL
I am desinging a web base for user to open/update/close tickets using oracle8i. My question is how do I setup to let user re-open a close ticket for updating. I use SQL command delete to close ticket so the ticket could not be re-open for updating. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LIKE and % operator
I am running oracle8i on solaris8. I have a word ( General ) in my column named subject, I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to restart SNMP daemon process
How do I restart a daemon process on UNIX if it dies? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to import PDF files into Oracle database
Is is possible to store PDF files in oracle database to allow user accesses the files, open it and read it? If so, please advise how. I am using oracle8i with DBI running on Solaris8. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to change timezone on unix
How do I change timezone on unix? Thanks, David
Script stops running.
Hi all,
I get a perl script to telnet to several machines on network to check
something I want to check. When it trys to connect a machine which is down,
the script will stop running. How do I tell it to continue to check the
next machine and ignore the one down?. Below is my script.
Thanks,
David
==
#!/usr/local/bin/perl -w
use Net::Telnet;
%city = qw(host1 passwd
host2 passwd
host3 passwd
host4 passwd );
$telnet = Net::Telnet-new
(
Timeout = 10,
Input_log = 'PSXreplication.log',
Prompt = ('/[%:] $/'),
);
foreach $key (sort keys %city) {
$telnet-prompt(/$key%/i);
$telnet-open($key);
$telnet-login('ssuser', $city{$key});
$telnet-prompt(/$key%/i);
$telnet-cmd('ls -l');
print =\n\n;
$telnet-close($key);
}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Oracle process causes High CPU
We have problem with oracle process ora_snp0 that causes high CPU and core files on our system. Does someone have idea how to fix it? Please help. Below is information captured from a trace file: Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_snp0_16657.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: pbna1 Release:5.6 Version:Generic_105181-26 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 16657, image: ora_snp0_SSDB *** 2002.01.29.03.13.33.000 *** SESSION ID:(7.11) 2002.01.29.03.13.32.000 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 5f4c6000 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78Background_Core_Dump = FULL Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle trace file on/off
Hi all, How do I find out if someone is running trace on oracle database and how do I turn trace off? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
