Performance Improvement in Pro*C
Pro*C code compilation builds executable depends on the parameters passed while compiling a code on Linux OS. GCC compiler is widely used for compilation.
Parameters that it provides enables memory management and linking etc...
This means : Without changing Code GCC compilation parameter change can give significant improvement in performance without impacting functionality. Attached document contents details study of the same.
This document gives details about environment,deployment and pre-post change analysis.
Sanjay J. Sontakke
CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE
Step 1: Check if Flashback is enabled.
If you have installed OBIEE 11g successfully, lets try to explore some of the new features and tools available with BI Publisher 11g.
Unlike 10g, where Report is a single entity and data sets are the part of Report definition, in 11g, Data Sets (which termed as Data Model in 11g) and Report definition are two separate entities.
Data Model, which drive/extract the xml data for report is the advance version of Data Template, So there is no Data Template in 11g, its all Data Model with a very nice Data Model editor to design simple to complex Data model. This support some new data source like, BC4J View Objects and EXCEL, which were not supported in earlier releases as data source.
Report definition includes the Data Model reference, Layout template and other report specific metadata required to render or generate the Report output.
For these many years, we are using RTF templates as main Layout Template, now there is new format available with 11g, it is xpt format, which looks like Oracle’s proprietary format. As claimed, it generates almost pixel perfect output and could be a good substitute for PDF Forms. A nice Report Designer is available to design these xpt reports.
As I mentioned earlier, the complete report consist of two main objects, Data Model and Report definition. Data Model should exist, before we start Report definition.
Before design the data model, make sure the required jdbc connection is setup through BI Publisher Administration UI. To access JDBC data source UI, click the Administration from the Top bar and select the Manage BI Publisher Administration from the Common Administration Page.
Today I planned to test “Recover the datafile without prior backup”
Currently there is no failure in database. I shutdown the database & removed the below datafile in OS level “D:\ORACLE\APP\ORADATA\CHE\TEST.DBF”.
1.Database must be in archive log mode.
2.We need all the archive log files from lost datafile created.
1.Login into che database
SQL*Plus: Release 188.8.131.52.0 - Production on Wed May 19 14:21:03 2010
Copyright (c) 1982, 2008, Oracle.
Oracle Data Recovery Advisor 11g new feature
Data recovery advisor is one of the oracle 11g new features.
The Data Recovery Advisor tool can assist with diagnosing media failures, making recommendations and providing the RMAN commands to resolve the problem.
Data Recovery advisor we have used three commands.
How it works?
The Data Recovery Advisor stores its information outside the database in the Automatic Diagnostic Repository (ADR - V$diag_info)
If you find any problem in database and Data recovery a
Security is gaining importance. As per the reports in the year 2008, loss of confidential information has increased to 63%. This loss of confidential information is a breach of Service Level Agreement (SLA). Organizations will have to compensate these loses in the form of financial penalties.
A recent information protection law from a state in U.S.A claims that information of residents of this state stored in databases across the globe will have to be encrypted. Upon failure, the database owners will have to pay $5000 penalty.
Oracle installation: Oracle Binary Cloning
Clone the oracle software between two server.
Please check the OS compatibility are same between source & destination server.
Tar the oracle home 10.2.0.1
$tar -cvf 10.2.0.1.tar 10.2.0.1
Copy the oracle binary tar file from source server to Destination server.
$mkdir -p /apps/oracle/product
DBA’s faced data fragmentation issues frequently. Data fragmentation affects the database performance.
In production database, we need to follow any one of the below method to solve the fragmentation issue.
1. Alter table
--- Also we need to rebuild the indexes associate with tables.
2. Export the table / truncate the table / import the table
3. Create table
4. Online Data Redefinition
Table is not accessible for during the reorganization of table using Method 1, 2 & 3.
RAC Background Processes:
1. Lock Monitor Processes ( LMON)
2. Lock Monitor Services (LMS)
3. Lock Monitor Daemon Process ( LMD)
4. LCKn ( Lock Process)
5. DIAG (Diagnostic Daemon)
Trasliteration - Conversion of double/triple byte characters to single byte characters for various requirementsSubmitted by ayush_anand on Mon, 2009-12-07 06:49
I recently came across a document where the requirement was to convert from triple/double byte characters to single byte characters to send it for export complaince check as the export compliance system can accept only single byte characters.
Basically the useful thing about this was they were using IBM ICU project(an open source project) for this process,so in a way making it more open to developers.
These were the pros and cons for IBM identified by them.
- No interface needed (written in Java, integrable in Oracle)
- High level of portability, flexibility and scalability
- No int