Gurus,
I have been an Oracle DBA for almost 5 years and would like very
much to venture into independent Oracle consulting (part-time). As i
have spent most of these 5 years as a sole DBA for different companies,
studying and learning the ropes of Oracle Administration through books,
magazines
Larry,
Have you seen paper 138 at Orapub.com
(http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=abs138) titled "Index Organized
Tables -- When should they be used? "
This has some benchmark figures.
Also, do you use Forms as a client - this can introduce some gotchas with IOTs
(particularly if s
Title: SQLPLUS spool file question
Perform a SHOW NEWPAGE command in
SQL*Plus. I imagine that you've got it set to "0"; if so, this is
what is producing the formfeed characters. Try setting either NEWPAGE
NONE or NEWPAGE ...
- Original Message -
From:
Vergara,
Michael (
Dennis,
The Toad provides "Waits"...
but there's a lot of events like "buffer busy waits","control file parallel
write","control file sequential read",.
Can you point me to the correct direction or suggest some informations about
how to analyse those events?
For STATSPACK, how to tell whether
Shaleen,
After a lot of digging into trace files, (and other DD tables such as
IDL_UB1$ and IDL_UB2$ and IDL_SB4$ tables :), I have concluded that stored
outlines are not being used for an SQL piece when it is part of a stored
procedure, (probably for certain situations). I was able to see that th
Listers,
Solaris 7, 8.1.7.4 64 bit, E10K.
Have a test IOT of around 120 million rows being created as we speak --
partitioned by month (3 months for the test), overflow by naming the column
at which to break, compressing the concatenated key, using secondary BMI's.
BMI's would be marked as unusab
Chris,
the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as
set p_oper_mode [lindex $parList [incr parList_i]]
set p_audit_level [lindex $parList [incr parList_i]]
set p_num_errors [lindex $parList [incr parList_i]]
set p_commit_frequency [lindex $parList [incr parLis
It appears to be version dependent...
Here is what I did in 9i R2 (and in 9i R1):
SQL> create table emp (num number,sal number);
Table created.
SQL> insert into emp values(1,1);
1 row created.
SQL> create or replace procedure t as
2 total number:=0;
3 cursor c1 is
4 select sal from em
Paula - Oracle has added a new table in 9i to help your analysis. V$UNDOSTAT
has a column MAXQUERYLEN that lists the longest query time, and can provide
a guide. SSOLDERRCNT column counts the number of snapshot too old errors in
a time period. In theory this should assist you in deciding whether yo
v$undostat has a maxquerylen column - thats a good
starting point in terms of avoiding ora-1555's if
that's your primary concern
hth
connor
--- [EMAIL PROTECTED] wrote: > Having had
frustration with rollback segments from
> time to time over the
> years I am happy to let Oracle handle it with th
John,
Thanks for the input. As far as I can see that sql's are exactly same in my
example. Morover none of the initialization parameters have been changed.
Need input from all Gurus
Thanks
Shaleen
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Th
Title: RE: UNDO RETENTION
Having had frustration with rollback segments from time to time over the years I am happy to let Oracle handle it with their recommended automatic undo management and a defined undo tablespace. However, it isn't that simple is it? I imagine that undo retention is cr
John,
I'm not sure what kind of timeframe you are looking at but you could
consider Move for Servers. I do not know if it handles this specific
problem but my experience with the product has been very good (certainly
handles long raws, etc) and their support is very forthcoming. I believe
the pr
Howdy,
I believe that truncating DUAL has also been known to leave developers
scratching their head. Of course I could never recommend that anyone try
it though.
Title: RE: Purging Managed Standby Database Archive Logs
Hi John,
Keeping things simple sometimes complicates things when they go haywire. I thought about the simple shotgun approach but wanted something a little more robust and I didn't want to risk deleting an archive log that hadn't been
Shaleen,
I have not been able to dig deeper (yet) into this. However the following
_may_ be why this is not working: I believe that the stored outline is
matched with an about-to-be-executed SQL using the Hash value of the SQL.
The hash value is computed by some mumbo-jumbo based on the actual SQ
Steve,
It's pretty simple. No need to record anything - see the Order By
Descending in the SQL below.
Here are a batch file and a SQL script I used on an 8.1.7 Standby DB under
Win2k. It ran reliably for months as a Scheduled Task once every hour and
got rid of all applied logs, assuming that
Hi all,
Be aware of the following caveat with LAST_CALL_ET:
A currently-executing SQL will NOT reset LAST_CALL_ET. I.e. if a session is
'ACTIVE' but the LAST_CALL_ET shows a large value (say your limit is 30 min)
you _cannot_ kill this session as it is still executing that SQL, albeit
long-runnin
It is an on line report. The client will enter the number of IDs, and I
will have to construct a query so the output will be
FROM
Id namevalue
1 a 5
1 b 10
2 a 15
2 b 20
THIS
name1
Hallo,
Dave- what is, Dual for Dummies?
-Original Message-
Sent: Thursday, December 12, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Hallo,
Problems with dual, please read link
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html
TIA,
Dave
--
Please
Hallo,
Problems with dual, please read link
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html
TIA,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 ht
Eriovaldo - Okay, we'll be here when you're ready. I can highly recommend
STATSPACK. It seems appropriate to my level of expertise and has helped me
get to the bottom of a lot of performance issues very quickly, had one this
morning in fact. Some people on the list have had to dig deeper than
STATS
Title: RE: ORA-600 error(solution for all of them).
So, Joe, are you pointless for a reason, or is there a joke I'm not aware of.
-Original Message-
From: JOE TESTA [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 7:29 AM
To: Multiple recipients of list ORACLE-L
Subject:
I don't think you can do it. I have resorted to tracking this through a
separate database schema and the invoking scripts for the backup. At the
beginning of the backup a timestamp and backup identification is inserted
into a "backup tracking" table and then at the end another timestamp is
in
Keep it simple. If you are on unix put this in your crontab.
30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc"
-mtime +0 -exec rm -f {} \;
This will run every hour on the half hour and purge everything over 24
hours old.
Modify as you like. (-mtime +1 gives you 48 hours) Yes,
There is a utility called "ORA-600 Lookup
Utility" which is on Metalink which prompts you for the first argument listed in
the ORA-600 error that will give you an idea where the problem
lies.
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 12
Satish,
Use the JDBC driver from the 9.0.1 database. The 8i JDBC driver causes this
error.
Scott
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of SATISH P
> Sent: Thursday, December 12, 2002 8:34 AM
> To: Multiple recipients of list ORACLE-L
> Subje
Satish - I think that means you get to be a pioneer. File it as a TAR.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 12, 2002 8:34 AM
To: Multiple recipients of list ORACLE-L
Hi ,
we are getting the error ORA-00600: intern
This error happens when 8i jdbc driver is used to connect to 9i database. we
reolved this by using 9i jdbc classes file. This error prevents the client
from opening connection to database.
-Shaleen
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Th
Yes, downtime currently isn't an issue.
We plan to attempt migration of new systems which are still in development --
thus only new applications will first go to HPUX. If the development
database migrates successfully to HPUX [we will "test the development" !],
further development from that point
Hi
Is this in a report if so i can help you else aim sorry.
thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walid Alkaakati
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailin
Title: Purging Managed Standby Database Archive Logs
Any one have a ready-made routine to purge the unneeded archives which have been automagically applied to a managed standby database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of the archive logs (v$ar
Try scanning your trace file at
http://www.ubtools.com/products/iorabugfinder/iorabugfinder.html.
- Kirti
-Original Message-
Sent: Thursday, December 12, 2002 8:34 AM
To: Multiple recipients of list ORACLE-L
Hi ,
we are getting the error ORA-00600: internal error code, arguments:
I looked on Metalink and found several hits. Most of them point to
Note:147731.1. I states you can get this error when using the 8i JDBC
driver to connect to a 9i database.
Just in case you didn't know, ora-600 is just a catch all error that you can
get for many, many reasons. You when searchi
Walid - Try this link.
http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96531/ch5_edit.htm
This is a page in the Oracle9iR2 New Features manual. Hope this is what you
need.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December
go to sql-server, bwahahahaha.
Ok as its been said numerous time(at least by me).
Yes I'll SHOUT NOW: YOU CAN'T FIX AN ORA-600 ERROR. ITS 98% OF
THE TIME A BUG. CALL SUPPORT, THE OTHER 2% OF THE TIME ITS A LARGE CAMEL
NOT A BUG. :)
thats is all.
joe
Hemant - You didn't mention performance issues. Is your database small
enough and your downtime window large enough that performance isn't a big
issue? That is nice when it happens. Also, I assume that you will do this
entire process as a test first, and let your users check it out for anything
mis
Dennis,
No, I don't want more information now. I am not using it.
I has just willing to know what is this.
Be sure , that when i will use it, i will post questions here.
Thanks a lot.
Eriovaldo
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wed
Title: RE: Active sessions chewing up a huge amount of RAM
I looked again and of course the concatenation should
be:
c1 := c1 || id || ' '
c2 := c2 || name || ' '
c3 := c3 || value || ' '
Yechiel AdarMehish
- Original Message -
From:
Yechiel
Adar
To: Multiple recipien
Have you checked the CONTINUEIF parameter of sqlldr.
Since a CR will signal a new record to sqlldr you simply
add a record with special character like '!' after the field
during the extract and use:
CONTINUEIF next (1:5) not equal '!'
If you write the multi line field as the last on the f
Has any body got Oracle 817 working on Red Hat Linux 8.0 Personal Edition?
If yes, it would be great if you would let me know whether you had to
install the glibc 6.2
Thanks
Sumathy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Panicker, Thankam S.
INET: [EM
Hi ,
we are getting the error ORA-00600: internal error code, arguments:
[ttcgcshnd-1], [0],
[], [], [], [], [], [] when trying to retrieve a result set from Java
EJB.
Searched metalink giving arguments for ORA-00600 but couldn't get any
solution.
I am being told that Weblogic 6.1 with oracle
Title: RE: STATSPACK
Raj,
Do you need beta testers for that?
I'd volunteer :-)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 8:23
AM
Subject:
Title: RE: STATSPACK
Right now we are evaluating the performance of that package (specifically the beer part) ... once it is ready ... I'll let you know.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN d
Title: RE: ora_sql_txt system defined event attribute
It (ora_sql_text) won't work in 8i .. but in 9202 it works fine, I think it was introduced in 8i, but extended in 9i...
I am not yet using dbms_system.ksdwrt in prod but on our ACPT instances, I use it to capture all the DDL that happens
Title: RE: Function-based Index
Cherie,
you could you a MV (with query_rewrite) ro do what you want ... make sure you use refresh on commit ... FBI won't be of much use in this scenario ...
Raj
__
Rajendra Jamadagni MIS, ESPN
Denham,
Thanks for the script. I modified it so the column OSUSER was selected
also to show the network id that they logged in with.
I use this script to see who is doing what on the system and who logs
in with what id. I will modify it to add the last_call_et calculations.
++
set linesize 90
You can use
select translate(field1||chr(126)||field2||chr(126),chr(015),' ')
in the program that creates the sequential file.
this will replace every chr(015) with blank.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday,
Standard Edition - A low-cost alternative for small/medium business or
departmental applications that want the power of Oracle but don't require the
high-end options of the Enterprise Edition.
Enterprise Edition - Offers industry-leading scalability and reliability in
both clustered and single s
Thanks for that Peter and Yechiel, whilst both posts were useful I don't
think they really answered my questions.
I know I could replace the CR characters but that involves a vast amount of
pre-processing (these are very large tables and there are hundreds of them
and they are in constant use). It
Title: RE: Active sessions chewing up a huge amount of RAM
Ah - a
nice tricky one!
The
explanation can be lengthy. The solution involves use of decode. The best advice
I can give is to refer you to the chapter on Decode in the Koch / Loney Oracle
Press book ('Oracle Complete Reference'). T
You need to cut and paste the rest of the link from the second line.
Anyway, here is what I found:
Standard edition does not have:
Oracle Data Guard
Transparent application failover
Oracle Real Application Clusters
Oracle Partitioning
Advanced Security Option
Oracle Label Security
Virtual Pri
Mr .Adar
sorry ,i can not find this link ..all i need is breif explanation .
thanks any way.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walid Alkaakati
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif
I cannot speak with experience of CRs in LONG fields, but they have
certainly caused problems in varchar2 fields for us.
FWIW, here the simple SQL I use to both detect presence of ascii(10), and
then clear them out:
select COLUMN_NAME from TABLE_NAME
where instr(COLUMN_NAME,chr(0)) > 0;
update
I would like this script.
If it is not long why don't you post
it?
You might even get some idea for
improvements.
TIA
Yechiel AdarMehish
- Original Message -
From:
Krishna
Rao Kakatur
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 8:53
A high blevel on a bitmap can often suggest that a
reasonable amount of dml is occurring on the
underlying table which is pretty much a no-no.
bitmaps are very prone to ballooning in size wildly
when lots of dml is applied.
Jonathan Lewis showed me a test case where a table
with just a few hundre
see:
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt
ions.html
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 7:43 AM
>
> Hi List ,
>
> I have one question please,what is
You may also want to explore whether you can simply
use profiles (namely idle timeout) to achieve what you
want.
hth
connor
--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: >
The last_call_et column of v$session shows the
> seconds elapsed since
> the session last made a database call, regardless
Listers,
I have got a number of tables with long columns in them. The text is
free-format and contains carriage returns. Some long columns may be empty
and others will have varying lengths of data (typical call-centre operator
input scenario) there is no end of record marker that is common between
Cherie
Oracle doesn't allow you to use aggregate functions in function-based
indexes but that's fine as you should be OK if you just specify a standard
b*tree index with the columns you mentioned.
Regards,
Mike Hately
-Original Message-
Sent: 11 December 2002 21:09
To: Multiple recipient
Title: RE: Active sessions chewing up a huge amount of RAM
You can try concatenation.
Pseudo code:
c1 := null
c2 := null
c3 := null
open cursor
while not end-of-set
c1 := id || ' '
c2 := name || ' '
c3 := vale || ' '
end-loop
Yechiel AdarMehish
- Original Message
I created a test table and build an index on columns t1 and t2.
Explain plan for: select min(t1) from test where t2=4;
was resolved using the index only so I think that will be very efficient.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTE
Jeremy Pulcifer,
Take a look at this link,
http://www.orafaq.net/archive/oracle-l/2002/10/04/103821.htm, several
people answered this topic and pmap does mean something.
Also take a look at this thread:
http://www.orafaq.net/archive/oracle-l
63 matches
Mail list logo
