CERT people called back and said that there were buffer
overrun issues with the PL/SQL module in 8i. They said
to check:
Oracle Security Alert #29
http://otn.oracle.com/deploy/security/pdf/plsextproc_alert.pdf
Oracle Security Alert #28
http://otn.oracle.com/deploy/security/pdf/ias_modplsql_al
select name
from user_dependencies
where type = 'VIEW'
and referenced_name = 'GIVEN_TABLE_NAME';
- Kirti
-Original Message-
Sent: Friday, March 15, 2002 4:34 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there a way of finding out what views are using a given table?
Shashank S
Sometimes I wonder if the correct thing to do is to install everything and then relink
the Oracle executable disabling the unpaid for options. My thinking is this: a need
arises where the option would be extremely useful; a successful case is made to
management; and an agreement is successfu
RE: Branching logic in PL/SQL, positive instead of exceptionDoesn't a cursor
loop only process the loop body when records are found? If this is true
then you will never execute the loop body when the %notfound condition is
true, control has already passed to the next statement following the for
l
How about a datafile is lost before it is backed up during the hot backup. Where will
you restore the file from? *You cannot use the backup from before; the logs have
been reset. You could, however, use a cold backup. Once the hot backup is finished
the cold one is not needed, but until
I have a system which stores messges in database (
just like out email messges ) and table having fileds
like sent-to , from , cc, bcc , new_indicator (y/n) ,
draft_indiacator , receive-date , ...
I have to write a proc to seach messages based on
different criterian like , all messages
Title: RE: Branching logic in PL/SQL, positive instead of exception
As an extension of this conversation, if I have eight conditional queries, eg.:
for i_row in main loop
build sql
declare cursor a select stuff
for a_row in a loop
if a%found
do stuff
elsif a%notfo
Hi Dennis,
Yes, your are right.
Thanks for catching it.
I messed up.
However, the order is still left to right...
While deciding on the partition when composite partition key is involved,
the partition is selected as follows (for 2 column composite key):
1. Value < column1
then sel
Hi Jared,
> > * You *have* to take a COLD backup of the database after using
> resetlogs.
> > (Not required - a Hot backup and archive logs is adequate. All hot
> backups /
> > archive logs prior to that are invalid, though...)
>
> Consider the following:
>
> Time:
>
> t0: database restored
Thanks all for your help . I got the answer
.
Big P
- Original Message -
From:
Igor
Neyman
To: Multiple recipients of list ORACLE-L
Sent: Friday, March 15, 2002 1:49
PM
Subject: Re: calling program
Not exactly true...
Well, since original question
Try querying dba_dependencies...
select referenced_name,referenced_type from dba_dependencies where name =
'your view name';
-- Janardhana Babu
-Original Message-
Sent: Friday, March 15, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
Hi,
Is there a way of finding out what vie
I've seen this on AIX, the controlfile will expand depending on the parm
maxloghistory that was set when the db was created.
eventually it will max out in size, and start spitting out errors in the
alert log at every time a log switch happens.
It happened to us about 3 weeks ago and i can't re
John,
You listed as an urban myth:
> * You *have* to take a COLD backup of the database after using
resetlogs.
> (Not required - a Hot backup and archive logs is adequate. All hot
backups /
> archive logs prior to that are invalid, though...)
Consider the following:
Time:
t0: database resto
Since the topic of Oracle licensing has come up, I'm wondering how
many organizations have site licensing and of what type (concurrent
user, named user, or processor).
We have a network license agreement for a set number of concurrent
licenses and we are co
"Jamadagni, Rajendra" wrote:
>
> I know it is normal, but is it normal to expand 15 times in 3 days?? This is
> 9012 in AIX 4.3
>
> If this isn't, where should I look for clues??
> TIA
> Raj
> __
> Rajendra Jamadagni MIS, ESPN Inc.
Hi,
Is there a way of finding out what views are using a given table?
Shashank Sinha
__
Phone: 262-317-9354
Cell: 262-424-1101
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinha, Shashank (MED, TCS)
INET: [EMAIL PROTECTED]
Fat City Network
This is and old but effective script, it's what you asked for and even
more
REM
REM $Author: oracle $
REM $Locker: $
REM $Date: 2000/06/19 17:35:26 $
REM $Revision: 1.1 $
REM $RCSfile: tool_shared_pool_statements.sql,v $
REM $Source: /home/oracle/DBA/tool/RCS/tool_shared_pool_sta
Dharminder,
Instead of the overhead of auditing, how about periodic queries of
V$SQL_Text for SQL statements that reference those tables. It should be
pretty easy to come up with occurrences and counts for each table, though
statements using bind variables could cause low counts for the tables
r
A Ha!
132 log switches ... just found the person responsible ... somehow was
testing a script to automatically clone the prod db, ON PROD MACHINE!! Well,
the log switches are back to normal numbers ... 3-5 an hour and although I
am not worried about control file expanding, I want to know why ...
(What everybody else said plus)
If you have root access (or get your sa to), vi /var/cron/log and look for
your job.
Under some situations cron will mail you a message and/or job output to
you, so check your unix mail.
The script template below should work (change as required). It's very very
Too many archived logs?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Rajendra
Sent: Friday, March 15, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
I know it is normal, but is it normal to expand 15 times in 3 days?? This is
9012 in AIX 4.3
If this isn
Yes, I just noticed it ... I have 6 logfiles at 200M and 2 of 128M ...
It is all BasketBall games data and stats ...
DateDay Total h0 h1 h2 h3 h4 h5 h6
h7 h8 h9 h10 h11 h12 h13 h14 h15 h16
h17 h18 h19 h20
Make sure to setup the environment. Try sourcing the oracle .profile and
using the full path for sqlplus.
Regards,
-Daniel
_
Daniel Harron
Database Management
IPsoft, Inc.
[EMAIL PROTECTED]
http://www.ip-soft.net/
Phone: 888.IPSOFT8
Fax: 212.353.2454
-Original Message-
Not 1500 times, 15 individual times ... no we haven't changed any schema,
except maybe a change in a package or two. It is the March Madness season,
so we are getting a lot (I mean a lot) of data. It is all games data (after
all we are ESPN).
sorry for the confusion ...
Raj
__
Ouch! Looks like I need to RTFM, not only before asking a question, but
before answering one - "shoot from the hip" = "shot in the foot". 8-(
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[
There is the vil way ... just drop the table and see who screams :)
Alec
-Original Message-
Dharminder
Sent: Friday, March 15, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L
In our production database environment, I have a list of about 1000 tables
,for which we want to find
Raj - Could you clarify please. Do you mean the control grew by 1,500% in 3
days? Or that you checked the size 15 times and it was larger each time?
Were you doing any database structure changes like adding
tablespaces, etc?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Ori
ALTER TABLE tablename MONITORING;
Every three hours or so, the SYS.DBA_TAB_MODIFICATIONS view gets updated
with the tables UPDATEs, DELETEs, and INSERTs, as well as wether or not the
table has been TRUNCATEd since the last time it was DBMS_STATS'd. The view
also gets updated on a SHUTDOWN, excep
Not exactly true...
Well, since original question was, if it's possible to know
calling procedure (or program),
I think DBMS_UTILITY..FORMAT_CALL_STACK function will return
as a VARCHAR2 call stack, which will provide info at least about calling
PL/SQL units (procedures, functions, or just
Correction: P2 ---> will contain values where column1 = 'X'
Regards,
Waleed
-Original Message-
Sent: Friday, March 15, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L
Kirti - If I can humbly beg to differ. I assumed that it would work the way
you described. However, I conducted s
make sure cron daemon is running
On Fri, 15 Mar 2002, Paul Heely wrote:
> Check the cron/crontab man pages to see what environment is setup for jobs
> run from cron. You can also re-direct any output from you script to a file,
> i.e.
> /opt/qqad/sql/QQAD_backupscript.sh > /some_file 2>&1
> This
Bhavin,
The reason behind this is that for option MAXLITERAL, valid values are
10-1024. Check the Pro*C compiler guide for more detail.
Thanks.
-Original Message-
Sent: Tuesday, March 05, 2002 6:23 AM
To: Multiple recipients of list ORACLE-L
hello ,
I am getting a syntax error
Does anyone have a handy PL/SQL script which can extract complete SQL
statement from v$sqltext sorting by v$sqlarea's buffer_gets ?
Thanks for the help
dj
_
MSN Photos is the easiest way to share and print your photos:
http://pho
-- -+
-- Procedure: Who_Called_Me
-- -+
-- Purpose
-- This procedure determines who the caller and line number was
--
PROCEDURE Who_Called_Me (
cname OUT VARCHAR2,
Actually you can, dbms_utility.format_call_stack, but you'll have to parse
the information. See http://osi.oracle.com/~tkyte/who_called_me/index.html
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
An
I know it is normal, but is it normal to expand 15 times in 3 days?? This is
9012 in AIX 4.3
If this isn't, where should I look for clues??
TIA
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opi
Big
Planet,
Whoa,
now there's a can of worms!
In a
word - no. Not unless you pass that info. in as an
argument.
Think
about what you're asking. Since PL/SQL procedures can be called from, not
only other PL/SQL procedures and functions, but the SQL*Plus command line, ODBC
calls, J
Check the cron/crontab man pages to see what environment is setup for jobs
run from cron. You can also re-direct any output from you script to a file,
i.e.
/opt/qqad/sql/QQAD_backupscript.sh > /some_file 2>&1
This should send STDOUT and STDERR to /some_file.
Inside your script you can also show
In our production database environment, I have a list of about 1000 tables
,for which we want to find if these tables are being used by anyone. How it
can be done. One of the ideas is that we start database auditing on these
tables for a considerable period of time say one month. Then for those
ta
yes, Jonathan Lewis was kind enough to correct me privately on this.
It is indeed only the first block that's used for header information,
the rest of the block is used for rollback change vectors.
--- [EMAIL PROTECTED] wrote:
> While on the subject..
> Please see the Oracle Metalink Note: 1029
you aren't wrong :)
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> Actually the rollback segment header in the first extent exists in a
> single
> block, the rest of the first extent, as I understand it, is available
> for
> undo. Thus making INITIAL and NEXT the same should be of no
> cons
Kirti - If I can humbly beg to differ. I assumed that it would work the way
you described. However, I conducted some tests and found to my surprise that
it seems to base decisions on the right-most column (although I only tested
two columns). Therefore, to use your examples,
P1 -- values less th
Hi LIst ,
Is there a way a pl/sql procedureor function
can know the calling procedure or calling program .
-ak
I think you also need to add -s to your sqlplus, so it runs in silent mode
e.g.
sqlplus -s system
You might want to add | mailx -s "Name of your table" youremail.com to your cron job
e.g.
04 17 * * 1-5 /opt/qqad/sql/QQAD_backupscript.sh | mailx -s "Name of your table"
youremail.com
so yo
Thanks for the info Robert.
Personally, I usually have more urgent matters to deal with that preclude
worrying about a possible 10meg wasted in a rollback segment. ;)
Jared
"Freeman, Robert " <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/15/02 11:23 AM
Please respond to ORACLE-L
If I understood the original question correctly, with the given conditions
there will be three partitions. Oracle evaluates concatenated key from left
to right order, so if the type and seq number are the partitioning columns
here then the partitions would be:
P1 -- values less than ('X', 99
Actually the rollback segment header in the first extent exists in a single
block, the rest of the first extent, as I understand it, is available for
undo. Thus making INITIAL and NEXT the same should be of no consequence in
this regard.
It is my understanding (and I'm sure I will be corrected if
What I am interested in is not a grid but sqlplus output. Like if I heve
feedback on it will tell me how many records I got in my select result etc.
Alex Hillman
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Post, Ethan
> Sent: Friday, March 15, 20
Are you using a different character set??
-Original Message-
Sent: Friday, March 15, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
I am trying to reverse engineer an Oracle (8.1.7 - running on NT)
schema using ERwin 4.0 (Windows 98). When it starts to load information for
the f
While on the subject..
Please see the Oracle Metalink Note: 1029850.6.
It says the first "block" of the first segment contains header
information.
> -Original Message-
> From: Kumanan Balasundaram
> Sent: 15 March 2002 17:59
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Sub
make sure your shell script is executable and put
#!/path/to/sh
as the first line in you script
On Fri, 15 Mar 2002, Hamid Alavi wrote:
> Hi All,
>
> I have a crontab job but this job never started, I have no idea what's
> wrong, actualy i am not a unix person, here is the job:
> cron job nam
I am trying to reverse engineer an Oracle (8.1.7 - running on NT)
schema using ERwin 4.0 (Windows 98). When it starts to load information for
the first table I get:
ORA-1403 no data found.
followed by:
ORA-03114 not connected to Oracle.
The last message repeats until I kill ERwin with the Win
You can use the a text box and a grid control. Use code to parse the
contents of the textbox and you create an ADO recordset that gets associated
with the grid control. Not too hard. Don't know what they are doing now
with the whole .NET thing, may have changed a bit.
- Ethan
-Original Me
Oracle recommends the size NEXT=INITIAL.
So if I had 10M initial, then most of the initial beyond the
header info will be wasted? Sure not!
Kumanan
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: 11 March 2002 21:48
> To: Multiple recipients of list ORA
I've never done partitioning but I've got an idea. What about adding a
column to hold a value of what partition you want to be in (P1-P6),
then populate that with a pre-insert trigger with whatever logic you
want...?
It's probably a naive idea, but I'm sure I'll learn from the list...
:-)
-rje
Hi,
You have to write in QQAD_backupscript.sh:
ORACLE_HOME=/u01/app/oracle/product/8.1.6; export ORACLE_HOME
ORACLE_SID=TEST ; export ORACLE_SID
$ORACLE_HOME/bin/sqlplus -s system/manager@QQAD @COLD_BAKUP_FOR_QQADha.SQL
- Original Message -
To: Multiple recipients of list ORACLE-L <[E
<>
ALways seems like the bugs I go looking for end up having
base bugs which are not publicly accessible on Metalink...
What I find really funny is that once in a while in the bug
reports that are publicly available, you will find the contact
(customer) name and phone number... and sometimes you
On Fri, Mar 15, 2002 at 04:08:37AM -0800, Boivin, Patrice J wrote:
> http://www.cert.org/advisories/CA-2002-08.html
>
--
At the top of this page it lists 8i Database in the "Systems Affected".
But there are no entries for 8i in the advisory. I called CERT
and they said, "hmmm...". I'm waiting
Yeah, make the foreign key from the parent the primary key in the child.
Jared
"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/15/02 08:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject
I am trying to find COM control with which I can execute SQLPLUS scripts and
get SQLPLUS output. Any idea please?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Open LDAP has issues.
Do a search on slashdot.org for commentary on it. I was quite surprised
at how many folks had problems with it that prevented them from using it.
Made me feel a bit better about never getting it to work. :)
Jared
"Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PRO
John - At last a question I can answer! Anyway I think so.
You can partition on a concatenated key. I just did this on our data
warehouse and brought query times from over 2 minutes to under 10 seconds.
Here is what my partition looks like.
create table sumacctfact2
nologging
pctfree 5
partition
In the past, I have seen databases not shutdown immediate b/c dbms_jobs were running,
not sure if still true w/ 8i 9i?
>>> [EMAIL PROTECTED] 03/15/02 10:13AM >>>
..which is why we have a shell script that runs out of cron and checks on database
jobs. Here is the SQL that we use to find jobs wi
Esteemed Gurus,
I have a client that wants to collect information on who is querying a =
table. The database is of the 8i variety. The table is accessed thru =
an application that uses Forms 6i, so the users are not issuing command =
line queries. Each time a user opens a form, our developed s
Oh, you lucky people. I love Seattle. Haven't been there for a couple of
years.
Lee
-Original Message-
Sent: 15 March 2002 16:43
To: Multiple recipients of list ORACLE-L
Seattle listers,
Rachel Carmichael will be in town this weekend. If anyone wants to
get together Sunday evening w
Hi,
Anyone know of a way OTHER THAN A TRIGGER to maintain a one-to-one
relationship between two entities (in this case a parent-child - only one
child for each parent)
thanks
bill
Bill Magaliff
Framework, Inc.
914-631-2322
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Au
It is using all 800 M of temp tablespace in our system.
How much do you have allocated to get this program to run.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204
Seattle listers,
Rachel Carmichael will be in town this weekend. If anyone wants to
get together Sunday evening with us and possibly some of the
Amazon.com DBAs, let me know.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Doh! disregard. Brain #$%^ in effect...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: [EMAIL PROTECTED]
> [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 15, 2002 9:49 AM
> To:
I think what my boss is asking me to do is not possible, but since I don't
have much experience with partitioning I thought I'd ask here (I did read
some of manuals but didn't find an answer that suited my conditions). My
boss wants a table partitioned by 2 columns - seq_no and type. If the type =
So, as we are about to implement Oracle Internet Directory 3.0.1. I had
planned to use our standard method of ARCHIVELOG mode and hotbackups, but
Oracle says that it won't be valid for recovery, due to the OiD admin
treating some operations, like "ldapaddmt" as atomic (one fail = all fail).
And t
We don't let developers run the job but your idea is good about
semaphore
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of E
Here's something that worked in Oracle7.1 It will still work although it's
a bit long-winded and uses dbms_sql. (See attached file: chkcase.sql)
Chaim
Lyuda Hoska <[EMAIL PROTECTED]>@fatcity.com on 03/14/2002 02:03:32 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
There is a good paper available on EMC architecture at the openworld site.
-Original Message-
Sent: Friday, March 15, 2002 6:23 AM
To: Multiple recipients of list ORACLE-L
http://www.eecostructure.com/
>>> [EMAIL PROTECTED] 03/14/02 09:18PM >>>
Where I can find more info concerning EMC
Hi All,
I have a crontab job but this job never started, I have no idea what's
wrong, actualy i am not a unix person, here is the job:
cron job name is : qqad.cron
04 17 * * 1-5 /opt/qqad/sql/QQAD_backupscript.sh
and here is the QQAD_backupscript.sh (in /opt/qqad/sql)
sqlplus system/manager@QQ
Do a:
desc dual
SQL> desc dual
NameNull?Type
---
DUMMYVARCHAR2(1)
SQL>
You are trying to do a bitand on a varchar2 column.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense
..which is why we have a shell script that runs out of cron and checks on database
jobs. Here is the SQL that we use to find jobs with problems:
/* Check for broken jobs or jobs that have failed more than 8 times. */
/* Also check for jobs that should have run in the last day, but haven't. */
s
Yes, I've seen that also.
Bugs 299259 and BUG:207590 describe this change in
behavior, and why it was done, but those bugs are not
accessible on MetaLink.
Jared
On Thursday 14 March 2002 15:03, Jonathan Lewis wrote:
> I hate to perpetuate a legend, but I THINK there
> was an early version w
And Jay Leno's poor because he's only making $17 million, while Dave
Letterman's making $31.5 M.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Friday, March 15, 2002 6:09
Hi,
Whenever we try to run the following query we got ora-00600 error:
What can be the possible Cause??
We found out that the following lines from end of query are creating the
problem
if we use only one condition out of these two the query works..
AND (anccorpfilter.id_ancestor IN (13
Harvinder,
Cursor_sharing does not reduce soft parsing, only hard parsing, and hard
parsing is only reduced if there are statements that only differ in literals.
When you say query performance degrades, where do you actually loose?
Parsing or executing?
I suggest you read my white paper o
They may not meet their sales target, but they are still making money. They try to make you think they are starving if they don't meet their funny numbers.
Rodd
On Fri, 2002-03-15 at 06:08, Boivin, Patrice J wrote:
Yesterday Oracle announced they will not meet their target for the qu
Raj,
Was it some kind of patch for 9011 or 9012, which fixed dbms_job?
Could you provide some details?
It's very important for us, because we rely heavily on dbms_job (NT
environment, looking to upgrade to 9i).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple r
I also agree, cron WORKS well ! The only thing I would add to cron jobs (shell
scripts) is to use a semaphore file.
e..g.
—---
semfile=/tmp/$0.RUNNING
if [ -f $semfile ] ; then exit ; fi
touch $semfile
DO SOME SHELL STUFF
rm $semfile
exit
—---
Sounds like a database issue, so it's not OT.
--
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
---
Possibly a candidate for Oracle Advanced Queueing?
-Joe
--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> dbms_job is the way to do since if you rollback the
> txn, then the job submission will also roll back
>
> hth
> connor
>
> --- Alroy Mascranghe <[EMAIL PROTECTED]> wrote: >
> > Several p
While I agree that dbms_job is the right way, we had lots of problems with
dbms_job suddenly failing (i.e. it just stops working) in 9011 and 9012
versions of database. Finally it was something to do with job queue
processes, with the help of OWS we fixed it. BUT, I still don't trust
dbms_job on o
http://www.eecostructure.com/
>>> [EMAIL PROTECTED] 03/14/02 09:18PM >>>
Where I can find more info concerning EMC disks, setting up the filesystem
and Oracle tuning + backups with EMC.
Thanks in advance,
sepi
_
Chat with frien
http://www.cert.org/advisories/CA-2002-08.html
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Regi
Yesterday Oracle announced they will not meet their target for the quarter.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l
That information looks very familar ;-)
Anjo.
Christian Trassens wrote:
> Regarding the subject, p3 gives us the cause of the
> buffer busy waits. It is a code or id and it has
> changed since 7.3. Fe.:
> 0 the common one, the block is being read.
> 1012 a modification is happening on a SCUR or
The reason behind the oddity is probably
that bitand() is defined (see standard.sql)
to return a binary_integer (it used to return
a number in earlier versions) and pure SQL
does not recognise that type, so you need
a method for coercing the result to a number.
It is probably slightly cheaper
select bitand(4,4)+0 from dual;
--- Sinard Xing <[EMAIL PROTECTED]> wrote: >
Hi,
>
> Can someone help me with this please
> What cause the error ?
>
>
>
> SQL> select bitand(4,4) from dual;
> ERROR:
> ORA-00932: inconsistent datatypes
>
>
>
> no rows selected
>
>
>
>
> Sinardy
> --
>
Because if property = 20, then bitand(prop,4) = 4
etc
hth
connor
--- Sinard Xing <[EMAIL PROTECTED]> wrote: >
Hi all,
>
> If an index with reverse key generated the table
> ind$.property it allways
> store value 4
>
> Why Oracle recommed this condition
>
> WH
dbms_job is the way to do since if you rollback the
txn, then the job submission will also roll back
hth
connor
--- Alroy Mascranghe <[EMAIL PROTECTED]> wrote: >
> Several programs writes to a table. From that table
> a process has to be
> initiated. (Currently it is working on a trigger but
>
Regarding the subject, p3 gives us the cause of the
buffer busy waits. It is a code or id and it has
changed since 7.3. Fe.:
0 the common one, the block is being read.
1012 a modification is happening on a SCUR or XCUR
buffer but has not yet completed.
1013 or 130 block is being read by another s
96 matches
Mail list logo