PeoplesoftOracleDBA

Below is the query I have to written to find access level that a specific permission list has on menu

Recently when was setting up new instance I got the above mentioned errors "THE SITE BOOTED WITH

Hi Friends While exporting and importing tables in oracle, i have read that buffer parameter plays a

Hi How is user called ora_monitor is created?what it is used for? It is also running the process to

Hi Friends How to get the base metrics for my database so that we can compare them in any problem in

Hi Anand There is no error in alert log file. I am copying and pasting text in ora trace file =======

Swati, Good to see your reply. One question, for which company ru working and what's your role

Click on http://groups.google.co.in/group/ask-oracle-dba/web/oracle-11g-features?hl=en - or copy

HI, Check with your data connection and check if you are applying any filters on the data. On Sun,

Hi..This is Sagar....I have completed BE I wish to make career in Oracle DBA.. So i have joined

Hi Swathi, You can add redo log file groups or members to the primary database without affecting the

Kumar In this scenario you willl have to perform point-in-time recovery (incomplete) till the time

Hi Vijayalakshmi Please find below the extract of Doc ID :443422.1 from metalink Applies to: Oracle

Hi Friends, How can we determine how many shared servers are needed when we are using shared server

Hi The db_cache_size is size in bytes of the cache of the standard block sized buffers The

hi, thanq for your sugestion. In 10g the db_block_size=4k. Then we create 4k tablespace defaultly. if

When you give sqlplus / as sysdba to login to database that means you are using host based/OS

if you don't specify the background_dump_dest parameter the default value is assigned to it.

Adding more to the above reply. In oracle both "SHOW PARAMETER PFILE" and "SHOW

Sometimes DBA may have to audit the user login details. Here is simple trigger to monitor user logon

In prior versions to 10g when a query executed by a user try to use an index which is in UNUSABLE

You cannot merge data files physically. there is no feature in oracle to do the same. but you can do

To find the memory used by oracle execute the following queries SQL> select sum(pga_used_mem) from

To check whether spfile is being used or not At SQL prompt execute the following command SQL> SHOW

Hi Whts difference between coalesceing a tablespace and resizing datafiles in a tablespace?? Which

Hi I am seeing that while we take hot backup of our database, lot of redo is generated. What is the

Have you changed this parameter at instance level.Means scope=memory or ru using any specific pfile.

Hi All We have Oracle 9i database on windows 2003 OS. Our system is very slow. So I have staspack

1)Check the current archive log mode in the database SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

Click on http://groups.google.co.in/group/ask-oracle-dba/web/steps-to-create-database-manually?hl=en-