Oracle Database Administration [Archive] - Page 88

Oracle RAC installation on a single node Linux
Oracle 9i Streams for Replication
index doesn't pick up for some reason
Who all are logged in last day
measure time a SQL has taken
logical reads
Does Select uses DB_buffer_cache?
How To Force Oracle To Use Index On The Update Statement???
Recursive Statements and Nested Tables
Security Alert #54 Patch
Network address routing
File layouts on disk
Load DB2-EBCDIC data with packed numerics using SQL*Loader
instances problems
Check the privileges user wise
Deleting 10 millions records from 90 million
Error in DBMS.CREATE_STATS_TABLE
Last submitted SQL statement from current session
update on view on 9i
Can I use session set events for cold back up
Egenera Blade Servers!
How to call executabels in PL/sql
Can I create primary key, foreign key cross schema?
Can I skip a corrupt archivelog in a restore?
listener for 8i and 9i
9i Install error on AIX
Database User usage
How to increase the max proceed?
how to update ORACLE_HOME to use a softlink instead of a real direcoty?
details on Oracle Clinical
How Temp Table is handled During System Crash in Oracle
ORA-1652: unable to extend temp segment by 32 in tablespace TEMP
ORA-1652: unable to extend temp segment by 32 in tablespace TEST_LARGE_IX
sql tunning
Oracle 8i Standby
utl_file problem on Solaris 9i database
configure retention policy to recovery window of 0 days;
datafile needs media recovery
Resetting Rman catalog when nothing else works....
8i to 9i to ugghh!!
Help with Oracle 9i..General DB Question
Which one is better to use ?
Index Rebuild
DBUA init parameter COMPATIBLE issue
9i deinstall on AIX 4.3.3
High Memory utilization
Transportable Tablespace
Sequence Number Generation
How to make standby server on remote locations
Regarding "Authentication" (RADIUS)
Moving Database from Dg Unix to HP Ux
Data Encryption (Entire tables)
error when make pfile from spfile
give me a way to study Oracle
Ora -01652
Agent is out of sync with OMS
sessions & processes relation
Moving a DRG to a new LAN
Materialized View
can an index improve import performance?
Library Make Error
OEM Server and Oracle Agent problem
slow in inserting to Temp table.
Explain Plan
Database Cluster table
Running a script remotely
Stats$sesstat
High I/O
set env on Linux
SQL*Net/Net8 Encryption
what privillege to grant?
privilege issue on OMS
What dictionary view should be querried to see all the table names in the database?
privillege question
backup, restore and then startup
table dump
Moving long raw data type table from Dictionary managed table space to LMT
rollback segments
Sql Prompt Change
Set autotrace
How to get length of an Long Raw Data type field in a table
partition by week day
Materialized views problem
Temporary Tablespace
help on this sql query.
skgpspawn failed encounter in alert.log
ORA-04020: deadlock detected while trying to lock object
How to bring up universal installer
Faster import solution
Rollback segments online when startup
Long Running Querry
off toic - touch a file in windows like unix
top 5 wait event
one timezone to another time zone
I get Unable to initialize threads: cannot fine class java/lang/Thread error
2 sessions executing same procedure same time
alter tablespace.......
Tool tablespace
best way to add a new column with value
data
Import from 7.3.4 to Oracle9i
How do you find out the timezone in which the server runs?
select * from tab
Problem with 9iAS infrastructure
Implement encryption between apps ser - 9i
concurrent sessions
ora-08177 can not serialize transaction
execution plan different
Inserting records from one table into another
Backgroung Process(LGWR,CKPT)
Creating index in foreign key
function based indexes on object tables
problem after migration..
9i DB Install
Listener.ora is missing
diff b/n char and varcha2
data loading fron db2 to oracle
nuts-n-bolts/tools-n-props DBA
Truncate a cluster Table
ORA-06508: PL/SQL: could not find program unit being called
execution plan not the same in 2 boxes (same RBDMS and DB)
what does "enqueue" in the stats pack result mean?
Cannot logon to management server
OS authentication mixup
Is RMAN availabe with Oracle 9i Standard Edition?
Syntax for assigning privileges to roles
pga_aggregate_target to workaround pga memory leak?
two listeners
How to read from a assigned variable name and help with clob datatype
PL/SQL Quest
oracle 9i database installation problem
Fast Refresh of MV not working
problem inserting DATE type.
Oracle Internet Directory an overkill for LDAP?
What went wrong with this rename column statement?
<java.sql.SQLException: ORA-01002: fetch out of sequence
Ora 9i for AIX 4.3.2?
online backup
Oracle System Privileges
System Tablespace Resize --Crusial thing happened
Install 9.2.0.4 patch
Ora-01403
high consistent reads and cpu running at 100%
lose snapshot changes in replication
Tuning (Optimizer uses a bad plan)
DDL for tables using indexfile
find out what privillege a user has
executing stored procedure
V$ Views
Changing a hostname
repeating trace errors in alert file
How to add other instances into management server?
database design
Spool to text file?
ORA-03113 while I create view
oemLaunchOms consuming lots of CPU
Is PMON still rolling back ?
Ora-30926:
Having trouble indentifying OraInst.loc for 4 Oracle_home
Exp-00091 On 9i Database
How will I find the patch level of the DB?
Installing 32 bit Oracle on 64 bit unix
Retention time in Oracle 9i
Excluding tables in full export
Hotbackup - doubt
Oracle Streams
import
oracle 9i database installation problem
Question on Installation of DBA Studio - 9i
Is there any way to import data in to one Tablespace and Index into other..?
Free space in SGA
Background processes locked objects
How to prevent reuse of password in 8i.
audit question
Sql tunning
DB Migation / Upgrade from 8i to 9i (ops)
How to delete RMAN backup automatically..?
Connection between Lotus notes and Oracle
using parallel in Index creation
OID MultiMaster Replication
Discover
9i
Replication!!
function
where in Oracle website can I find info about how to use log Miner?
View Images from Blob Field
Oracle 8 Client
Ora-604 And Ora-942 Running An Insert Statement
importing db tables
Is there any way to know particular record is in which data file..?
Indexes using ASC/DESC order
problem in configuring MTS mode
standby DB controlfile issues
Urgent!!! Materialized view in 9i
alert log is not updating..
startup failed , ora-1122
discover
Release locks?
Default schemas
Is it a TABLE SCAN?
Neophyte: sub-select returning multpile rows
why din't this alter system work ?
Analyze and Temp Tablespace
LONG datatype error
Dataloads in 2 different boxes
Track a long DELETE execution
Latest error number
how to Insert an image
Cannot drop Materialized view
Importing 8i data into Oracle 9i database
how to interprete unix TOP ultility program result?
Schema Size
0922 error
Pro*C need to re-compile if Oracle Upgrade from 8i to 9i??
Hotspots??
how to oracle db
Moving Enterprise Manager to another server, How??
oracle on cluster
nls_Date_format ?
new partition slows down report
ORA-30553: The function is not deterministic
Could not Locate Java runtime when starting OEMCTL?
Expression in Primary Key
Expression in Primary Key
Memory Settings
How do I delete replication?
Freeware Linux?
Optimizer Architechture
How to claim back space in a tablespace or datafile?
At what point a session terminates exactly?
EXP-00008: ORACLE error 1555 encountered & IMP-00009: abnormal end of export file
ORA-00406 COMPATIBLE parameter needs to be string or greater
Max number of sessions exceeded
DB Link
Quantity of Archive Log Files
rman single question
Preferred credentials for node when exporting in LINUX box
dblink
Ref:(Few queries on Hot Backup)
8.1.7.4 and Security Alert #59
Multiple Archive Destination
Database Creation
extract data from Oracle to UDB
all control files are lost
pfile vs spfile
waits on segment header and data blocks
Table Size
database link question
Finding ROWID's locked
Shared Pool