 | | | Oracle List | | DBA Learning schrieb
> Hi
> I am newbie here. I have made a backup on Oracle 10g using rman and
> 10g catalog. My backupset is in C /first_location/*.bak. This is shown
> in catalog database.
>
>
> > > >Am I correct? Could I use QFS for Oracle datafiles as well
as flash recovery area? If yes is there a perticular reason to choose
QFS over ASM beside eaiser file management?
...Sun should be As Cary is THE profiling guy I 'd suggest he 's book
"Optimizing Oracle Performance " from O 'Reilly
Felix
www.oraConsult.de <http //www.oraconsult.de/ >
-----Urspr?ngliche Nachricht-----
Von ora > > >In simple words Local disk are waaaaayyyyy slower than SAN
> > >and remote disk subsystems.
...and this is generally not true for Linux BTW (scsi midlayer madness)
--
http //www.freelists.org/weHi
if you 're really using this script you 're issuing 50000 commits - no wonder it takes so long. Make the commit at least outside the loop!
Felix
-----Urspr?ngliche Nachricht-----
Von oracle-l-hmmm... don 't they still have that stupid write throttle stuff too?
Hi
You can use a system event trigger (logon) that automatically kills the connections established when the clients use something you don 't wont!
Felix
-----Urspr?ngliche Nachricht-----
Von oraWW91IGNvdWxkIHRyeSBzb21ldGhpbmcgc2ltaWxhciB0byBhbiBhcHAgd2UgdXNlLiAgRXZlcnlv
bmUgaXMgZ3JhbnRlZAphIHNldCBvZiBwYXNzd29yZC1wcm90ZWN0ZWQgcm9sZXMgdGhhdCBhbGxv
dyBxdWVyeSBvciBtYWludGVuYW5jZQphY2Nlc3MgdG8gdGHi all
Environment
6 node 10G RAC on Solaris 2.9 E25K domains with 10.1.0.5 patchset with Veritas SFRAC 4.1 and Vxfs
We 've had the following problem on 2 nodes where we lose
tHeh! Looks like Russian DBA 's "love " DB 's web sites. -)
2006/6/8 Juan Carlos Reyes Pacheco <juancarlosreyesp@(protected) >
> This is the message there
> http //dba.ipbhost.com/
>
> Offline
> We have This is nothing new. It has happened to me almost every time I 've patched
Standard Edition since maybe 9.2.4.
If you ask Oracle Support about it they 'll probably tell to extract a
library from the There couple problems with your code.
First you want probably pass the values for "year " and "major " as a
parameters to your procedure
create or replace procedure ddh_test2(pYear IN
uwsias.i_majis " year using year " and " major_code using major_code " a valid sql syntax ??
me don 't think so ...
Raj
--
http //www.freelists.org/webpage/oracle-l
This might be a repost (Hemo is famous for that)
http //books.slashdot.org/article.pl?sid 06/06/07/1458232&mode nocomment
http //www.oreilly.com/catalog/artofsql/
Sample chapter
http //www.oreillyOn several occasions we have had a "bad " plan generated by the CBO (I
know this is old hat for you veterans in the field *grin*). A few in
particular will demonstrate these symptoms
* At some point Well this is PL/SQL batch and not OCI/JDBC. Anyway Oracle 9.2.0.4 as
methioned in the first post. Did you consider using Profiler to
analyze how much call to DBMS_APPLICATION_INFO contributes?
You cI am trying to use dbms_metadata.get_ddl but the ddl returned is too long and is getting truncated in sqlplus. I went to the sqlplus doc and the only set command I could find for lobs is lobof which Bob
We 're in the process of partitioning huge tables in the 3rd Party
Financials system (IFAS) that AISD uses. It 's not Peoplesoft but I think
the approach would be the same. We did get approvaJohn
Do you have 10g Automatic Memory Management (AMM) turned on? If so
then a lot of the init parameters are ignored.
To use AMM you set the sga_max_size sga_target and
pga_aggregate_target paramCannot see any problem with subquery i.e. why the second query is bad?
BTW both statistics are copied from the second run of each select to
avoid first time parsing overhead. Anyway to get the maximumWouldn 't it be interesting if the exam tested something important rather
than ambiguous terminology?
I hate exams that throw in questions that mean nothing just to try and
catch someone on a vague rewuff. That 's not funny. That 's the fact that optimizer never knows all the facts.
Sometimes I would like Oracle to stop overoptimizing and revert to the old good rules approach...
BTW it may be mereI had a request to install a database on a single node that if
required can have another node setup and added (i.e. 2 node cluster).
Has anyone done this before?
I thought I would ask before takinPaula Stankus wrote
> How do you unarchive files with ufsdump? )
ufsrestore )
--
http //www.freelists.org/webpage/oracle-l
Hi all
I don 't know if it 's off topic but I met it in SQLPlus.
I SPOOLed the output into a text. When the file reached to GB an
exception "xrealloc cannot reallocate 706258176 bytes (0 bytes aMy backup files are ufsdump filews. When using ufsrestore I get missing device name. I have not used ufsdump before.
Help? )
Hi
I checked out Async CDC a couple of months ago but currently I do not have
a 10GR2 environment.
I have a few questions on Asynch CDC in regards to setting up the change
table.
1. After lettiWe have about 10 windows servers some w2k some w2003 with 9i and 10g
databases on them. When the server gets rebooted the database services
don 't get stopped and the instances crash. They always r > Ok but my database 's tablespaces are NOT in backup mode. So what 's
> this actually telling me?
MetaLink Note 353606.1 After A Tablespace Hot Backup Ended Fuzzy Value Not
Set To Null
Regards
DCan you suggest some books and other resources to learn about
profiling.
Thanks
Joseph Amalraj
Cary Millsap <cary.millsap@(protected) > wrote
> though the fact that almost all of your |
|
|
