 | | | Oracle List | |
Busy hunting Metalink for information but maybe someone here can
point me to likely causes to investigate.
I get ORA-06508 "PL/SQL could not find program unit being called ".
Not an unusual error aI got this error sometime back and I believe I used 'statistics none '.
Raja.
-----Original Message-----
From Mladen Gogala [mailto gogala@(protected)]
Sent Friday August 05 2005 6 54 AM
To o
oracle-l-bounce@(protected) gravou em 2005-08-08 10 12 44
> My suggestion would be to first understand the fundamentals of data
> warehousing then the Oracle pieces will fall into place.
Unless you have the 3D Pipes screen saver on. <grin >
Jim
-----Original Message-----
From oracle-l-bounce@(protected) on behalf of Billy Verreynne (JW)
Sent Tue 8/9/2005 11 09 PM
To oracle-l@(protected)The documentation has error of ommission as shown below -
Using any text editor create or edit the /etc/sysctl.conf file and
add or edit lines similar to the following
kernel.shmall 2097152
kerSomckit
We 're using NetBackup 5.1 on an ADIC Scalar tape library with LTO-1 drives (or so I 've been told from the admins - it 's all behind the scenes to me) on which I typically get a little under I finally figured out the problem with the SQL*Net more data to client problem. The developer defined output variables as CHAR since he was only passing back a single character.
Well the max size > > >
> > >The whole thing smells to me like Oracle has no idea and is
> > >grabbing at straws but I would like to get people 's
> > >opinions. Feel free to email me off-list if you 'd rather
> > >not publiJuan
some simple tests I ran with timing on.
table record count 3079
table data is identical.
box 1 OpenVMS Oracle 8.1.7.4 cpu 400 Mhx 1 GIG dedicated memory ALPHA server class
box 2 Redhat OraclHi
I had been reading several articles about how much faster is linux
than windows. I don 't know what is real and what is marketing.
Could some one share please their own tests.
Thank you
--
Ora
oracle-l-bounce@(protected) gravou em 2005-08-04 21 45 28
> Beside how to determine my dbms_job really run?
[...]
> Check on dba_jobs .... did show job alrdy run.
So don 't you trust dba_
oracle-l-bounce@(protected) gravou em 2005-08-04 11 20 44
> There is
> advice to use RAID 5 if 90% or more of the operations are reads and
> 10 if not. I don 't know the distribution of reads anbackup format 'your format here ' (archivelog all delete input)
> What can I lose if start to migrate to deevloper release instead of
> the real realease.
Your sanity.
Hi all
We have got Oracle 10g AS (Release 10.1.2.0.0) installled on RHES
4(Nahant). Now I just wanted to know
1) What are the services should be started all the time when my server is
getting sHI All
Does the analyze table compute statistics (or dbms_stats) statement lock the table
in anymode
Thanks
Raj
oracle-l-bounce@(protected) gravou em 2005-08-04 12 12 04
> >...He went into the "generation gap " issue. Was fascinating.
>
> Being employed at a job also entails a "value system ".
>
> It is thisHi All
oracle 8i. (8174)
os win2000 server.
(basically this is a people soft datebase being cloned from W2k to anotehr w2k machine)
Is there any specific process to follow to clone an instnaHi
At least OCI allows LOB buffering (search for LOB buffering subsystem) and also LOB update bundling so you can create several LOBs in your application and flush these to database later on. Actuahow about just putting the sql contents in a shell script and call it
using 'nohup '
say
1.sh
sqlplus <username >/ <password >@ <connectString > < <EOF
select 'whatever you want to do goes here ' fWhat does the 'BUFFER SORT ' step mean and how does it
get calculated say in below example? It is out of a
tkprof output of a star transformation query.
105 BITMAP MERGE
351549 BITMAGroup
Has anybody installed Oracle via the Solaris pkgadd utility? Any help will
be appreciated.
thanks.
Is the session still in v$session. Sometimes when you
kill a session it takes a while to actually get go
away.
Is anyone else on the list receiving duplicate emails from the past few days or is it just me?
Thanks
Brandon
Privileged/Confidential Information may be contained in this message or attachmentsI am sorry If the question is very basic. I wanted to audit everything
for a particular user.
This is what I tried but I couldn 't find any audit entry.
C \ >sqlplus sys/welcome as sysdba
SQL*Plus ReIgnore my previous email. I assumed audit_trail was set whcih is not.
---------- Forwarded message ----------
From Sami Seerangan <dba.orcl@(protected) >
Date Aug 3 2005 12 27 PM
Subject audit- can Greetings All
We have one database on a Sun server (Sun Enterprise 450) with Solaris
7. Currently the database runs on Oracle 8.1.7 with the 2GB of
memory(RAM). We are estimating for the memory requHi
We are running an update statement (stripping off all HTML tags from the not
nullable clob and saving into another clob column which can be null) and
getting this error
(Error) ORA-06502 PDavid Wendelken wrote
> Remind them that CEOs and CFOs have been stealing the
>money recently not DBAs. )
>
>
David you 're my hero. I 'd like to see the face of my CIO if I ever
blurted out anwhat about load test tools?
On 8/3/05 Ray Stell <stellr@(protected) > wrote
>
> I assume you do not have network admin support or you wouldn 't be
> here. You really need to have your network admin |
|
|
