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
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.