First session:
SQL> CREATE OR REPLACE procedure testing authid
current_user is 2 sql_stmt VARCHAR2(4000); 3 c
number; 4 n number; 5 a
varchar2(1000); 6 Begin 7 sql_stmt := 'Alter
Session Set Current_Schema = scott'; 8 Execute Immediate
sql_stmt; 9 Dbms_o
Hi has anyone sat the OTC exam before and did they find it difficult
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Bris
You are probably right but it was good to have V6-type control over the
mechanism. log_simultaneous_copies, log_small_entry_max_size (maximum
number of characters that was allocated when allocation latch was acquired)
and log_entry_prebuild_threshold (the size of redo after which the user
process
Wrong alert in HP Open view (you can configure that) and (again) ignoring
other more relevant performance information ('High CPU usage'). I have never
seen a system where tuning the redo copy latches made a huge improvement in
performance.
Anjo.
On Wednesday 02 July 2003 22:20, you wrote:
>
I run the query and it run even though in Rapid SQL send the
next error:
unexpected token:LEFT
My questions is what is the difference between
where an join in Oracle, what is better and
why?
>>> [EMAIL PROTECTED] 07/02/03 06:55PM
>>>
Hi !!
(I am using Oracle 9.2)
I am trying to run the n
Hi !!
(I am using Oracle 9.2)
I am trying to run the next query but I received an error in
the from statement.
SELECT POLINE.ITEM AS
CVEART,
POLINESRC.QUANTITY
AS CANT_PE,
ROUND( ITEMLOC.SOH_QTY - (
ITEMLOC.ALLOC_QTY + ITEMLOC.IN_PROC_QTY), 2) AS EXIS_BOD,
CASE WHEN POL
On 2003.07.02 05:10, Craig I. Hagan wrote:
> Linux file systems usually do not support direct I/O (bypassing the buffer
> cache), which means that you're going to have double caching with almost
This is no longer the case. Look at the O_DIRECT open option, which can be
used
with oracle. Make sure t
Gurus,
Reposting.. since this might have got lost in emails.
Any thoughts...?
Thanks, -Ravi.
"..
Help me figure this one out. Was helping a colleague
diagnose slow response time (8.1.7/Solaris running
Peoplesoft ). x$bh showed 102,248 out of 170,000
buffers belonged to a single table, which he s
Well, I am not particularly fond of SQL Server, but it does point in time
recovery and online recovery. At least we did it in the DB Admin class for
SQL Server 2000.
Docn isn't that great (except maybe the IT Professional series).
From: "Nuno Souto" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTE
Jared, I hope this is not too much off-topic for the list. I don't know if you prefer
that we check with you first but I imagine you have a lot of e-mails to read already.
>From ComputerWorld:
ISS WARNS OF COORDINATED HACKER ATTACK ON JULY 6
Internet Security Systems Inc. is warning that an in
Separating tables from indexes is one of those mythical things.
I agree. It is not given that separating those two will have much impact
on performance. However, as you point out yourself it is dependent on the
amount of IO. I did say it was nice to be able to separate different
database obje
Due to bugs and limitations in the internal structure of rollback
segments.
ie. they aren't allowed more than 32k extents.
See MetaLink note 50380.1
Jared
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 01:55 PM
Please respond to ORACLE-L
To: Multiple recipient
Jared,
I tried this 2 years back on a 8.1.6.2 databases with same result.
Previously it was 505 extents with 8K blocksize on 7.3.4.5. I did not used
hidded param _unlimited_rollback_segments in 7.3 which was the prereq for
putting unlimited extents.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED
does the 32k limit hold in 9i with undo tablespaces?
- Original Message -
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 5:31 PM
> Due to bugs and limitations in the internal structure of rollback
> segments.
>
> ie. they aren't allowed more than 32k extent
Separating tables from indexes is one of those mythical things.
If you want to separate files to different filesystems/volumes/whatever,
do
so based on the amount of IO per file.
disclaimer: I still tend to do that myself, partly by necessity. SAP
demands it,
and it's a starting point on new
Just now noticed that on 8.1.7.4 this statement:
alter rollback segment RBS1 storage ( maxextents unlimited );
results in a max_extents value of 32765, just below the point
at which rollback extension would cause a crash.
Jared
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 01:
Hello list, I am planning to appear for my Oracle 9i database
fundamentals II exam ( 1z0-032 ) on the 7th .
I would be grateful for any advice , pointers ,etc. Bit nervous
cause
it looks tougher than 1z0-031 ( dba fundamentals 1 )
thanks
...
--
Please see the official ORACLE-L FAQ: http://w
Dick,
Thanks. I am definately looking for such company. Before joining my last
employer, I was told lot of problems even in my interview. But after joining
it in March 2000 and responsible for production support, I fixed possible
problems and just keep proactive monitoring and fixing things fro
Thanks for all the replies (to the list and some private..)
All that was done by the script was to send an e-mail to the VSDBA, when TS usage
crossed some
percentage, set by the VSDBA for those databases (they wanted almost everything that
Patrol did).
The only difference now is that the scrip
elain he wrote:
>
> Hi,
> I have a file called file1.doc stored in a BLOB column that I would like to
> retrieve and save it to the filesystem. Can someone post a sample PLSQL code
> or tell me where I can get the information.
>
> Thanks!
>
> elain
>
www.orafaq.org/papers/lobs.doc
--
Regard
Title: RE: CASE in PL/SQL
I am
already using it that way, but giving that condition in cursor is not
possible.
Thanks
for your help.
Surendra
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 02, 2003
5:01 PMTo: Multiple recipients of
OMF ? What was the name of the file ? You can tell from that whether
its omf or not.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 02:05
: Hi List,
:
: Today I have dropped a big tablespace(4 Gig) as soon as I dropped
1. query on v$session to get the SID
select sid from v$session where username='user_name';
2. Then pass sid to the follwing query
select sql_text
from v$sqlarea a, v$session b
where a.hash_value=b.sql_hash_value
and a.address=b.sql_address
and b.sid=&essiedi
/
3. Also query v$open_cursor t
Question : How can I determine if this redo copy latch is causing the
performance issues , guess that is my main question before altering some
hidden parameter in init.ora.
Do a 10046 trace and see if you have any waits on this latch. I'll run the
risk of being sued for copyright infringement a
Well, heres a script that will dump out contents of blob that I used to test
things out. The script takes 3 arguments:
1) Name of table
2) Name of CLOB/BLOB field
3) ROWID of record with the LOB that you want, OR an asterisk * for all
records
Saving it into the file system is left as an
RAID 0+1 and RAID 1+0 provide similar performance but RAID 1+0 has the
advantage of offering more redundancy/availability. If you take your sys
admin's advice and go with 2 x 3 disks in a 0+1 config and you lose one
disk then you lose the other two spindles in that stripe as well. That's
half
Roger Xu wrote:
>
> Hi,
>
> >From V$SESSION, I can find out all the sessions for a user.
> How do I find out the current SQL and previous SQL for that session?
>
> Thanks,
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
SQL statements are identifi
I still feel that
to_char(add_months(sysdate, 6), 'Q')
is a simpler solution than
MOD(TO_NUMBER(TO_CHAR(add_months(sysdate,9),'Q'))+1,4) + 1
when determining the fiscal quarter. Also, the latter solution above is
off-by-one regarding the results per your original email wherein the fiscal
ye
Rafiq,
If we had a slot for you I'd probably recommend you submitting a resume. As
it is we're full up on DBA's. I have not had a major, or minor problem for that
matter, in years. In this company keeping things running smoothly is a recipe for
success. And proactive monitoring is t
I guess fixing queries and code can give much significant and noticable
performance gain compared to what one can get by fixing redo copy latch .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 9:40 AM
> Hello ALL,
Hi,
I have a file called file1.doc stored in a BLOB column that I would like to
retrieve and save it to the filesystem. Can someone post a sample PLSQL code
or tell me where I can get the information.
Thanks!
elain
_
Help STOP SPA
Title: RE: Microsoft VS Oracle (again)
We handle our fail over in the code and trust me users don't know. Nor it affects any scores that we put on the TV ... works just fine, but code design plays important role.
BTW talking of TAF, has anyone experimented with 'warming the lib cache' ??
Title: RE: CASE in PL/SQL
just use the sql to assign value to your variable ... if you really want my advise, make this a function or a procedure so you can call it from where ever you want. As function can be completely written in pl/sql you should be okay ...
-- this is a procedure ...
crea
i read this somewhere. why is it a bad idea to use maxextents unlimited in your
rollback tablespaces?
>
> From: "Goulet, Dick" <[EMAIL PROTECTED]>
> Date: 2003/07/02 Wed PM 04:40:45 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Should percent increase higher t
I totally agree with Dick...The person who si saying not to bother these two
,must be a sleeping DBA waiting for trouble to come and then jump and this
is the right strategy in US market. I lost my job because I kept my
production databases so smooth and trouble free (with proactive
monitoring)
Hi,
>From V$SESSION, I can find out all the sessions for a user.
How do I find out the current SQL and previous SQL for that session?
Thanks,
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
__
Hi
all,
I'm doing the data
model for an Operational Data Store. The ODS will serve to consolidate data from
many operational systems and mainly from a new ERP, then most of the data
will go in an existing data warehouse.
I've worked with
datawarehouses before but never with ODS.
I've
Guang,
In temp I really don't watch anything. In Rollback I watch for segments that
are approaching maxextents and just plain running out of space.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, July 02, 2003 3:51 PM
To: Multiple reci
you can find them at fatcity.com
Click on sign up, sign in, should be easy from there.
Jose Luis Delgado <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 11:30 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
At the moment I have 5, more to come.
What fun.
"Niall Litchfield" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 12:50 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: What are the
Hi,
> I once experimented with it (8.1.7.smth on linux), but started having
> crashes. Don't remember what exactly crashed, but it didn't work. I
> believe
> last version where it was supported, was 8.0?
I think it was supported in Oracle 8.1.5 and is documented in the tuning
manual.
we used the
I forgot to say: the first listing is the tnsnames.ora on the client(s).
> -Original Message-
> From: Stephen Lee
> Sent: Wednesday, July 02, 2003 3:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: service name, sid ..
>
>
>
> Example using Transparent Application Failo
Like that tag line April...
Robert G. Freeman
Consultant - TUSC
www.tusc.com
Silence is consent...
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/2/2003 1:49 PM
Good Lord, you can NEVER have too many books!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Syste
A quick scan of it looks ok.
Not sure about copying the password file.
Too easy to create it to bother I think.
BTW, export the Oracle registry key to a file first.
It comes in useful on occasion. :)
Jared
Jack van Zanen <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 01:10 A
Paul Baumgartel wrote:
>
> OK, I'm going to aim a little lower: is _anyone_ using Logical
> Standby? Any tips, gotchas, implementation accounts to share?
>
> TIA
>
> =
> Paul Baumgartel, Adept Computer Associates, Inc.
> [EMAIL PROTECTED]
>
Paul,
I am not using it but sometimes testi
Thanks Kirti,
We have HP Openview implemented on our database and hence got some alert on redo copy
latch. When I have queried the database I found the contention on this latch. Yes we
have other performance issues ( HIGH CPU utilization , because of lotta bad code ).
and We are checking every po
Hi George,
With this solution you can only find Quarter number. but I also need Year of
that quarter number.
when you say to_char(date,'Q'), it might go next year or stay in current
fiscal year depending on number of months we add to the date.
Thanks,
Surendra
-Original Message-
Sent: We
Title: RE: Re[2]: Online tech books
Well Robert, you're the author of two books on my shelf as well. Oracle 9i:New Features and Oracle9i:RMAN backup & Recovery.
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 02, 2003 2:41 PM
To: Multi
Hi Arup,
LogMiner is fine for certain tasks but not for auditing everything, it
has some deficiencies such as it cannot be used in an MTS environment as
it uses PGA memory, it doesn't fully support chained and migrated rows
(fixed in 9i), doesn't support selects (as they are not recorded in the
re
Example using Transparent Application Failover (TAF)
If I didn't forget something, here's what it looks like:
XXTP_QUOTE.WORLD =
(DESCRIPTION=
(LOAD_BALANCE=OFF)
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1527))
(ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.47
Hi Rudy,
Thanks for your suggestion. But I got a better suggestion from Metalink.
Here what I was suggested:
SQL> SELECT (MOD(TO_NUMBER(TO_CHAR(add_months(sysdate,9),'Q'))+1,4) + 1) qtr
2 , DECODE(SIGN(TO_NUMBER(TO_CHAR(main_rec.termination_date,'Q')) - 3)
3 , -1, TO_NUMBER(TO_CHAR(main_rec.ter
What are the things that we should be monitoring in ROLLBACK or TEMP
tablespace? So far I don't have any script to monitor ROLLBACK or TEMP
(havn't had any problem though). I too thought Oracle would take care of
rollback and temp ts space management. Right or wrong?
Guang
-Original Message-
Must say that I approve of your set of books :-))
Robert Freeman
Author of at least two books on your bookshelves!
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/2/2003 1:26 PM
Bless you Bob !
I will use your pictures to settle the argument of too many books wit
Title: Raid 0+1 vs. mirrored pairs
Hi Everyone,
I guess I am stuck in the old myth which says "one giant raid array for everything is bad". We have been told Windows 2000 server is what we will now run Oracle on. Setting aside the debate putting of Oracle on a Windows box, I am curre
I don't have any great answers other than there is good docs on MetaLink. However,
one word of warning. We have been attempting to install DataGuard here and have
encountered bugs. We have open bugs for release 9.2.0.1, 9.2.0.2 and 9.2.0.3. The
bugs are supposed to be fixed in 9.2.0.4, but t
Jared wrote
> Which reminds me, I somehow missed that when cloning a
> SAP db last weekend. Guess I'll go fix it now.
Surely one of those things is more than enough :(
Niall
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall Litchfield
INET: [EMAIL PROTECTED]
Interesting. For some reason, the term "transparent failover" sticks in my
head. Then again, I was remembering incorrectly. The Oracle Workload
Generator demo was for load-balanced queries between the two nodes of the
RAC. The failover was a SQL statement run from SQL*Plus, which probably
comes
Rich,
> So, what's the case for code changes?
TAF (Transparent Application Failover) will provide both SESSION failover as
well as SELECT failover. In the former case, the session aborts on the
now-failed server and starts from the beginning on the new node, while the
latter enables user with op
one gotcha -- logical standby is based on logminer techniques. so
anything that logminer can't handle (and there is a bunch, well
documented), logical standby can't handle
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> OK, I'm going to aim a little lower: is _anyone_ using Logical
> Standby?
What is the port? How did you check that it wasn't used?
Which distro, which version of the database?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 02, 2003 2:36 PM
To: Multiple recipients of list ORACLE-L
Hi,
When I am t
AK,
Let me put it this way, from our own
configurations:
Specs.world is an alias(service name) for
database (instance name/db name) BART3 which resides on host BART in SID
03.
Does that help??
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message
Sounds like a duplicated IP or duplicated Service name.
Luis
-Original Message-
Sent: Wednesday, July 02, 2003 12:36 PM
To: Multiple recipients of list ORACLE-L
Hi,
When I am trying to start listener on Linux box ,getting error
TNS-12542: TNS:address already in use
TNS-12560: TNS:protoco
Guys...
I need to find some past threads about security
schemas from develop to production schemas...
How can I find them ?
Do I need to register at www.fatcity.com?
May be some of you can help me with ideas about the
topics that I should take into account when we develop
our security schemas...
According that suggestion you do seem to have redo copy latch contention.
As far as getting that ratio close to suggested value, you may set some special
init.ora
parameters. There is plenty of notes on Metalink for that.
But, you should first determine if this is causing any performance issue. H
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: July 2, 2003 11:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Microsoft VS Oracle (again)
>
>
>
> How do you go about finding MS SQL Server on
> MS Advanced Server?
>
> We have quite few Win2k
I am reading oracle network admin guide and getting
confused abt service name, instance name , db name , sid ..
why service name is not same as db name .
Earlier service name and sid used to be same thing .. isn't it ( ? )
.
Can some one clarify with some examples .
TIA
-ak
OK, I'm going to aim a little lower: is _anyone_ using Logical
Standby? Any tips, gotchas, implementation accounts to share?
TIA
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 p
Title: RE: Re[2]: Online tech books
Good Lord, you can NEVER have too many books!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need
Kirti,
I will kinda agree with your Very Senior DBA. Make TEMP an LMT with uniform
extents, of type temp and with a tempfile & your most likely not to have a problem
there that will have any lasting effect. It's one of those things that you have to
accept end user complaints on to det
Reiserfs' biggest strength is in its ability to deal with directories
with huge numbers of files in a very speedy fashion. Obviously, for
oracle this is less relevant.
As far as the max-readahead option, I don't understand the specific
relevance to fibre-attached storage. I would imagine, tho
Bless you Bob !
I will use your pictures to settle the argument of too many books with my wife! I told
her I reduce my number of books as long as she reduces the number of shoes. She got a
bit offensive.
Luis
-Original Message-
Sent: Wednesday, July 02, 2003 10:11 AM
To: Multiple recip
Hi,
When I am trying to start listener on Linux box ,getting error
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
I checked no process fro listener and no port used by another process.
Let me k
Yeah, it's an asp.net app (you can tell from the .aspx file extension on the
URLs). But the db could be anything...
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 9:16 AM
To: Multiple
That's OK, I know a couple who never heard of optimal and/or "organization index"
either.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 01, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L
I saw a "Sr. DBA" few years ago, who claimed
Title: RE: Automate an update
select case when to_number(to_char(sysdate,'HH24')) between 8 and 16 then 'Window Open' else 'Window Closed' end
from your table
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
I see
the problem. Looks like your file is empty.
;o)
Dave
-Original Message-From: Shishir Kumar Mishra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 02, 2003 5:16
AMTo: Multiple recipients of list ORACLE-LSubject: error
reading file
why not create a view like this ...
SELECT 'Y' AS FLAG
FROMDUAL
WHERE TO_CHAR(SYSDATE,'HH24MI') BETWEEN '0800' AND '1600'
UNION ALL
SELECT 'N' AS FLAG
FROMDUAL
WHERE TO_CHAR(SYSDATE,'HH24MI') NOT BETWEEN '0800' AND '1600';
that would have the flag on and off without an update ..
there are a couple of finer points that are left out...
There are really two versions of TAF that they are talking about here...
1) Session Failover -- it's easy to do, just rebuild the TNSNAMES.ORA file on the
client machine, and create a backup connection. If the connection fails to connect t
After we rolled out our own scripts to monitor TS usage (de-Installing BMC Patrol)
following is a
line from a Very Senior DBA's email sent to us (not-so-senior-DBA-team-members)
yesterday:
"I don't think the script should monitor ROLLBACK or TEMP tablespace for space issues
- these
normally re
Joshua,
How about this:
CREATE OR REPLACE TRIGGER
"SCOTT"."WINDOW_OPEN_TR"
BEFORE INSERT
ON "SCOTT"."ORDER_TYPE"
FOR EACH ROW
DECLARE
l_compare_time NUMBER;
BEGIN
SELECT to_char(sysdate,'HH24')
into l_compare_time
FROM dual;
IF l_compare_
If your Jul is 1st quarter, then your offset is should be 6 months instead
of the 9 months in your email; or think of it another way, if you Jan is the
beginning of the 3rd quarter, it is the beginning of the 2nd half of the
year, and half a year is 6 months.
With this in mind, you really don't n
yeah,
I see that error. really sucks.
-Original Message-From: Shishir Kumar Mishra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 02, 2003 6:16
AMTo: Multiple recipients of list ORACLE-LSubject: error
reading file
FGA/VPD/RLS(*) is not a candidate solution to your problem.
FGA via RLS is more for access control (who has permissions
to see the records) rather than keeping track of who has
exercised their access rights. Oracle's auditing may not
provide the level of detail that you want, so your best
bet is t
Is it possible that other oracle installations have been done with /oracle
as inventory location?
Is there another inventory location specifically for your 920_64
installation?
We have had similar issues with Opatch and as a consequence, we are now
putting inventory location inside ORACLE_HOME.
Monday, June 30, 2003, 10:39:40 AM, you wrote:
BM> I just returned frm vacation, but I wanted to respond to Jonathan
BM> Gennick regarding my collection of books.( I managed to delete that
BM> message) But, Ive taken some pictures of my collection.. Ive actually
BM> purchaced all the books you see!
Fine grained access control doesn't tell you who did what, it restricts
users from doing certain things.
If you want to just capture the changes, not the actual update
statement, you can do this via triggers which insert into a copy of the
table, with the additional columns of timestamp and user
Are we forgetting that your current schema is SCOTT
??
comment that line, and then try running the procedure
...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strict
> what would happen if Hogwarts taught Oracle Tuning using
> wands & spells ;)
Isn't that how Oracle Education does it? Alomahorabuffercachehitratio!
Gudmundur
Þessi póstur var sendur með vefpósti mi, http://www.mi.is
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Autho
Do window_open's values depend on the time the record is inserted, or the
time it is retrieved? If the former, you could do it in a trigger. If the
latter, you could make window_open a calculated column in a view.
What are you using for a user interface--oracle forms, sql*plus, java,
vb...?
HTH
How do you go about finding MS SQL Server on
MS Advanced Server?
We have quite few Win2k/NT servers around here:
no mention of MS SQL in the register, and it's
not on the program menu.
Jared
On Tuesday 01 July 2003 13:10, Goulet, Dick wrote:
> Well, I'll be a little more forgiving than Raj
The divination class does use a book called "The Dream Oracle". :)
-Original Message-
Sent: Tuesday, July 01, 2003 7:21 PM
To: Multiple recipients of list ORACLE-L
Not a problem, Cary :)
I was pleasently surprised to see Chris Lawson's new book at Borders. Did a fair
amount of reading
Hi Listers,
The below procedure gets created successfully in TEST
Schema. But when I execute the
procedure by starting a fresh session connecting as TEST schema I get the below
error and when I execute the procedure for the second time it executes
successfully. I have granted the dba
Has anyone read the articles? One point states that failover for RAC
requires coding changes to take advantage of it. Not from the demo I saw.
HPaq (or whoever they are these days) took a circa '99 Oracle test GUI
called Oracle Workload Generator and got failover to work with only changes
to the
generally, but not always if the first thing someone tells you about themselves or the
first justification for doing something is their years of experience, that person is
probably a novice.
alot of people assume that just because they have been doing something for a while
they have been doing
Hi,
Anyone has experience with OPatch tool? While applying a patch using OPatch,
I have error saying "Can not set up OUI inventory session". Any idea?
Thanks.
lostdog:oradv2 5% opatch apply
PERL5LIB=/oracle/DV2/920_64/Apache/perl/lib/5.00503; export PERL5LIB
/oracle/DV2/920_64/Apache/perl/bin/perl
> As long as you are using bind variables,
> the overhead of multiple executes should
> not be very high.
It's all a matter of degree. On several trace files I've analyzed lately,
the whole response time problem was caused by thousands of 'SQL*Net message
from client' calls. They had nice little l
Title: RE: fine grained access
auditing triggers will do a fine job than FGA. Simpler ... easier ..
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD:
When I create database under 9iR2. supposely I should
run following two SQL files by
"system", but I run it by "sys":
$ORACLE_HOME/sqlplus/admin/pupbld.sql
$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql
my questions are:
1. do I need remove those objects from "sys" which
create by those two
You don't need CASE.
try :
to_char( date , 'Q')
George
> Hello ALL,
>
> I am trying to find quarter number from a given date . Here is the
> description
>
> Our Financial year runs from July thru June. So, Given any date between
> these dates I need to find 3 quarters(9 months) from it.
> July
This may be complex but I think can work
,
create a payload in advanced queue with delay=8hrs
( or whatever ). run a job(immediately..no future timing) which listens to
this advaced queue . As soon as job gets the event in queue (after 8hrs) it will
update the column based on logic ( if time
1 - 100 of 129 matches
Mail list logo