Submitted by maheritc on Tue, 2010-01-12 18:40
Installing Oracle 11g 64 bit on Windows Server 2008
When installing Oracle 18.104.22.168 on Windows Server 2008 64 bit, the installer gave a an error saying the Operating System ( OS ) was not supporting. In looking at the install log on c:\program files\oracle, I noticed the installer thinks the OS is windows vista.
To work around this error, I selected the check box for user verified and continued with the install.
Submitted by David Lozano Lucas on Fri, 2010-01-08 08:56
Use the SQL Tuning Advisor for tuning SQL statements. Typically, you can run this advisor in response to an ADDM performance finding that recommends its use.
Additionally, you can run the SQL Tuning Advisor on the most resource-intensive SQL statements, referred to as top SQL, from the cursor cache or the AWR, as well as on a user-defined SQL workload.
To run the SQL Tuning Advisor do the following:
Submitted by jorgensundberg on Sun, 2009-12-20 16:36
Submitted by jp_vijaykumar on Mon, 2009-12-14 18:36
KILLING SESSIONS IN ORACLE
Author JP Vijaykumar
Date Jan 27th 2009
Modified Jan 29th 2009
One of my procedure is taking long time to complete. I want to kill my job and
re-run the procedure after incorporating HINTS.
Let us explore the options to kill long running jobs.
From the v$session, I found that my session is active.
select username, osuser,sid,serial#,status from v$session where sid=57;
Submitted by atchaya on Thu, 2009-12-10 06:14
I have worked in a table with one timestamp field namely Actiondate. We have updated the sysdate value of inserting time to that field. It contains around 30 lakhs records.
I want to get the records which are inserted a particular day.
I run the following 2 queries..
select * from history
where trunc(actiondate) > trunc(sysdate)
order by docintno
select * from history
where trunc(actiondate) > '01-dec-2009'
order by docintno
Both are taking too much time to give the results.
Submitted by simitechy on Thu, 2009-12-10 02:16
Both SQL Trace and TKPROF help to find the statistics of an SQL statement which could be used for query optimization.
Start Oracle SQLTRACE:
In Oracle, to start an SQLTRACE for the current session, execute:
ALTER SESSION SET SQL_TRACE = TRUE;
Stop Oracle SQLTRACE
In Oracle, to stop SQL tracing for the current session, execute:
ALTER SESSION SET sql_trace = false;
Submitted 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)
Submitted by vjain on Wed, 2009-12-02 14:42
Submitted by sarathannapareddy on Tue, 2009-12-01 14:22
SQL for SAS Programmers - Introduction
What is SQL?
SQL stands for Structured Query Language and was designed for development and maintenance within a Database Management System (DBMS). A DBMS consists of one or more tables of data, typically joined in a hierarchical fashion, and a series of programs for organizing the data.
Typical tasks performed with SQL code include the following:
Submitted by sarathannapareddy on Tue, 2009-12-01 14:21
In my view, Display Manager commands didn’t get much attention of SAS programmers as they should be. It may be because...
1) SAS Documentation has very little information about how to use this facility.
2) Even Google searches aren’t helpful enough.
Here are the list of Display Manager Commands I know…
Using Manager commands we can open the dataset from any directory without touching the Explorer window…