 | | | Oracle List | | I 'm finally replacing the backup scripts we use for
our databases with RMAN and am looking for any tips
from people that have been using it for a while.
First off if you 're not using a recoveryInherited a test box that has four 8.1.7.4 databases on an HP-UX box
running memwindows so they will all fit. This also incorporated a
"strange " set up with the listener in that it appeared as bestWe are running 9 2E2 2E0 2E6 on AIX 5L and suddenly we are getting weekly 20
ORA-600 [KGHALO4] errors in our alert 2Elog 2E Two weeks ago the database 20
actually crashed after one of these 2E AYes that is a good one for someone that doesn 't know how to setup a website
Microsoft VBScript runtime error '800a0006 '
Overflow 'CLng '
/getarticle.asp line 10
Rich
-----Original M
Hello list
I 'm trying to create a test scenario to understand what RMAN
construes to be a "corrupted " block. The initial assumption
is that its "backup validate check logical " command should
I 'm trying to nail down the range of NUMBER values. The range I come
up with based on a maximum precision of 38 and a scale range of -84
through 127 is illustrated by the following code block
On Apr 3 2005 10 08 PM Jonathan Gennick <jonathan@(protected) > wrote
> Is there any file in an Oracle installation that provides the
> declarations to the built-in functions? For example I 'd likHi
Talking Right To The Point
I Am A Oracle 9i Dba Looking Out For An Job Recently We Had A Campus
Recrute For DataWarehousing
The Compnay Was Taking About The Tools Of Datawarehousing Hello list
I have found Oracle strange behaviour many times that if a table has
restricted rowid the query takes hell a lot of time. I will give you
one scinario which I am facing.
we have OraMladen
Oracle is not unbreakable and will never be neither on Linux nor Windows.
The only reason you don 't see a 1-off patch is because no customer has
reported an issue yet.
Be creative and fi
You can check the my script posted at
http //www.quest-pipelines.com/pipelines/dba/tips.htm
HTHU
Ankur Shah
Oracle DBA
DHG-GA
Quoting dba1 mcc <mccdba1@(protected) >
> I tried to liYou cannot move the system tablespace you have to re-create the control
files to change the system data file 's path.
*****************************************************************************I am sure you are asking about how to move these TSs while db is up and
running..but it is not possible...
My only option would be
1) Shutdown the db
2) move(cp could be safe thing to do so thatHi
I have a question about partitioned tables. I am testing insert
performance on an ordinary table and a partitioned version of the same
table. Both tables are in the same tablespace with loWhat would make a tim value jump (as seen from a trace file from a
customer)
FETCH
#43 c 3D0 e 3D27 p 3D0 cr 3D3 cu 3D0 mis 3D0 r 3D0 dep 3D3 og 3D4 tim 3D6
589577675
EXEC
#44 c 3D0 eGlobal manufacturing company in the Ann Arbor Michigan area has 2 positions
available for
Oracle candidates.
This company is converting several platforms to Oracle using Oracle Financials
and MHi guys!
Setting Event 10499 to revert to the earlier behavior of NUMBER
datatypes that have no explicit setting of their scale value was no
expected effect on my Oracle database. What i?m doin > Both cpu and elapsed are displayed with two decimals so you separate
> them after the 1.47. Looks like elapsed came out so big that it ran out
> of room and besides running into the tail of cpu Hi I Got An Question To Ask
My Friends Recently Faced An Problem Relating To CharacterSet.
He Told Me The Clients Data And The Database Oracle Are Haveing An
Character MisMatch So How WouWe ran into the exact same issue noticing a lot of sql with high version
counts. After talking to oracle developers who worked on parts of the
code the bottom line is if CURSOR_SHARING 3DSIMILAR thselect dbms_metadata.get_ddl( 'TABLE ' table_name owner)
from dba_tables
where owner 3D 'USER1 '
This email is only intended for the person to whom it is addressed and may
contain confidentiHello list
We have one query in our trading application thats executed 1770 times
in just 20 mintues of time and around 490 users were connected
bascially this query runs for every tranaction.You can check the my script posted at
http //www.quest-pipelines.com/pipelines/dba/tips.htm
HTHU
Ankur Shah
Oracle DBA
DHG-GA
Quoting dba1 mcc <mccdba1@(protected) >
> I tried to list aI have an issue with slow I/O on FireWire drive. Drive throughput accordin
g
to my measurements is 500 KB/sec. It 's "K " not "M ". Other IDE or SCSI dri
ves
have throughput in excess of 20MB/seHi all
my company asked me for evaluating High Availability solutions using
various Oracle features. I considered RAC and Stand-by solutions
eventually combined together (RAC at the local site I never ever use US7ASCII
my default is we8iso8859p15
on request I also used we8mswin1552 and utf8
Peter
On Mar 31 2005 3 31 PM Scott Dial <smd@(protected) > wrote
> Just aDave
I agree. A couple of years back we managed to mess up an 8i installation on dev
server by copying the software (Oracle worked fine but not patching etc. was
possible). The issue related to I haven 't worked with a VMS instance since my first contact with
Oracle products in the early 90s so no practical experience to share
with you.
And that 's my point.
Most people don 't use OraYes please report back. I for one would definitely be interested. 20
-----Original Message-----
Steve Rospo
At the last PSOUG meeting Daniel was very excited about Oracle RAC on
Mac.
I can 'tCheck out this presentation from the RMOUG training days
http //www.rmoug.org/TD2005_Pres_Sum.htm - search for "Firewire "
"Building 10g RAC on Linux and Firewire-Based Storage "
Thomas
-- |
|
|
