RE: Router filtering
i am not entirely sure about the ports and how they are used as I have not attempted such things. However some of the active state firewalls, Cisco PIX and Checkpoint fit into these, I believe do active filtering and will open ports at random by looking at the actual traffic. I believe that it is to solve these exact issues. It looks at whether it is a reply to a request from previous traffic as I understand it. The problem with these products is that they aren't cheap. HTH Peter At 07:50 PM 1/06/2001 -0800, you wrote: KK - you probably got something on this already, but if you're on NT (making appropriate gagging or adulatory noises) then there is a way to have the listener use the same port to listen and maintain connections. I gather it's deprecated, since a listener bounce snaps the connections. But, f*ck it, it's NT. It's not like you'll be keeping those connections up for seven years straight or anything. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/1/2001 3:55 PM i went through this same issue recently. Unfortunatley my only option was to open up all ports to the specific db server to specific IP's. I don't like doing it, but I had to. If you look on Metaslop there is some information on this problem. There are fixes for some routers, check and see if yours is one of them. -Original Message- Turner Sent: Friday, June 01, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Anyone have any recommendations on getting sqlplus connections to a database running MTS which has a router in between that is filtering except on port 1521? I can open up additional ports but opening a whole slew of them for MTS's random port allocation has put the network guys in shock. We have set SERVER=DEDICATED in tnsnames to get connections thru for now and I'm looking at CMAN for a permanent fix, but does anyone else think they have a better way? Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner 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: Kevin Kostyszyn 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: Mohan, Ross 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: Peter McLarty 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: Public Synonyms Performance
Synonyms have a sustantal impact on performance. Public synonyms are by far greater impact on performance than private ones. The use of synonyms can prove to have a considerable negative impact on cpu time used during parse phase of queries. It can also prove to negatively impact aging of sql statements in the libary cache. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/1/01 8:35 PM HI all, I think someone ask this question before, but I don't have any mails about this. What are the performance implications in the use of PUBLIC synonyms ? (What about private synonyms?) How does Oracle resolve internally a public synonym use? TIA ___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= 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: Christopher Spence 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: what is wrong with this procedure
temp_name should be %rowtype variable;
-Original Message-
Sent: Saturday, June 02, 2001 2:18 AM
To: Multiple recipients of list ORACLE-L
create or replace procedure remove_bucket
as
cursor c1 is
select table_name from (
select table_name from user_constraints
where r_constraint_name ='PK_T_ACC_USAGE_1');
temp_name varchar2(255);
temp_count number(10);
str varchar2(2000);
begin
open c1;
loop
fetch c1 into temp_name;
exit when c1%notfound;
select count(*) into temp_count from temp_name;
dbms_output.put_line(temp_count);
end loop;
close c1;
EXCEPTION
WHEN OTHERS
THEN DBMS_OUTPUT.PUT_LINE('INVALID SYNTAX');
end;
/
I am geeting following error:
15/1 PL/SQL: SQL Statement ignored
15/38PLS-00201: identifier 'TEMP_NAME' must be declared
what is the possible solution...
Thanks
Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shahid Malik(IT)
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: Tkprof/explain plan errors
Note that tkprof's execution plan shows execution plan against current database connection to which tkprof is connected. So, execution plan in trace file and execution plan in tkprof output may be different. And, I guess, tkprof shows first execution plan. If your statement parsed more than once, Execution plans may be different. have you run itrprof at http://www.unal-bilisim.com/products/itrprof/itrprof.html . It reports execution plans in trace files(so, correct execution plans) and you can see all execution plan(s). regards... [EMAIL PROTECTED] wrote: I am trying to do some performance tuning on a users query by using tkprof. After running tkprof on the trace file (which was generated after using alter sessions set sql_trace true), I look at the results and they say error connecting to database using: / ORA-01017: invalid username/password; logon denied EXPLAIN PLAN option disabled. However, the correct username/password is being used. Not sure what is going on with Explain plan. Any suggestions - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: dbms_job query?
we had these situations for this we had to break the job first and then kill the snp process after some time u will see the sid out of v$session. Even if you kill the snp it will be kicked back later on from pid or spid i think i am not sure but it works Try this out it should work Well there must be some better answers from the experts out here check it out From: Seema Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: dbms_job query? Date: Fri, 01 Jun 2001 14:11:10 -0800 Hi If status=KILLED in v$session and the process is SNP oracle background process corresponding to that sid and dba_jobs_running has the same sid,no entry corresponding in dba_jobs then how to kill that process. Thx -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C 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: interpreting ses_actions in dba_audit_object
This script was accurate for 8.0.6, haven't tried it in 8i.
column obj_name format a30
select obj_name, to_char(timestamp,'MM-DD- HH:MI:SS'),
decode(ses_actions,
'---S','DELETE',
'--S-','INSERT',
'-S--','SELECT',
'--S-','UPDATE',
'---S--S--S--','DELETE/INSERT/SELECT',
'---S--S--SS-','DELETE/INSERT/SELECT/UPDATE',
'--S--S--','INSERT/SELECT',
'--S--SS-','INSERT/SELECT/UPDATE',
'-SS-','SELECT/UPDATE',
'UNKNOWN')
from dba_audit_object where owner in ('VGN','PCAT60')
order by 2 ;
TAG DBA wrote:
I enabled all auditing on a table. After doing a select, insert and delete I have
one row in dba_audit_object which shows the following for ses_actions column:
---S--S--S--
I know that I have to tie this up with audit options in dba_obj_audit_options to get
a more readable report like :
Object TEST was SELECTED, INSERTED etc etc
I am planning to use decode and some string functions to test for S in the above
string and determine whether a certain action happenned or not.
Does anyone have any better ideas (or better still a read made script ? :-)
Regards,
dbatag
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: TAG DBA
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: Suzy Vordos
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: Bumper Stickers [Re: Bumoer Stickers [RE: Rebuilding indexes]
1. Driver only carries $20 in ammunition. 2. Save the whales! Collect the whole set. 3. If it's not vaporware, it's crap! 4. Please pay MS now to complete rebooting your PC 5. A failure to plan on your part does not constitute as a crisis on my part 6. A conclusion is simply the place where you got tired of thinking. 7. There cannot be a crisis today; my schedule is already full. 8. Why is 'abbreviation' such a long word? 9. 2400 Baud makes you want to get out and push!! 10. We now offer an AOL CD for completing 10 years of service Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 5:43 PM To: Multiple recipients of list ORACLE-L My two favorites - 1. My karma ran over my dogma. 2. Save wildlife - party naked. Srini Chavali Oracle DBA Cummins Inc Jim Hawkins [EMAIL PROTECTED]@fatcity.com on 06/01/2001 03:33:11 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: My bumper sticker: If you make it idiot-proof, they will build a better idiot. (Note: can be paraphrased with the word developer) Jim It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT Don't forget HELP - Kirti -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rebuilding indexes On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote: I don;t quite understand you quoting Once the indexes have all been rebuilt nologging into the original tablespace, all that's left is to refresh the datafiles for that tablespace onto the primary. Is primary a typo error (i.e. standby)? Argh! It was a typo. Of course, after doing many unrecoverable operations, you should refresh the affected datafiles from the primary to the standby. Vadim Gorbounov mentioned the column 'unrecoverable_change#' in v$datafile. This looks like an SCN, not a count of unrecoverable changes. Either way, it seems like a useful way to decide if a datafile shoule be refreshed onto the standby. I can even imagine improving a standby log applier that could be made to refresh such files from the primary automatically. On another topic, I believe I qualify for some sort of award as uber geek. This week I obtained the Washington State license plate ORA DBA for my '74 Volvo. It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
MEA CULPA: Snapshot Logs Explanation Needed
Evidently my original message was bounced back, so I'm
resending.
-- amb
Date: Fri, 1 Jun 2001 11:25:20 -0700 (PDT)
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
In-Reply-To:
[EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Brian,
You are absolutely correct and I was wrong. I went
back and RTFM and for PK-based snapshots
DBMS_SNAPSHOT.BEGIN_TABLE_REORGANIZATION and
END_TABLE_REORGANIZATION exist for just this purpose.
Thanks Brian for setting me straight.
Before I checked the manual, however, I tried some
tests myself (8.1.6 on Win2K) and I may have uncovered
a new bug. I was unable to find an existing bug on
metalink, but I want to do some more tests before I
report it.
If you drop and recreate the snapshot log without
calling the procedure above, the next fast refresh
will not report an error, but it removes the rows from
the snapshot log and they are NOT refreshed to the
snapshot which means the snapshot will be out of sync!
Bad news. Subsequent fast refreshes work properly.
I'm just listing an excerpt from the spool file,
SVRMGR select * from test;
COL1 COL2 COL3
- - -
1 2 3
2 4 6
3 6 9
3 rows selected.
SVRMGR create snapshot snaptest refresh fast as
select * from test;
Statement processed.
SVRMGR select * from snaptest;
COL1 COL2 COL3
- - -
1 2 3
2 4 6
3 6 9
3 rows selected.
SVRMGR drop snapshot log on test;
Statement processed.
SVRMGR create snapshot log on test;
Statement processed.
SVRMGR -- the primary key option is not needed since
that is the default
SVRMGR insert into test values (seq1.nextval,
seq1.nextval*2, seq1.nextval*3);
1 row processed.
SVRMGR commit;
Statement processed.
SVRMGR select count(*) from test;
COUNT
-
4
1 row selected.
SVRMGR select count(*) from mlog$_test;
COUNT
-
1
1 row selected.
SVRMGR select count(*) from snaptest;
COUNT
-
3
1 row selected.
SVRMGR execute dbms_snapshot.refresh('SNAPTEST','F');
Statement processed.
SVRMGR select count(*) from mlog$_test;
COUNT
-
0
1 row selected.
SVRMGR select count(*) from snaptest;
COUNT
-
3
1 row selected.
SVRMGR execute dbms_snapshot.refresh('SNAPTEST','F');
Statement processed.
SVRMGR select count(*) from test;
COUNT
-
4
1 row selected.
SVRMGR select count(*) from mlog$_test;
COUNT
-
0
1 row selected.
SVRMGR select count(*) from snaptest;
COUNT
-
3
1 row selected.
SVRMGR -- snapshot is now out of sync!
SVRMGR insert into test values (seq1.nextval,
seq1.nextval*2, seq1.nextval*3);
1 row processed.
SVRMGR commit;
Statement processed.
SVRMGR select count(*) from test;
COUNT
-
5
1 row selected.
SVRMGR select count(*) from mlog$_test;
COUNT
-
1
1 row selected.
SVRMGR select count(*) from snaptest;
COUNT
-
3
1 row selected.
SVRMGR execute dbms_snapshot.refresh('SNAPTEST','F');
Statement processed.
SVRMGR select count(*) from test;
COUNT
-
4
1 row selected.
SVRMGR select count(*) from mlog$_test;
COUNT
-
0
1 row selected.
SVRMGR select count(*) from snaptest;
COUNT
-
4
1 row selected.
SVRMGR select * from snaptest;
COL1 COL2 COL3
- - -
1 2 3
2 4 6
3 6 9
51015
4 rows selected.
SVRMGR -- Notice the gap, row w/values 4,8,12 has
been lost
I'll let y'all know what I find out on the bug.
-- Anita
--- Norrell, Brian [EMAIL PROTECTED] wrote:
OK, checked TFM and there are two type of fast
refresh snapshots: primary
key (new in 8)
and rowid.
For a rowid snapshot, when the table (EMP) is
updated, a row is added to the
snapshot log (MLOG$_EMP) containing mainly the type
of action, timestamping
info, and the rowid (MLOG$_EMP.M_ROW$$) of the
affected record (rowid x
deleted at 2pm).
The snapshot object (type UNDEFINED in dba_objects)
that lies underneath the
table seen by the end users is akin to a table (it
has an index) and has an
extra column (also called M_ROW$$) that contains the
rowid from the master
table (rowid y is a copy of master rowid x). During
a refresh, the changes
from the snapshot log are applied to records in the
shapshot with the
appropriate *master* rowid (DELETE FROM
snap.CAREGIVERS WHERE M_ROW$$ = x).
So if you drop the table and recreate it without a
full refresh, the M_ROW$$
values in the snapshot object are now invalid
because they point to the
emp.rowid before the reorg.
For a primary key snapshot, there is no M_ROW$$
column. Instead, the
primary key columns are placed in the snapshot log
and used to identify the
rows in the snapshot. Because rowids are not
involved, a primary key
snapshot CAN be fast refreshed (according to TFM)
after a drop an recreate.
However, there are some procedures that need to be
called to let the system
know you are doing a reorg so that it doesn't flip
out when the table goes
away.
Clear as mud?
HELP, AND
Re: MaterializeRe: Snapshot Logs Explanation Needed
Dave, /* SOAPBOX ON */ I'm well aware that hacking the data dictionary is possible, but you'll never see me advocating that on the list. I believe hacking should be done only as a last resort to save a db or avoid rebuilding it and even then should be done only under the guidance of Oracle Support. In many cases even they won't let you make the changes, but will require dial-in access so they can make the changes to ensure that they're done properly. Since there are virtually no PK/FK relationships defined in the data dictionary it's far too easy to miss one of the relationships and end up with a corrupted dictionary. Said corruption may not manifest itself until days, weeks, or months later, at which point you'll have a bigger and messier problem than the original one. So even if you practice this on a test db and it seems to work OK, it might just be that you haven't performed the operations that would reveal the corruption. Definitely not something I want to attempt via email. IMHO the disclaimers backup first and use at your own risk are insufficient. /* SOAPBOX OFF */ -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi Anita, I'm not sure if you are the original poster but There is a way to force a view into fast refresh mode after you have restructured the snapshot logs WARNING: This is unsupported by Oracle and involves messing with the data dictionary. I once had to create a 4GB snapshot over an ISDN line This was done by creating the snapshot locally, exporting, ftp, import and then: In DBA_SNAPSHOTS (I believe) I compared the entry in the local database to the remote. One field was different in my case. A simple update to the data dictionary enabled the FAST REFRESH to take place. THIS IS DANGEROUS STUFF :) Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: dbms_job query?
Hi Seema, - v$session.status="KILLED" is not enough to say that session is really killed. Check v$session.server column, too. If it's something other than pseudo i.e. dedicated,shared, it means that there are activities such as network I/O or rolling back a transaction, etc. - As I remember If an snp is killed, it wakes up after a while(but, I'm not sure) - If PMON has a lot of activities, it may take time to clean all resources allocated by killed session. - PMON can not remove session object. It is removed when a killed session tries to make kernel call (gets ora-28). - If a transaction is killed, current working statement is not killed immediately. for example: - insert - select ... - update 1000-- KILL here - update 5 If you kill during updating 1000 rows, Oracle will update 1000 rows, then session will be killed before updating 5 rows. what about SELECT (???) -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * ARUN K C wrote: we had these situations for this we had to break the job first and then kill the snp process after some time u will see the sid out of v$session. Even if you kill the snp it will be kicked back later on from pid or spid i think i am not sure but it works Try this out it should work Well there must be some better answers from the experts out here check it out From: "Seema Singh" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: dbms_job query? Date: Fri, 01 Jun 2001 14:11:10 -0800 Hi If status=KILLED in v$session and the process is SNP oracle background process corresponding to that sid and dba_jobs_running has the same sid,no entry corresponding in dba_jobs then how to kill that process. Thx -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C 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: Danisment Gazi Unal (Unal Bilisim) 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: function index for like '%string%'
I understand what you want to do, but realistically
how do you expect Oracle to maintain an index or
efficiently search it when the leading characters are
unknown and of variable length?
Perhaps this would be suitable for a
context/intermedia index? I have long since forgotten
what little I knew about context from O7, so I'm not
much help there.
Is the substring that you're interested in a fixed
value or a range of exclusive values (i.e. the string
will not contain more than one of the values)? If so,
why not create a trigger which populates another
column and index that column? I would think a bitmap
index would be ideal for that situation.
Hmm, now that I think about it couldn't you create a
fbi that uses the instr function to accomplish this?
HTH,
-- Anita
--- SuzyV [EMAIL PROTECTED] wrote:
How unpleasant, the answer I expected but didn't
want to hear. At points of
loopy desperation I've tried dumbest things to make
this work, eg., creating the
index as lower('%email_addy%') which produces the
expected useless result in
dba_ind_expressions:
SQL create index idx_test
on test (lower('%email_addy%') ;
SQL select index_name, column_expression from
dba_ind_expressions
where table_name = 'TEST'
INDEX_NAME COLUMN_EXPRESSION
-- -
IDX_TEST '%email_addy%'
My suggested workaround to the developers is to
store the string lower case.
For some strings this is okay, but obviously not a
great solution for strings
which may be case-dependent.
fbi = f**ing boneheaded index :)
Suzy
Joseph S. Testa wrote:
i spent about a week about 6 months ago looking
for something to fill
that possibility to no avail.
joe
Rachel Carmichael wrote:
she knows why it isn't being used. What Suzy
wants to know (and I do too,
because I have a similar situation) is if there
is a way to create an index
that will let you search with the like clause.
Unfortunately my gut instinct is that you can't
make Oracle do that
From: Hillman, Alex
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: RE: function index for like '%string%'
Date: Fri, 01 Jun 2001 14:11:08 -0800
index is not used because you have leading % in
the like predicate.
Alex Hillman
-Original Message-
Sent: Friday, June 01, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
I've created a function index for
lower(column_name). However the query
does
a like comparison rather than equality so the
index isn't used. Is there a
way to create a function index for this?
Here's the index and query:
create index fx1_auth_users
on auth_users (lower(current_email)
tablespace app01_midx ;
select current_email from auth_users
where lower(current_email) like '%datsit.com%'
;
Thanks much,
Suzy
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Suzy Vordos
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
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup
DBA support?
For Sale: Oracle-dba.com domain, its not going
cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joseph S. Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
FAX: (858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be
removed from). You may
also send the HELP command for other information
(like subscribing).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: SuzyV
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,
Steps for removing jobs
Hi all! There have been several posts lately regarding how to kill or remove jobs from the job queue once they're running, so here are the steps. Background -- * Removing a job from the job queue, removes it from the queue, but does NOT abort the job if it is currently running (i.e. in DBA_JOBS_RUNNING). * If the job# in dba_jobs_running doesn't exist in dba_jobs, then the job has already been removed from the job queue. * You can only manage your own jobs, even if you're a DBA user. Someone else mentioned using BECOME USER to manage another user's jobs; sounds like a great idea, but I haven't had a chance to try that to see if it works. * Jobs in the job queue are not run by the SNP processes when the db is started up in restricted mode or when JOB_QUEUE_PROCESSES=0, but may be run manually. To kill a currently running job --- 1. First you must break or remove the job in the job queue, otherwise the job will just start right back up again the next time the SNP processes check for jobs to run (based on job_queue_interval). As the job owner: execute dbms_job.broken(job#,true); or execute dbms_job.remove(job#); 2. Kill the SNP process at the OS level. You can identify the process to kill using the SID from DBA_JOBS_RUNNING: select s.sid, p.spid from v$session s, v$process p where s.paddr=p.addr and s.sid=sid; p.spid is the OS process ID 3. As with any session that is killed, it will need to be rolled back and cleaned up. To restart a broken job --- A job will be marked as unbroken the next time it is successfully run or when it is marked as unbroken. As the job owner: execute dbms_job.run(job#); or execute dbms_job.broken(job#,false); Also check out Note 61730.1 Using the DBMS_JOB Package HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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 DBA Talent Needed in the northern part of Virginia (DC
We are currently seeking Oracle candidates with the following skills for a well known company client in Northern Virgina. ( Greater DC Area) These are full time staff opportunities that require 100% travel and U.S. citizenship. Candidates local to the Greater DC area only. No sub-contractors or third parties please. Please do not call or send a resume if you are not a U.S. citizen. Positions available are: * DBAs * Developers * Data Architects/Data Modelers * Data Warehousing These positions require 5+ years of Oracle Experience and excellent communications skills. This companies offer: * Challenge * A compensation package * The opportunity keep up with the lastest technologies. NO sub-contracting opportunities. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist Orastaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/O. Skills/NOVA/Steve We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Bumoer Stickers [RE: Rebuilding indexes]
On Fri, 1 Jun 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -THAT one I'll put on my car :) - -and my desk. and the developer's face OK so who's geting them printed?;-) or should i look into it? -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ MIPS: Meaningless Indicator of Processor Speed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: function index for like '%string%'
On Fri, 1 Jun 2001,Joseph S. Testa scribbled on the wall in glitter crayon: -i spent about a week about 6 months ago looking for something to fill -that possibility to no avail. dumb question would a contex... oh excuse me InterMedia index work? - -joe -Rachel Carmichael wrote: - - she knows why it isn't being used. What Suzy wants to know (and I do too, - because I have a similar situation) is if there is a way to create an index - that will let you search with the like clause. - - Unfortunately my gut instinct is that you can't make Oracle do that - - From: Hillman, Alex [EMAIL PROTECTED] - Reply-To: [EMAIL PROTECTED] - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] - Subject: RE: function index for like '%string%' - Date: Fri, 01 Jun 2001 14:11:08 -0800 - - index is not used because you have leading % in the like predicate. - - Alex Hillman - - -Original Message- - Sent: Friday, June 01, 2001 5:09 PM - To: Multiple recipients of list ORACLE-L - - - - I've created a function index for lower(column_name). However the query - does - a like comparison rather than equality so the index isn't used. Is there a - way to create a function index for this? - - Here's the index and query: - - create index fx1_auth_users - on auth_users (lower(current_email) - tablespace app01_midx ; - - select current_email from auth_users - where lower(current_email) like '%datsit.com%' ; - - Thanks much, - Suzy - -- - Please see the official ORACLE-L FAQ: http://www.orafaq.com - -- - Author: Suzy Vordos -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 - - - - -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ MIPS: Meaningless Indicator of Processor Speed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: data files - How big?
I personally am not a fan of auto extend. I like to have a procedure when adding new data files. I tend to keep data files smaller against popular opinion, there is no performance loss with many different data files. Also there is less likely of having OS locks when data files are more and smaller. Also, it is much easier to manage them if they need to be moved around if they are only 100 or 500Mb rather than 10Gb or 100Gb. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 10:40 AM To: Multiple recipients of list ORACLE-L I am setting up a new linux server (redhat 6.2 oracle 8i 8.1.7) with a 1Ghz Processor and 512Mb RAM. How large should individual data files in a tablespace be allowed to grow? I can't find any advice on this in my oracle manuals/books. Is there a data file size that starts to hurt oracle. I've got one tablespace that will have 1-1.5 Gb of data. Should I allow a datafile to grow to that size, or would oracle like it better if I split it into 3 500Mb datafiles? Likewise, how should I handle the SYSTEM tablespace? Should I leave it as 1 large datafile or should it be broken into smaller ones? I would also like to know what good oracle email lists are available to ask dba related questions other than this one. Thanks, Barry Stubbs Windham School District -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Stubbs 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: Christopher Spence 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).
online oracle backup on windows2000
i wanna to take online backup on w2000 and i will write a batch file to perform ALTER TABLE SPACE ... BEGIN BACKUP and END BACKUP commands. but i dont know how can i sent files to tape on command prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar 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).
to list administrator
i have been receiving each mail two times -Original Message- Sent: Saturday, June 02, 2001 7:30 PM To: Multiple recipients of list ORACLE-L Hi all! There have been several posts lately regarding how to kill or remove jobs from the job queue once they're running, so here are the steps. Background -- * Removing a job from the job queue, removes it from the queue, but does NOT abort the job if it is currently running (i.e. in DBA_JOBS_RUNNING). * If the job# in dba_jobs_running doesn't exist in dba_jobs, then the job has already been removed from the job queue. * You can only manage your own jobs, even if you're a DBA user. Someone else mentioned using BECOME USER to manage another user's jobs; sounds like a great idea, but I haven't had a chance to try that to see if it works. * Jobs in the job queue are not run by the SNP processes when the db is started up in restricted mode or when JOB_QUEUE_PROCESSES=0, but may be run manually. To kill a currently running job --- 1. First you must break or remove the job in the job queue, otherwise the job will just start right back up again the next time the SNP processes check for jobs to run (based on job_queue_interval). As the job owner: execute dbms_job.broken(job#,true); or execute dbms_job.remove(job#); 2. Kill the SNP process at the OS level. You can identify the process to kill using the SID from DBA_JOBS_RUNNING: select s.sid, p.spid from v$session s, v$process p where s.paddr=p.addr and s.sid=sid; p.spid is the OS process ID 3. As with any session that is killed, it will need to be rolled back and cleaned up. To restart a broken job --- A job will be marked as unbroken the next time it is successfully run or when it is marked as unbroken. As the job owner: execute dbms_job.run(job#); or execute dbms_job.broken(job#,false); Also check out Note 61730.1 Using the DBMS_JOB Package HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: Arslan Bahar 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: function index for like '%string%'
good question, i've not tried any intermedia/context stuff. any experts out there? Joe Thater, William wrote: On Fri, 1 Jun 2001,Joseph S. Testa scribbled on the wall in glitter crayon: -i spent about a week about 6 months ago looking for something to fill -that possibility to no avail. dumb question would a contex... oh excuse me InterMedia index work? - -joe -Rachel Carmichael wrote: - - she knows why it isn't being used. What Suzy wants to know (and I do too, - because I have a similar situation) is if there is a way to create an index - that will let you search with the like clause. - - Unfortunately my gut instinct is that you can't make Oracle do that - - From: Hillman, Alex [EMAIL PROTECTED] - Reply-To: [EMAIL PROTECTED] - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] - Subject: RE: function index for like '%string%' - Date: Fri, 01 Jun 2001 14:11:08 -0800 - - index is not used because you have leading % in the like predicate. - - Alex Hillman - - -Original Message- - Sent: Friday, June 01, 2001 5:09 PM - To: Multiple recipients of list ORACLE-L - - - - I've created a function index for lower(column_name). However the query - does - a like comparison rather than equality so the index isn't used. Is there a - way to create a function index for this? - - Here's the index and query: - - create index fx1_auth_users - on auth_users (lower(current_email) - tablespace app01_midx ; - - select current_email from auth_users - where lower(current_email) like '%datsit.com%' ; - - Thanks much, - Suzy - -- - Please see the official ORACLE-L FAQ: http://www.orafaq.com - -- - Author: Suzy Vordos -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 - - - - -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ MIPS: Meaningless Indicator of Processor Speed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: to list administrator
No Wonder, U may be getting one from Lazy Dba list and Other from this List!! Check it out. -Original Message- From: Arslan Bahar [SMTP:[EMAIL PROTECTED]] Sent: Saturday, June 02, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Subject:to list administrator i have been receiving each mail two times -Original Message- Sent: Saturday, June 02, 2001 7:30 PM To: Multiple recipients of list ORACLE-L Hi all! There have been several posts lately regarding how to kill or remove jobs from the job queue once they're running, so here are the steps. Background -- * Removing a job from the job queue, removes it from the queue, but does NOT abort the job if it is currently running (i.e. in DBA_JOBS_RUNNING). * If the job# in dba_jobs_running doesn't exist in dba_jobs, then the job has already been removed from the job queue. * You can only manage your own jobs, even if you're a DBA user. Someone else mentioned using BECOME USER to manage another user's jobs; sounds like a great idea, but I haven't had a chance to try that to see if it works. * Jobs in the job queue are not run by the SNP processes when the db is started up in restricted mode or when JOB_QUEUE_PROCESSES=0, but may be run manually. To kill a currently running job --- 1. First you must break or remove the job in the job queue, otherwise the job will just start right back up again the next time the SNP processes check for jobs to run (based on job_queue_interval). As the job owner: execute dbms_job.broken(job#,true); or execute dbms_job.remove(job#); 2. Kill the SNP process at the OS level. You can identify the process to kill using the SID from DBA_JOBS_RUNNING: select s.sid, p.spid from v$session s, v$process p where s.paddr=p.addr and s.sid=sid; p.spid is the OS process ID 3. As with any session that is killed, it will need to be rolled back and cleaned up. To restart a broken job --- A job will be marked as unbroken the next time it is successfully run or when it is marked as unbroken. As the job owner: execute dbms_job.run(job#); or execute dbms_job.broken(job#,false); Also check out Note 61730.1 Using the DBMS_JOB Package HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: Arslan Bahar 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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: 4 join methods?
I did have to RTFM - A cluster join is nothing more than a nested loops join involving two tables that are stored together in a cluster. Because each row from the dept table is stored in the same data blocks as the matching rows in the emp table, Oracle can access matching rows most efficiently Sam - Original Message - From: Vadim Gorbounov To: Multiple recipients of list ORACLE-L Sent: Friday, June 01, 2001 6:25 PM Subject: RE: 4 join methods? Hi, DBAs, RTFM is so boring, but... There is cutpaste from "Oracle8i Designing and Tuning for Performance" The Optimizer Optimizing joins Join Operations To join each pair of row sources, Oracle must perform one of these operations: Nested Loops (NL) Join Sort-Merge Join Hash Join (not available with the RBO) Cluster Join Cheers, Vadim Gorbounov Oracle DBA
Re: function index for like '%string%'
ooh ooh a fbi with instr! can't wait until Monday to try that one out on
the table in question...
From: A. Bardeen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: function index for like '%string%'
Date: Sat, 02 Jun 2001 07:45:27 -0800
I understand what you want to do, but realistically
how do you expect Oracle to maintain an index or
efficiently search it when the leading characters are
unknown and of variable length?
Perhaps this would be suitable for a
context/intermedia index? I have long since forgotten
what little I knew about context from O7, so I'm not
much help there.
Is the substring that you're interested in a fixed
value or a range of exclusive values (i.e. the string
will not contain more than one of the values)? If so,
why not create a trigger which populates another
column and index that column? I would think a bitmap
index would be ideal for that situation.
Hmm, now that I think about it couldn't you create a
fbi that uses the instr function to accomplish this?
HTH,
-- Anita
--- SuzyV [EMAIL PROTECTED] wrote:
How unpleasant, the answer I expected but didn't
want to hear. At points of
loopy desperation I've tried dumbest things to make
this work, eg., creating the
index as lower('%email_addy%') which produces the
expected useless result in
dba_ind_expressions:
SQL create index idx_test
on test (lower('%email_addy%') ;
SQL select index_name, column_expression from
dba_ind_expressions
where table_name = 'TEST'
INDEX_NAME COLUMN_EXPRESSION
-- -
IDX_TEST '%email_addy%'
My suggested workaround to the developers is to
store the string lower case.
For some strings this is okay, but obviously not a
great solution for strings
which may be case-dependent.
fbi = f**ing boneheaded index :)
Suzy
Joseph S. Testa wrote:
i spent about a week about 6 months ago looking
for something to fill
that possibility to no avail.
joe
Rachel Carmichael wrote:
she knows why it isn't being used. What Suzy
wants to know (and I do too,
because I have a similar situation) is if there
is a way to create an index
that will let you search with the like clause.
Unfortunately my gut instinct is that you can't
make Oracle do that
From: Hillman, Alex
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: RE: function index for like '%string%'
Date: Fri, 01 Jun 2001 14:11:08 -0800
index is not used because you have leading % in
the like predicate.
Alex Hillman
-Original Message-
Sent: Friday, June 01, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
I've created a function index for
lower(column_name). However the query
does
a like comparison rather than equality so the
index isn't used. Is there a
way to create a function index for this?
Here's the index and query:
create index fx1_auth_users
on auth_users (lower(current_email)
tablespace app01_midx ;
select current_email from auth_users
where lower(current_email) like '%datsit.com%'
;
Thanks much,
Suzy
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Suzy Vordos
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
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup
DBA support?
For Sale: Oracle-dba.com domain, its not going
cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joseph S. Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
FAX: (858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be
removed from). You may
also send the
RE: Bumoer Stickers [RE: Rebuilding indexes]
what was the date of this cartoon?? At 01:25 PM 6/1/01 -0800, Post, Ethan wrote: This is getting stupid, sorry I'm going to contribute to this...how about Calvin (http://www.ucomics.com/calvinandhobbes/viewch.htm) peeing on a SQL Server Logo, sure beats him peeing on a Ford sign. - Ethan Post -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Hal Wigoda 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: Is DBMS_OBFUSCATION free in Enterprise Edition?
Hi Cherie, Sorry to be late... Platform Aix 4.3.3 / Oracle 8.1.7 EE Two months ago, i tried to use 3DES (new in 8.1.7 DBMS_OBFUSCATION toolkit) and i got an error saying that i had to install Advanced Security Option to use this algorithm (for simple DES you don't get this error) So, depending on the algorithm you want to use, you can have extra cost as ASO is not free at all. Check carefully with your Oracle rep as i never get a definitive answer on that matter. HTH Gilles Parc Email : [EMAIL PROTECTED] carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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).
NT script question ???
Hi, I have couple of questions about bat file in NT 4.0 for Oracle 8.1.5. 1. how to make bat file take parameters. I had a backup.bat, and like to pass in Oracle SID, so the script can backup any database. 2. in the bat file, how to dynamically append date/time into a directory name, like backup_06022001121314 Thank you! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: About parallel server
It was DG/UX on DG Aviion Systems, with Clariion storage system. We were sharing filesystems between 2 nodes. Don't know about the rest of DG, but EMC purchased their Clariion storage system unit. Jared On Friday 01 June 2001 14:25, Richard Ji wrote: A couple of years ago, no vendor has a distributed file system (one that will let all nodes in a cluster to mount and access the same file system simultaneously). And that's why we had to use raw device. Maybe DG had it? So which vendor has it then and who has it now? Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Auto Extend
Good point John for large databases. We were using 20 gig files in a Lawson system on AIX. Great for DW. Jared On Friday 01 June 2001 15:22, John Kanagaraj wrote: Neither large files nor small files are evil. As with all things, fit the solution to the problem. Small files can leave you with lots of separate datafiles which isn't necessarily a drag on performance but can be an administrative chore and can cause more wasted space due to that pesky 'end-of-datafile' free extent. Mike, I will have to disagree with you about small files not necessarily being a drag on performance. Given a specific size of a database, it would be better to go in for larger files (avoiding the 2Gb pitfall if possible) since each datafile adds its own component to the flurry of I/O activity that takes place during log switch, i.e. when all datafile headers need to be updated. In simpler terms, (Large number of) Small datafiles + small redo logs + high DML activity = disaster during (the frequent) log switches... People who want to set up databases larger than a terabyte will inevitably have a budget to invest in new kit and buy-in to up to date OS and software levels. Not everyone has that luxury and a lot of legacy kit doesn't like 2GB+ files. That's only my opinion but really, why play around with any area that is demonstrably strewn with bugs unless you need to? Fully agreed! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Check/Remove stray shared_memory_segment and semaphore
Not necessary to use glibc-2.1, Oracle has a patch for using with glibc-2.2. It's on the download page for linux Oracle, it's at technet.oracle.com. It is a set of stubs that point 2.1 calls to 2.2 functions. It requires relinking Oracle and includes instructions. Jared On Friday 01 June 2001 19:15, [EMAIL PROTECTED] wrote: Hi Look under $ORACLE_HOME/bin for oracle executable. Do you see the file ? There was an installation bug and the relink fails with out creating the executable. If you do see the file then, check under $ORACLE_HOME/rdbms/log for any alert messages or traces. Also, Did you follow the procedure to use glibc-2.1 instead of glibc-2.2 ? Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Apps Sol [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/01/01 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Check/Remove stray shared_memory_segment and semaphore Folks, I am trying to start a new db on one of my new Linux box Dell 2450 , RHAT 7.0 and 8.1.6 .. 1GB ram and huge disk space .. but I get a error at SVRMGR ORA-03113: end-of-file on communication channel when I further checked and changed my SID to a new one .. no luck I even tried DBASSIST (Hate to do it though) no luck .. there is no error in my alert log Can any one tell me what are the things i need to look into .. Cheers RK Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function index for like '%string%'
Suzy,
You haven't detailed how you are search for a part of
the email address.
Is it random? Or is it on a definable piece of the address
such as the domain name?
If so, then why not use a trigger to break the email address
down into it's separate components store them in
separate columns?
If not, then you probably need to consider Intermedia, which
has already been suggested.
Jared
On Friday 01 June 2001 22:15, SuzyV wrote:
How unpleasant, the answer I expected but didn't want to hear. At points
of loopy desperation I've tried dumbest things to make this work, eg.,
creating the index as lower('%email_addy%') which produces the expected
useless result in dba_ind_expressions:
SQL create index idx_test
on test (lower('%email_addy%') ;
SQL select index_name, column_expression from dba_ind_expressions
where table_name = 'TEST'
INDEX_NAME COLUMN_EXPRESSION
-- -
IDX_TEST '%email_addy%'
My suggested workaround to the developers is to store the string lower
case. For some strings this is okay, but obviously not a great solution for
strings which may be case-dependent.
fbi = f**ing boneheaded index :)
Suzy
Joseph S. Testa wrote:
i spent about a week about 6 months ago looking for something to fill
that possibility to no avail.
joe
Rachel Carmichael wrote:
she knows why it isn't being used. What Suzy wants to know (and I do
too, because I have a similar situation) is if there is a way to create
an index that will let you search with the like clause.
Unfortunately my gut instinct is that you can't make Oracle do that
From: Hillman, Alex [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: function index for like '%string%'
Date: Fri, 01 Jun 2001 14:11:08 -0800
index is not used because you have leading % in the like predicate.
Alex Hillman
-Original Message-
Sent: Friday, June 01, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
I've created a function index for lower(column_name). However the
query does
a like comparison rather than equality so the index isn't used. Is
there a way to create a function index for this?
Here's the index and query:
create index fx1_auth_users
on auth_users (lower(current_email)
tablespace app01_midx ;
select current_email from auth_users
where lower(current_email) like '%datsit.com%' ;
Thanks much,
Suzy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
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
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: OT: Is Linux A Cancer ? well M$ thinks so ...
Same old FUD. Try to associate your competition with a scary word and make them a pariah. McCarthyism in the 50's, Balmerism in the 00's. Jared On Friday 01 June 2001 14:17, Jamadagni, Rajendra wrote: Read the story here (urlhttp://www.suntimes.com/output/tech/cst-fin-micro01.html/url) and have a good laugh. LOL! TGIF Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NT - Re: online oracle backup on windows2000
Arslan Bahar wrote:
i wanna to take online backup on w2000 and i will write a batch
file to perform
ALTER TABLE SPACE ... BEGIN BACKUP and END BACKUP commands.
but i dont know how can i sent files to tape on command prompt.
you don't need to execute it in a batch file - run it from sqlplus:
alter tablespace SYSTEM begin backup;
host ocopy D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF G:\backup\TEST\hot\
host dbv FILE=G:\backup\TEST\hot\SYSTEM01.DBF BLOCKSIZE=8192
LOGFILE=G:\backup\TEST\HOT\SYSTEM01.LOG
host pacomp -a -c1 E:\zipfiles\TEST\hot\SYSTEM01.zip
G:\backup\TEST\HOT\SYSTEM01.*;
host del /Q G:\backup\TEST\hot\SYSTEM01.*;
alter tablespace SYSTEM end backup;
The bonus lines in this backup job run the DBVerify utility and then
compress the datafile.
You will need a batch file to call this file with sqlplus (which will be
executed as a scheduled job in the OS).
as far as NT Backup - here's the man page
ntbackup backup [systemstate] bks file name /J {job name} [/P {pool
name}] [/G {guid name}] [/T { tape name}] [/N {media name}] [/F
{file name}] [/D {set description}] [/DS {server name}] [/IS
{server name}] [/A] [/V:{yes|no}] [/R:{yes|no}] [/L:{f|s|n}] [/M
{backup type}] [/RS:{yes|no}] [/HC:{on|off}] [/UM]
and here is an example job - use the GUI to schedule it at a future
time, and examine the properties of the scheduled job in he control
panel - scheduled tasks (the job won't show in an AT command - Windows
2000 only).
C:\WINNT\system32\ntbackup.exe backup @C:\Documents and
Settings\pldrake\Local Settings\Application Data\Microsoft\Windows
NT\NTBackup\data\test_system.bks /n Media created 6/2/2001 at 6:58 PM
/d test_system /v:yes /r:no /rs:no /hc:on /m copy /j test_system
/l:f /p Travan
hth,
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
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: OT: Is Linux A Cancer ? well M$ thinks so ...
Jared Still wrote: Same old FUD. Try to associate your competition with a scary word and make them a pariah. McCarthyism in the 50's, Balmerism in the 00's. Jared On Friday 01 June 2001 14:17, Jamadagni, Rajendra wrote: Read the story here (urlhttp://www.suntimes.com/output/tech/cst-fin-micro01.html/url) and have a good laugh. LOL! TGIF Raj This is not an email that I would normally post to the list - but since its the weekend - why not? Jared, The GPL has been referred to as a virus previously, due to inclusion of GPL code causing the entire piece of code (at the execution unit) to be required to be released under the same license. I have a problem with this section of the article: snip Q: Do you view Linux and the open-source movement as a threat to Microsoft? A: Yeah. It's good competition. It will force us to be innovative. It will force us to justify the prices and value that we deliver. And that's only healthy. The only thing we have a problem with is when the government funds open-source work. Government funding should be for work that is available to everybody. Open source is not available to commercial companies. The way the license is written, if you use any open-source software, you have to make the rest of your software open source. If the government wants to put something in the public domain, it should. Linux is not in the public domain. Linux is a cancer that attaches itself in an intellectual property sense to everything it touches. That's the way that the license works. snip Open Source != GPL. The GPL is one license - there are many like it, many unlike it. http://www.fsf.org/philosophy/license-list.html#GPLCompatibleLicenses Here is an article by Stallman http://www.cnn.com/TECH/computing/9911/08/freedom.GNU.idg/ Linus Torvalds chose the GPL so that no one could own Linux. There are other licenses that can be used for Free Software or Open Source Software, such as the LGPL, Apache and BSD Artistic License. I've heard rumors that much of the TCP/IP stack in Windows 2000 has its origins in FreeBSD code - licensed under the BSD license. To Balmer - if Microsoft cannot own it - it is evil - and should not be funded. As not all Open Source work is licensed under the GPL, his statement is overly broad and therefore false. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).
one more question about NT bat script
Hi, one more question about bat script in NT 4.0: when I put del c:\test\*.* in the bat file, and run it, I got Are you sure (Y/N)?, how to surpress this question? Thank you. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: function index for like '%string%'
The query allows a user to search for any token within an e-mail address:
select current_email from auth_users
where lower(current_mail) like nls_lower('%string%') ;
Where string could be '%user%' '[EMAIL PROTECTED]%' '%@domain%', '%@host%'
etc...
Which leads me to another question: the developer feels all user input searches
should use nls_ functions. I'm missing the point, we aren't doing
locale-specific searches so why nls_ functions?
Jared Still wrote:
Suzy,
You haven't detailed how you are search for a part of
the email address.
Is it random? Or is it on a definable piece of the address
such as the domain name?
If so, then why not use a trigger to break the email address
down into it's separate components store them in
separate columns?
If not, then you probably need to consider Intermedia, which
has already been suggested.
Jared
On Friday 01 June 2001 22:15, SuzyV wrote:
How unpleasant, the answer I expected but didn't want to hear. At points
of loopy desperation I've tried dumbest things to make this work, eg.,
creating the index as lower('%email_addy%') which produces the expected
useless result in dba_ind_expressions:
SQL create index idx_test
on test (lower('%email_addy%') ;
SQL select index_name, column_expression from dba_ind_expressions
where table_name = 'TEST'
INDEX_NAME COLUMN_EXPRESSION
-- -
IDX_TEST '%email_addy%'
My suggested workaround to the developers is to store the string lower
case. For some strings this is okay, but obviously not a great solution for
strings which may be case-dependent.
fbi = f**ing boneheaded index :)
Suzy
Joseph S. Testa wrote:
i spent about a week about 6 months ago looking for something to fill
that possibility to no avail.
joe
Rachel Carmichael wrote:
she knows why it isn't being used. What Suzy wants to know (and I do
too, because I have a similar situation) is if there is a way to create
an index that will let you search with the like clause.
Unfortunately my gut instinct is that you can't make Oracle do that
From: Hillman, Alex [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: function index for like '%string%'
Date: Fri, 01 Jun 2001 14:11:08 -0800
index is not used because you have leading % in the like predicate.
Alex Hillman
-Original Message-
Sent: Friday, June 01, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
I've created a function index for lower(column_name). However the
query does
a like comparison rather than equality so the index isn't used. Is
there a way to create a function index for this?
Here's the index and query:
create index fx1_auth_users
on auth_users (lower(current_email)
tablespace app01_midx ;
select current_email from auth_users
where lower(current_email) like '%datsit.com%' ;
Thanks much,
Suzy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
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
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
2 batch jobs kill performance
There is a site www.hotsos.com and a paper about why 2 batch jobs kill system performance. The paper is protected so is there anybody on the list who can explain this, Im very curious thanks Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 03, 2001 6:15 AM Jared Still wrote: Same old FUD. Try to associate your competition with a scary word and make them a pariah. McCarthyism in the 50's, Balmerism in the 00's. Jared On Friday 01 June 2001 14:17, Jamadagni, Rajendra wrote: Read the story here (urlhttp://www.suntimes.com/output/tech/cst-fin-micro01.html/url) and have a good laugh. LOL! TGIF Raj This is not an email that I would normally post to the list - but since its the weekend - why not? Jared, The GPL has been referred to as a virus previously, due to inclusion of GPL code causing the entire piece of code (at the execution unit) to be required to be released under the same license. I have a problem with this section of the article: snip Q: Do you view Linux and the open-source movement as a threat to Microsoft? A: Yeah. It's good competition. It will force us to be innovative. It will force us to justify the prices and value that we deliver. And that's only healthy. The only thing we have a problem with is when the government funds open-source work. Government funding should be for work that is available to everybody. Open source is not available to commercial companies. The way the license is written, if you use any open-source software, you have to make the rest of your software open source. If the government wants to put something in the public domain, it should. Linux is not in the public domain. Linux is a cancer that attaches itself in an intellectual property sense to everything it touches. That's the way that the license works. snip Open Source != GPL. The GPL is one license - there are many like it, many unlike it. http://www.fsf.org/philosophy/license-list.html#GPLCompatibleLicenses Here is an article by Stallman http://www.cnn.com/TECH/computing/9911/08/freedom.GNU.idg/ Linus Torvalds chose the GPL so that no one could own Linux. There are other licenses that can be used for Free Software or Open Source Software, such as the LGPL, Apache and BSD Artistic License. I've heard rumors that much of the TCP/IP stack in Windows 2000 has its origins in FreeBSD code - licensed under the BSD license. To Balmer - if Microsoft cannot own it - it is evil - and should not be funded. As not all Open Source work is licensed under the GPL, his statement is overly broad and therefore false. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Sam Roberts 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).
NT - Re: one more question about NT bat script
Andrea Oracle wrote: Hi, one more question about bat script in NT 4.0: when I put del c:\test\*.* in the bat file, and run it, I got Are you sure (Y/N)?, how to surpress this question? Thank you. del /Y Paul C:\del /? Deletes one or more files. DEL [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names names Specifies a list of one or more files or directories. Wildcards may be used to delete multiple files. If a directory is specified, all files within the directory will be deleted. /PPrompts for confirmation before deleting each file. /FForce deleting of read-only files. /SDelete specified files from all subdirectories. /QQuiet mode, do not ask if ok to delete on global wildcard /ASelects files to delete based on attributes attributesR Read-only filesS System files H Hidden files A Files ready for archiving - Prefix meaning not If Command Extensions are enabled DEL and ERASE change as follows: The display semantics of the /S switch are reversed in that it shows you only the files that are deleted, not the ones it could not find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: OT: Is Linux A Cancer ? well M$ thinks so ...
Here's a link to an ESR email discussing Balmer's interview: http://lwn.net/daily/esr-big-lie.php3 In the last three months, Jim Allchin and Craig Mundie and Steve Ballmer have launched a classic Big Lie campaign against open source. They have described it as un-American, a destroyer, and a cancer. They have deliberately confused the GPL with non-infectious open-source licenses, and they have deliberately confused active combination of code with passive aggregation of data. They have lied, and lied, and lied again. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).
