Alterei o valor de um parâmetro no server parameter (SPFILE), mas será que este valor realmente refletiu no arquivo que trará o valor real no próximo processo de STOP/START do banco de dados? A resposta para esta pergunta pode ser obtida através da view V$SPPARAMETER.
Sendo assim, segue abaixo um exemplo usando o parâmetro db_files:
- Alteração do parâmetro:
SQL> show parameters db_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_files integer 200 SQL> SQL> alter system set db_files=500 scope=spfile; System altered.
- Visualização do parâmetro na instância atual:
SQL> show parameters db_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_files integer 200
- Visualização do parâmetro no SPFILE antes mesmo do STOP/START da base de dados:
SQL> SELECT name, value FROM v$spparameter WHERE name='db_files'; NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- db_files 500
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)