If CPU is very slow What can u do to speed up?
Answer / braj123
--> use VMSTAT to check the cpu enqueues.
--> also use top and sar commands for cpu load.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the diffrence between core dba and apps dba?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What command would you use to encrypt a PL/SQL application?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How would you go about increasing the buffer cache hit ratio?
what is ora 24313?what is the procedure to exclude that error?
Explain an ORA-01555
what is logical system in sap basis
Where would you look for errors from the database engine?
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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How many memory layers are in the shared pool?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)