 | | | Oracle List | | On 5/17/07 Jeremiah Wilton <jeremiah@(protected) > wrote
>
> A regex returning the first word from the address should do it
>
> SQL > select regexp_substr( 'foo.bar.baz ' '\w* ') from dual
>
>
>
16 32 Those of you in the Boston Mass USA area who are looking for a junior
to mid level DBA please contact me privately. I 've an acquaintance who
is looking for a job.
Is there a way to name the trace file with dbms_system.set_ev()
sys.dbms_system.set_ev()
I have a login trigger that does
sys.dbms_system.set_ev(l_sid l_serial# 10046 l_level ' ')
but I need tSounds like a job for a good text editor. May I suggest Ultraedit from
www.idmcomp.com.
The problem is that you still have objects in the tablespace using
extents high up in the file. You can look into the tablespace with the
following query to see what objects are using space
select Check the non-paged pool for usage via task manager or sys internal tools.
Sounds like a listener problem that I had at one point. Listener wouldn?t
let go of non-paged memory and eventually the lChristian is of course correct that an extra logical member would force the
idiot or saboteur to delete a second file.
The question posed however is NP-incomplete. Any preventative measure
suggesteHey all
For anyone that wants a copy I 've just posted the fourth paper in the
Oracle Forensics series I 'm writing to http //www.databasesecurity.com/.
This paper covers what an incident responder all
do you have such experience about working with 10r2.0.3 rac with itanium 2?
i got problem with clusterware when restarting machine the
crs css and evm could not starting....
thanks for the reHello to you all
I 'm experiencing some problems with an Oracle Database (10g release 1 - *
10.1.0.2*) on a Windows Server (2000 Advanced Server - SP4).
I 'm repeatedly getting the following error onOn 5/17/07 Anand <shastry17@(protected) > wrote
>
> Hello all
> Why should we assume LD_ASSUME_KERNEL with some value during oracle
> installation. Is that because the kernel versions are different foThanks John for the valuable Advice.
Since 2000 Objects are scattered across 55 Tablespaces but of Total
Data Size 8 GB only I achieved the Data transfer from 1 Schema to
Another thru expdp - SCHEMHi Avadhani
Please put this question in the proper group from now on. There is a group
called oracle-l@(protected) which helps you out in core DBA things.
Reg
Anand
---------- Forwarded messageHi All
As we know when we issue a COMMIT the log buffer content is flushed to the
online redo log file before the "Commit complete " status is returned to the
user. Please correct me if I am wrong.
You can check SQL Memory Management in Oracle9i
http //www.cs.ust.hk/vldb2002/VLDB2002-proceedings/papers/S29P03.pdf
and search google for other papers by both authors of this paper.
Don 't know whetheprobably you need some purging on these workflow tables n queues. check
whether following concurrent programs are scheduled to run periodically in
your instance
Purge Obsolete Workflow Runtime Data
Hi
I am trying to understand the algorithm used by Oracle when using
pga_aggregate target and it looks like to get the information on
Expected_WorkAreaSize Oracle already knows about the value oWe have the source on Oracle 10.2.0.3 ( Windows 2003 Cluster) and target on
Oracle 10.2.0.3 ( Solaris[tm] OE (64-bit))
We are getting this error while trying to create a change set. Tried all
modes That depends on your moral matrix. For me I consider the useless generation
of entropy to be evil. Since brain cells firing use energy thinking about
hit ratios generates entropy. Since hit ratios dGreeting
I am playing with TDE and uploading Oracle Wallets to OID as a means of
storing and backing up the wallet. For purposes of encrypting using TDE
it is possible to create the wallet via sqlplhi
I 'm reading Steve Adams 2001 Feb. News letter
http //www.ixora.com.au/newsletter/2001_02.htm
I have the same problem with high shared pool & library cache latch
contention on our production daI 'd be asking the why and what version question at this point - it 's
entirely possible that a combination of DBMS_MONITOR and trcsess in 10g will
help you.
That all said using oradebug to attach to tDon
The other thing you haven 't mentioned is what your database workload is
like. For example if it is an OLTP system you don 't want a parallel
process to max out the machine but force all your oJust upgraded from 10.2.0.3 and this view won 't compile. View references
columns that don 't exist in X$ESTIMATE_MTTR. Not sure if is the view of X$.
- Ethan
<br >Just upgraded from <a href "http //10I usually start at the top and run
du -sk *
two times...see which directory just grew and cd to it
repeat until you are in folder consuming all of the space.
I usually start at the top and run <brWe have installed 9i RAC (9.2.0.8) on Linux AS 4.3 AMD x86-64. We were
able to install Clusterware and RDBMS without any issues. Started
cluster service on both nodes and GSD on node 1 butt we are unThe online option appears to be an Enterprise Edition feature/option.
Here 's the result from a 10.2.0.2 standard edition attempt on RH Linux.
-joe
SQL > alter index THUNDERHEAD.PK_CM_ANNOTATIONS rebuI am reading the section regarding conditional compilation here.
http //www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part1.html#compile
What is the difference for the example below aWe 're looking for a senior level DBA here.
Want someone very proficient in RMAN partitioning large multi-TB
databases. RAC would be a definite plus.
Environment is AIX and HP-UX with OracleHi all
Anyone have access to both 7.2 database / documentation ?
I 'm after a list of the supplied plsql packages (DBMS_ UTL_ etc) that came
in 7.2
Cheers
Connor
Connor McDonald
|
|
|
