 | | | Oracle List | | EXECUTE on SYS.DBMS_LOCK to PUBLIC worked
Thanks so much Neil
Cheers
Vivek
Have you looked at security? Has the user who is creating the package
been given execute priv on the package?
Tom
Afternoon all
> > "Alex Gorbachev " <gorbyx@(protected) > 05/15/07 01 28PM > > >
> > Seems like it 's inefficient execution plan.
> > I know that Oracle might go crazy joining dictionary views and V$
> > viewhi all
I 'm working on a (telecom) high transactional system where many individual records could be in a dirty state (updated/deleted but not commited until a later time possibly minutes or more). John
When you type "env " on the $ prompt do you see the Oracle
environmental 's defined?
Secondly try "cd 'ing " to the $ORACLE_HOME/bin directory and running
Sqlplus right from there and see wha
Folks
How can the Schema OWNER of ALL Objects Owned by (say) OWNER1 be Changed
to OWNER2 in 10gR2?
NOTE - OWNER2 does NOT exist in the Database.
NOTE - Other / multiple schemas & respective ObjJohn
No paper at had but an example how I set up a failover of the tnsnames
entry below might help
#
# The application alias failover to the active primary
#
d10b
(DESCRIPTION
(FAILOVEIn response to a recent question about monitoring Cary replied
Simple answer to this one Anything that causes increase in business task
response times.
So if you 're monitoring end-user response tDuring some recent RAC scalability testing we saw a lot of GC type waits
during our transaction performance runs after adding a 4 'th node into the
cluster. The issue turned out to be a lot of contentiFolks
I 've done the RTFM searched Metalink and the Oracle-L archives and
haven 't found a definitive answer on the subject. So I 'm going to ask
a simple question Has anyone gotten an Oracle Folks
During Oracle 's direct path operations (direct read direct write hash
joins etc.) there are certain init parameters that govern the
bandwidth of the IO size that Oracle processes. It seems Hello.
I understand that there exists a master(instance) for a resource. I follow
remastering of the resource. I
But I like to know more about Master Node in the cluster. I infer that
OCSSD (Oracl
Afternoon all
Sorry about the 'stupidity ' of the following question but I 've just
been bitten by it and I can 't find a proper answer anywhere in the
Oracle DOCS online or anywhere. If you know o
It Worked as advised LSC. Thanks so much
Cheers
Folks
Attempting to run an SQL Script in background (with nohup) in HP-UX is
Failing
Details -
SQL Script Runs without nohup
$ sqlplus system/manager @(protected)
SQL*Plus Release 10Environment Oracle 8.1.7.4 on Solaris 5.8
I am trying to create a copy of a database from an rman hot backup
running in nocatalog mode following the example in the Duplcate command
section of the OWhat is port 1830 used for? Where does it need to be open. What "machine/service " initiates the connection and what machine/service is the target.
I 've got folks working on a firewall request andAt 11 59 AM 5/10/2007 Binh Pham wrote
>The output does not look PRETTY at all.
Beauty is in the eye of the beholder
-)
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.cOh I 'm sure the CBO changed alrighty I have bunches of queries that got
mugged. My question was about factual issues
Does the upgrade from one version of the db to another touch indexes or
otherI 'm working on an SR with Oracle because a number of key queries got their
execution plans mugged in an upgrade from 9206 to 9208. I got the following
in the SR
After having upgraded to 9.2.0.8 thTricky situation. Cluster group which is hosting the majority of
votes lowest node number will survive. Other groups will be kicked
out.
--
Best Regards
K Gopalakrishnan
Co-Author Oracle Wait InI have a question about write ahead protocol of Oracle.
If the *current* redo log is lost then
- Will Oracle halt? I think yes.
What happens if checkpoint crashes in the middle and the correspondinOn 5/10/07 Clarke Andrew <andrew.clarke@(protected) > wrote
> > I 'm researching the idea of migrating to WE8ISO8859P1.
>
> If these are smart quotes or other MS characters you might wish to
> conI agree - I like to have a DBA involved to check things out whenever the
host and/or instance is restarted. We 've got about 10 unix (AIX & HPUX)
boxes and none of them has ever crashed in over 8 year
I will be out of the office starting 10/05/2007 and will not return until
22/05/2007.
I will respond to your message when I return.
The information contained in this e-mail message including anyHas anyone got around to implementing it yet <vbg >
On 5/10/07 Anjo Kolk <anjo.kolk@(protected) > wrote
>
> Has been at the heart of YAPP since 1996 but then again that is over
> almost 12 years oldHarvinder
> We see lot of waits in the database on "SQL*Net message from client "
> and following is one of the sample query with wait events from tkprof
> what can be the possible reason for long waCan 't see your paper. Please send as an attachment.
On 5/10/07 Jeremy Paul Schneider <jeremy.schneider@(protected) > wrote
>
> Hey everyone ?
>
> I just finished putting together a research paperI know our RMAN/Netbackup backups automatically retry 3 times if they
fail and we don 't do it from the client side - our "Storage/Backup
Admins " have it configured on the Netbackup server somehow.
Unf |
|
|
