Oracle

December 2005

STATSPACK question from a previous interview - just curious
(31 Dec 2005 17:11:42)
PSP Process Form Page
(31 Dec 2005 14:35:51)
LISTOWNER- EMAIL SHIELDING
(31 Dec 2005 14:0:16)
LISTOWNER- Too Many Emails in your inbox?
(31 Dec 2005 14:0:2)
IP check
(31 Dec 2005 8:57:43)
Block error
(31 Dec 2005 6:15:31)
Problem
(31 Dec 2005 2:54:55)
Happy New Year
(31 Dec 2005 1:30:41)
crontab and exec
(30 Dec 2005 21:59:45)
New Year Greeting
(30 Dec 2005 21:4:29)
Re: Number of Occurrences
(30 Dec 2005 14:28:30)
Number of Occurance
(30 Dec 2005 14:12:44)
Please Help me
(30 Dec 2005 13:25:46)
Tablespace Recover
(30 Dec 2005 10:21:26)
archive log stop: rollback:
(30 Dec 2005 8:18:46)
Database version
(30 Dec 2005 7:58:15)
How To Open File ?
(30 Dec 2005 0:40:13)
Re: [***SPAM***] - Calling Linux scripts from Oracle stored procedures - Number of numbers in MIME From exceeds maximum threshold
(29 Dec 2005 20:44:54)
Calling Linux scripts from Oracle stored procedures
(29 Dec 2005 20:39:18)
AIX 5L and Oracle 9.2.0.6 ORA-04030 errors...
(29 Dec 2005 18:54:4)
processes/sessions
(29 Dec 2005 17:4:5)
UNDO Tablespace Growing
(29 Dec 2005 16:59:28)
7.3.4
(29 Dec 2005 15:27:55)
counting hits in an application
(29 Dec 2005 14:51:32)
how can i catch the client ip?
(29 Dec 2005 14:47:10)
NLS_CHARACTERSET
(29 Dec 2005 14:4:44)
10g R2 on Redhat 3
(29 Dec 2005 10:23:38)
Nice User Hit Ratio Script
(28 Dec 2005 20:23:44)
How to rebuild Oracle 9i database once the Oracle_Home is lost.
(28 Dec 2005 17:47:43)
Installing Oracle on AIX 5.2
(28 Dec 2005 16:16:44)
Viewing connected users ip address
(28 Dec 2005 13:31:59)
DBWR VS DB_BLOCK_LRU_LATCHES
(28 Dec 2005 12:36:58)
How to Call SP from Unix Shell Script ?
(28 Dec 2005 10:29:22)
Substraction of 3 date fields
(28 Dec 2005 8:43:43)
Re: [SPAM] - Substraction of 3 date fields - Number of numbers in MIME From exceeds maximum threshold
(28 Dec 2005 8:28:9)
how to ???
(28 Dec 2005 0:53:48)
Noarchive mode
(27 Dec 2005 21:26:31)
spfle question....
(27 Dec 2005 20:12:52)
application.log
(27 Dec 2005 20:11:32)
listener question
(27 Dec 2005 19:48:11)
Re: create rman database
(27 Dec 2005 17:55:17)
RMAN
(27 Dec 2005 17:39:35)
OFF TOPIC - PLEASE!
(27 Dec 2005 15:49:2)
Oracle 9.2 Parameter list
(27 Dec 2005 15:19:40)
Deletion Wait Events
(27 Dec 2005 15:14:9)
Schema Backup
(27 Dec 2005 14:34:9)
standby and backup
(27 Dec 2005 14:24:16)
OFF TOPIC!
(27 Dec 2005 14:2:38)
Full table scan problem
(27 Dec 2005 11:13:21)
longraw
(27 Dec 2005 9:41:34)
FTP PACKAGE OR PROCEDURE FROM ONE SERVER TO ANOTHER.
(26 Dec 2005 14:25:29)
CheckPoint Rate
(26 Dec 2005 14:16:44)
MS Access to Oracle >>>>>>>
(26 Dec 2005 14:3:22)
MsAccess DB to Oracle >>>>>>>>>>>>>
(26 Dec 2005 14:1:6)
Redirect unix
(26 Dec 2005 13:54:20)
temp tablespace full
(26 Dec 2005 13:29:25)
Java Stored Procedure Problem >>>>>>>
(26 Dec 2005 11:26:10)
MS SQL Server equivalent to Oracles @TYPE definition
(24 Dec 2005 17:30:8)
Oracle9i HTML DB vs OAS
(24 Dec 2005 16:34:34)
Calling external procedure using SOAP
(24 Dec 2005 14:8:17)
Help with Trigger / Stored Procedure
(24 Dec 2005 14:8:8)
Merry Christmas ...
(24 Dec 2005 5:0:54)
RMAN & MML for HPUX?
(24 Dec 2005 0:56:21)
mailing to an external id
(23 Dec 2005 21:54:41)
DBAs
(23 Dec 2005 19:34:42)
Re: [***SPAM***] - RE: comma delimited list - Number of numbers in MIME From exceeds maximum threshold
(23 Dec 2005 16:17:13)
DBMS_REDEFINITON for Oracle 9i
(23 Dec 2005 15:18:44)
migrate oracle to oracle db
(23 Dec 2005 10:36:30)
DB PROBLEM
(23 Dec 2005 6:13:24)
Columns used in Views
(23 Dec 2005 5:10:6)
Oracle to SQL Server
(23 Dec 2005 4:45:30)
DBMS_METADATA alternative ... ???
(22 Dec 2005 21:50:15)
Recover Problem
(22 Dec 2005 21:15:30)
Question about DBMS Jobs
(22 Dec 2005 20:45:26)
DBMS packages views ...
(22 Dec 2005 20:44:32)
RMAN and CONTROL_FILE_RECORD_KEEP_TIME and RESTORE/RECOVERY
()
32 bit -> 64 bit conversion
()
Oracle Books
()
changing intelligent agent port
()
Analyze to DBMS_STATS
()
Holiday Greetings
()
Tablespace Online /Offline
()
Statspack
()
proc error
()
OCP center in Chennai.
()
One more UNIX HOW TO ... ps -ef
()
check constraint -> xxx.xxx.xxx
()
UNIX find ... HOWTO
()
while table is locked for update, why affect select
()
statspack ...
()
Daylight Savings Time
()
Documentation for Oracle 10g Policy Framework
()
Holidays
()
Upgrade 9.2.0.4 to 9.2.0.6
()
Random Numbers in Oracle
()
AQ purging question for good DBAs and AppDevs
()
comma delimited list
()
Oracle Streams and LogMiner
()
DELETE taking more time.
()
How to change log_buffer value?
()
How to Rename a Table
()
Datawarehouse repository metadata scriptbuilder
()
Re: Work simulate interviews ... thank you
()
Work simulate interviews ...
()
HTML DB
()
Oracle STREAMS and ARCHIVELOG mode
(20 Dec 2005 19:15:39)
DELETE taking more time. Rollback Segment
(20 Dec 2005 16:45:9)
db check
(20 Dec 2005 15:44:45)
ora-12500 dedicated sessions URGENT (repost)
(20 Dec 2005 11:32:15)
Killing the Session
(20 Dec 2005 11:6:36)
Configuring Listener
(20 Dec 2005 9:49:55)
Re: 10g - DB GROWTH script - i.e. how much is my DB growing per month?
(20 Dec 2005 1:31:37)
what is up with this?
(20 Dec 2005 1:10:50)
db Startup/shutdown script
(20 Dec 2005 0:6:5)
How to decide what DB_BLOCK_SIZE to use
(19 Dec 2005 23:51:3)
Disable Shared Server
(19 Dec 2005 18:6:27)
metalink ?
(19 Dec 2005 17:34:2)
Converting DB block size
(19 Dec 2005 17:26:11)
ORA-600 How deep is the st__________ I am in?
(19 Dec 2005 17:21:4)
Nologging in Oracle Database.
(19 Dec 2005 15:45:22)
size of SGA
(19 Dec 2005 15:23:6)
Drive Configurations
(19 Dec 2005 13:38:44)
Database migration
(19 Dec 2005 12:54:4)
Rép. : database migration
(19 Dec 2005 11:57:50)
export options
(19 Dec 2005 10:34:22)
Re: Error applying 9.2.0.6 patch on Solaris 5.8
(19 Dec 2005 8:18:25)
Error applying 9.2.0.6 patch on Solaris
(19 Dec 2005 8:14:23)
Re: OS system call failure
(19 Dec 2005 7:57:19)
TIMED_STATISTICS
(19 Dec 2005 5:53:44)
DBMS_METADATA.GET_DDL
(19 Dec 2005 4:18:45)
TEMPFILES, UNDO, ROLLBACK SEGMENTS
(18 Dec 2005 23:35:22)
Users being locked at unspcified time intervals
(17 Dec 2005 4:59:14)
Stop and start jobs
(16 Dec 2005 22:18:47)
Oracle ASM ?
(16 Dec 2005 22:13:11)
Viewing users actively using the database
(16 Dec 2005 19:38:9)
Limiting Journaling
(16 Dec 2005 18:13:35)
Pipe line Function
(16 Dec 2005 17:40:38)
backup policy
(16 Dec 2005 16:57:59)
Oracle 10G Database (Flashback Query)
(16 Dec 2005 16:45:29)
multimaster replication
(16 Dec 2005 15:54:41)
Re: export/import
(16 Dec 2005 15:26:31)
AQ purging question.
(16 Dec 2005 13:54:20)
Re: [***SPAM***] - RE: proc error
(16 Dec 2005 13:46:14)
tkprof
(16 Dec 2005 13:38:7)
connect as sysdba using connect string
(16 Dec 2005 9:38:1)
date
(16 Dec 2005 5:55:37)
Date format
(16 Dec 2005 5:43:41)
Corrupted ROLLBACK SEGMENTS ....
(16 Dec 2005 2:30:47)
Applying Privs for Single Schema Import
(16 Dec 2005 1:27:25)
Re: [***SPAM***] - Re: Reduce length of a column - Number of numbers in MIME From exceeds maximum threshold
(15 Dec 2005 20:32:32)
Should be easy one to those who Know -
(15 Dec 2005 20:24:3)
Re: ORA-27102 out of memory
(15 Dec 2005 20:11:35)
Question?
(15 Dec 2005 18:59:24)
Re: [***SPAM***] - RE: proc error - Number of numbers in MIME From exceeds maximum threshold
(15 Dec 2005 16:19:29)
Reduce length of a column
(15 Dec 2005 15:42:23)
RMAN and cross-OS recovery...
(15 Dec 2005 15:30:49)
SQL Licensing
(15 Dec 2005 15:14:19)
Re: Help On Crystal Report Oracle
(15 Dec 2005 14:52:43)
Performance over VPN
(15 Dec 2005 14:17:16)
Performance issue
(15 Dec 2005 11:18:49)
Oracle database version...
(15 Dec 2005 4:37:56)
DBMS package to refresh objects
(14 Dec 2005 21:17:7)
sybase???
(14 Dec 2005 20:41:50)
Audit config validation
(14 Dec 2005 18:40:3)
Oracle View
(14 Dec 2005 15:28:30)
database schema
(14 Dec 2005 15:15:49)
ORA 12705 Invalid or Unknown NSL Parameter error.
(14 Dec 2005 14:20:37)
Schema Import and Creation of Users and Roles
(14 Dec 2005 13:24:7)
ORA-27102 OUT OF MEMMORY
(14 Dec 2005 12:10:59)
occupants in the SYSAUX tablespace
(14 Dec 2005 6:56:48)
Blob in Oracle
(14 Dec 2005 6:22:33)
Oracle RMAN
(13 Dec 2005 20:16:9)
adpatch and opatch
(13 Dec 2005 19:31:45)
SQL Scripting help
(13 Dec 2005 14:49:8)
query help
(13 Dec 2005 14:46:53)
Newbie SQL Question
(13 Dec 2005 14:34:27)
dead locks
(13 Dec 2005 14:5:51)
Re: [***SPAM***] - How to have variable table name with FROM in my sql... - Number of numbers in MIME From exceeds maximum threshold
(13 Dec 2005 13:51:51)
Re: Distributed Transaction
(13 Dec 2005 13:48:3)
Distributed Transactrion
(13 Dec 2005 13:44:0)
RAC Documentation
(13 Dec 2005 13:0:19)
Upgrade from Oracle8.1.7.4 to Oracle9.2.0.6
(13 Dec 2005 10:54:19)
Interconnect
(13 Dec 2005 8:37:55)
Re: unable to extend temp segment
(13 Dec 2005 6:59:7)
Red Hat vs. Novell SUSE
(13 Dec 2005 6:35:52)
OracleApps patches ...
(13 Dec 2005 4:49:14)
scheduled cold backup
(13 Dec 2005 3:54:12)
Materialized View in Oracle
(12 Dec 2005 23:41:7)
Oracle Materialized Views
(12 Dec 2005 19:45:5)
ORA-1578 Oracle data block corrupted error
(12 Dec 2005 19:39:2)
any experience with 12801
(12 Dec 2005 19:27:4)
Re: [***SPAM?***] - RE: sybase??? - Number of numbers in MIME Fro m exceeds maximum threshold
(12 Dec 2005 18:4:26)
spfile or pfile
(12 Dec 2005 16:18:50)
keep object
(12 Dec 2005 15:12:47)
DataBase Size
(12 Dec 2005 13:28:6)
Export errors. PLEASE HELP
(12 Dec 2005 12:15:25)
find grep and ls -l
(12 Dec 2005 10:29:11)
Oracle Database 10G (FLASHBACK_TRANSACTION_QUERY )
(12 Dec 2005 8:38:8)
Oracle Database 10G (RECYCLEBIN )
(12 Dec 2005 8:36:57)
query somehow go parallelism for no reason...
()
How to manage Oracle Application accounts thru queries
()
How to have variable table name with FROM in my sql...
()
TRICKY SITUATION?
()
Upgrade from 8173 to 8174 with no downtime??
()
RMAN Recovery Issue
()
Rman Backup Fails.
()
how to check status of listener.
()
variable column list sql or PL/SQL
()
archive log problem
()
How Temporary Tablespaces works
()
9i reports builder
()
Oracle Database 10G
()
PARTITIONS
()
ora-01722 YES IT IS A NUMBER!!!
()
SQL Question
()
novice advice needed
()
BLOCK SIZE of tape drive ...
()
(its urgent plz reply soon)
()
Re: TNS:permission denied - Urgent
()
Re: snapshot too old
()
Data warehouse doc
()
to hceck longest running query for to increase Undo_retention parameter
()
Re: OCA-Dummy papers
()
RE:ORA-00372 and ORA-01110 errors(Urgent )
()
Setting a trace
()
Oracle 9i standby database.
()
Dynamic SQL larger than 4000 bytes
()
Automatic file creation from Primacy to Standby Server
()
SELECT CONNECT BY ...
()
Insert data in a partitioned table parallel mode
()
Oracle's installation Manual Oracle 9i on Itanium (RHEL AS 4)
()
error no 12838
()
Names Server and Database links
()
trim imbedded spaces
()
External Table Problem
()
Application Server assistance?
()
Oracle Management Server insufficient privileges
()
DBID on RMAN ....
()
IN vs EXISTS
()
Package & Package Body
()
user within a procedure
()
_trace_files_public = TRUE
()
NULL Value
()
Oracle training
()
The Future of Oracle PL/SQL
()
Oracle - Find All Occurrences of a Comma in a VARCHAR2 Column
()
logminer
()
language
()
Killing running sessions
(7 Dec 2005 9:1:44)
ora-12500 dedicated sessions URGENT
(7 Dec 2005 7:59:46)
ORA files PLEASE HELP
(7 Dec 2005 6:51:7)
ORA-00372 and ORA-01110 errors(Urgent )
(7 Dec 2005 5:35:7)
8i OO4O to 10g OO4O
(7 Dec 2005 3:50:47)
View Constraints!
(7 Dec 2005 3:4:32)
Replication
(6 Dec 2005 23:15:28)
RMAN restore database to another host
(6 Dec 2005 19:54:58)
Read files from Oracle
(6 Dec 2005 18:55:20)
ORA-00918
(6 Dec 2005 18:49:22)
Re: ORA-00932 Inconsistent Datatypes (clob)
(6 Dec 2005 18:23:15)
Exporting to a flat file
(6 Dec 2005 16:19:23)
Nulling of existing data for anyone not in specified group
(6 Dec 2005 15:50:33)
Question
(6 Dec 2005 14:34:33)
CROSSCHECK STATUS, EXPIRED - UNAVAILABLE
(6 Dec 2005 14:27:54)
FlashBack Query after Drop
(6 Dec 2005 13:4:16)
RE : check
(6 Dec 2005 13:2:17)
error occuring while instance startup(its urgent plz reply)
(6 Dec 2005 12:31:15)
DBCA
(6 Dec 2005 12:18:6)
Upgrade errors
(6 Dec 2005 11:53:36)
table grants upon structure modification
(6 Dec 2005 11:29:41)
Faire suivre : DBCA
(6 Dec 2005 10:59:2)
hi
(6 Dec 2005 10:29:27)
RE : FlashBack Query after Drop
(6 Dec 2005 10:22:41)
RE : RE : check
(6 Dec 2005 9:27:3)
check
(6 Dec 2005 9:16:34)
Encrypt
(6 Dec 2005 7:32:5)
ORA-00604
(6 Dec 2005 7:6:22)
Purge RMAN Catalog database?
(6 Dec 2005 3:42:44)
NOLOGGING during ALTER INDEX or ALTER TABLE ...
(6 Dec 2005 2:14:28)
CONTROL_FILE_RECORD_KEEP_TIME on NOCATALOG
(6 Dec 2005 0:8:4)
ORA-00932 Inconsistent Datatypes
(5 Dec 2005 21:29:56)
Need Script Please
(5 Dec 2005 20:41:37)
Upgrading JDK 1.3 to 1.4 on Oracle 9i client
(5 Dec 2005 20:34:50)
Large Full Table Scans. 1,000,000 rows.
(5 Dec 2005 20:33:10)
32bit 64 bit : ORA-06553: PLS-801: internal error [56319]
(5 Dec 2005 20:16:1)
SQLLoading Latin American Characters
(5 Dec 2005 17:43:6)
faster compliation of invalid objects
(5 Dec 2005 17:10:33)
Oracle Forms 6i on AIX
(5 Dec 2005 16:18:53)
Oracle LNNVL and NANVL Statements
(5 Dec 2005 16:6:46)
ORA-4031
(5 Dec 2005 15:28:28)
Oracle DECODE and CASE Statements
(5 Dec 2005 15:13:10)
Faire suivre : AW: rman : connected to base or not ?
(5 Dec 2005 14:14:22)
Repeating the most recent RMAN block of commands?
(5 Dec 2005 13:19:8)
Oracle Installation on Redhat-Linux
(5 Dec 2005 13:15:39)
Oracle 10g isqlplus/dba login problem
(5 Dec 2005 12:1:35)
Oracle 9i Apache Http server stratup error
(5 Dec 2005 11:49:31)
Automatic database shutdown on windows?
(5 Dec 2005 11:30:43)
Error ora-28522
(5 Dec 2005 10:39:44)
rman : connected to base or not ?
(5 Dec 2005 10:38:50)
Migration form IBM UDB DB2 7.2 to Oracle(10g)
(5 Dec 2005 10:29:43)
RMAN - SET UNTIL SEQUENCE NNN THREAD
(5 Dec 2005 10:15:39)
Re: tns permission denied
(5 Dec 2005 8:32:49)
ora-00314 error
(5 Dec 2005 7:1:46)
RMAN and DBMS_PIPE ... IS IT USEFUL, WHY?
(5 Dec 2005 3:22:22)
system error
(5 Dec 2005 1:14:37)
regranting upon table structure modification
(3 Dec 2005 13:14:38)
Change from onames to ldap...
(2 Dec 2005 20:27:54)
sql loading of flat file with ' in the file
(2 Dec 2005 20:25:8)
Help with Oracle 9i Install on Itanium RedHat 4.0
(2 Dec 2005 18:23:1)
Oracle analytics equivalent of the followoing
(2 Dec 2005 16:38:45)
Am I interpreting the trace incorrectly?
(2 Dec 2005 16:31:0)
Spool > 1000000 bytes
(2 Dec 2005 14:57:48)
newbie question
(2 Dec 2005 14:54:47)
rman 20052
(2 Dec 2005 12:56:14)
Can any body has a scramble function in oracle
(2 Dec 2005 12:56:12)
Re: [SPAM] - Re: Import issue - Number of numbers in MIME From ex ceeds maximum threshold
(2 Dec 2005 12:39:48)
IMPORT Issue
(2 Dec 2005 12:33:37)
SPOOL statements using Strored Procedure
(2 Dec 2005 12:20:46)
EXP-errors in Oracle10g
(2 Dec 2005 12:1:29)
DBMS Job
(2 Dec 2005 5:39:48)
Differnce
(2 Dec 2005 4:52:47)
Tablespace deletion
(2 Dec 2005 4:29:30)
Oracle TRACE files ...
(2 Dec 2005 4:17:30)
Exp-Imp problem
(2 Dec 2005 4:11:7)
Re: [SPAM] - Differnce - Number of numbers in MIME From exceeds maximum threshold
(2 Dec 2005 4:7:46)
oracle 8.1.7 on aix 5.3 -- urgent
(1 Dec 2005 20:19:40)
2nd Undo Tablespace
(1 Dec 2005 19:45:7)
OEM Job Output (reporting)
(1 Dec 2005 19:42:26)
Is there a way to update the user id in the SQL prompt dynamically ?
(1 Dec 2005 19:21:49)
Move index to another tablespace
(1 Dec 2005 19:16:9)
Replication questions
(1 Dec 2005 17:46:58)
Oracle10g Dataguard Question
(1 Dec 2005 17:44:6)
CNTRL characters in UNIX ...
(1 Dec 2005 16:11:13)
Help with query please
(1 Dec 2005 15:28:6)
10g client
(1 Dec 2005 14:58:50)
SPANISH CHARACTERS IN DB >>>>>>>>>>>>>
(1 Dec 2005 14:41:51)
How do I get text between two strings from CLOB
(1 Dec 2005 13:20:30)
Fatal exception c0000005 caught
(1 Dec 2005 12:58:51)
degree used by indexes.
(1 Dec 2005 12:47:21)
Control-M
(1 Dec 2005 12:38:21)
DUL or other
(1 Dec 2005 12:3:26)
Convert TEXT to HTML
(1 Dec 2005 10:51:21)
This is URGENT
(1 Dec 2005 9:38:11)
User & Roles
(1 Dec 2005 8:8:3)
ORA-600 Error
(1 Dec 2005 8:4:33)
bigfile tablespaces
(1 Dec 2005 7:47:49)
Change IP numbers on servers
(1 Dec 2005 7:18:10)
Locks during alter database datafile resize
(1 Dec 2005 0:24:30)
oracle lazydba home page