 | | | Oracle List | |
-----Original Message-----
From Tom Carty [mailto tcarty@(protected)]
Sent Friday May 13 2005 10 39 AM
To Ruth Gramolini
Subject RE force a title to print in sqlplus
Thanks RutHi 20
I have to use NVL function ( or similar ) in where clause. 20
I need to have column accessed via index. 20
Creation of functional indexes on nvl(column_name ) can not be done
for all columnOn 5/13/05 Ruth Gramolini <rgramolini@(protected) > wrote
> Good morning all
> One of my developers wants to know if there is a way to force the ttitle
to
> print on a report even if no roWe are in process of moving from a 2-node (4 CPU per node Xeon 1.6GHz) RAC to a 3-node (2 CPU per node 3.0GHz) RAC. The 2 CPU machines are hyper-threaded so it appears as 4-CPU 's. We 're splitting daHi
Can I use 10g to do logminer to analyze the archive redo log created from 8.0
Thanks
--
http //www.freelists.org/webpage/oracle-l
I 've not received any posts from the list for the last several days. Up until
this I 'd had no problems. Anyone any ideas (sensible please) why?
Thanks
Chris Dunscombe
Christallize Ltd
--
First error numbers and a code sample would be helpful.
Second you need to be using 9i or later to be able to read & write
binary data via UTL_FILE. You also need to use the PUT_RAW function
rHi
My database is 9205 on HP-UX 11.11. I was looking at a query that was
taking a long time to run today.
My guess from the trace is that the Oracle server process is reading 1
block and shiAny command I give gives the same error. I saw all the BP. All are
running fine.
Any idea why this is happening?
SQL > select open_mode from v$database
select open_mode from v$database
*
ERI have been setting a select few of my indexes to 'monitoring usage ' and 20
this is working for us 2E I have been able to identify several large 20
indexes that are never being used in our producWe are recovering from a SAN failure as we put things back together 20
we notice that copying database files from NFTS on one server to OCFS
on the Windooze cluster fails even a 1 k file. We can coOracle 10.1.0.3
Solaris 5.9
Several of my dba_hist views go invalid every night. I see a
discussion of this on metalink but no solution. (Both Mark Powell
and John Kanagaraj contributed to thI 'm trying to debug an application which had zero dba participation when it was built and now a client who is using it is experiencing 'performance ' problems.
In their statspack reports I originiaDrop index is waiting for the library cache lock as per the the trace
file below.
How to map the p1 and p2 parameters to identify who is blocking this object
?
I don 't see anything in gv$lock.
All
We have an application with 4 200 PL/SQL packages on Oracle 9.2.0.5 on
AIX 5.3. Many of them use associative arrays (index-by tables) and SQL
varrays. One or more of these packages does I have succeeded in getting PEAR to talk to Oracle from a Windoze box.
I am having a problem getting PEAR to successfully talk to Oracle from Linu
x.
It appears I am connecting to the Oracle DB wiYep here too.
On 5/12/05 William B Ferguson <wbfergus@(protected) > wrote
> Yep I wound up with the magazine yesterday.
> 20
> Hi all
regarding Oracle 8x 9x 10x.....
If I have a global temporary table and I store data in it commit it
and
the the session drops due to what reason ever what about the data that
Hi all
after upgrading an Oracle instance from 8.1.7.4 to 9.2.0.5 it began to log a lot of deadlocks. It 's was a critical production system so we have to find a rapid solution there was no time to
In an effort to upgrade an oracle database server I have run into a
problem that I need some assistance with. I have a server running
RedHat Linux AS 2.1 which has Oracle 9.2.0.4 running whicHi
I Got An Question Been Searching The Documentation .. Not Getting An
Hang Of It.
I Would Like To Know If Undo Block Is Brought In The Buffer Cache
During An Update.. SO What ProcesHello all
I am consolidating a number of applications to a single database.
I want to use the SERVICE_NAME feature to set current_schema for the appropriate application. I have created services_nMichael
This is exactly what I did for our HP-UX servers I found that the
9.2.0.6 <http //9.2.0.6 >patching process was actually easier than the
other
9.2.0.* options with the necessary security pRetail Company in the Greater New York City New York Area ( Long Island)
has an opening for
a sharp hands-on Oracle DBA Manager.
Selected candidate will have hands on technical responsibilities I ran a test this morning on a database involving a trace on an Oracle 9i2
database running on AIX with a Windows front end.
I was under the impression that the tim value in the header was millions Greetings
Oracle 8174 on HPUX 11 Multiple CPU Server using EMC Disks
I see 100s of Av Rd(ms) for some of the Datafiles in our hourly
Statspack reports.
If we look at the sar -d reports for tHi all
environment
Oracle 8.1.7.4.0
OS Solaris 8
We have a procedure that fails with the fallowing error
ORA-04030 out of process memory when trying to allocate bytes ( )
ORA-06512 at "PJeff
Have you thought of something as simple as an additional column with a
check constraint of values 1 thru 6? And then make this a part of the
primary key of the child table
Table B
PK dba1 mcc wrote
>
>I am collect the information now. Anyone have
>suggestion what kind of major tasks ORACLE consultant
>should do?
>
>
Well I 'd begin with 20 push-ups then some crunchesHi list
in 10.1.0.3 I tried to delete system statistics with
exec DBMS_STATS.DELETE_SYSTEM_STATS
No error. In sys.aux_stats$ the 'Flag ' goes from 1 to 0. And values for mreadtim sreadtim |
|
|
