Query – Tablespace Max Size

I sometimes see concerned emails from developers that they are running out of space in tablespace and the DBA need to do something immediately. The DBA will start wondering we have monitoring in place, then how come it did not catch an out of space situation, but a user/developer did… For you developer/user, if you … Read more

Rename Diskgroup in ASM

Rename ASM Diskgroup [11gR2] In 11gR2 it is possible to rename an ASM diskgroup. This is especially useful when performing database copy using OS level LUN mirroring technologies. The renamedg command is used to rename diskgroups. It has the following options: $ renamedg -help Parsing parameters.. phase                           Phase to execute,                                 (phase=ONE|TWO|BOTH), default BOTH dgname                          … Read more

Oracle11gR1 – To Read…

 Database Replay – OTN  Documentation  Interval and Reference Partitions – Paper   Documentation  SQL Query Result Cache – OTN   Documentation SQL Performance Analyzer – OTN Documentation  SQL Plan Baseline – OTN  Documentation Automatic SQL Tuning Enhancements – Documentation Snapshot Standby – Documentation Active Data Guard (Real-time query) – Documentation OLTP Table Compression – OTN-OOW   Documentation AutoTask Infrastructure … Read more

Passwords are Case Sensitive in Oracle11g

The passwords in Oracle11g are case sensitive. All new users created in the 11g database have case sensitive password by default. For databases upgraded from earlier releases, the passwords are not case sensitive for existing accounts. They become case sensitive when you change password. A new column PASSWORD_VERSIONS is added to DBA_USERS view. A value … Read more

Read Only Tables [Orig Published Apr 2000]

In Oracle (all versions including 10g) you can make a tablespace read only, but not a single table. To make a table read only, you need to have that table in its own tablespace. If the tablespace has many tables, then you can either make all the tables read only or not. For large or … Read more

SQL*Net Configuration [Orig Published – Apr 1999]

Let’s set up SQL*Net (known stuff for most DBAs, but I get many questions on this subject often, so here I just provide some examples/templates for the configuration files) on the UNIX server and client PC using the TCP/IP communication protocol. In Oracle8 SQL*Net is called Net8. SQL*Net enables client-server and server-server communication across any … Read more