Mindmajix

Oracle DBA

6

Jun

Access to Network Services in Oracle Database

What is a listener? Listener is a process that resides on the Oracle server whose responsibility is to listen for …

Read More

6

Jun

How to Create Profiles and Password Management in Oracle DBA

Profiles   The Profile specifies the name of the profile to be created. Use profiles to limit the database resources …

Read More

6

Jun

Managing Oracle Database Controlfile

Control file management The control file is a small binary file necessary for the database to start and operate successfully. …

Read More

6

Jun

Managing the Redo Log – Oracle DBA

The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that …

Read More

6

Jun

Listing privilege and role information in Oracle DBA

To list the grants made for objects, a user can query the following data dictionary views: All_col_privs, user_col_privs, dba_col_privs All_col_privs_made, …

Read More

6

Jun

Revoking user privileges and roles – Oracle DBA

REVOKE Use to revoke privileges already granted to other users. For example to revoke select, update, insert privilege you have …

Read More

6

Jun

Granting roles and privileges in Oracle DBA

This section describes aspects of granting privileges and roles, and includes the below topics: Granting system privileges and roles: You …

Read More

6

Jun

Managing user roles – Oracle DBA

This section describes aspects of managing roles, and includes the following topics: Creating role. Predefined role. A role groups several …

Read More

4

Jun

Managing User Privileges and Roles – Oracle DBA

Privileges:             A privilege is a permission to execute an action or to access another user’s objects. The following are …

Read More

4

Jun

Managing Oracle Database Users

Each oracle database has a list of user names. To access a database, a user must use a database application …

Read More

4

Jun

Locally vs. Dictionary managed tablespaces – Oracle DBA

Rdbms server comes into picture when oracle allocates space to a segment (like a table or index), or when a …

Read More

4

Jun

Viewing tablespace information in Oracle Database

The following data dictionary and dynamic performance views provide useful information about the tablespaces of a database. View Description V$tablespace …

Read More

4

Jun

Oracle DBA – Using transportable tablespaces: scenarios

The following sections describe some uses for transportable tablespaces: Transporting and attaching partitions for data warehousing:          Typical enterprise data …

Read More

3

Jun

Oracle DBA – Transporting tablespaces between databases: a procedure and example

The following steps summarize the process of transporting a tablespace. Details for each step are provided in the subsequent example. …

Read More

3

Jun

Oracle transportable tablespaces

Introduction to transportable tablespaces: You can use the transportable tablespaces feature to copy a set of tablespaces from one oracle …

Read More

3

Jun

Regulating locally managed tablespace : Oracle DBA

Oracle database includes the dbms_space_admin package, which is a collection of aids for diagnosing and repairing problems in locally managed …

Read More
Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.