Questions tagged [oracle-11g]
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
715
questions
4
votes
1
answer
2k
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 ...
- 143
18
votes
4
answers
62k
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 ...
- 183
2
votes
1
answer
11k
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 ...
- 205
1
vote
1
answer
15k
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 ...
- 113
3
votes
3
answers
6k
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 ...
- 269
3
votes
3
answers
5k
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 ...
- 269
1
vote
1
answer
12k
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 ...
- 23.8k
15
votes
3
answers
38k
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,351
4
votes
2
answers
3k
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 ...
- 143
19
votes
6
answers
83k
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 ...
- 335
4
votes
2
answers
8k
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
...
- 12.2k
20
votes
4
answers
91k
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 ...
- 12.2k
10
votes
2
answers
6k
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 ...
- 12.2k
3
votes
1
answer
2k
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.
- 23.8k
5
votes
2
answers
2k
views
Oracle - Need help with RMAN Active Duplication on Windows 32 bit to a 64 bit
I need to have an Oracle 11g R1 on a Windows 32-bit duplicated to a Windows 64-bit using RMAN Active Duplication.
32-bit setup:
Windows Server 2003 R2 Standard Ed. SP2
Database - Oracle 11g ...
r3d