 | | | Oracle List | | Alex
> If let 's say it takes 10 seconds does Oracle guarantee the values I
> am seeing are from 10 seconds ago? I am pretty sure undo is not used
> for memory structures or wrong?
For the fine manuaHmm to upgrade or patch a 9.2.0.6 database to 9.2.0.7 (or any newer version)
you start the database with 9.2.0.7 binaries. Assumming Cloning doesnt mean
RMAN clone so I guess you can.
Copy your 9.2.0Hi All
I have a requirement to create an aggregation based on a 600 million
row date-partitioned table. Given the size of the table a complete
refresh isn 't really viable and as analytic functiXiaoyan
Yes this is a priv problem. "Grant select on test.courses to king "
Tom
Hi Leng
I have setup with 12 servers running (1 master and 11 snapshot sites) with > 1000 snapshots on ~10 groups replicating to any of the sites. We have some very andavnced things like 3-tier rtype at the unix prompt
. .env
Hi
I want to change default URL to some diffrent URL.
from http //servername. <sid > portname to
http //webapps. <name >.com
Which file I 've to change httpds.conf right ?
Please advice.
Thx
__________Hi
Few users have been noticing error during data entry.The error is
"FRM 92100 YOUR CONNECTION TO THE SERVER ... ".
We are having HRM/pAYROLL/FINANCE etc.
All modules are having this issue.Since thi
> > >Well thanks to faster CPUs the time to try to get a latch
(spin) has reduced but also the time to release the latch (to complete
the work that requires latch protection) has gone down as weI believe a simple way to corrupt an oracle datafile redolog controlfile could be
echo " <somewhat string > " > > oracle_file
This should alter the file offset (I don 't know if this is the correct te overwriting the binary files but being simpled-minded I was using vi.
I thought about using the unix dd utility - unfortuantely I do not have
enough experience to be surgical (easy to mess up the fiI frequently run into situations where production support folks
(basically former developers converted to support their code now in
production) would like to find more information out about what 's goiFunny topic eh? I am practicing backup and recovery procedures and finding
that recovery is quite easy since I never have corrupted blocks to worry
about. So how do I practice for a "worse case " sceSure that 's possible though at the low end. I used to run a 7.3.2
database on an old laptop that had only 32MB total RAM and I think I ran
it with a 4MB SGA. I didn 't need a big Buffer Cache o*SAP Oracle /SQL Server DBA Position Available Boston Area- Paid relocation
Salary $90 000 - $100 000 range
Location Waltham MA
Requirements
Bachelors degree in Computer Science OR approprThere has got to be a way to do this but I 'm not finding anything.
I would like the ability to refresh materialized view 'a ' but ensure
that all materialized views that 'a ' depends on are refreshed Hi!
Whats wrong with stored procedures?
You should be able to put your script in an package...
/Bjoern
----- Original Message -----
From Johan Muller
To oracle-l-bounce@(protected) OraclI 'm guessing you mean that the database and monitoring software are on a
server (or servers) and you just get alerts to the handheld device? Or
are you talking about actually running Oracle on a handHi Mark
Just some comments...
> In my opinion parallelism is something you use when you are dealing
> with vast amounts of data and you really have no choice but to
> chomp through it all regardl
We have a winner. I cannot announce who it is without their
permission.
Their response to the challenge was Metalink 5232574
which I thought was an amusing reply to the challenge.
> have huge
Hello all
Twice this week the 10g listener spun a child process and hung all new
connections to any database (10.2.0.2 on HPUX 11.11) This is what it
looked like
ps -ef ...
oracle 21170 16606 It was throwing 503 errors a few hours ago (from the greater Milwaukee
WI area) but she 's OK now...
Rich
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)Hey all
Finally getting our new ERP installed on 10.2.0.1.0/AIX5.3 (next server
is 10.2.0.2.0 w/July2006 CPU) and I wanted to see how many of the 3300+
tables in the vendor 's schema don 't have PKs. The worst was when I headed close to 40 good people in Oracle Premium
Services in the late 90 's and I wanted them all to become OCP 's The
Performance part of it was completely utterly wrong and rSanjay
ASH maintains samples of the session-state information in its own
buffers within the System Global Area (SGA). The amount of information
that ASH maintains could quickly become substantial ifCan 't find much on this yet and thought I would ask here. While trying
to get values from sys.exppkgact$ to reinsert after performing a full
export without the analytic workspaces in a database I ra > > >I realize this is off-topic but the MySQL mailing lists
> > >have a much worse signal/noise ratio
I don 't participate in them you know
--
http //www.freelists.org/webpage/oracle-l
Hanspeter
Congratulations! Now you just have to figure out how to retain some of that
knowledge. But the tests certainly force you to look at parts of Oracle you
might not otherwise encounter.
DenniIsabel
Has role_y been granted to the y user?
Here is what I would do.
Revoke everything from user y.
Connect as user x.
grant select on vw_qqqq to role_y.
You do not need to granmurtuja khokhar wrote
>Who is Freddie ?
Freddy Mercury was a flamboyant Zoroastrian rock singer with a notably
high operatic style voice. He died of AIDS 15 years ago. His group was
called Queen. |
|
|
