Answer / Rishish Mishra

The System Global Area (SGA) is a shared memory region in an Oracle database that contains data structures essential for database operations. It includes the Database Buffer, Redo Log Buffer, Shared Pool, and Large Pool.nnFor mid-sized OLTP environments, the SGA can be configured as follows:nn - Database Buffer Size: Increase to accommodate larger amounts of data for faster query response times.n - Redo Log Buffer Size: Adequate size to minimize I/O operations when writing redo logs.n - Shared Pool Size: Optimal size to manage shared memory structures like SQL area, library cache, and dictionary cache.nnTuning the SGA involves adjusting its size parameters based on workload, system resources, and performance requirements. This may include analyzing database usage patterns, monitoring wait events, and using tools like DBMS_STATS or AWR reports.

what is the use of home directory???

1 Answers   HP,

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1 Answers   Patni,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1 Answers  

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1 Answers  

---

How do you open a cluster administrator? : sql server DBA

1 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

how can you get actual data change values from previous transactions in oracle?

1 Answers   Oracle,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

---