 | | | Oracle List | | I am writing a package that adds a bunch of instrumentation to existing
PL/SQL packages. There is no real debugging in this app so one thing it
will do is replace all the existing DBMS_OUTPUT callsHi Seema
We have exactly the same problem in processes not releasing virtual
memory - even if our physical memory goes down to 45% virtual memory
stays around 30% . We used svmon with oracle Hi Terry
Bug aside... I see only two situations that lead to unused free space
- the inserts are performed with direct load (e.g. hint "append ")
- minimize record per block is enabled and a veTry
http //www.oracle.com/technology/tech/windows/odbc/index.html
HTH
Jared
On Fri 12 Nov 2004 10 23 29 -0500 David Boyd <davidb1588@(protected) > wrote
> Hi All
>
> We 're goin
Hi all...
It 's been awhile since I 've posted to Oracle-L. I 've been lurking only.
However I haven 't seen discussions of this so I thought I 'd give it a
try.
Has anyone tried to setup sHi List some comment about this parameter in nt
Thanks.
USE_SHARED_SOCKET
You can set parameter USE_SHARED_SOCKET to true to enable use of shared
sockets. If this parameter is set to true the > Subject Listener stops accepting client requests/connections
>
>
> Hello Folks
>
>
> Has anyone any idea what this issue could be.
>
> We have two servers a 9.2.0.3 and 8.1.7.4.1 botHi Steve
Please read the execellent paper from Richard Foote (which can be
downloaded from Miracle 's site)
http //www.miracleas.dk/images/upload/Docs/Richard%20Foote.pdf
Conclusion form thiPerhaps a synopsis of just is being demonstrated is in order?
Jared
On Fri 12 Nov 2004 00 54 35 -0800 Adam Donahue <adonahue@(protected) > wrote
> It 's not so much a question as a demonstraOh no not a "which is the best editor " thread ! (I am ( or was ) of
Oraclescene BTW!)
Howard
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)Hey all
On 9.2.0.5.0 (HPUX 11.11) we had a new programmer add a column to a table. This caused an avalanche of dependant objects to become invalid. Since we have a job that regularly checks for iYou 're supposed to monitor cron jobs? This is probably not the list you
want to ask.
Unless you can get root or want to hack into the box you probably
aren 't going to have much luck. And wFolks let 's say I run this query
select drc.dvc_id FROM role_classes cr device_role_classes drc
WHERE cr.role_class_id drc.role_class_id (+)
START WITH cr.role_class_id 5
CONNECT BY cr.parSam
man cron or man crontabs should tell you where the crontab files are
(on HP /var/spool/cron/crontabs)
but permissions are likely 400 so it won 't help you much
Plan A give the task to someone Apart from tracing (which with such a rate of execution is not highly
advisable) the best you can do is probably collect those aggregate values at
regular intervals compute differences and work ouRunning 8.1.7 on Solaris 8. Yesterday I deleted 2 datafiles luckily
in a non-production environment. However this system does not get
backed up. Im thinking I am most likely stuck recreating thBeware Earlier versions of Application Server will cease working if
domain is changed 20
I think its somethig to do with the way that the password is encrypted?
-----Original Message-----
FromIts nice to know we should be careful with discount codes and have a
backup plan. -)
Where I live registration takes 15 minutes. In my opinion its no big
deal if its cancelled by anyone or anHi Ryan
>I could have swarn I read somewhere(yes I forgot where again) that if I
use system stats the
>following parameters are ignored by oracle. Is this correct?
NO! They just made the twoI think Oracle uses spfile as default when the instance starts. You could
probably do something like
1. Shutdown DB
2. Move the spfile to another temp directory
3. Edit your "init.ora "
4. StartHi Brian
in my current RAC env i backup to disk using multiple
channels each channel has connection to different
instance. So disk backupset are located in different
server.
Now i also nYou can get a bunch of session information which I think you 're looking
for by using the SYS_CONTEXT object.
EG SELECT SYS_CONTEXT( 'USERENV ' 'OS_USER ') FROM dual
Will give the Operating SystSol
We are using 8.0.6.3.1 SQL*Net client (installed with Developer 6i) to
connect to 9.2.0.5 databases haven 't had any issues so far with this
configuration. Am going to try with 10.1.0.3 dataHi
I have been noticing database disconnect issues with one of client.
Application box Perl/apache/applictaions LINUX box
DB box AIX 5.x box OracleEE817
I noticed the memory on database at tI believe Arup Nanda has an article about some of the 10g Rman features.
One that is pertinent here is that you can actually merge and
incremental backup into a previous full backup ...that 's not dSteven
I know your post is old but I didn 't see any responses so I thought I 'd
propose the following
SELECT SUBSTR(string 2)
FROM (
SELECT SYS_CONNECT_BY_PATH(name ' ') string
You 're probably thinking of "ALTER SESSION SET CURRENT_SCHEMA .... "
command.
Also see the article 'Sin-onyms ' on http //www.ixora.com.au/
Also try searching the archive of this mailing for Dear All
Win2000 Oracle8.1.7.4 init.ora proceses 450.
I 'm following up a DB crash due to ORA-00018. Seems V$sessions and V$license
only report "user " sessions not "all " sessions that the procArul
> By any chance can we control this "auto-cleanup " timing and bring it down to around 30 minutes or so. Every INACTIVE session after 30 minutes should be killed? Please let me know your viewNaveen
You 've not given much background to the problem but the answer to
your problem. May be a lot simpler than tracing.
Ora-01555s normally stem from problems from rollbacks. Either to few |
|
|
