Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.
6
votes
2answers
2k views
How Long Would Take to Upgrade an 1T Oracle DB from 10g to 11g?
How long would take to upgrade an Oracle DB which has 1T data from 10g to 11g usually/roughly? I need to estimate the down time for it since it is a prod db. Thanks much!
3
votes
1answer
87 views
Are database backups specific to the OS on which they are created?
I am trying to get a better understanding of the behaviors of database backups for Sybase (15.X) and Oracle (11.x) as it relates to the underlying OS. Is the backup file OS specific or can it be ...
1
vote
2answers
2k views
What are the mandatory/required oracle 11g tablespaces?
Ok, what are the mandatory tablespaces in oracle 11g. My research has lead me to believe there are three of them: System, Sysaux, and Undo. However since I am taking the OCA and all the ...
2
votes
2answers
632 views
Piplelined Result Set over Database Link Alternatives
Since a pipelined result set cannot be returned over a database link (see MOS note 560743.1), what workarounds/alternatives are there. I can think of a few, but I'd rather not lead the question. I ...
2
votes
2answers
4k views
ORA-01502: index or partition of such index is in usable state problem
I have a table in my Oracle database, where
select pkcol, count(*) from myTable group by pkcol having count(*) > 1;
yields
PKCOL COUNT(*)
------- ----------
1 2
2 ...
3
votes
2answers
5k views
Oracle 10g dump file push into Oracle 11g database
Currently when executing the imp command with the following parameters: file=my.dmp log=my.log fromuser=myuser touser=myuser
The following errors occur:
IMP-00058: ORACLE error 12560 ...
1
vote
2answers
6k views
Clone / Copy Oracle 10g & 11g
Hi I am absolute begginer in Oracle domain. I would like to learn way how to clone copy oracle database to som backup, use this backup on another server.
Oracle is installed on Windows server 2003.
...
4
votes
2answers
1k views
Determine Index Compression Candidates Online
By doing the following I can determine if an index will benefit from compression and how many columns should be included in the compression:
ANALYZE INDEX Owner.IndexName VALIDATE STRUCTURE OFFLINE;
...
1
vote
2answers
446 views
Performance tuning OLTP query
I have following sqls executed million times a day, single execution isnt an issue but executing million times causing some performance issues..Thanks in advance for your help!
NOTE: data can change ...
6
votes
4answers
5k views
In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?
I'm writing a script to populate some tables with data for testing.
I would like to write something like the following but I don't know how to do it (I'm Oracle 11g)
SET ENABLED_USER_ID = ...
5
votes
1answer
2k views
Add Oracle Label Security to an existing Oracle installation
We are using Amazon EC2 to host some Oracle database instances while we are evaluating and prototyping some software. We are using the AMIs provided by Oracle - specifically, Oracle Database 11g ...
8
votes
2answers
402 views
LNNVL Justification
LNNVL is an oracle built in function that returns TRUE for conditions evaluating to FALSE or UNKNOWN, and returns FALSE for conditions evaluating to TRUE. My question is what would be the benefit of ...
5
votes
1answer
821 views
DROP PARTITION strategy using LIST-REF composite partitioning
We have a large Oracle 11gR2 instance with some tables that have recently become an annoyance when deleting data. This database powers a large optimization cluster that takes input metadata from the ...
6
votes
4answers
11k views
How can I unload Oracle database tables into a csv files?
I need to retrieve certain data from an Oracle 11g release 1 database and provide it as one or more CSV files. The data resides in multiple tables and/or views. All this should work via the command ...
1
vote
1answer
3k views
Net Start OracleXETNSListner
I am trying to run Oracle Express Edition on Windows 7 and getting the following error.
C:\oraclexe\app\oracle\product\1O.2.O\server\BIN>net start OracleXETNSListener
System error 5 has ...
1
vote
1answer
3k views
How to take undo datafile offline ,which is in recovery mode?
I am trying to take undo datafile in offline mode using following command
alter database datafile '<datafile path>' offline;
this datafile is in recovery mode. Oracle shows message as ...
3
votes
3answers
4k views
AWR Report - Tuning Database
We have an OLTP system, following are our AWR reports taken during peak hour window for three days once each day. We see a lot of direct path reads; we want to add more PGA in-order to reduce wait ...
3
votes
3answers
2k views
cursor: pin S wait on X in 11g
This has been one of top5 wait events in our database, even though there were not many waits but we see it as a potential threat, we want to find the root cause and solution.
Any advice will be ...
1
vote
1answer
4k views
Asynch Descriptor Resize explanation
What do asynch descriptor resize wait events mean on an Oracle 11g database running on Windows 2008 R2? According to My Oracle Support, this event applies to any platform, but the description ...
8
votes
3answers
5k views
Is there any difference between Rem and — comments for SQL*Plus?
On SQL*Plus prompt, both Rem and -- qualify as comment indicators:
Rem this is a comment
-- this is also a comment
create table emp (
id number primary key,
name cvarchar2(40));
Is there any ...
3
votes
2answers
1k views
Connection Pooling for PHP based website using Oracle 11g database
I am using Oracle 11g database server and now I am getting to see that OCI's persistent connection isn't much of a use, and a new connection is created anyway when a new user accesses the page. I ...
10
votes
4answers
9k views
Best way to delete very large recordset in Oracle
I manage an application which has a very large (nearly 1TB of data with more than 500 million rows in one table) Oracle database back end. The database doesn't really do anything (no SProcs, no ...
3
votes
2answers
1k views
How to return a CTE as REFCURSOR from an Oracle stored procedure?
I tried to modify an Oracle stored procedure to use a CTE instead of a simple Select Statement.
My procedure looked like this:
Create or replace Myproc ( MyRefCursor IN OUT SYS_REFCURSOR)
as
begin
...
15
votes
3answers
15k views
Can I change the SID of an Oracle database?
The Server is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Is there an easy & quick way to change the SIDs of the test databases on the server?
Dropping & recreating of ...
7
votes
2answers
2k views
Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?
I want to access data in an Oracle 11g database from SQL-Server 2008
I set up a linked server and when I execute
select * from [Link_server_name]..Oracle_schema.Oracle_table
and Oracle_table ...
3
votes
1answer
244 views
Is there a way to allow a proxy connection to use passed authentication in a public database link?
I think the answer to this is no, but I could be wrong. If nothing else it might be nice for others to be aware of this limitation of proxy connections.
