ORACLE 11g Database Parameters (Datawarehouse) - Recommended/Best Practice

Advertisement
November 30

Hi all
What are the generally recommeded database parameter settings for a a VLDB datawarehouse implementation with regards to:
- Online Redo log file size
- Number of Redo log file

Advertisement

Replay

Fahd Mirza wrote:
In My data warehouse of size just above 2TB, I have three tablespaces for three different schemas. One is for staging, other is for history and the other is for analysis and some near real time data. I use 3 bigfile table spaces of sizes 700G. The version of database is 11gR1 on Solaris 5.10, and I use ASM.
Fahd,
What's your backup startegy ?
Have you enabled "change tracking" so that rman can use proper incremental backups, or do you let rman scan the entire 700GB file to identify changed blocks, or do you use some type of "split mirror"/"snapshot" method offered by the hardware vendor ?
What's your resilience/recovery strategy ?
The OP is talking about lots of "nologging" activities - is your system similar, or do you force logging and run with a standby to protect yourself against failure.
(I kow I'm addressing the questions to you, but they're really there to prompt the OP to think about some of the related issues, and you may have some good answers that will help him/her.)
Regards
Jonathan Lewis

View 15 Replies

General Oracle Database Performance trouble solving best practice Steps

November 30

We useĀ  Oracle 11g DB on Windows2008R2 as web application backend DB. We have peformance trouble in that DB. I would like to know General Oracle Database Performance trouble solving best practice Steps. Is there any good general best practice documen

View All Replies

Apex 3.2 install in oracle 11g database

November 30

hi, how to install oracle apex 3.2 in oracle 11g database and any other tool have like oracle query browusr (need to build a query drag and drop). regards denDen Oracle 11g comes with apex. You should refer to the documentation at... [http://www.orac

View All Replies

Oracle 11g database can we update patch directly from 11.2.0.3.0 to 11.2.0.4.0?

November 30

Hi, I have installed Oracle 11g database. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for 64-bit Windows: Version 11.2.0.3.0 - Production NLSRTL Ve

View All Replies

Oracle 11g database link to Oracle 8

November 30

Hi, database-links from an Oracle 11g to an Oracle 8-Database seem to do not work: The error in enterprise manager is: socket error (translated from german). There are no alerts at the Oracle 11g-Database. On the other (Oracle 8) side, the alert we h

View All Replies

Oracle 11G database and Application Server installed on same server

November 30

What are the pros and cons installing Oracle 11G database and Oracle Application Server (Forms and Reports) on the same server? Thank you in advance, SonyaSome may want their data in a separate network zone for security reasons. It also depends if it

View All Replies

Oracle 11g database stores CAS number incorrectly in chemical database.

November 30

Hi, I have an issue in Oracle 11g database. I am working on a chemical database which handles chemical structures ,formulas, CAS numbers, ACX number. The database has a compound table which stores compound attributes like chemical structure, molecula

View All Replies

Oracle Tuxedo 8.1 With Oracle 11g Database

November 30

Hi, I have an old application that must be compiled with oracle 8.1 and Oracle9i Database. We are migrating to Oracle 11g Database, and now we have some inssues to compile with Oracle 11g Database. For example some Libraries that the Tuxedo XA Resour

View All Replies

Which latest web logic server compatible with oracle 11g database

November 30

which latest web logic server compatible with oracle 11g database >is weblogic server 12c is compatible with oracle 11gR2current environment= forms and reports 10g and database 10gR2,os windows 32-bit. wants to implement and configure as below: serve

View All Replies

DB13: Execute Redo log backup of remote Oracle 11g database fails

November 30

Dear Experts, First of all I have to state I am not very experienced in administrating (Oracle) databases, but I would like to ask you all the following: We run two SAP Systems with each their own database on the same host: 1. SAP SRM ABAP system on

View All Replies

Oracle 11g Database Crashed

November 30

Dear All, We have Oracle 11g R1 64-bit database on MS Windows 2008 64-bit. It is having Oracle RAC and we have two nodes on RAC. It was crashed due to out of memory issue. Where as each node is having 16GB of RAM. I am displaying current init paramet

View All Replies

Oracle 11g Database Examples when to install Pre(or)Post DBUA?

November 30

Hi Friends, I am performing Oracle DB Upgrade from 11.2.0.1 to 11.2.0.3 I want to install Oracle 11g Examples also so when can i install it , Pre (or) Post DBUA (or) both are supported? Plan A: 1) Install Oracle 11.2.0.3 on new home 2)Install Oracle

View All Replies

Weblogic with Oracle 11g database

November 30

Hi All, I've just upgrade oracle 11g and suddenly the apps informed me that their weblogic version 10 has issues connecting to 11g database. Please advice which version of weblogic supports 11g and details like jdbc driver or etc will be beneficial.

View All Replies

Issue in Oracle 11g Database Change Notification  for Java application

October 11

Hi, I am trying to use Oracle's Database Change Notification in Java application. I followed the sample application (+DBChangeNotification.java+ , Example 29-2), provided in the following link: +[http://download.oracle.com/docs/cd/B28359_01/java.111/

View All Replies

Oracle 11g Database 64-bit, Client 32-bit

November 30

Hi, I have a problem, I have an IBM Sever with 64-bit processors. On it there is a Windows Server 2008 also 64-bit. I've installed Oracle Client 11g 64-bit. And there is my problem. I can't connect to this database using tools like SQLTools or BDE Ad

View All Replies

Oracle 11g database Skills testing

November 30

Hello, I want to know, if there exist any system or tool or any real time case study which can I run on oracle database and test my knowledge and skills. Since I'm at student level and are learning Oracle 11g in deep. Now I want to make a real world

View All Replies

Can I use oracle client 10g express to work on oracle 11g database

November 30

I have installed an oracle DB 11g, I also installed oracle client 10g express edition to create users and tables. I noticed that the users I created can't connect to db with error message "Error java.sql.SQLException: ORA-01017: invalid username/pass

View All Replies

Oracle 11g Database Backup

November 30

hi, How do we take a schedule backup from oracle 11g db. i am now taking manually using EXP. i am looking similar to MS SQL Server scedule backup.The easiest way would be to do it through the EM of 11g. Its the gui interface of RMAN but it would appe

View All Replies

Import oracle 11g database into oracle 10g Server -

November 30

Hi guys, We have a oracle db running on Oracle 11g. Now, we would like to export from oracle 11g into Oracle 10g XE for important demo. Is it possible?? When i try to import into Oracle 10g XE, the following Error msg appears : IMP-00010: Not a valid

View All Replies

Warehouse Builder with Oracle 11g Database

November 30

Hi, I feel a bit confused. We are using the Business Intelligence Standard Edition One and we have installed the corresponding 10 version. With this Warehouse builder 10 version, we can not import tables from a 11g Oracle database. What should I do?

View All Replies

Tags:

  1. mctube pro cannot download pdf
  2. anything
  3. reset dw fabrica iphone modelo a1418?
  4. macbook pro osx10.6.8 hdmi display on tv
  5. nokia n81 stuck on nokia logo
  6. youtube does not open safari mac kids ç
  7. Neha jpx pothos
  8. screen exist used in ml81n
  9. RBKP RBSTAT Update BAPI
  10. how to make my bt id as a primary bt id
Copyrights 2017 Fcffair BigData Resource, All rights reserved