I saw a Sr. DBA few years ago, who claimed he had worked with Oracle since
V4.0, and he didn't have a clue what PCTINCREASE is...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 11:51 PM
What about ones that you don't
Cannot tell for sure. Maybe - but there are lots of
other queries with FTS executed thoughout the week.
There appears to be no change to x$bh for these table
blocks (including buf#) .
-Ravi.
--- AK [EMAIL PROTECTED] wrote:
Did u do a full scan of table again after nocache
setting ?
-ak
Title: RE: Do Not Call
Hey, yeah, it COULD have been a LISP Eliza...!
-Original Message-
From: TOMPKINS, MARGARET
To: Multiple recipients of list ORACLE-L
Sent: 7/1/2003 4:40 PM
Subject: RE: Do Not Call
Yeah. It was either that or a Turing machine. Maggie
-Original
- Original Message -
Any comments?
Yes. got that one last year. Still got it.
Installed the doco in my PC at work so I could
read it in peace and quiet (!). Installed the s/w
as well so I could play with it.
Went straight to their recovery manual. Basically,
it reads like this:
After fix this problem. I am done with this. LEARN PERL.
[EMAIL PROTECTED] wrote:
Learn Perl and forget this ugly MS batch stuff.
It's such a kludge.
Seefelt, Beth [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/01/2003 02:49 PM
Please respond to ORACLE-L
To:
Historically, two values of PCTINCREASE were practical:
0 - keep same extent size
100 - double extent size
Have Fun :)
Gaja Krishna Vaidyanatha wrote:
Greetings,
Non-zero PCTINCREASE causes unnecessary free space
fragmentation in your tablespaces and should be
avoided. Especially in
Not a problem, Cary :)
I was pleasently surprised to see Chris Lawson's new book at Borders. Did a fair
amount of reading
(3 chapters), while waiting for Harry Potter's book to go on sale by 12:01 AM on June
21! (also,
wondered what would happen if Hogwarts taught Oracle Tuning using wands
MetaLink Bug 2458246 (fixed in 9.2.0.2)
DENNIS WILLIAMS wrote:
Offhand it sounds to me like you may have uncovered an error. I would search
metalink and if you don't find an error matching this situation, I would
file a TAR.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Thanks Tanel,
All of the resetlog_change#'s where the same. The problem has been
resolved, with 2 likely sources. The disk mirror set on the affected mount
points were completely rebuild, and (my mistake) we used a backup
controlfile instead of a copy of an active one to recover. I could have
Von: Goulet, Dick [mailto:[EMAIL PROTECTED]
Frank,
I've not done dll calls from Oracle as well, we use
HP-UX and Linux, which I believe is much simpler. Anyhow,
along a similar lane, here's a snippet of extproc C code that
I've written to run an SQR from a PL/SQL call:
char
I have a few databases in Home0 and a few in Home1 and need to move one from
Home0 to Home1
So if I understand correct I can do:
Oradim -delete -sid SID
Remove the entries that look like
ORA_SID_AUTOSTART
ORA_SID_SHUTDOWN
ORA_SID_SHUTDOWNTYPE
ORA_SID_SHUTDOWN_TIMEOUT
From Home0(if not done by
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?
Anyway, even if it would run correctly, I wouldn't use it anywhere else than
during one-time migrations
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 that your distribution has support for it.
I acutally work with oracle ever since the version 4.1 (IBM PC/XT, 512KB
RAM)
but
a) I've never worked with 4.0
b) I know very well what PCTINCREASE is.
Conclusion: Tanel, it wasn't me! I swear!
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original
Hi all,
I need help in order to create a following "mechanism".
I have a table where is a column called window_open and it has two values 'Y' and 'N'
Now I need to automate the update a single row based on following rules:
If time is between 08:00-16:00 the value on that window_open column
you mean we don't tune Oracle using spells, incantations and prayers?
Dang, I knew I was doing something wrong!
--- Kirtikumar Deshpande [EMAIL PROTECTED] wrote:
Not a problem, Cary :)
I was pleasently surprised to see Chris Lawson's new book at Borders.
Did a fair amount of reading
(3
not a guru Chris? me thinks you sell yourself short. i like both solutions
- very nice and TMTOWTDI!
and Tim's coming soon to a module near you: execute_array() was nice too ;)
hopefully that answers the original posters question.
-Original Message-
Sent: Tuesday, July 01, 2003 6:05
Hi,
If you are looking to populate this table with the y/n value based
on the time, you could just create a job (oracle/cron) to update the
table with the appropriate value when the time changes over. That
would be the simplest way, but maybee not the cleanest.
HTH,
Joe
--
Joe Frohne
Rawson
Title: Message
snip
http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
Well, if it were unix then it couldn't be SQLserver. It is Windows,
therefore I assume its SQLserver, but it could be Oracle. But who runs
Oracle on Windows anyway *hahahaha*
... We do
...
Thanks to all who replied. Especialy thanks to Seefelt. This solution
works. except errorlevel 1 is not a match.
Thanks again!!!
Joan
Seefelt, Beth wrote:
That actually makes it alot easier
FOR /F tokens=1-5 delims=/, %%i in ('date/t') DO SET MMDD=%%j%%k
if NOT EXIST
Joshua,
To update existing rows you could do something like:
update x set window_open = 'Y'
where to_char (time_field, 'hh24:mi:ss') between '08:00:00' and '16:00:00';
Similar for window_open = 'N'. Create a trigger to deal with future inserts.
Gudmundur
Þessi póstur var sendur með
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 -Sep - 1st Quarter
Oct -Dec - 2nd Quarter
Jan -Mar - 3rd
Hello ALL,
Do you guys think we have redo copy latch contention ?? Also what are your suggestions
on tuning Redo Copy Latch ??
SUBSTR(LN.NAME,1,20)GETS
MISSES IMMEDIATE_GETS IMMEDIATE_MISSES
Title: RE: Oracle DBA 9i Books ever needed.
The Oracle school of Witchcraft and Wizardry
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
What our security officer wants is that he can see
who changed something in those tables
Sounds more like auditing than FGAC.
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
--
Author: Gudmundur Bjarni
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
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 -Sep
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 sql
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.
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
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
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
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
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
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
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
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...?
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
--
Author:
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
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
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!
BM
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.
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
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
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
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_time
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
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
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
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
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
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 he
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
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
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
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,
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
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
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
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
-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/NT servers
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.
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
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:
AK,
Let me put it this way, from our own
configurations:
Specs.world is an alias(servicename) 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-From: AK
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
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? Any
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
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
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]
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
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 currently in
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
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
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,
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))
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
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:
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:
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
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 testing it.
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 AM
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
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 Failover
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
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:
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 withODS.
I've
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
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
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 ...
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'
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
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
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
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 identified by 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
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
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
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
1 - 100 of 126 matches
Mail list logo
