Protected: Creation of Files in UNIX (Session-03).
There is no excerpt because this is a protected post.
Author: Binnary Ajay Kumar
Protected: BASIC ARCHITECTURE OF UNIX OPERATING SYSTEM(Session -02).
There is no excerpt because this is a protected post.
Protected: Introduction to UNIX(Session -01).
There is no excerpt because this is a protected post.
Protected: Configure Postfix to use Gmail as a Mail Relay on UBUNTU Server.
There is no excerpt because this is a protected post.
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02)
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02) IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. MATERIALIZED VIEW WITH REFRESH FAST : Now that we know how materialized view logs track changes to base tables we can use them to perform fast materialized view refreshes, i.e. refreshes where… Read More
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS.
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. Materialized views are schema objects that can be used to summarize, compute, replicate, and distribute data. They are suitable in various computing environments such as data warehousing, decision support, and distributed or mobile computing. In data warehouses, materialized… Read More
RMAN Enhancements in Oracle 12c
Dear Readers, In this article, we will see the following RMAN Enhancements in Oracle 12c. 1.SQL Interface Improvements In Oracle 12c, you can run SQL commands in RMAN without preceding the command with the SQL keyword. You also no longer need to enclose the SQL… Read More
DDL Wait Option in Oracle.
DDL Wait Option in Oracle. A DBA is trying to alter the table called SALES to add a column, TAX_CODE. he issues the following SQL statement:
|
1 |
SQL> alter table sales add (tax_code varchar2 (10)); |
But instead of getting something like “Table altered”, he gets:
|
1 2 3 4 |
SQL>>Alter table sales add (tax_code varchar2 (10)) * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired |
The error message says it all: the… Read More
Fine-Grained Auditing (FGA)
Fine-Grained Auditing (FGA). Fine grained auditing extends Oracle standard auditing capabilities by allowing the user to audit actions based on user-defined predicates. It is independant of the AUDIT_TRAILparameter setting and all audit records are stored in the FGA_LOG$ table, rather than the AUD$ table. The following example illustrates how fine… Read More
Auditing in Oracle
Auditing in Oracle. Auditing is used to track the occurrence of SQL statements in subsequent user sessions. In this article will see how can dba track all types of sql operations (select,insert,update,delete drop,create and alter) of particular user. Auditing is a default feature of the… Read More
