Perhaps we depend to much on the force to guide and protect us at times...
:-)
Laugh you may, but in the last UK census (not a poll mind you but the actual
national census) 400,000 people indicated their religion was Jedi. This
was more than put their religion as Sikh, Jewish or Buddhist.
Of
Dear list,
Have any of you every experienced MV's not refreshing
for no particular reason?
We have been using some simple MV's for several months
with no problem. Now after upgrading our app and database,
there seem to be problems.
Servers:
Master: Win2k SP2 Oracle 8.1.7.4.1
Slave: NT
It's one of those oracle processes that for instance takes care of jobs in
the job queue.
They can be killed on oracle level w/o problems (8.0.5 at least). Test it
first in test environment
Jack
-Original Message-
Sent: dinsdag 25 februari 2003 8:04
To: Multiple recipients of list
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
LOL
Thank you Stephen ... I needed that laugh.
Ciao
Fuzzy
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Stephen Lee
Sent: Wednesday, February 19, 2003 21:44
To: Multiple recipients of list ORACLE-L
Subject: RE: GR OWS
A good website
Not true. This isn't a list for urban myths - if you're going to go
off-topic, you could at least do it accurately. :-)
http://www.statistics.gov.uk/cci/nugget.asp?id=293
Sikh - 336,000 people.
Jewish - 267,000 people.
Buddhist - 152,000 people.
Jedi was classified under 'Other religion' along
Useful white papers and articles on www.nyoug.org under presentation link.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: RE: Third Party Application Madness
That's the situation I'm in now, but the
language is Hungarian.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?
-Original Message-
From: Odland, Brad [mailto:[EMAIL
A little more digging:
http://www.statistics.gov.uk/census2001/profiles/commentaries/ethnicity.asp#
religion
At the time the Census was carried out, there was an internet campaign that
encouraged people to answer the religion question Jedi Knight. The number
of people who stated Jedi was 390,000
Try:
alter session set sql_trace = true
then you're update both with and without the trigger
enabled. This will show the statement(s) that are
causing the delay
hth
connor
--- Basavaraja, Ravindra
[EMAIL PROTECTED] wrote: Hi,
I have an update statement that affects 1 record in
a
0 was next line. Wasn't 4 Forward and 5 Back? I've CC'ed Michael
Möller, who writes DSI (Data Server Internals) classes in Oracle
Development. He taught me all I ever needed to know about the EDT editor
on VAX/VMS. He really should be able to remember all those wonderful
keys. Yes, it was
It's parameter substitution.
Use the first one if not null, otherwise use the second.
Try this:
TEST=${ORACLE_HOME:-NOT SET}
echo $TEST
Now try misspelling ORACLE_HOME
TEST=${ORACLE_JOME:-NOT SET}
echo $TEST
In a script you may have to begin the line with a colon.
e.g. :
Answer1: ROOT # man bash
Answer2(copy paste form answer1)
${parameter}
The value of parameter is substituted. The braces are
required when parameter is a positional
parameter with more than one digit, or when
Title: RE: How long to hold onto old Oracle CDs?
It figures. We're one the largest accounts Oracle
has got. Heck, Oracle has two people at HQ that
deal with nothing but GE business units, and I
STILL can't get 7.3.4, 8.0.5 or 8.0.6 for NT.
Even my dedicated account rep struck out getting
Dear list,
Have any of you every experienced MV's not
refreshing
for no particular reason?
We have been using some simple MV's for several
months
with no problem. Now after upgrading our app and
database,
there seem to be problems.
Servers:
Master: Win2k SP2 Oracle 8.1.7.4.1
Slave: NT 4
Seems to be different queries to me:
select count(case ... ) into count1,
count(case ... ) into count2
from isi.nametag
suggests a full scan on isi.nametag whereas the two
separate queries:
select count(*) from isi.nametag where geneid=geneid1
select count(*) from isi.nametag where
Hello Sinardy,
Tuesday, February 25, 2003, 3:28:42 PM, you wrote:
SX Hi all,
SX Can someone help me understand this...
SX ROOT # TEST=${2:-.}
SX ROOT # echo $TEST
SX ROOT #.
SX what is 2:-.
The construction ${A:-B} is just like oracle nvl function. If variable
A is defined and not null then
look into man page eg bash or sh and search for ${ (is type in /\$\{ )
and find all necessary details.
lol
Apologies for any typing mistakes I failed to notice.
Markus Reger
Oracle Applications DBA
Webmaster
MBC
University for Music and Performing Art
Vienna
[EMAIL PROTECTED] 02/25/03
hello to everybody
recently a security breach was detected with OpenSSL - the password of a
user could be decoded within hours, the bank account was robbed - but
just for testing purposes -
has anyone ever heard about a similar problem regarding to oracle ssl.
we use it and i couldn't find a
Probably a little obvious, but what do you get when
you slap a trace on the refresh job (on both source
and target db's) - do you see any attempt to read rows
from the mview log at all? any updates being attempted
on the target?
hth
connor
--- Jared Still [EMAIL PROTECTED] wrote:
Dear list,
Not true. This isn't a list for urban myths - if you're going to go
off-topic, you could at least do it accurately. :-)
http://www.statistics.gov.uk/cci/nugget.asp?id=293
It would seem you have the definitive source.
However, I wasn't just repeating something I heard down the pub. I was
Actually Peter,
This came under the category of No Religion which had 9+ million people in
it
(15.5% of respondents, see below).
About sixteen per cent of the UK population stated that they had no
religion. This category included agnostics, atheists, heathens and those who
wrote Jedi Knight.
You're right, it is obvious, but I hadn't yet done it.
The thought had occurred to me to do this at both nodes,
but I think lack of sleep has dulled my senses a bit and I
forgot to do it. All the work involved in repeating myself
in the TAR maybe, I dunno.
I've dropped and recreated the
http://www.theregister.co.uk/content/53/29419.html
Regards,
Pat.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
Title: RE: security alerts #48, 49, 50, 51 - patchsets, 9i
Here
is an article on this topic.
http://www3.gartner.com/DisplayDocument?doc_cd=113293
Regards,
Pat.
No errors, no trace files. Refreshing via refresh group or
directly via the snapshot both failed to update the MV.
They've since been recreated and are working at the moment.
I'll slap a big ole note on my forehead that says 'run a trace on
them stupid!' so I will remember to do so if these
You would have to verify what version of SSL.
http://www.theregister.co.uk/content/55/29423.html yesterday posted a notice
that the experiment was with an older version of SSL.
It could be that iAS and other Oracle products are still using that version,
I know they were way behind in the Apache
And there is no such thing as an 'unofficial' religion. It's just whether
people recognise it or not.
Damn funny! I agree that there's no such thing as an unofficial religion
but surely there is nobody (excepting the heavily medicated and chronically
deluded) who truly believes that they are a
On iAS 1.0.2.2.0 with 8.1.7.4.x NT Server 4 server.
The Oracle performance counters don't load, Metalink hasn't been able to
come up with an answer yet.
Has anyone been able to load these counters on an iAS server?
To confuse the issue further, we installed a db on the iAS server itself --
so
GRIN...
That buzzing sound you just heard was me powering up!! Back off buster ;O)
-Original Message-
Sent: 25 February 2003 12:24
To: Multiple recipients of list ORACLE-L
And there is no such thing as an 'unofficial' religion. It's just whether
people recognise it or not.
Damn funny!
Last word is that it should be available within 2-3, maybe sooner.
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
Is the job even firing at all? It is a common step in upgrading to set
job_queue_processes=0 and this will prevent materialized views from refreshing
automatically. Make sure this is greater than 0; I normally set it to 2.
[EMAIL PROTECTED] 02/25/03 04:29AM
Dear list,
Have any of you every
We had the problem where the M$LOG was not being purged after the
materialized view was updated. That doesn't seem to be your problem
though.
Hi,
On one of our customers site (WINDOWS) we have databases that have alertlogs
with the name sidALRT.LOGsidALRT.LOG (double the normal name) and oracle
keeps on writing to it.
I thought if a file is renamed oracle will create a new alertlog when
needed. I have a php script that reads the
Jared,
Does it work if you do a manual refresh?
Henry
-Original Message-
Sent: Tuesday, February 25, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Dear list,
Have any of you every experienced MV's not refreshing
for no particular reason?
We have been using some simple MV's
That's weeks, not days.
Pat.
-Original Message-
Sent: Tuesday, February 25, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
Last word is that it should be available within 2-3, maybe sooner.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
Title: RE: Embeded password in script
Thank you, Jared. I have the book you wrote and will look into it.
Regards,
David
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 4:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
No, no this is very relevant to a DBA. We should learn the Jedi mind tricks.
I need to denormalize this table.
No you don't want to denormalize that table.
No I don't want to denormalize this table.
You want to go back to your desk and not bother the DBA.
I want to go back
OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on
HP-UX 11.0). The dispatchers start up just fine, but won't register with the
listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't
see the problem.
mts_servers=5
mts_max_dispatchers=10
The recently installed 9i rel2 pachted to 9.2.0.2.0 uses openssl version 0.9.6b
The latest version is 0.9.7a was 0.9.6i.
Compile and then just change the file will most likely not work, will it?
kr
Apologies for any typing mistakes I failed to notice.
Markus Reger
Oracle Applications DBA
All
We are attempting to move some applications off Compaq T64 into Sun Solaris
8 and running into performance issues.
I am trying to rebuild an index which is taking more than 3 1/2 hours while
it used to take 20 min on T64.
I find most of the waits on DIRECT PATH READS and DIRECT PATH
Do a rewrite in Perl to run it on Windows.
There is am smtp module for Perl that will allow you to inject an message
straight to a mail server.
You could then use that both on Unix and windows
Cheers
--
=
Peter McLarty E-mail:
try operfcfg
Usage: OPerfCfg [-U username] [-P password] [-D [database name]]
steve
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 6:44 AM
On iAS 1.0.2.2.0 with 8.1.7.4.x NT Server 4 server.
The Oracle performance
Take a backup of C:\Program Files\Oracle and copy it back if you plan to go
with import/export of registry keys
Regards
Naveen
DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged.
Before opening attachments please check them for viruses and defects.
What platform? Isn't the 5th number platform-specific? (I forget)
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, February 25, 2003 8:11 AM
To: Multiple
Hi,
We're unfortunately still on 7.3.4.5 and this is how my mts config
looks:
mts_dispatchers=ipc,10, tcp,15
mts_servers=10
mts_service=VU_2
mts_listener_address=(ADDRESS=(PROTOCOL=ipc)(KEY=VU_2))
mts_listener_address=(ADDRESS=(PROTOCOL=tcp)(HOST=stirling)(PORT=1526))
mts_max_dispatchers=40
Babu - I would recommend checking:
- Where is the tablespace of the table? Shared disk with temp or index
tablespace?
- Check your SORT_AREA_SIZE on both systems.
- Do some basic disk I/O tests. On both the Compaq and Solaris, move a
large file from one drive to another, just to see what
Keep your CDs forever. I once had a job that
frequently required producing data for our very
efficient legal system. It was not unusual for
requests for information from attorneys to go back ten
years. We had a really good librarian, the media was
always available. Sometimes building an old
Dick,
here is what I use
mts_dispatchers =
(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.99.28))(DISPATCHERS=5)
local_listener =
(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.99.28)(PORT=1521))
mts_max_dispatchers = 10
mts_servers = 10
mts_max_servers
Jack,
I've seen the same result (alert log funny file name) when I rename the file
also doing oracle log maintenace. I'm guessing the same thing you are -
that the rename hits at the same time that a write operation is happening.
a subsequent rename works fine.
For you second problem, I would
We are converting from SQL Server and Sybase to Oracle.
To convert functions and stored procedures we have been using the
Oracle Migration Workbench (OMWB) which produced WEAK REF CURSOR and
TRANCOUNT global variable.
I looked at (trace and explain plan) statements in the procedures
and
sorry... win32.
Pat.
-Original Message-
Sent: Tuesday, February 25, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
What platform? Isn't the 5th number platform-specific? (I forget)
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
Looks fine. We only have the following entries on a 9i database..
dispatchers = (protocol = TCP)(dispatchers = 6)
max_dispatchers = 12
shared_servers = 10
max_shared_servers = 40
Works fine, we ended up commenting out local_listener. How long have you
waited for the dispatchers to
Actually, this would still display the password in the output of ps -ef
because the $syspw environment variable is resolved before handing it to
sqlplus.
Try sqlplus dbimpl/$syspw and then a ps -ef...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
Hi
No Oracle isn't slower than alternative RDBMS, at least if it is 9 times slower then
it is either misconfigured, or the code is bad, or both. I'd strongly suspect the code
to start with. If you treat the output of OMWB as a first cut, or functional prototype
then you have a reasonable
WAS an editor? WAS? Some of us still use it! Well, I have migrated to
the EVE editor built on TPU, but it still has the same wonderful
functionality of the original in addition to a programmable interface (wrote
some sweet sweet TPU back in the day). The KB I'm typing this on is an
LK450,
Hi DBAs
We are reviewing anything related to database monitor. The following is my
aware. Is there anything else you recommend
Spotlight from quest
Pocket DBA from Expand Beyond
Oracle Performance Monitor
Thanks in advance.
Mitchell
--
Please see the official ORACLE-L FAQ:
service_names, I believe is an optional thing. But if you use it, I think
it is supposed to be set to a sort of alias name, not a number.
-Original Message-
can't
see the problem.
service_names=05
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen
- Where is the tablespace of the table? Shared disk with temp or index
tablespace?
Its on a different mountpoint (and disk) from the index or the temp
tablespaces
- Check your SORT_AREA_SIZE on both systems.
Its 1 Mb. I have done the tests with as much as 250M but same results
- Do
We are converting from SQL Server and Sybase to
Oracle.
To convert functions and stored procedures we have
been using the
Oracle Migration Workbench (OMWB) which produced
WEAK REF CURSOR and
TRANCOUNT global variable.
I looked at (trace and explain plan) statements in
the procedures
and
Title: Skill Sets - This may be a dumb question
Hello everyone,
Well I've been reassigned. I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same
You can have username/password in the first line of the sqlplus script.
sqlplus @your-script.sql
Your-script.sql will have id/pw in the first line.
Regards,
Waleed
-Original Message-
Sent: Monday, February 24, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked
Mitchell - What platform are you on? Do you have any particular criteria, or
just trying to monitor anything?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, February 25, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Karma. The price is unbeatable and it's one very good monitor, too.
Also, look into DB-Artisan from Embarcadero technologies, BMC Patrol.
I'm sure that CA have an oracle RDBMS monitoring product. You also
need to look in the capabilities of Tivoli from the Big Blue.
-Original Message-
Or, you can create user OPS$ORACLE and grant DBA privilege to that account.
That way , password will never be exposed.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject: RE:
There is also a bug in 8i with set current_schema. We use a login
trigger to set current_schema for client database connections. It works
great unless the client's code is PL/SQL. They don't get an ORA-600,
but instead get PLS-201. Creating the public synonym fixes that
problem.
Rachel
Let's see, how about overnight and yes I have reloaded the listener.
Dick Goulet
Reply Separator
Author: Adrian Roe [EMAIL PROTECTED]
Date: 2/25/2003 7:09 AM
Looks fine. We only have the following entries on a 9i database..
dispatchers =
Oracle isn't slower, you need to analyze the SQL and re-tune it. Indexes,
indexes, indices.
-Original Message-
From: Bahar, Rivaldi (BBASSI-CHQ) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle slower ?
The archivelogs have to have been backed up by rman for rman
to delete them. Thisscript is the one we use.
execute script alloc_name1_disk;
backup format
'/dbback/al_%sdbname_%p' (archivelog
all delete input); execute script
rel_pa1_disk;}
HTH,
Ruth
- Original Message -
Title: Skill Sets - This may be a dumb question
Lisa:
I know you are disappointed, but be happy you have a
job. I was laid off a year ago and the job situation here in the TC's area
is not improving. I'll trade places with you any day.
Ken Janusz, CPIM
Hugo, MN
- Original Message
Hi All,
Do not tune because a statistic looks bad
Do tune because a luser says this is slow and is
adversely affecting my productivity.
Do not use MTS
Yes I know there are a few exceptions, but in general
MTS causes more problems than it solves.
Dave
--
Dave Morgan
Hi Mitchell,
When you say monitor, what exactly do you mean? The definition of a
Monitoring tool (in my eyes at least) is a tool that will sit and monitor
your database, and tell you when a problem could be, or is, imminent (via
background processes and alerts).
The list that you specify, whilst
One advantage of database architect is that he is less dependent on a specific
database. I am some kind of system architect/analyst and in my previous job I worked
with Oracle products as well as with some Open source ones. Now my new company is
working only with M$ SQL Server and I don't have
Both Oracle (817) and Sybase running on the same test machine (Sun Solaris
6)
but in different mount point. Both not at optimum datafiles and I/O
configuration.
If I run every SQL in the procedure manually from SQLplus it run at minimum
cost
(explain plan), indexes used.
There are loops in the
Lisa - You can always answer questions on this list to keep your hand in. I
wouldn't sweat it too much. I agree with you that the harder skills like
Oracle show up better on a resume. But frankly you can still put Oracle on
your resume for a LNG time and be perfectly truthful. And if they want
Title: Message
Ken:
My
sympathies go out to you too, I spent the time from 04/01 until 12/01 unemployed
as well. Tough way to go in any market, try one in a small (30K population)
market that is 90+% dependent on asmall state's government for work. I'm
very thankful to be working yet
sqlplus /nolog !
conn dbimpl/password
@SQLscript.sql
!
-Original Message-
Sent: Monday, February 24, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run
Title: Message
Don't
you just HATE change. You were getting all nice and comfy in your current
job, and mgmt throws you a curve ball.
This
has happened to me a few times, and I have learned to "step into their shoes" to
try and better understand why. Why me!!!?!? Not that I ever agreed
Title: Skill Sets - This may be a dumb question
Simple, eliminate the married couple. Then you
should have your pick of jobs.
Dave
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]Sent: Tuesday, February 25, 2003
10:34 AMTo: Multiple recipients of list
List Gurus,
I need help and I won't be ashamed to ask :)
Oracle 8.1.7 on AIX 4.3
Here is what my data looks like in a table called item_w:
WHSE_CODEITEM_NUM LAST_COST
-- --
HL1 111230
Go check one of the on-line salary surveys. Used to be that Oracle DBA was
head of the pack. Now it's data architect and web designer. The only
reason that it seems like a soft skill to you is because you're so good
at it that it's second nature. Leave a regular L'User alone to do their
own
Babu,
I think it is trying to do a KAIO call and failing. Then it attempts a
synchronous PWRITE call.
But our SAs are not able to help us to confirm this. Have any
of you seen
this issue?
I think you have hit the nail on the head. By default, the Oracle port on
Solaris sets
Title: Message
I have never had
good luck with DBMS_STATS. It seems that the old analyze runs much
faster.
Runs in 45
seconds:
analyze table
log_trans partition (log_trans_20030104) estimate statisticssample 5
percent;
Takes over 2
hours:
execute
Thank you very much for the information Don. We are using 9i and I think
MTS, though I am not certain of that. I will pass this on to our DBA, I am
sure he will find this helpful.
At 06:03 PM 2/24/2003 -0800, you wrote:
I guess I should have asked also:
1) what version of Oracle are you
Title: Message
I
retract what I said the other day about Metalink
technicians...
:
(
Pat.
Proof of pudding is in eating Whip up a couple of examples and
check out the timings. I suspect the CURSOR FOR LOOPS would run
faster.
I recall a similar mention by Tom Kyte in Oracle magazine while
answering a question about explicit and implicit cusrsors. Unlike the
conventional wisdom
Title: Skill Sets - This may be a dumb question
Lisa,
I'm
sorry for selfish reasons. I liked having someone else on a
Peoplesoft/Oracle/AIX environment out there. As far as the new position, just
change your job title to Data Architect (what does that do to your tag
lines?)
Henry
Title: Message
May have something to do with bug 2649728,
which I just heard about for the first time no more than 10 seconds ago.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- RMOUG Training Days 2003, Mar 56
Denver
- Hotsos Clinic101,
Mar 2527
Jared:
How do you do this for an export cron job ?
Thanks
David Jones
ITResource
-Original Message-
Sent: Monday, February 24, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L
The 'hide.c' program can be implemented and compiled to prevent
parameters from appearing to ps. I
Title: Message
ok, I
will take a look. thanks
-Original Message-From: Cary Millsap
[mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003
1:35 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: DBMS_STATS
May have something to
do with bug 2649728, which I
I logged a TAR with Oracle, they responded that this is privileged
information.
; )
I recommend sending a question to the Oracle Alerts people.
That's what I am doing...
Pat.
-Original Message-
Sent: Tuesday, February 25, 2003 10:11 AM
To: Multiple recipients of list ORACLE-L
The
Wild. You would think a business that makes and sells software would keep
better track of it. Sounds kind of sloppy.
So I guess I got lucky.
David
From: Mogens Nørgaard [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: How
Hi Lisetrs,
I have enough free memory from shared_pool_size and
I run stats every week but the BD still shows up the
low hit ratio and some times the later full down to
15%!
Here is some informations:
Obj mem: 79503437 bytes
Shared sql: 23852410 bytes
Cursors: 244875 bytes
Free memory:
Title: RE: SQL struggle
(see answer below)
-Original Message-
From: Saira Somani [mailto:[EMAIL PROTECTED]]
Oracle 8.1.7 on AIX 4.3
Here is what my data looks like in a table called item_w:
WHSE_CODE ITEM_NUM LAST_COST
--
This is somewhat
related tothe question earlier about how to encrypt a password in a
script... however, what I want to do is also be able to start that database
through a script.
(Oracle
9.2.0.)
Essentially I have a
database that I want to shut down at 5pm every night, and start it
Hi
all,
A developper wants
to pass a collection (varray) between 2 stored procs on 2 databases via a
dblink.
Can we declared a
collection of a remote database locally ?
This is on
8172
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
Lisa,
You are correct in your needing a vent or whining as you so
eloquently put it. Corporate policy can and has ruined a great career if
you are not prepared for the unforseen changes that the bean counters
produce.
Not knowing the knowledge level of your spouse and not wanting to
start a
Didn't help to do it manually.
On Tuesday 25 February 2003 06:14, Henry Poras wrote:
Jared,
Does it work if you do a manual refresh?
Henry
-Original Message-
Sent: Tuesday, February 25, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Dear list,
Have any of you every
Yes, the jobs were firing, verified by timestamps in both
the dba_jobs and dba_refresh views.
On Tuesday 25 February 2003 05:33, Darrell Landrum wrote:
Is the job even firing at all? It is a common step in upgrading to set
job_queue_processes=0 and this will prevent materialized views from
No, they were not being purged.
On Tuesday 25 February 2003 05:59, Thomas Day wrote:
We had the problem where the M$LOG was not being purged after the
materialized view was updated. That doesn't seem to be your problem
though.
Jared Still
1 - 100 of 179 matches
Mail list logo