DBA_FREE_SPACEDBA_SEGMENTSDBA_DATA_FILES.

Newton Aseri

• Oct 7th, 2015

DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES..

Answer Question  Select Best Answer

 Installing and upgrading the Oracle Server and application tools.Allocating  system storage and planning future storage requirements for the database  system.Managing primary database structures (tablespaces)Managing primary objects (table,views,indexes)Enrolling users and maintaining system security.Ensuring compliance with Oralce license agreementControlling and monitoring user access...

skumarpenugonda

 Profile Answers by skumarpenugonda Questions by skumarpenugonda

• Jul 7th, 2006

adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloa...

Prabha Sharma

• Apr 13th, 2006

Defining physical and logical schema of database.Take periodically backup of the database.Assign authorization to the database users.Define various method for storing and retrieving of data.

Answer Question  Select Best Answer

 SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL  *  Loader  -  It loads data from standard operating system files (Flat files) into ORACLE database tables. Export  (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Chiranjeevi Manne

• Mar 30th, 2007

SQL Plus, SQL Loader, EXP, IMP

Answer Question  Select Best Answer

What is Oracle Wallet?

imran44

 Profile Answers by imran44 Questions by imran44

• Dec 28th, 2008

Wallet is a Oracle object which keeps the record of Master key for the entire database and all other digital certificates used by the database for encryption purpose. The Walled kept outside the database software and has a different password then DBA system password.

Answer Question  Select Best Answer

meetsanc

 Profile Answers by meetsanc Questions by meetsanc

• Oct 2nd, 2008

For applications dealing with this highly sensitive data like passwords, Oracle provides the DBMS_OBFUSCATION_TOOLKIT PL/SQL package to encrypt and decrypt data. It includes string inputs and raw inpu...

Answer Question  Select Best Answer

Roles  are  named groups of related privileges that are granted to users or other roles.

Patrick McShea

• Dec 7th, 2006

Roles are named groups of privileges (which my OR MAY NOT be related to each other) that are granted to users or other roles.

Mangla

 Profile Answers by Mangla Questions by Mangla

• Sep 20th, 2006

Roles  are  named groups of related privileges that are granted to users or othersBhim Mangla(IBM)

Answer Question  Select Best Answer

Monitoring of user access to aid in the investigation of database use.

Chiranjeevi Manne

• Mar 30th, 2007

Auditing involves in recording all the activities based on the auditing rulesSome types of auditing are Database level Auditing, Schema Level auditing, Object level Auditing and Statement level auditing.

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 3rd, 2006

Auditing in Oracle can be done by writing logs to either the SYS.AUD$ table or to the OS itself. Auditing to the OS makes deleting the audit trail by a DB user more difficult. But auditing all accounts and all actions would severely affect performance.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

prakashpichika  

 Profile Answers by prakashpichika Questions by prakashpichika

• Member Since Jun-2006 | Oct 3rd, 2006

---

oracle@localhost> lsnrctl

LSNRCTL> set current_listener LISTENER

Current Listener is LISTENER

LSNRCTL> set save_config_on_stop on

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

LISTENER parameter "save_config_on_stop" set to ON

The command completed successfully

LSNRCTL> change_password

Old password:

New password:

Reenter new password:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

Password changed for LISTENER

The command completed successfully

LSNRCTL> set password

Password:

The command completed successfully

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

The command completed successfully

LSNRCTL> exit

Cheers

Mohammed Abdul Afroze

• Oct 4th, 2007

To set the password for the listener.ora are as follows;lsnrctl>lsnrctl password

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 3rd, 2006

oracle@localhost> lsnrctlLSNRCTL> set current_listener LISTENERCurrent Listener is LISTENERLSNRCTL> set save_config_on_stop onConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))LISTENER ...

Improve Answer

The  Tablespace  to  contain  schema  objects  created without specifying a tablespace name.

kapil

• Nov 1st, 2015

Users need to have a default tablespace, where their objects will be created if they dont explicitly assign a different tablespace during object creation

Chiranjeevi Manne

• Mar 30th, 2007

The default tablespace is the tablepsace in which the user's objects are created. Generally while creating the user, the default tablespace is mentioned. If by any chance the default tablespace is...

Answer Question  Select Best Answer

Each  database  user  is  assigned  a Profile that specifies limitations on various system resources available to the user.

gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 15th, 2007

A profile is used to restrict the reource uses, password reuses, idle time of a session etc.  We can also attach a password verify function for the database user.  A database user can be assigned a profile.  It is an optional clause.  By default it takes DEFAULT profile.

Chiranjeevi Manne

• Mar 30th, 2007

A profile contains the details about the RESOURCE LIMITS and PASSWORD LIMITS at Oracle level pertaining to a specific user.

Answer Question  Select Best Answer

      Shut the database     Backup the database     Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.     Start up the database.

Chiranjeevi Manne

• Mar 30th, 2007

1. it possible to enable archive log mode while creating the database using DBCA.2. By mentioning the required parameters like LOG_ARCHIVE_DEST, LOG_ARCHIVE_FORMAT, LOG_ARCHIVE_START in init.ora file ...

Nitan Jandial

• Dec 28th, 2006

These are points we should consider when we think abt archivelog mode starts automatic Before stutting down the DB, just alter the parameter name "log_archive_start" into "TRUE"Issue the following st...

Answer Question  Select Best Answer

How will you enable database auditing? In How many ways can you implement database auditing?

yossin

 Profile Answers by yossin Questions by yossin

• Oct 15th, 2009

There's another option.There is a product called OraPlayer, that is tracking all actions performed by all the end-users of Oracle Forms. It tracks all the data sent from the forms user to the server and from the server.

johnjohn1976

 Profile Answers by johnjohn1976 Questions by johnjohn1976

• May 25th, 2009

Auditing is a functionality which keep track of all the activity happening to DB There are two type of auditing in Oracle 1, Standard Auditing2. Fine grained Auditing The standard Auditing is again di...

Answer Question  Select Best Answer