blog.contractoracle.com
Contract Oracle Limited is not affiliated to Oracle Corporation.
Blog Archive
►
2011
(1)
►
October
(1)
Enable APEX in Oracle 11.2
►
2010
(22)
►
October
(2)
Script to detect duplicate file names in different...
Script to increment sequences
►
May
(2)
Rebuilding unusable indexes, index partitions, and...
Diagnosing RAC cluster waits.
►
April
(1)
MMON automatically deletes AWR snaps if SYSAUX is ...
►
March
(7)
Freeing up db_recovery_file_dest reclaimable space...
DBMS_SHARED_POOL.PURGE
DBMS_ROWID
Test of parameter NOSYSDBA
using DBMS_SESSION.SET_CONTEXT to store variables
Duplicate database from active
Create a Dataguard Broker Configuration
►
February
(4)
ORA-07445: exception encountered: core dump [ktuGe...
ORA-28378: Wallet not open after setting the Maste...
DBA_FEATURE_USAGE_STATISTICS
An open database is not really open ?
►
January
(6)
ORA-00600: internal error code, arguments: [kcvhvd...
Allow 11g to access UTL_SMTP
Oracle 11.1.0.7.2 DB cannot write to 11.1.0.7.1 AS...
ASM diagnostics Report
Auditing feature usage in Oracle
Using PLSQL to load images into a BLOB
▼
2009
(94)
►
December
(2)
Using Flashback Archive to avoid ORA-01555
asmcmd CP command fails
►
November
(11)
Cannot export empty tables in 11.2
ORA-32016: parameter "db_name" cannot be updated i...
Global Temporary Tables generate REDO and UNDO
Analysis of Oracle password expiry
Changing NLS session parameters changes the plan
MAA for Active Dataguard
Checking Dataguard Transport Lag
Using x$logbuf_readhist to check for Dataguard Tra...
Enable Active Standby on a database with Dataguard...
Sqlnet Listener :- status READY, has 0 handler(s) ...
ORA-01503, ORA-12720 when creating controlfile
►
October
(1)
Identifying low cardinality indexes
►
September
(12)
Recover standby database using incremental backup
Table DML auditing to identify unused tables
Index monitoring to identify unused indexes.
Enable Oracle auditing BEFORE you need it.
Shared pool contents - v$db_object_cache
ORA-00604, ORA-01405 when dropping a table
SP2-0618: Cannot find the Session Identifier. Che...
PRKS-1009 : Failed to start ASM instance
Opatch - Inventory check failed
dbms_scheduler job class
Streams Heartbeat example
11gR2 released. Time to play.
►
August
(11)
adcri commands
►
July
(18)
►
June
(14)
▼
May
(4)
TEMP tablespace usage
Shrinking datafiles.
Monitor rollback operations
EMD upload error: Upload was successful but collec...
►
April
(4)
►
March
(8)
►
February
(5)
►
January
(4)
►
2008
(156)
►
December
(2)
►
November
(1)
►
October
(28)
►
September
(35)
►
August
(90)
Friday, May 29, 2009
TEMP tablespace usage
select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment