Oracle FAQs - dbapool.com

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Interview Questions

FAQs

Blog

Frequently Asked Questions


DB Administration Which script is used to create base data dictionary tables? Which are the views for finding the database version, options and port installed? Can one change the INITIAL and NEXT parameter of an object once it is created? How can one coalesce free space in a tablespace? Which data dictionary view should one query to get the name of database's datafiles and redo log files? What is the effect of DB_Name parameter and database name on each other in control file? How can one determine the size of buffers in the buffer cache of SGA? How you can check the version of oracle and its components in your database? Can one rename a database user (schema)? Can one resize the data files if experiencing problem with the tablespace size? I would like to increase the size of the archive logs which should hopefully decrease the number of logs switched per minute? Describe REDO and UNDO in detail? Which oracle facility can be used for sending mails. Which oracle facility can be used for scheduling jobs. I am getting error " Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded!"? How can I get the largest amount of physical reads by any query? What is the difference between a database and an instance? What is the difference between V$ and GV$ , also V$and V_$? How do you find out the unix process id of a database session? How to register Listener in the database? How to check the Instance Name, Host Name, and Instance Startup time of an Oracle Database?
Back to Top


Perf & Tuning Which tools or utilities should I use to diagnose the poor performance of my database? How can I calculate SGA size in Oracle 8i? Which are the most crucial parameters in init.ora? How can I get the largest amount of logical reads by any query? What is the optimum value for hit ratio? How can I get the largest amount of physical reads by any query? When I should increase DB_BLOCK_BUFFERS? What are the techniques to increase the reliability and performance? What is the recommended size of block for an OLTP database. How can I find Table, Index and Column which are indexed? How to determine redo log size?
Back to Top


Backup/Recovery What are the different tools/utilities for taking backups? What is the difference between Logical and Physical Backups? What is the difference between On-line and off-line backups? What kind of backup are supported by RMAN? How I can get database in Archive log mode? What are the popular backup solutions available in the market. What I can do if running out of rollback segments while importing? How to change temporarily change the archive location?
Back to Top


9i New Features Can I create indexes on index organized tables online? How to use iSQL*PLUS in Oracle 9i?
Back to Top


Oracle on Unix How can one examine the size of Oracle Processes? How can one Monitor paging/swapping on Unix system? What are the Kernel Parameters associated with the SGA? What are Semaphores? How can one set number of process per user? How can I find the OS Block Size . How to check background process status in Unix environments? How to run OEM on linux?
Back to Top


Shells What are the main Unix shells? What is a Secure Shell? What is the difference between SSH1 and SSH2? How to execute Shell Scripts? How to find shell that I am currently running. What are the default prompts of the shells.
Back to Top


Sed & Awk What is sed? How do I replace "/some/UNIX/path" in a substitution? How do I read environment variables with sed?
Back to Top


Solaris How can I restrict the number of processes per user? How can I have more than 16 groups per user? How can I disable _POSIX_CHOWN_RESTRICTED? My users want to chown files? Where can I download Solaris binaries from? How to find what Solaris release am I running on my system? How can I know which Solaris/hardware do I have - 32 or 64 bit? Can not login as 'root', getting 'Not on system console' error message on solaris. How to check physical memory on solaris?
Back to Top


Solaris – x86 Is Solaris Intel 64-bit aware? What's the difference between partitions and slices? Is Plug-and-Play (PNP) supported by Solaris/x86?
Back to Top


Linux What Is Linux? Who Wrote Linux? How to mount cdrom on redhat linux?
Back to Top


NFS How to debugging NFS problems? Why do I get "permission denied" or "access denied" when I try tomount a remote filesystem? When I try and umount a partition, why do I get the following error: /partition: Device busy
Back to Top


General What Is a core File? How To Enable or Disable Core Dumps? What is a firewall?
Back to Top


Installation What are the operating system requirements for SQL Server 2000? What are the different editions available in SQL Server 2000?
Back to Top


Programming How does Microsoft SQL Server handle encryption?
Back to Top


Server How can I qualify a named instance in a linked server query?
Back to Top


Clustering Does SQL Server 2000 clustering support load balancing? Can SQL Server 6.5 or 7.0 be installed on one node of a cluster and SQL Server 2000 be installed on the other node?
Back to Top


Tools Is it possible to use SQL Server 2000 tools to connect to SQL Server 7.0?
Back to Top


Miscellaneous Where I can find more documentation on MS SQL Server?
Back to Top

Home Discussion Forum FAQs Articles Jobs Newsletters Directory Downloads

Our Premium Sponsor

Confio Software