Home / Tag Archives: TABLE SPACE

Tag Archives: TABLE SPACE

Managing Security for Oracle Database Users

Managing Security for Oracle Database Users About User Security Each Oracle database has a list of valid database users. To access a database, a user must run a database application, and connect to the database instance using a valid user name defined in the database. Oracle Database enables you to …

Read More »

COMPONENTS OF ORACLE DATABASE ARCHITECTURE

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

COMPONENTS OF ORACLE DATABASE ARCHITECTURE USER PROCESS : It is the process which places request from client side and will be created when user starts any application. SERVER PROCESS : It is the process which will do work on behalf of user process on server side. PRIVATE GLOBAL AREA (PGA) …

Read More »

Upgrading to Oracle Database 10G to 11G

Upgrading to Oracle Database 10g to 11g

Upgrading to Oracle Database 10g to 11g Upgrade Oracle Database 10g to 11g Manual Upgrade We are going to use Manual Upgrade Install 11g database software in different ORACLE_HOME from source Database [email protected]:/opt/app/oracle/product/11.1/rdbms/admin> pwd /opt/app/oracle/product/11.1/rdbms/admin [email protected]:/opt/app/oracle/product/11.1/rdbms/admin> ls -lt utlu111i.sql -rw-r–r– 1 oracle oinstall 138636 2007-07-11 09:01 utlu111i.sql [email protected]:/opt/app/oracle/product/11.1/rdbms/admin> pwd /opt/app/oracle/product/11.1/rdbms/admin …

Read More »

Partitioned Tables and Indexes

Partitioned Tables and Indexes

Partitioned Tables And Indexes Maintenance of large tables and indexes can become very time and resource consuming. At the same time, data access performance can reduce drastically for these objects. Partitioning of tables and indexes can benefit the performance and maintenance in several ways. Partition independence means backup and recovery …

Read More »

Compressed Backups

Compressed Backups

1.Compressed Backups RMAN has been enhanced to provide binary compression for backup sets, reducing the amount of disk space required to make a backup. In many cases, the additional overhead required to compress the backup set is offset by the reduced I/O load when writing the backup set to disk. …

Read More »

Managing Security for Oracle Database Users

About User Security Each Oracle database has a list of valid database users. To access a database, a user must run a database application, and connect to the database instance using a valid user name defined in the database. Oracle Database enables you to set up security for your users …

Read More »

Oracle Tablespace Management

WHAT IS MEANT BY TABLE SPACE? Table space is nothing but logical representation of data in oracle database. Database is divided into one or more logical storage units called Table spaces. Table spaces are where you store Oracle database objects such as tables, indexes and rollback segments. A table space …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe