 | | | Oracle List | | Hello all.
In my last job I set up a test environment to check the benefits of
CIO and
JFS2 using
Oracle 9iR2 (9.2.0.6) on AIX 5.2 ML5
Machine one partition with one processor of an IBMBecause the numbers are added up. Those specific statistics are not
designed to be aggregated.
On 5/31/05 Amihay Gonen <AmihayG@(protected) > wrote
> Hi.
> I have some specific situation that IPerhaps I 'm missing something here but .. do you really need DataGuard with
this configuration?
You just can stop the primary and start the other one ... or you need the
secondary open in readPCMCIA actually stands for People Can 't Memorize Computer Industry Acronyms
so COTS actually means Completely Obscured Technological System.
punchline If in doubt spell it out. If you 're sureExcellent company in Austin Texas is looking for an experienced Oracle DBA
who has 9i and data warehouse experience.
The selected candidate will be responsible for the design creation
maintenanceHi All
We have requirement for 3 Apps DBAs with +2 yrs. of experience.
The job location will be Hyderabad or Mumbai (India).
The candidate should be good at troubleshooting patching cloning hi all
I have got one doubt. Is it possible to set username for the background
processes which is normally blank and osuser column contains value "SYSTEM ".
Why I am asking is because I have not
SQL > CREATE OR REPLACE PACKAGE ref_test AS
2 TYPE RefTyp IS REF CURSOR RETURN sys.dual%ROWTYPE
3 PROCEDURE ref_proc (p_ref IN OUT RefTyp)
4 END ref_test
5 /
Package created.
Has anyone had an issue with MAX* columns within DBA_TEMP_FILES being
wrong?
I 've got one temp tablespace type temporary defined for all users and
the default at the database level (9.2.0.4 The OAUG DBSIG is holding a meeting during the OAUG Connection Point 2005
Conference (aka The OAUG global conference for 2005.) For folks in your
situation I can 't think of a better place to be. In SQL > describe dba_objects
Regards Carel-Jan
If you think education is expensive try ignorance. (Derek Bok)
> Izzit possible to retrieve when the table or any
> database objeHave you opened a TAR on this? You should if you have support that is
not charged per incident.
What is your version? There were a couple of bugs related to this
view but I don 't see anything reWell I 've R 'd the FMs and can 't seem to find a clear answer - as I 'm
new to DataGuard I need your help! -)
I 've been asked what the ramifications of doing a cold backup on a
physical standbySol
I purchased the Wise-STD product using the same logic. 10 bucks is a
cheap price if the product helps even a little bit.
OS RedHat AS 2.1 and AS 3.0
Oracle 10.1.0.3
The problem I foDid somebody see too many Dirty Harry movies over the weekend?
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Mladen Gogala
SeSee inline.
> 1. Using a physical database as the Data Guard does the second server
3D
> have to have the exact same physical equipment for the disks or does it
3D
> just have to be the Just saw Adrian Cockroft has a blog.
http //perfcap.blogspot.com/
Commented recently on a storage performance product created by Dave Fisk
and mentions Oracle.
http //www.ortera.com/
MiHello Carel-Jan
I am always reading with a great pleasure your postings ).
I have tried to keep the configuration as symmetric as possible.
"stby " ist the name of the connectString for the staSELECT table_name
FROM user_tab_columns
WHERE column_name 'MEDICODE '
/
----- Original Message -----
From Kean Jacinta
Sent Fri May 27 00 34 02 MDT 2005
To oracle-l@(protected)Hi
Does anyone have advance knowledge about this?
http //www.oreilly.com/catalog/advperl2/
New version due next month?
Regards
Mike Thomas
--
http //www.freelists.org/webpage/oracleQuoting David Turner <dnt9000@(protected) >
>
> I 've set up a script that montors the db every minute
> but it just doesn 't appear to be catching what is
> causing our normally fast running queriOn 5/26/05 Jesse Rich <Rich.Jesse@(protected) > wrote
> Hey all
> 20
> The link I had for showing the diffs between the One Standard and
> Enterprise editions is no longer valid. And IMichael
While other DBA 's are sharing good tech info I can not.
> > "That doesn 't matter. We have willed it to be Sql Server. "
I can get past this statment. Seems the discussion is already overDave
DBMS_METADATA is rather buggy in 9i. You might have to write your own procedure to extract db_links. Most object names in the database are 30 characters so the procedure was probably writMichael
This RAD approach is interesting. What has happened is that most
systems are so small either in the number of users or the amount of data
that proper database design really doesn 't mattHi all
I have a query on a simple table of a few thousand rows that suddenly takes minutes instead of < 1 sec and it is only slow when called from a procedure. One suspicion is that the system statsHi All
TRADE_BASE is a partitioned table .
SELECT COUNT (*) AS totalcount
FROM trade_base
WHERE (buyer_account 'www.cnoug.org <http //www.cnoug.org > ' OR
seller_account 'www.cnoug.org <httuse log_archive_dest_n parameter.
log_archive_start is obsoleted in 10g. remove this parameter from your
spfile or pfile.
On 5/26/05 Oracle <all_about_oracle@(protected) > wrote
>
> Hi
>
>We used DBUA to upgrade from 8.1.7.4 to 9.2.0.6 and everything went well
except in the POST upgrade steps. Specifically the schema recompile.
Oracle hardcoded a serial recompile and it take about 1This is just an FYI. Oracle 10.1.0.4.0 on Windows.
User A has all privileges necessary to flash back user B 's tables. 20
Some of User B 's tables are protected by a row-level security policy. 20
|
|
|
