SPOOLING TO A DYNAMICALLY GENERATED SPOOL FILE NAME
QUESTIONS How to create a spool file with the date appended to file name? Is it possible to change the spool file name dynamically? REQUEST I want to produce a spool file with a name generated during runtime. SOLUTION Create a substitution…
GENERATING THE CURRENT INITIALIZATION PARAMETER FILE
REQUEST To generate an initialization parameter file by querying a database. RELATED IS MY DATABASE USING PFILE OR SPFILE? DETAILS V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. V$SPPARAMETER displays information about the contents of…
IS MY DATABASE USING PFILE OR SPFILE?
QUESTIONS How to check whether an Oracle instance is started using pfile or spfile? REQUEST To get a full path of an initialization parameter by querying of a database. RELATED QUERYING THE ORACLE_HOME PATH FROM A DATABASE SOLUTION SET LINES 300…
AN INTERVIEW QUESTIONS [RUSSIAN] FOR ORACLE DBA POSTITION
При очередном устройстве на работу в 2015 году, в качестве тестового задания я получил данный список вопросов. В течении дня я должен был ответить и отправить ответ потенциальному работодателю. Название компании уже не помню, но находилась она в соседнем здании от Luxoft, на 1-й Волоколамский…
REMOVING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK
REQUEST I want to remove a file through PL/SQL block RELATED WRITING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK READING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK COPYING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK TESTCASE To remove a…
COPYING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK
REQUEST I want to make a file copy through PL/SQL block RELATED WRITING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK READING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK REMOVING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK TESTCASE In this…
READING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK
REQUEST I want to read the content of a file through PL/SQL block RELATED WRITING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK COPYING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK REMOVING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK TESTCASE…
WRITING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK
REQUEST I want to create a file and write a some content into it through PL/SQL block RELATED READING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK COPYING AN OPERATING SYSTEM FILE THROUGH A PL/SQL BLOCK REMOVING AN OPERATING SYSTEM FILE THROUGH A…
FIXING ADFC-00032 [ADFc] IN OEM 13.1.0.0.0
REQUEST I receive lots of emails with these errors reported as Critical from Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0.0). I want to stop them to be generated. SYMPTOMS Host=dbpilot.net Target type=Oracle Management Service Target name=dbpilot.net:4889_Management_Service Categories=Diagnostics, Error Message=Incident (ADFC-00032 [ADFc])…
HOW TO SUPPRESS BEA-000337 ALERTING
QUESTIONS I receive lots of emails with these errors reported as Critical either from Oracle Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4) and from Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0.0). I want to stop them to be generated. RELATED…
Search
Categories
- Linux (7)
- Networker (1)
- Oracle (44)
- Account (2)
- AWR (1)
- Database Errors (3)
- Datapump (1)
- Enterprise Manager (13)
- Environments (4)
- Interview (1)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (4)
- UTL_FILE (4)
- Prerequisites (1)
- Redologs (1)
- Segment Shrink (1)
- Session (3)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Statistics (2)