Hi Imran,
Instead of alert, you can try to display a web page with the message
"...incorrect data, continue?" and Yes and No button.
Hope it helps.
Regds,
Catherine
This communication (including any attachment) is meant only for the
recipient(s) named above and may contain confidential or lega
Hi,
We have 8.1.6.0 installed on a NT server. There are 2
databases(development of size 120MB when FULL export is done) already
running on the system. Now our requirement is to install 8.1.7.4 and
bring one of the DB into this environment.
My plan of approach is as follows, any feedback, comments
Bala Regupathy,
I suggest you to use shell script and cron. NFS can do it, but if your
alpha is down then your primary sun will be in trouble. And use standby to transfer it
to another machine is not some good idear,especially when you target is a different
operation system.Maybe
Krishna Rao Kakatur,
You can try bbed(password blockedit).
Regards
zhu chao
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
=== 2002-12-10 16:00:00 ,you wrote£º===
>Hi,
>
>Could you please suggest me how to corrupt a data file, for testing r
We were testing a small script that calls
DBMS_APPLICATION to set the module and action.
Most of the time we did not see the results
in V$SESSION. We added a dbms_lock.sleep to
make the script run a little longer.
What was happening was BOTH SQL*PLus and TOAD
seem to update the program (and DBMS_A
(stumbling out of my lurker corner)
Several years ago on a AIX Oracle 7.3 project, a co-DBA was tasked to do
some performance testing for something similar, I saved his results.
YMMV. Good luck.
Method KB/Sec Notes
-
Hi Hemant,
Thanks for the tips.
Does anyone know whether SNP process .ie. DBMS_JOB will degrade the database
performance ? Please advise. Thanks.
Regds,
New Bee
This communication (including any attachment) is meant only for the
recipient(s) named above and may contain confidential or legally
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/dfiles.htm
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 09, 2002 5:24
AMTo: Multiple recipients of list ORACLE-LSubject:
Increase size of data files and rollbac
Title: RE: Oracle 9i installation - Basic Qs - HELP!
How
comfortable with perl are you? I think you could put together a
quick perl daemon that could query your local archive directory every few
minutes and then copy new files to your alternate host via nfs mounted drives or
ftp if you are
Title: RE: Oracle 9i installation - Basic Qs - HELP!
One of
the requirements stated in the Standby Database Concepts and Administration
Manual is that... "You must use the same version and release of an operating
system on the primary and standby hosts. The standby host can, however use
a d
Hi,
We are having a
full tablescan issue with query used by DBMS_AQ.deque procedure and as per
John's recommendation I am playing with outlines to fix this issue. Since this
is an internal query I do not have the exact text of the query . So I was trying
to create the outline and when I ex
David,
As a start, look up the following commands in the SQL Reference guide:
alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize
20480M;
Read up on the implications of autoextend and whether you want it
alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.
Solaris' kernel parameters are a lot simpler that HP's. Practically all of Solaris'
parameters are dynamic, whereas on HP, you need to do a fair bit of tweaking.
A good example is the need to allocate memory available to Oracle, so you can size the
SGA accordingly. Chances are, you will need se
Hi,
There are a few options available - other people have already suggested
replication, etc.
I think the decision depends slightly on data volume and personal
preference:
* Certainly I have been in situations where database links are used to both
pull and push data from one database to another.
Hi,
Could you please suggest me how to corrupt a data
file, for testing recovery.
I am trying to test Block Recovery with my Personal
Oracle 9i on Windows Me. I am not able to open or overwrite the files because
oracle.exe locks them.
Thanks, Krishna
Title: RE: OT: Guidelines/Standards for supporting non-oracle
You need a corporate data administrator nazi-type technocrat... A "data administrator" god not a mere database administrator dweeb. :-) Here's a long quote from a Tom Cox article:
--
"The Data
Title: RE: OT: Guidelines/Standards for supporting non-oracle
Hi,
I've made a lot of money over the years fixing Access databases as a consultant. They usually called me after being painted into a corner with a non-normalized, Excel spreadsheet looking thing. I have to diplomatically tell t
"Technicolor yawn"
The memories...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
-Original Message-
Sent: Tuesday, December 10, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
I
Unfortunately, the ACCESS virus has been let loose in my company.
The main production Oracle database consumes about 150GB.
The total sum of ACCESS files in now at 200+GB & growing at a faster rate
than the Oracle files.
The users spend a LOT of time trying to reconcile differences between
various
Yeah, I'm a closet/pseudo Aint's fan. If the Pack loses for the
Big One, they're my second choice. Now if they just hadn't given up Ricky,
they'd be set. But I digress:
As I re-read my original message, it doesn't make sense (I'm 0 for 2 today).
What I should have asked is "Do you have multip
Title: RE: Oracle 9i installation - Basic Qs - HELP!
Well,
one of us is probably wrong not sure which. But, I thought that , as
long as the file structures are the same that there should not be any difference
in an archive log for one OS over another.
Since
you are coming from Solaris
Title: RE: arc destination odd behavior
Hi Rich -
Nope. It's 1.
Can you believe I even forgot to watch the game on Sunday. I can always cheer for the Bucs, lots of ex-Vikes :) "Death before losing a game"
Have a great night, all.
Lisa
-Original Message-
From: Jesse, Rich
Hey Lisa,
Is the value of log_archive_min_succeed_dest > 1?
Rich
p.s. I guess they really are Bloody Vikings. Hey, there's always next
year... :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Or
Title: RE: Oracle 9i installation - Basic Qs - HELP!
In
other words, I would like to simulate the behavior of
:
log_archive_dest_2 = 'SERVICE=PRODSB REOPEN=30'
using
unix/sql script.
Bala.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ba
Title: RE: Oracle FM interpretation of locking behavior
I like the term "liquid laughter" better.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Jeremy Pulcifer [SMTP:[EMAIL PROTECTED]]
> From: Jesse, Rich [<
At 01:15 PM 12/10/2002 -0800, [EMAIL PROTECTED]
wrote:
Hi,
We are virtually an Oracle shop with 2-3 sql server databases due
to
3rd-party software restrictions.
We have been asked about supporting other "small" databases
such as
Access,etc within our company. My question is if
you were asked to
Rick,
I would consider defining small based on something other than size.
eg perhaps some combination of:
small means less critical (ie small business loss if data is unavailable or lost
forever)
small means small number of concurrent users
small means don't need extremely quick response times
Rick,
Similar situation over here as well. The party line on Access and other
similar projects is "you are on your own.". Seems to work pretty darn well.
Hasn't stopped them and it keps the fires out of here.
Dick Goulet
Reply Separator
Author: [EMA
You must use the same
version,
release, and patch of
the
Title: RE: Oracle 9i installation - Basic Qs - HELP!
Kevin,
I
thought the pre-requisite to create a standby database is it should have
the same OS level and Oracle version as primary. Am I wrong
?
Bala.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
Hi,
We are virtually an Oracle shop with 2-3 sql server databases due to
3rd-party software restrictions.
We have been asked about supporting other "small" databases such as
Access,etc within our company. My question is if
you were asked to support "smaller" databases what
restrictions/guidelines
Title: arc destination odd behavior
Hi all -
8.1.7.2, Windows 2000 sp 2
I'm working on my backupexec implementation. For some odd reason the backup job that copies the arclogs to tape and deletes them off the disk (what BE calls an 'archive' job) wants to delete the directory too. Somet
There is a parameter to tell the archive process to ignore errors on
secondary locations and to proceed normally if one succeed.
as it is 23:00 here, I do not remember the exact parameter.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
Title: RE: Increase size of data files and rollback segments
> From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
>
> Alright guys, just because you know Jeremiah better than me
> so you can take
> his joke.
I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed
Title: RE: Oracle FM interpretation of locking behavior
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
>
> my ribs are still tender from repeated reverse peristalsis.
>
Remember the good ol' days when we just called "barf" "spew"?
If security policy allows, and you don't have any religious convictions
against doing it, you can put a .rhosts file in the home directory of the
target user/box that will allow you to use rcp on the source box. Be sure
to set the permissions to 400 after creating it.
If you can't do this, anoth
Oh yeah. I forgot to say, if you create a script with a password in it, be
sure to change the permissions so nobody but you can read it. For example
chmod 700 (or 500) script_name
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
F
Title: warehouse builder's dependance on oem job system.
no we
aren't using workflow. last time i checked, that was very buggy too.
i.e. the dependancies could not be verified so all the jobs executed
regardless of whether or not the conditions of execution were met. i could
be wrong abo
Bala,
Could you not have the second archive destination as the Dec server
location? Or can you nfs mount a directory from the Dec onto the Sun and
use that as the second archive location.
Keep in mind of the ramifications if the second destination is
unavailable, I believe that the system will con
Yes, it does answer my question. And it should have been easy enough for me
to test if I had been *thinking*.
I'll blame it on me being sick yesterday and still not in the right frame of
mind, and my ribs are still tender from repeated reverse peristalsis.
Thanks, Robert! :)
Rich
Rich Jesse
Alright guys, just because you know Jeremiah better than me so you can take
his joke. My apology to him as I did not recognize it was a joke, however
when I am asking for help from the group, I am in a situation to resolve
problem ASAP and hope to find a answer not a joke.
If you were in my situa
Title: RE: Oracle 9i installation - Basic Qs - HELP!
And
what is the problem with having a standby DB on a different OS than the primary
???
-Original Message-From: Bala Regupathy
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002
2:06 PMTo: Multiple recipients of li
Title: RE: Oracle 9i installation - Basic Qs - HELP!
Hi,
How
can I archive redo logs automatically to a different machine ?. Standby
database is not an option because the target machine's OS is different from the
primary.
Primary db is 8.1.7.2 resides on SUN E10k with SunOS
5.8.
Targe
hello all,
Is there anyone who has written a front end(unix is all i'm looking at now)
for using RMAN?
I've got a ~50 shell script framework written for doing RMAN backups
to/from disk, catalog maintenance, control file backups, archive log backups,
some of the report commands.
I'm loo
And if the table already exists, look to disable the constraint, and then
enable them after the import.
Raj
"Yechiel
Thanks, I had to drop off the Lazy DBA list because of all the sniping. I
would hate to have to drop off Jared's list too.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 1:20 PM
> 1) he's reading the list while tr
Title: warehouse builder's dependance on oem job system.
after
reading this over again, i'm not sure i was very clear on
this.
to
paraphrase:
does
anyone know a way to schedule runs of owb generated code without the use of
oem?
thank
you very much for any help.
-Original Messa
Title: warehouse builder's dependance on oem job system.
You may
have implied this in your message, but are you using Oracle Workflow in
conjunction with OEM? That is the
scheduling method that is taught in the OWB class by Oracle.
I am
currently learning OWB but have not setup sched
Walt,
Your french is pretty good !
--- "Weaver, Walt" <[EMAIL PROTECTED]> a écrit : >
Au contraire, I welcome Jeremiah just about
> anywhere, as long as he doesn't
> drink too much of my beer.
>
> Read between the lines, David. There's a message
> there. :>)
>
> --Walt Weaver
> Bozeman
Title: RE: Increase size of data files and rollback segments
ORACLE ORACLE ORACLE ORACLE SQL*NET
Just bringing it back on topic :)
Nick
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:21 AM
To: Multiple recipients of list
Title: warehouse builder's dependance on oem job system.
Chris,
All
the owb etl jobs are packages and if you have configured it right, then you
could the execute the package_name.main procedure to run the etl process. your
best best would be to read the tcl script and the associated paramet
You can define your own exceptions in the declare section, then RAISE that
exception.
> -Original Message-
>
> I want to trap the case where either no value for i_runcr is
> specified at
> runtime (and thus the assignment should be NULL) or a
> non-numeric character
> is specified (e.g
Title: RE: trapping errors from assignment of SQL*Plus Input Variables
this
was the right direction -
I
changed the assignment line to this:
v_runcr := nvl(to_number('&&i_runcr'), 0);
and it catches the 6502 (numeric or value error) quite
nicely.
Thanks, Lisa!
-bill
-Origina
Title: RE: Oracle 9i installation - Basic Qs - HELP!
Guys,
I followed the instructions but still got:
Xlib: connection to "clientip:0.0" refused by server
Xlib: Client is not authorized to connect to Server
xhost: unable to open display "clientip:0.0"
I think I am mis
I welcome David input always, especially when he is yanking the leg of
someone who did not troubled himself to open the SQL manual and look at
obvious commands like alter rollback segment and alter tablespace.
I liked his answer.
BTW, Please do not tell ANYONE on this list to shut up.
It is bad b
Maybe you can do this:
1) imp index=n constraint=n
2) imp ignore=y rows=no
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 11:58 AM
> Hi all,
>
> I have dump files (1 table 1 dump file, dump filename
1) he's reading the list while traveling
2) I'm having dinner with him tonight I'll tell him
:)
--- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> Stop fighting children, or I will have to tell Daddy Jared when he
> gets
> back. Ruth
> - Original Message -
> To: "Multiple recipients of
If I understand what you are asking, a simple test
will tell you.
>>> Session A
SQL> create table t2 (x number);
Table created.
SQL> insert into t2 values (1);
1 row created.
SQL> insert into t2 values (2);
1 row created.
SQL> commit;
Commit complete.
SQL> update t2 set x=4 where x=1;
1
Shiva,
I think, your problem is not in using "print" command, but in
using network devices.
Batch file called from java stored procedure is executed using
NT account being used by OracleService.
Usually, OracleService runs under SYSTEM account,
which can not have any "network" privileges wh
David,
Wrong. we very much welcome Jeremiah here. He has helped countless
people on this list, and if he on occasion chooses to make a joke (as
do we all), then so be it.
He was a good deal gentler and nicer than my first thought, which was
to tell you to read the fine manual before asking basic
Title: RE: trapping errors from assignment of SQL*Plus Input Variables
Well, seems to me the script won't execute unless A value for v_runcr is specified, or v_runcr is defined in the sqlplus environment prior to execution. Now, numeric or not, sqlplus doesn't care, of course. In the anon bl
Title: RE: trapping errors from assignment of SQL*Plus Input Variables
yes -
would it matter?
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002
1:05 PMTo: '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'Subject: RE: trapping errors from
For those that require a GUI interface, look into Tora. Runs very nicely on linux,
and I believe
there is a Winders version too.
BTW, yes I am a command line guy, but sometimes the boss wants to see pretty pictures.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncov
Title: RE: Increase size of data files and rollback segments
Au
contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink
too much of my beer.
Read
between the lines, David. There's a message there.
:>)
--Walt
Weaver
Bozeman, Montana
-Original Message-
Speak for yourself, man. I think the type of people we don't welcome
here is those who don't bother to read a doc on something as trivial as
how to increase the size of datafile and can't take a joke.
Richard
-Original Message-
Sent: Tuesday, December 10, 2002 10:50 AM
To: Multiple recip
Title: RE: trapping errors from assignment of SQL*Plus Input Variables
Bill, is this an anonymous block you are talking about?
Lisa Koivu
Oracle Diaper Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Magal
Title: RE: Increase size of data files and rollback segments
What bothers me is why can't you use sqlplus? Why do you need GUI tool?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion ex
Title: warehouse builder's dependance on oem job system.
ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for
Stop fighting children, or I will have to tell Daddy Jared when he gets
back. Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 12:15 PM
> I disagree! I do welcome Jeremiah's input on this list. David, I think
you
Title: RE: Increase size of data files and rollback segments
I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message.
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10
Govind,
Large indexes would tend to be 'taller'. However, I believe you can achieve
a flatter structure for the same index by using a larger block size. If you
are on 9i (any release?) then you could probably create new tablespaces with
larger blocksizes and recreating these indexes therein. Not
David,
If my three year old said that, he'd be "on the step" immediately. Jeremiah
has helped a lot of people on this list. The point is that you need to take
a certain amount of responsibility to do some research before posting a
question (i.e. metalink, tahiti.com, ...). Also, all answers should
Title: RE: RE: a PL/SQL design question.
I'd like to add a point here as well...
Because DBMS_JOBS are asynch, ie not transaction bound and not read-consistent, by design they should not be allowed to be fired from triggers or other event-driven mechanisms _if_ they are to accomplish some tr
Title: RE: Help Urgent Where is Tablespace Manager??
Back to my roots.
-Original Message-
From: Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help Urgent Where is Tablespace Manager??
We sto
Is there any way to trap errors from the assignment of a SQL*Plus variable
to a PL/SQL variable?
I have this in my executable section:
v_runcr := &&i_runcr;
(v_runcr is declared as a number)
I want to trap the case where either no value for i_runcr is specified at
runtime (and thus the assig
Gurus
I am still
struggling to print text files to a network printer. I have tried various
options to issue a print command through batch file.
my batch files
are
test1.bat
print
/d:\\myprinterserver\myprinter c:\myfolder\myfile.txt
test2.bat
net use lpt1: \\myprintserver\myprinter
hi,
i have a web application developed using Web
Application Server tool kit. The form is dynamically
produced by calling a package/procedure www_aaa.
I have very little knowledge of this but have been
given a small job to do on it.
The user enters some data on the form then hits
'Submit'. The
Gurelei
According to Note 116310.1 on Metalink, you probably created rbs01 as a
locally managed tablespace. You need to ensure that the extent size
specification in the tablespace is at least 4 times the db_block_size. For
most objects, the minimun uniform extent size is 2 database blocks, RBS
r
Title: RE: Help Urgent Where is Tablespace Manager??
OEM
had the tablesapce manager in it. Its called the Storage Manager
now. Maybe that is where the mixup is ?
Run
oemapp by itself. It will tell you which applications are loaded. If
you have loaded it, you should see STORAGE in the l
Hey all,
After converting three columns on a multi-million row table from NULLs to
SPACEs, the devs found one other program that pops NULLs into those columns
(sigh). So, with only 150 rows needing updating, my knee-jerk reaction was
to do a simple:
UPDATE mytable
SET mcol1 = ' '
Jeremiah,
I am seeking for help. If you are not willing to help then just SHUT your
mouth. I don't think we welcome such people like you here.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David
Denham,
To find the idle time for a user can be difficult with a script. If
you query the v$session you can get the STATUS and LOGON_TIME and
calculate the difference from current time, But that does not tell you
when they became inactive. They might have run a query that ended 20
minutes ago or 5
Title: RE: Help Urgent Where is Tablespace Manager??
We installed OEM on a Linux box ... far away from all production boxes ... works great ... that box only has the OEM installation.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Raj
We stopped using it for the same reasons, plus the fact that we had multiple Oracle
Homes on our cluster - which confused OEM.
Where is tablespace manager -> just type "sqlplus"
Jay
>>> [EMAIL PROTECTED] 12/10/02 09:04AM >>>
Paula,
I am using DBA Studio as a stand-alone product - not using th
I think the logic is wrong.
You could build the fact table first and then add lookup tables and the
constraints.
You have to know your data and order it by hand.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, December
We run both HPUX and Solaris systems here. Quite frankly the HP systems
give us less problems that the Sun systems. What you are getting
from the vendors is exactly what you called it "FUD".
Rodd Holman
On Tue, 2002-12-10 at 00:08, hkchital wrote:
> We are considering implementing a number of n
Is it Certified ?
For Setup & Performance Tuning - Any Links , Docs ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing lis
See Note #1068369.6 on MetaLink.
Hemant
At 01:28 AM 10-12-02 -0800, you wrote:
Hi Gurus,
If you need to copy data (after some manipulations) from database A to
another table in database B, how do you achieve that ?
Our current practice is to use crontab (schedule daily job) and sqlplus
(proced
Are you using LMT for the tablespace and if so what size extents?
I have had that problem when I have defaulted the LMT extent size to 64K (by
accident) and I have tried to create extents at 1M
HTH
John
-Original Message-
Sent: 10 December 2002 14:14
To: Multiple recipients of list ORACL
It is true that you need to check your kernel parameters before
installing and creating databases. Read the readme's and install docs
completely first. Also as you have done search metalink for
installation on HUPX 64 bit.
Once the parameters are set, installation and db creation goes along
quit
Most likely, you will have to run the imports to get the data and the
primary keys. Then run them again with ignore=y and rows=n to get the
foreign keys.
>
> My problem is with referential
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMA
Denham - I'm going to make a guess here and someone will probably correct
me. How about
select sid from v$session_wait where event = 'SQL*Net message from
client' and seconds_in_wait > 1800
You can join to other tables like V$SESSION to get more information.
Dennis Williams
DBA, 40%OCP
Lifet
Simple.
run statsdrp and statscre.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 6:14 PM
> Hi
> How to clean all old STATSPACK data?
> Thx
> -Seema
>
>
>
>
>
> __
Title: RE: RE: a PL/SQL design question.
Dear Richard,
These are a bunch of developers who think they are "GOD" (at-least their managers think so) ... we have learned that it is better to let them try and fail themselves rather than trying to explain them the right thing ... it works all the
On NTFS there is an allocation unit and the Os gives space in multiple of
allocations units which is 4k or 8k.
So if you use bfile you will waste 3k for each file, increasing your disk
space by 60%.
I am not sure about the size of the allocation unit.
Please verify this with your sysadmin.
Yechie
DBMS jobs are good things for stuff that can occur totally within the database
and on a scheduled basis only. It sounds, RAJ, like your developers made a real
mess. What would have been a better idea would have been to have the trigger
update a table that the job on a scheduled basis checked for
Title: RE: AQ query from dequeuw procedure not using index -URGENT
When a hint is in your code it will
automatically use the cost based optimizer, even if you have the database
or session is set to RULE. Therefore you will need stats
collected. If you still have problems then look over thi
Well, no. However, my organisation's policy is to stick with the Big-Unixes --
Linux is not on our radar screen [though some of us, me included, do now
want to start putting a few databases on Linux to see how well Linux can
handle them, and we can handle Linux].
Hemant
At 03:58 AM 09-12-02 -08
Title: RE: AQ query from dequeuw procedure not using index -URGENT
When a hint is in your code it will
automatically use the cost based optimizer, even if you have the database
or session is set to RULE. Therefore you will need stats
collected. If you still have problems then look over th
Denham,
How about using status='INACTIVE' and last_call_et > 30 minutes?
Regards
Raj
Denham Eva
1 - 100 of 120 matches
Mail list logo