DBMS_UTILITY.ANALYZE_SCHEMA
10:17:18 SYS@WEBP:-> execute dbms_utility.analyze_schema(‘CS’, ‘COMPUTE’, NULL, NULL, NULL);
Category: Oracle
Gathering statistics with DBMS_STATS
———————————————- Gathering statistics with DBMS_STATS ———————————————- DBMS_STATS.GATHER_TABLE_STATS DBMS_STATS.GATHER_TABLE_STATS gathers statistics for a table and its columns, and optionally the associated indexes. Call syntax dbms_stats.gather_table_stats(ownname, tabname, partname, estimate_percent, block_sample, method_opt, degree, granularity, cascade, stattab, statid, statown); The first two parameters are mandatory, the rest are defaulted to a value. ownname – owner tabname – table name…
VIvek Encryption Package and Its Usage
create or replace package subs_cipher is function scramble ( obfs_in varchar2 ) return varchar2; — pragma not required as of 8.1.5 pragma restrict_references( scramble, wnds, wnps, wnps); function unscramble ( obfs_in varchar2 ) return varchar2; — pragma not required as of 8.1.5 pragma restrict_references( unscramble, wnds, rnds, wnps ); end; create or replace package body…
create database link syntax
In the following statement, user hr on the remote database defines a fixed-user database link named local to the hr schema on the local database: CREATE DATABASE LINK local CONNECT TO hr IDENTIFIED BY hr USING ‘local’;
Adding or Dropping Online Redo Log Files When Physical Standby in place
Changing the size and number of the online redo log files is sometimes done to tune the database. You can add online redo log file groups or members to the primary database without affecting the standby database. Similarly, you can drop log file groups or members from the primary database without affecting your standby database….
Read More “Adding or Dropping Online Redo Log Files When Physical Standby in place” »
Example of How To Resize the Online Redo Logfiles Note:1035935.6
EXAMPLE OF HOW TO RESIZE THE ONLINE REDO LOGS: ============================================== Often times the online redo logs are sized too small causing database performance problems. The following is an example of how to resize the online log groups: 1. First see the size of the current logs: SVRMGR> connect internal (with 9i/10g use SQL> connect /…
Read More “Example of How To Resize the Online Redo Logfiles Note:1035935.6” »
Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1
Purpose: ======== The purpose of this article is to describe the behavior of the standby database when one or more datafiles on the primary database are resized. Standby Database Behavior When a Datafile is Resized on the Primary Database: ============================================================================= On the primary database the initial size of the datafile is 113246208. You decide to…
AWR settings- MMON is not taking snapshot.
POTENTIAL SOLUTION(S) for AWR Snapshot Error ============================================ (*) To take the snapshots we need to populate WRM$_SNAPSHOT table successfully and for that instance metadata should be present in WRM$_DATABASE_INSTANCE. (*) To regenerate the AWR objects run catnoawr.sql and catawr.sql scripts from $ORACLE_HOME/rdbms/admin (*) Then RESTART the database So, if we have regenerated the AWR objects…
Changing the Global Database Name
Changing the Global Database Name: Example The following statement changes the global name of the database and includes both the database name and domain: ALTER DATABASE RENAME GLOBAL_NAME TO demo.world.oracle.com;
Resolving RMAN Hung Jobs
PURPOSE ======= This note discusses resolving an RMAN Hung Job SCOPE & APPLICATION =================== Anyone involved in running RMAN jobs Resolving an RMAN Hung Job ========================== Components of an RMAN Session The nature of an RMAN session depends on the operating system. In UNIX, an RMAN session has the following processes associated with it: –…