Oracle
in [SQL]
|
Composite partitioned table purge causes need for index rebuild Oracle 10.2.0.3 EE on RHEL 4 In a critical 24/7 database we have a very large transactional table which is partitioned by date (weekly) and then further subpartitioned by list (we have 3 subpartitions per week). The nature of the list partitioning means we have one very large subpartition and 2 much smaller sub... 16 Sep 2009 19:43
How do I create a new emkey for Enterprise Manager Database Control? Hi, I just installed 11gR2. I am evaluating it. How do I create a new emkey for Enterprise Manager Database Control? I tried various combinations of this command: emctl config emkey I did find a probable bug: $ emctl config emkey -emkey -emkeyfile emkey.ora -force -sysman_pwd he11ow0rld Oracle En... 12 Sep 2009 05:22
Ora-19906 when restoring user managed backup - stumped! I have a test database I often restore from an online user managed backup (not rman), the procedure is simple: shut test database down copy files from last online backup on prod to test db locations, along with any archived logs since backup startup mount the test db, rebuild the controlfile renaming datab... 11 Sep 2009 11:43
Surprising Performance Changes with Oracle 11.2.0.1 (Long Post) I am working on an Oracle performance related project, so I thought that I would compare the performance of Oracle database 11.1.0.6 (on 64 bit Linux), 11.1.0.7 (on 64 bit Windows), and 11.2.0.1 (on 64 bit Linux). I set up a test case with a table containing 100,000,000 rows having an average row length of 53 byte... 11 Sep 2009 09:29
So is 11.2.0.2 going to be out anytime soon? Various posts on the oracle forum seem to say 11.2.0.2 linux stuff ... The version that Oracle is supplying now is 11.2.0.1 ... aka $ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 3 14:14:32 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. .... Any ideas gang? I tri... 7 Sep 2009 16:43
a contrast between oracle articles currently playing I think the current #2 article is on 11g version 2. The current #3 article is something about Sun and Oracle ... and how fast they are together. A copy and paste gets us these words ... Oracle and Sun together are hard to match. Just ask IBM. Its fastest server now runs an impressive 6 million TPC-C transactio... 4 Sep 2009 08:42
How to rewrite the query using with Clause Hi, Can any body help me out in rewriting the query using with clause where ever necessary or any method which suits for better performance. SELECT distinct (SELECT ood.organization_name FROM org_organization_definitions ood WHERE ood.operating_unit = ood.organization_id AND ood.... 24 Dec 2008 00:55
Grid Control 10gR2: repository password oracle(a)oracle-test-04$ uname Linux oracle(a)oracle-test-04$ uname -r 2.6.18-6-amd64 oracle(a)oracle-test-04$ echo $ORACLE_HOME /opt/oracle/product/oms10g oracle(a)oracle-test-04$ /opt/oracle/product/oms10g/bin/emctl getversion Oracle Enterprise Manager 10g Release 4 Grid Control Copyright (c) 1996, 2007 Oracle Corpor... 20 Dec 2008 09:57
libaio Hi, I am testing some storage configuration (raw devices/SAN) using oracle ORION tool. But SOMETIMES I've got error: waiting for async I/Os failed Linux-x86_64 Error: 14: Bad address Additional information: -1 Additional information: 1048576 I din't found any errors like that for this configuration (meta... 18 Dec 2008 16:05
ASM and RAID Now that we have sufficiently beat the RAID5 horse to death, let's add a twist to the debate. What is your experience either in the lab or real sites where you have the virtualization at the array level (pick your RAID level) in addition to the virtualization provided by ASM in an Oracle eBusiness environment. ... 21 Dec 2008 13:13 |